Columbia County presents a cash-flow-versus-exit-liquidity tension: Zillow’s county observation labeled 2026-06 puts median home value at $274,669, while measured median asking rent is $1,546 per month and stated gross yield is 6.75%. Investors seeking durable income should investigate, while buyers relying on rapid resale should be cautious. Zillow’s value change is 0.13%, whereas the 2025 FHFA repeat-transaction HPI rose 5.89%. Those are different vintages and methods, so they cannot be combined into one appreciation reading.
Because market asking rent is published, the gross yield is computable, but it is neither NOI nor a cap rate. HUD’s two-bedroom FMR is a payment standard, not an asking-rent estimate; it cannot replace measured rent in this analysis. The effective property-tax rate is 0.74%, a known carrying cost against value and rent. Insurance, maintenance, vacancy, utilities, financing terms and assessment detail are not published, preventing net-cash-flow, debt-coverage and parcel-tax underwriting.
Realtor.com’s separately labeled 2026-06 MLS listing-market evidence shows 87 median days on market, 25.36% of listings price-reduced, and a 29.83% pending-to-active ratio. These are asking-market supply, marketing-time and concession indicators, rather than closed-sale prices or standalone proof of demand. QCEW’s separately sourced 2025 annual average records 24,823 covered jobs at county workplaces, not resident employment or an unemployment measure; Trade, transportation, and utilities is the largest disclosed private supersector. Net migration of 288 tax-return households coincides with a $7,714 positive incoming-versus-outgoing average AGI gap. The stated 4.72% investor share alongside 615 total purchases signals visible but limited recorded non-occupant competition.
Inland flood is the dominant hazard, and modeled expected annual climate loss equals 0.17% of building value; that county-level model does not establish a property’s flood exposure, insurance availability or deductible. Next checks are parcel flood-zone and elevation records, insurance quotes, closed-sale comparables, lease-level rents and occupancy, operating expenses, and financing terms. Without them, the income thesis, resale liquidity and risk-adjusted return cannot be underwritten.