2208-2210 Shamrock DrColumbiaMO65202



INVESTMENT ANALYSIS
Investment Verdict
Income-ProducingCapital preservation and steady income define 2208-2210 Shamrock Dr, Columbia, MO, 65202 in Columbia. Rental yield 6.55%. The 1.21 coverage passes Ziffy Mortgage's DSCR threshold for non-U.S. residents. Five-year appreciation of $96,699 and $3,224/yr in principal reduction project total return of $115,387.
| This Property | City Avg | |
|---|---|---|
| Gross Rental Yield | 6.6% | 6.8% |
| Monthly Cash Flow | $(271) | $1,420 |
City averages based on Columbia market data in our database. Property projections are estimates.
DSCR Loan Qualification
| Monthly Rental Income | $1,909 |
| Total Monthly Debt Service | $2,040 |
| DSCR Ratio | 0.94x |
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.
Multi Family
Built in 2002
0.29 Acres lot
$N/A/sqft
No HOA
Neighborhood Data
Neighborhood data shown for ZIP Code: 65202, Columbia, MO area.
Housing Distribution
Housing Statistics
| Category | Value |
|---|---|
| Total HU (Housing Units) | 22,464 (100%) |
| Owner Occupied HU | 12,818 (57.1%) |
| Renter Occupied HU | 7,973 (35.5%) |
| Vacant Housing Units | 1,673 ( 7.4%) |
| Median Home Value | $230,096 |
| Average Home Value | $280,896 |
Housing Distribution
Address Breakdown
Residential
21,110
Single Family
20,925
Multi-Family
185
Businesses
931



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


Multi Family
Built in 2002
0.29 Acres lot
$N/A/sqft
No HOA
Neighborhood Data
Neighborhood data shown for ZIP Code: 65202, Columbia, MO area.
Housing Distribution
Housing Statistics
| Category | Value |
|---|---|
| Total HU (Housing Units) | 22,464 (100%) |
| Owner Occupied HU | 12,818 (57.1%) |
| Renter Occupied HU | 7,973 (35.5%) |
| Vacant Housing Units | 1,673 ( 7.4%) |
| Median Home Value | $230,096 |
| Average Home Value | $280,896 |
Housing Distribution
Address Breakdown
Residential
21,110
Single Family
20,925
Multi-Family
185
Businesses
931
Nearby investment properties with comparable rents
Nearby investment properties with comparable prices



Listed by: Natalie Wier • Central Missouri Real Estate
Mls Name: CBORMLS
Mls Provider:
Mls ID: #427880
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.








