Back to Search
Property profile & analytics
OFF-MARKET
Strip malls
6903 Saint Andrews Rd Columbia, SC 29212-1142
Entity Owned
25-yr Hold
Absentee Owner
Free & Clear
Property ID
US77-0858781
Property profile
Verified
Property type
Strip malls
Use group
SHOPPING CENTER, STRIP CENTER
Year built
2006
Total area
1,500 SF
Lot
0.79 ac (34,412 SF)
Zoning code
R1
APN
002797-03-020
UPID
US77-0858781
Cap rate & NOI
Priority signal for investors
Implied cap rate, NOI & suggested price
Cap rate vs submarket · NOI estimate · 3 price anchors
Implied cap rate, NOI & suggested price
Cap vs submarket · NOI estimate · 3 price anchors
Value estimations
Realmo proprietary · 4 methods
AI Approach
AI
by Request
CAP Approach
CAP
by Request
Comparable Approach
Comparable
by Request
Blend (final)
Blend
by Request
Owner & transaction history
Ha Smith LLC · 25 yrs held
Ha Smith LLC
since 2001
1 recorded transaction
Zoning & alternative use
R1 · Columbia, SC
Permitted uses
Permitted uses
Allowed · conditional · prohibited
Cap rate
Implied · in-place · derived from last sale + estimated NOI
Implied Cap rate
#1
Implied · in-place · NOI ÷ last sale
In-place · derived from last sale + estimated NOI
Cap rate, NOI & submarket benchmark
Implied cap rate vs Columbia submarket · NOI estimate · Typical band, median & reading
Implied cap rate, NOI & submarket benchmark
Cap vs Columbia submarket · NOI estimate · typical band, median & reading
Refine your cap rate
8-question underwriting flow
1.
Property current status — Going-In vs Stabilized
2.
Price for denominator — asking / offer / market
3.
Leasing status & lease structure (NNN / Gross)
4.
Tenant risk profile & vacancy assumption
5.
Upload T12 / rent roll / OM (optional)
Refine in 60 seconds, get exact suggested price
T12 upload · Submarket benchmarks · Sensitivity grid
Suggested price · 3 cap rate anchors
Income approach @ 5% / 7% / 9% — aggressive / typical / conservative
Suggested price at 5% / 7% / 9% cap
Aggressive / typical / conservative · Implied $/SF per anchor · Sensitivity grid
Suggested price at 5% / 7% / 9% cap
Aggressive / typical / conservative · implied $/SF · sensitivity
Value
AI, CAP & Alternative Use estimations · Realmo proprietary blendValue Estimations
Based on Realmo’s proprietary methodology
AI Approach
CAP Approach
Comparable Approach
Alternative Use
Get a detailed, property-specific estimation — fast and free
Price per SF
Sale + rent benchmarks
Subject property
—
Submarket sale & rent benchmarks
Median sale $/SF · Asking & closed rent · Submarket vacancy
Submarket sale & rent benchmarks
Median sale $/SF · asking & closed rent · submarket vacancy
Property tax & assessments
Tax year 2023Property tax & assessments
Tax year 2023
Tax billed
$19,328
Tax year 2023
Assessed value
$44,613
Assessed 2023
Previous assessed
$44,613
+0.0% YoY
Effective rate
43.32%
On assessed value
Assessed land
$14,454
Assessed improvement
$30,159
Land market value
$240,900
Improvement market value
$502,660
Total market value
$743,560
Applied tax rate
5.0000
Comparables
6 recent transactions · within 1.5 miComparable in this city
6 recent transactions
Comparable in this City
Similar Nearby for Sale
Similar Nearby for Lease
Recent comparable sales
Sale price & price/SF · Sale date & distance · Adjustments & confidence
Recent comparable sales
Sale price & $/SF · sale date & distance · adjustments
Property description
Physical attributes from public recordsBuilding & lot
Public records
Property type
Strip malls
Use group
SHOPPING CENTER, STRIP CENTER
Status
Off-Market
Year built
2006
Heating
FORCED AIR
Bathrooms
1
Total area
1,500 SF
Lot
0.79 ac (34,412 SF)
Zoning code
R1
APN
002797-03-020
UPID
US77-0858781
Jurisdiction
LEXINGTON
Zoning & alternative use
R1 · Columbia, SCZoning R1 · permitted uses
R1 · Columbia, SC
Permitted & conditional uses
Allowed uses · Special-permit conditions · Prohibited uses
Permitted & conditional uses
Allowed · special-permit conditions · prohibited
Building & site characteristics
From public records
Year built
2006
Heating
FORCED AIR
Bathrooms
1
Lot
0.79 ac
Current owner
From public records · entity-resolved
Ha Smith LLC
Entity
Free & Clear · 25 yrs held
Mailing address
7 AUDUBON OAKS CT, IRMO, SC 29063-8208
Mailing matches property
Different — outreach signal
Owner-occupied
No
Ownership since
2001
Owner contacts — direct phone, email, and related entities
Decision-maker phone · Verified email · Related entities & filings
Owner contacts
Email · phone · related entities
Sales History
1 recorded event · public records
Date
Price
Buyer
Seller
Deed Type
Mortgage
May 22, 2001
$126,300
Ha Smith LLC
—
Grant Deed
—
Coming soon
Costs & Benchmarks
Operating expenses, capex projections, utility benchmarks, and submarket comparables — all in one view.
Coming soon
Risks
Flood, climate, environmental, title, and tenant-concentration risk — surfaced with mitigations and source citations.
Try Rey
Ask anything about this address in plain English.
“Is 15.6% cap rate sustainable?” · “Best tenant mix for BU1?” · “What’s the redev upside?”
You own 6903 Saint Andrews Rd?
List it free. Reach 20,000 daily buyers.
We’ve already pulled the facts. Confirm photos + price and you’re live in 2 minutes.
List this address →
Full reports are paid
Unlock the full Property Analytics report
Start free for 7 days — no card required. Full owner contacts, all 4 valuations with methodology, refine flow, comparable adjustments, foot-traffic deep dive, export to PDF / CSV.
