Realmo Analytics
Get reports on 50M+ commercial properties in the US. Find and target property leads based on your business goal.
We will call you to discuss how Realmo analytics may help you.
Property summary
This exceptional investment opportunity presents a 3,233 square foot, Class A retail property located at 538 St Andrews Rd, Columbia, SC 29210. The property, built in 1997 and situated on a 0.85-acre lot, is a thriving Shell fuel station and convenience store operating under an absolute NNN lease with a franchisee tenant. The lease, boasting a remaining term of 17.6 years (expiring July 31, 2042), includes favorable 1.5% annual rent bumps. The current Net Operating Income (NOI) stands at… $120,194, yielding an attractive 6.75% cap rate. This hard-corner location benefits from excellent visibility and accessibility, with daily traffic exceeding 24,000 vehicles. The property is in a densely populated area, with over 118,000 people residing within a 5-mile radius, in Columbia, the 10th fastest-growing city nationally. The tenant, a highly experienced operator with 42 units, is committed to regional expansion. This investment offers significant tax benefits through accelerated depreciation and cost segregation, making it a compelling opportunity in a recession-resistant industry. The asking price is $1,780,000.
Ownership intelligence
Owner of record from public deeds, plus portfolio, hold profile and investor signals where the data supports them. Included with a plan.
Owner contacts
Skip-traced phones and e-mails of the owner. Included with a plan.
Debts
Recorded lenders, amounts and estimated maturities of the owner's loan book — included with a plan.
Property tax
No data for this sectionNo tax or assessment record is on file for this parcel in the county feed.
Value estimate
· Oct 2026No data for this sectionNo value estimate could be modeled: the record carries too little market input for this parcel.
Recently sold
No data for this sectionNo cleaned sale $/SF benchmark exists for this use type in this ZIP, submarket or county yet.
Cap rate analysis
No income signal is modeled for this parcel yet — the Cap Rates tab runs the workflow.
Zoning insight
No data for this sectionNo zoning code is on file for this parcel. Coverage grows with every catalog release.
Location intelligence
Demand index: how under-served this business type is around this point — modeled from the LocInt grid (area demand vs. what already operates, adjusted by real visit traffic). Higher means stronger unmet demand.
Location
Every figure names its source: public record, benchmark, or modeled. Coverage varies by property — thin data is stated as missing, never invented.
Comparables
6 recorded sales · 15 properties nearbyComparable nearby
Similar Nearby for Sale
Similar Nearby for Lease
Instant AI valuation built from comps, income signals, and proprietary benchmarks.A defensible range, not a single guess.
from $199/month
- GBA
- 3,233 SF
- Lot area
- 0.85 ac
- Year built
- 1997
Cap rate calculated from real income and expense signals, benchmarked against sales of similar assets nearby.
from $199/month
The recorded zoning designation, what the district officially allows, and the municipal source it comes from.
No zoning code is on file for this parcel. Zoning coverage grows with every catalog release — check back, or open Location Intelligence for use analysis of this corner.
Unlock the evidence behind ownership: portfolio, transactions, debt and any signals we can model, to help you decide who to contact next.
Registration is required before any owner information is shown.
Phones and e-mails of the people behind this property's owner, traced from licensed contact data.
Owner phones and e-mails come with a plan - traced from licensed contact data, with verification and Do-Not-Call flags on every number.
The mortgage data comes with a plan: recorded loans of the owner - lender, amount, rate and the estimated maturity - as part of the Ownership Intelligence workspace.
Registration is required before any owner information is shown.
- 10 Targeted Leads
- 1 Full Property Report
- Lead Lists by Intent
- Signals & Scores
- Building Details
- Value Estimation
- Cap Rate Evaluation
- Liens & Mortgages
- Ownership & Contacts
- Local Market trends
-
Zoning Insight— not in this plan -
Location Analytics— not in this plan
- 300 Targeted Leads a month
- 30 Full Property Reports
- Lead Lists by Intent
- Signals & Scores
- Building Details
- Value Estimation
- Cap Rate Evaluation
- Liens & Mortgages
- Ownership & Contacts
- Local Market trends
- Zoning Insight
-
Location Analytics— not in this plan
- 1,500 Targeted Leads a month
- 150 Full Property Reports
- Lead Lists by Intent
- Signals & Scores
- Building Details
- Value Estimation
- Cap Rate Evaluation
- Liens & Mortgages
- Ownership & Contacts
- Local Market trends
- Zoning Insight
- Location Analytics
The PDF can’t be displayed here
Use Download PDF or Open in new tab above to view the sample report.
Sample leads
-
Off Market
AK
Absentee
AK
-
Off Market
406 W, BROADWAY, AK
Absentee
406 W, BROADWAY, AK
-
Off Market
W, BROADWAY, AK
Absentee
W, BROADWAY, AK
-
Off Market
1201, CAPTAINS BAY RD, AK
Absentee
1201, CAPTAINS BAY RD, AK
Sample leads
-
Off Market
1404, ATS, AK
Loan from 20067.7% rateColumbia State Bank
1404, ATS, AK
-
Off Market
1503, BALLYHOO RD, AK
Loan from 2009Columbia State Bank
1503, BALLYHOO RD, AK
-
Off Market
721 E, DEPOT DR, AK
Loan from 2019Northrim Bank
721 E, DEPOT DR, AK
-
Off Market
AK
Loan from 2008Bmo Capital Markets Corp
AK
Still being built. It lands here next, beside the two above.
The PDF can’t be displayed here
Your browser has no PDF viewer of its own.
