Individually Owned 
For Sale
1 / 43
Contact for pricing
1704 Bush River Rd, Columbia, SC 29210
View Listing →
Property summary
AI-generated overview
Exceptional investment opportunity in Columbia, South Carolina, featuring a mixed-use property totaling 6,750 square feet across two single-story buildings. This prime location boasts high visibility and proximity to numerous retail establishments, hotels, and entertainment venues, including a bowling alley. The property is zoned for commercial use and offers a strong 8.10% cap rate with a current NOI of $97,200. The property is currently leased to two tenants: a thriving Indian restaurant franchise, NAWABI HYDERABAD HOUSE, with a newly signed 5-year lease (plus a 5-year option) and a 2% annual rent increase
Property profile
Verified
Property type
Turn key restaurants
Use group
RESTAURANT
Year built
1984
Total area
4,250 SF
Lot
0.98 ac (42,689 SF)
Zoning code
C2
APN
003697-07-004
UPID
US77-0585526
Cap rate & NOI
Priority signal for investors
Implied cap rate, NOI & suggested price
Cap rate vs submarket · NOI estimate · 3 price anchors
Current use
Occupant on record · Public records
-
Restaurant
Location
Value estimations
Realmo proprietary · 4 methods
AI Approach
AI
$260k
CAP Approach
CAP
by Request
Comparable Approach
Comparable
by Request
Blend (final)
Blend
$270k
Owner & transaction history
since 2022
Last sale
$290,000
2 recorded transactions
Zoning & alternative use
C2 · Columbia, SC
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
Value estimation
Instant AI valuation built from comps, income signals, and proprietary benchmarks. A defensible range, not a single guess.
17% off on annual
Unlock the complete Valuation workflow
Full NOI reconstruction, selected comps, alternative-use scenarios, data audit and PDF export.
Full NOI build-up · 6 steps
Sensitivity value band
Source audit · 6 inputs
PDF export
Analytics Standard · 5 reports
from $99/month
from $99/month
Summary
1
Valuation conclusion
Included free
Estimated market value
$270k
Value range
$243k – $297k
±10% around blend
Estimated value / SF
$64 / SF
Confidence
Property data
88
Market benchmarks
33
Comparable evidence
60
Income certainty
100
$243k
blend $270k
$297k
Market-derived valuation under stabilized market assumptions. Desktop analysis. No physical inspection performed.
2
Subject property
Included free
GBA
4,250 SF
Lot area
0.98 ac
Year built
1984
APN
003697-07-004
Zoning
C2
Assessed value
$21,186
Annual tax
$9,181
3
Income approach: direct capitalization
Partial preview
Estimated Stabilized NOI, derived from market rent, vacancy and expense benchmarks. Actual property income not reported.
Estimated market rent / SF
Potential gross income
Vacancy allowance
Effective gross income
Benchmark operating expenses
Stabilized NOI
Property tax
$9,181
Selected cap rate
4
Sales comparison
Partial preview
Too few qualifying comparables for a sales-approach estimation.
5
Sensitivity & risk
Partial preview
Downside
−10%
Base
$270k
Upside
+10%
Bounds of the ±10% band vs the blend — never simulated scenarios.
6
Current market position
Included free
Benchmark
Observed band ($/SF)AverageSubject delta
County 66 sales
$240
-74%
Band = middle half (Q1–Q3) of recorded sale $/SF for this use type per geography; the diamond marks the subject at $64/SF. Delta below average reads as headroom. Source: Realmo CRE sales derivatives (county records).
7
Data & methodology
Included free
Building area
County record
Property tax
County record
Assessed value
County record
Zoning designation
County record
Operating expenses
Modeled
Market rent
Market benchmark
Not analyzed due to unavailable source data: actual rent roll, tenant leases, physical condition and capital
requirements are outside a desktop analysis.
Cost Approach excluded: income and sales evidence cover the value conclusion.
Automated valuation analysis, not a licensed appraisal. Figures are derived from public
records and proprietary models. Desktop analysis: no physical inspection, tenant leases or reported
property income. Verify with a licensed appraiser before transacting.
Cap rate
Cap rate calculated from real income and expense signals, benchmarked against sales of similar assets nearby.
17% off on annual
Unlock the complete Cap Rate workflow
Full market tables, editable assumptions, comparable evidence, saved work and exports.
9-scenario matrix
NOI build-up · 9 steps
Market rates by use type
PDF export
Analytics Standard · 5 reports
from $99/month
from $99/month
Overview
Selected market yield
8.08%
Selected cap rate for this turn key restaurants
Derived from the Columbia market rent, vacancy and expense benchmarks for this use type.
Lower yield / higher price
Higher yield / lower price
5.0%
This property · 8.08%
9.0%
NOI (est.)
$89k *
Last sale · Sep 2022
$290k
* derived from a real price signal at a 7% cap
Price sensitivity
The rate is the decision lever; valuation is the consequence.
Test a cap rate
Implied value$1.10M
Move the market yield to see immediate price impact.
Value / SF
$259
Vs. selected
Base
Derivation
NOI ÷ cap
Arithmetic over the derived NOI * — not market scenario modeling.
NOI × cap matrix
Preview
Preview of 9 modeled outcomes.
NOI
7.58%8.08%8.58%
$80k
$1.06M
$990k
$932k
$89k
$1.17M
$1.10M
$1.04M
$98k
$1.29M
$1.21M
$1.14M
NOI sensitivity ±10% across the selected-rate band (±0.5 pp) — derivation of the NOI above.
Property tax & assessments
Tax year 2023Property tax & assessments
Tax year 2023
Tax billed
$9,181
Tax year 2023
Assessed value
$21,186
Assessed 2023
Previous assessed
$21,186
+0.0% YoY
Effective rate
43.34%
On assessed value
Assessed land
$7,944
Assessed improvement
$13,242
Land market value
$132,400
Improvement market value
$220,708
Total market value
$353,108
Applied tax rate
5.0000
Automated cap rate analysis. Based on public records, market benchmarks and proprietary
models. Verify with a licensed professional before transacting.
Property description
Physical attributes from public recordsBuilding & lot
Public records
Property type
Turn key restaurants
Use group
RESTAURANT
Status
For Sale
Year built
1984
Heating
CENTRAL
Bathrooms
3
Total area
4,250 SF
Lot
0.98 ac (42,689 SF)
Zoning code
C2
APN
003697-07-004
UPID
US77-0585526
Jurisdiction
LEXINGTON
Zoning & alternative use
C2 · Columbia, SCZoning C2 · permitted uses
C2 · Columbia, SC
Permitted & conditional uses
Allowed uses · Special-permit conditions · Prohibited uses
Building & site characteristics
From public records
Year built
1984
Heating
CENTRAL
Bathrooms
3
Lot
0.98 ac
Zoning
The recorded zoning designation, what the district officially allows, and the municipal source it comes from.
Zoning designation
County-recorded code
C2
Jurisdiction
Columbia, SC
Recorded code
C2
Zoning Insight
What can be built and operated here — officially.
The district profile from the municipal source: what is on file for C2 in Columbia, SC.
What opens after registration
Zoning profile
3 official documentsVerified municipal sources with file download
Match provenanceAssignment basis, match tier and confidence
Private report access
See the official zoning profile for this address.
Registration is required before the official district profile is shown.
One complete report on every paid plan · 5 · 30 · 100 reports per month.
Ownership Intelligence
Find the owner behind the property.
Unlock the evidence behind ownership: portfolio, transactions, debt and signals that help you decide who to contact next.
What opens after registration
Ownership report
Owner identityResolved entity and name variants
Portfolio holdingsLinked properties and estimated value
Deal signalsSell-side activity worth following
Debt & historyRecorded loans and transaction history
Private report access
See the ownership record for this address.
Registration is required before any owner information is shown.
One complete report on every paid plan · 5 · 30 · 100 reports per month.
Owner of record and activity signals are derived from public records and modeled classifications.
They do not confirm beneficial ownership or intent to transact.
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?”
Full reports are paid
Unlock the full Property Analytics report
Pick a plan to open full owner contacts, all 4 valuations with methodology, the refine flow, comparable adjustments, the foot-traffic deep dive and PDF / CSV export. Cancel anytime.
