5620 Lightpost DrColumbiaMO65201



INVESTMENT ANALYSIS
Investment Verdict
Appreciation PlayMarkets with strong demand fundamentals often produce low-yield, high-appreciation assets. 5620 Lightpost Dr, Columbia, MO, 65201 in Columbia fits: $1,575,000, 1.68% gross yield, and a projected 5% annual appreciation rate adding $435,143 in value within five years. Rental yield 1.68%. The narrow rent-to-debt spread is the trade-off for market growth. Ziffy Mortgage's DSCR loan (0.31) finances non-U.S. buyers without personal income documentation; optimise coverage with a 30–35% down payment. $14,506/yr in principal paydown and $435,143 in appreciation project a total return of $100,705.
| This Property | City Avg | |
|---|---|---|
| Gross Rental Yield | 1.7% | 6.8% |
| Monthly Cash Flow | $(7,728) | $1,420 |
City averages based on Columbia market data in our database. Property projections are estimates.
DSCR Loan Qualification
| Monthly Rental Income | $2,201 |
| Total Monthly Debt Service | $9,302 |
| DSCR Ratio | 0.24x |
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 2025
0.82 Acres lot
$N/A/sqft
$120 monthly HOA
Neighborhood Data
Neighborhood data shown for ZIP Code: 65201, Columbia, MO area.
Housing Distribution
Housing Statistics
| Category | Value |
|---|---|
| Total HU (Housing Units) | 22,582 (100%) |
| Owner Occupied HU | 6,281 (27.8%) |
| Renter Occupied HU | 13,910 (61.6%) |
| Vacant Housing Units | 2,391 (10.6%) |
| Median Home Value | $312,605 |
| Average Home Value | $358,527 |
Housing Distribution
Address Breakdown
Residential
20,008
Single Family
15,512
Multi-Family
4,496
Businesses
1,763



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 2025
0.82 Acres lot
$N/A/sqft
$120 monthly HOA
Neighborhood Data
Neighborhood data shown for ZIP Code: 65201, Columbia, MO area.
Housing Distribution
Housing Statistics
| Category | Value |
|---|---|
| Total HU (Housing Units) | 22,582 (100%) |
| Owner Occupied HU | 6,281 (27.8%) |
| Renter Occupied HU | 13,910 (61.6%) |
| Vacant Housing Units | 2,391 (10.6%) |
| Median Home Value | $312,605 |
| Average Home Value | $358,527 |
Housing Distribution
Address Breakdown
Residential
20,008
Single Family
15,512
Multi-Family
4,496
Businesses
1,763
Nearby investment properties with comparable rents
Nearby investment properties with comparable prices



Listed by: Bennett Arey • Arey Real Estate
Mls Name: CBORMLS
Mls Provider:
Mls ID: #426690
Disclaimer: IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.








