Columbia County presents a narrow underwriting tension: Zillow’s county median home value is $454,910, down 0.8% in 2026-06, while FHFA’s repeat-transaction HPI rose 0.18% in separate 2025 data and gained 35.21% cumulatively over five years. FHFA is an appreciation index, not a home value; its vintage and method should not be averaged with Zillow. The thesis is selective: income-focused buyers should investigate, while appreciation-dependent or thin-margin buyers should be cautious.
Median asking rent is $1,763 per month, up 5.41%, and supplied gross yield is 4.65% before operating costs, financing, vacancy, and capital items. HUD’s $1,922 two-bedroom FMR is a payment standard, not asking rent; market rent is 91.7% of it, so FMR cannot upgrade the rent estimate. Property tax is 0.74%, with median annual tax of $3,137. Insurance and property-level expenses are missing, preventing a net-cash-flow conclusion.
Demand evidence is mixed. Realtor.com’s 2026-06 MLS record has listing prices down 0.65%, active listings up 17.34%, and median marketing time at 61 days; these are asking-market and marketing signals, not closed-sale prices or proof of demand. QCEW’s 2025 record shows improving covered employment and wages, but measures workplace jobs, not resident employment; its largest disclosed private supersector, trade, transportation, and utilities, is only one economic segment. Positive net migration and higher inbound mover income merit review, while low investor participation relative to total purchases argues against assuming investor-led competition.
Risk limits are material. Inland flood is the dominant hazard, and modeled annual building-value loss is 0.23%; the model supplies no parcel flood zone, insurance quote, deductible, mitigation condition, or financing treatment. The record also lacks closed-sale comps, unit-level rent rolls, vacancy and expense history, and property-specific insurance. Next checks should verify address-level insurability, reconcile actual rent and expenses to the contract, and test resale liquidity against closed comparables. These gaps prevent a full risk-adjusted cash-flow or exit conclusion.