CashFlowRE
Sign in Sign up
No image
Duplex
B- Composite 68.36
Why this score? — see what drove the B- grade

The composite is a weighted blend of 9 inputs, each scored 0–100. Each bar is that input's sub-score; the figure is the points it added to the 100-point composite (weight × sub-score).

  • Cash flow +29.7/30.0
  • DSCR +10.0/10.0
  • ARV discount +7.5/15.0
  • 1% rule +7.4/10.0
  • Livability +4.2/5.0
  • Rent growth +4.0/5.0
  • Schools +3.1/10.0
  • Condition / age +2.5/5.0
  • Appreciation +0.0/10.0

$350,000

1601-1603 S Handley Pl · Columbia, MO 65203
6 bd · 4.0 ba · 3,500 sqft · MultiFamily public records · 1 Days on market
Built 1987 7,551 sqft lot

🖨 Deal sheet 📄 Offer letter ✓ Due diligence

Multi-family units

County records classify this as Multi-Family (2-4 Unit). Listing-text estimate: 2 units. confirmed

Key facts

  • 7,551 sq ft lot
  • Built 1987

Neighborhood map

Property Rental comp Retail Transit Schools Stadiums Fortune 500 · Circle radius: 3.0 mi
Loading POIs…

What this means for you Summary

Snapshot

  • This is a 2 × 3-bed/?-bath units multifamily listed at $350k.

Deal economics

  • At list price, monthly cash flow is $1k ($15k/yr) — positive. Per door: $636/mo.
  • The deal already cash-flows at list — no discount required.
  • Meets the 1% rule at list price ($4k rent vs $350k).
  • Cap rate 10.7% vs local median 2.9% in Columbia — top-decile yield for the area; either an underpriced asset or a hidden risk that comps aren't pricing in. Stress-test before assuming the spread holds.

Location & tenants

  • Location reads 83/100 on livability (#9 in MO, #862 nationally) — a professional / high-income tenant draw. Strengths: amenities A+, commute A+, cost of living A+; Watch: crime D+.
  • Columbia 93 (urban): math 30% / reading 43% proficiency, ranked #194 of 324 in MO (top 60%) — families likely to look elsewhere, expect single-tenant / working-renter base with shorter leases.
  • Zoned schools: Fairview Elem. (math 42% / reading 52%, grade D-, #347 of 1,115 statewide, top 35%, 468 students, 28% FRL); David H. Hickman High (math 27% / reading 55%, grade F, #236 of 521 statewide, top 45%, 2,044 students, 33% FRL) — zoned schools at 31% FRL track the district average.
  • Market conditions: Rents rising fast (+6.1%/yr); 459 active listings in the ZIP; solid renter incomes; 1,303 units permitted in Boone County in 2024 (549 in 5+ unit buildings).
  • At $4,333/mo this rent would consume 65% of the median local household income ($80k/yr) (locally 1991% of renters already pay >50% of income on rent) — very limited rent-growth headroom before tenants either downsize or default.

Forward outlook

  • Local home prices are declining (-3.0%/yr); year-one equity from $2k of loan paydown is wiped out by about $10k of value loss. Plan a longer hold.
  • Boone County population projected at +36% by 2050 — long-run rental-demand tailwind backs the buy-and-hold thesis.
  • At projected returns (-3.0% appreciation + 6.1% rent growth), your $98k cash investment doubles in ~7 years — after that, you're playing with house money.

Negotiation context

  • Only 1 days on market — expect competitive offers; lowballing is unlikely to land.
Recommended offer $350,000

Questions for the listing agent

  1. Can we see the unit-by-unit rent roll, current vacancy, and any below-market leases? What's the average tenancy length?
  2. What capital expenditures (roof, boiler, parking lot, exteriors) have been made in the last 5 years, and what's planned in the next 2?
  3. Is there a deadline driving the sale (1031 exchange, divorce, estate, relocation)? That informs how much negotiation room exists.
  4. Schools are B-rated — typically a magnet for longer-tenancy family renters. What's the average tenant stay here, and is there a school-zone premium baked into asking?
  5. Crime grade is D in this area — have there been break-ins, vandalism, or insurance claims at this property in the last 3 years? What carrier currently insures it and at what premium?
  6. What's the average days-on-market for RENTAL listings here right now (not sales)? A rising rental-DOM trend means longer vacancies and softer asking-rent achievability than the comps imply.
  7. What's the recent tenant-quality profile in this submarket — average credit score on applications, eviction rate, late-payment / NSF rate, and stable-employment percentage? A property-management company in the area should have these aggregated.
  8. How much new apartment / multifamily construction is in the pipeline within 1–3 miles? Heavy new supply (>2% of stock underway) typically softens rents 12–24 months out; light construction supports rent growth.

Investment metrics

1% rule
1.24%
Cap rate
10.66%
Cash-on-cash
15.59%
DSCR
1.69
GRM
6.7

CMA / ARV

No comps found within radius.

Projected returns pro-forma

-3.0% appreciation · 6.09% rent growth · sell at horizon

5-year hold
IRR
9.6%
Equity multiple
1.39×
Total profit
$38,138
Equity at exit
$52,186
10-year hold
IRR
21.0%
Equity multiple
3.02×
Total profit
$197,916
Equity at exit
$30,262

Cash invested: $98,000 (down + closing). Projections, not guarantees.

Landlord ↔ Tenant lean methodology

Overall (STATE)
81 Strongly Landlord-Friendly
State Missouri
81 Strongly Landlord-Friendly · R+10
County
— inherits STATE
City
— inherits STATE
Generally landlord-friendly; St Louis has some habitability requirements.

ZIP-level market 65203

Rents YoY
6.1%
Active inventory
459
Price-to-rent
13.5×

Monthly cashflow live

Estimated rent
$4,333 high interval (Pro) →
Mortgage (P&I)
$1,835
Tax from tax record
$169 /mo · $2,028/yr
Insurance
$146
HOA
$0
Vacancy / Maint / Mgmt
$910
Net cashflow
$1,273

Break-even live

Break-even rent $2,722
Max offer price $350,000
Occupancy floor 66%

2-unit breakdown (identical units grouped — click to expand)

UnitsBedsBathsEst. rent
Total (2 units) $4,333

UW: 25.0% down · 7.5% · 30yr · 1.5% tax · 5.0% vac · 8.0% maint · 8.0% mgmt

Financing live

Cash to close

Down payment
$87,500
Closing costs
$10,500
Reserves months
Total cash needed

Loan-product check · same deal, 3 products live

Conventional

25% down · 7.5% · 30yr

Down + closing
Monthly P&I
Monthly cashflow
DSCR
Eligible?

Personal DTI + credit; lowest rate.

DSCR

20% down · 8.5% · 30yr

Down + closing
Monthly P&I
Monthly cashflow
DSCR
Eligible?

No personal income docs; deal must DSCR.

Hard money

10% down · 12.0% · 12mo

Down + closing
Monthly P&I
Monthly cashflow
DSCR
Eligible?

Short-term bridge; refi at stabilization.

Listing history 2 events

  1. 2026-04-21
    status Pending
  2. 2026-04-21
    listed $350,000 Active

ⓘ Source: listings_history table (triggers on properties + properties_extension) + one-shot backfill from property_details.listing_events for pre-trigger history.

Tax reassessment forecast MO · Resets to sale price

Current annual tax
$2,028 · $169/mo
Projected year-2 tax
$3,395 · $283/mo
Expected delta
+$1,367/yr (+$114/mo · 67.4%)

ⓘ Screening estimate from a state-policy table — verify with the county assessor before closing.

Climate risk First Street

  • 🌊 Flood 1/10 Low FEMA zone X (unshaded) · 0% chance over 30 yrs
  • 🔥 Wildfire 1/10 Low
  • 🌡 Heat 4/10 Moderate 7 d/yr ≥107°F today · 19 d/yr by 30 yrs out
  • 💨 Wind 2/10 Low
  • 🫁 Air quality 2/10 Low 1 unhealthy d/yr today · 1 by 30 yrs out

Nearby sold comps map

Loading sold comps map…

Walkable amenities ~0.75 mi

Loading nearby amenities…

Taxation est. · year 1

Rental income
$51,996
− Mortgage interest
−$19,605
− Property taxes
−$2,028
− Insurance
−$1,750
− Repairs & maintenance
−$4,160
− Management
−$4,160
− Depreciation
−$10,182
Taxable income
$10,111
combined federal + state — saved on this device
Est. tax owed @ 24.0%
−$2,427
After-tax cash flow
$12,847/yr

For passive investors: Depreciation is non-cash, so a rental often shows a tax loss while cash-flowing — sheltering income. Rental losses are passive: they offset passive income freely, and up to $25,000/yr can offset ordinary (W-2) income if you actively participate and your MAGI is under $100k (phasing out to $0 by $150k); unused losses carry forward. On sale, claimed depreciation is recaptured at up to 25%, and gains may owe capital-gains tax (a 1031 exchange can defer both). Figures are a year-1 estimate at your 24.0% rate — not tax advice; consult a CPA.

Schools (NCES district)

District
Columbia 93
NCES district ID
2901000
Math proficiency
30% ▼ -12.00%
Reading proficiency
43% ▼ -4.00%
Median HH income
$46,547
Composite
31.21/100
National rank
#6036
State rank
#194 of 324 in MO

Livability — Columbia

Score
83/100
State rank
#9
US rank
#862

Category grades

Amenities A+ Commute A+ Cost of living A+ Crime D+ Employment C+ Housing A+ Health & safety A+ User ratings F

Schools grade is shown separately in the Schools card above.

Census & demographics

Census place
Columbia, MO
County
Boone County · 158,877 people
City population
158,877
Metro
Columbia, MO
Population (ZIP)
61,539
Household income
$79,960
Rent vs Own
37.9% rent · 62.1% own
Severe rent burden
1991.0

Population outlook (Boone County) Hauer SSP2

Today (2025)
202,891 people
By 2030
217,799 · +7.3%
By 2040
246,789 · +21.6%
By 2050
276,116 · +36.1%
By 2075
348,426 · +71.7%
By 2100
400,856 · +97.6%

Race, ethnicity, and origin ACS 2023

Neighborhood character
Predominantly White (77%)
Race & ethnicity
White 77% Black 9% Asian 6% Two or more races 5% Hispanic / Latino 3%
Common ancestry
Italian 3% Slovak 2% Romanian 2%
Foreign-born
7% · China, South Korea, Canada
Languages at home
91% English-only · Chinese 2% Spanish 2% Korean 1%

Political lean MEDSL · Boone

2024 margin
Lean D (+9.8) · D 53.9% · R 44.1% · Other 2.1%
2008→2024 swing
-2.2pp toward R · 2008: 12.0pp · 2024: 9.8pp
All cycles
2024: D+9.8 2020: D+12.5 2016: D+5.9 2012: D+3.1 2008: D+12.0

Not yet ingested

Civics

Market trends

HPI YoY
▼ -274.18%
Current HPI
194.3615
Rent YoY
▲ 6.09%
Metro
Columbia, MO
State GDP YoY
▲ 1.84%
F500 in state
20

Industry mix (Fortune 500 HQ in MO)

Industry F500 HQs Revenue

Price history

2 events — show timeline
  • 2026-04-21 Pending CBORMLS
  • 2026-04-21 Listed $350,000 CBORMLS

Property tax history

+2.0%/yr

Latest (2025): $2,028 · +6.8% YoY. Source: county tax records.

Cash-flow waterfall

monthly

Sold comps — $/sqft

last 12 mo · ≤1 mi

Loading sold comps…