2820 Duncan StColumbiaSC29205
INVESTMENT ANALYSIS
Investment Verdict
Appreciation Play2820 Duncan St, Columbia, SC, 29205 in Columbia is priced for appreciation, not yield. Rental yield 4.54%. At $499,900 with a 4.54% gross yield, the monthly income is modest, but 5% annual price growth is projected to add $138,113 in value over five years, making equity the primary return driver. Ziffy Mortgage's DSCR mortgage (0.84) can still finance this property for non-U.S. residents; a 30–35% down payment typically produces the cleanest underwriting for appreciation-focused assets. Total projected cumulative return: $119,286.
| This Property | City Avg | |
|---|---|---|
| Gross Rental Yield | 4.5% | 4.8% |
| Monthly Cash Flow | $(1,428) | $850 |
City averages based on Columbia market data in our database. Property projections are estimates.
DSCR Loan Qualification
| Monthly Rental Income | $1,892 |
| Total Monthly Debt Service | $2,777 |
| DSCR Ratio | 0.68x |
Ziffy Mortgage typically prefers a DSCR of 1.0+, but in some cases you may qualify with a DSCR below 1. To explore if this deal qualifies for an investment mortgage, book time with your loan officer →
Estimates assume 6.0% rate / 30-yr fixed, 30% down, 1% tax, 0.5% insurance. Not a commitment to lend.
Single Family
Built in 1938
10,454 sqft lot
$N/A/sqft
No HOA
Neighborhood Data
Neighborhood data shown for ZIP Code: 29205, Columbia, SC area.
Housing Distribution
Housing Statistics
| Category | Value |
|---|---|
| Total HU (Housing Units) | 13,610 (100%) |
| Owner Occupied HU | 6,798 (49.9%) |
| Renter Occupied HU | 5,092 (37.4%) |
| Vacant Housing Units | 1,720 (12.6%) |
| Median Home Value | $346,573 |
| Average Home Value | $420,577 |
Housing Distribution
Address Breakdown
Residential
12,188
Single Family
10,741
Multi-Family
1,447
Businesses
780
Nearby investment properties with comparable rents
Nearby investment properties with comparable prices
Ziffy AI Summary
A quick, investor-focused snapshot highlighting income strength, yield potential.
| Key metrics | Value |
|---|---|
| Price | $399,900 |
| Est. Rent | $3,200/mo |
| ROI | 18% |
- Attractive rent-to-price ratio for income stability
- Good fit for DSCR financing with healthy coverage
Single Family
Built in 1938
10,454 sqft lot
$N/A/sqft
No HOA
Neighborhood Data
Neighborhood data shown for ZIP Code: 29205, Columbia, SC area.
Housing Distribution
Housing Statistics
| Category | Value |
|---|---|
| Total HU (Housing Units) | 13,610 (100%) |
| Owner Occupied HU | 6,798 (49.9%) |
| Renter Occupied HU | 5,092 (37.4%) |
| Vacant Housing Units | 1,720 (12.6%) |
| Median Home Value | $346,573 |
| Average Home Value | $420,577 |
Housing Distribution
Address Breakdown
Residential
12,188
Single Family
10,741
Multi-Family
1,447
Businesses
780
Nearby investment properties with comparable rents
Nearby investment properties with comparable prices