Columbia’s Zillow ZHVI typical home value is $330,373 and ZORI typical observed market rent is $1,424 a month. That implies a 5.2% gross yield before every operating cost, debt service and vacancy. These are current Zillow measures, not a forecast. The ZHVI is 5.0x ACS median household income, while annual ZORI equals 25.7% of that income, framing acquisition and rental affordability at the city level.
City housing stock totals 56,054 units, with 51.3% of occupied units renter-occupied and a 6.2% citywide vacancy rate. Single-family units account for 59.3% of all units, versus 10.7% in large multifamily buildings. ACS surveyed occupied housing reports a $284,600 median owner-reported home value and $1,097 median gross rent, which includes selected utilities. Those ACS measures differ in population, definition and period from Zillow’s typical value and observed market rent, so they should not be combined.
Among city renters for whom burden is determined, 51.0% spend at least 30% of income on gross rent. Of vacant city units, 39.8% are classified as for rent, but vacancy reasons and structure shares do not measure investable inventory or leasing speed. Population is 128,548, up 6.0% between overlapping ACS vintages; that change is not annualized and may reflect boundary changes. Median household income is $66,498, while poverty is 19.3% and unemployment 4.0%, descriptive demand constraints rather than causes.
At the county scope, Boone County shows a 44-day median listing time and a 23.8% price-reduced share among active listings, useful for negotiating context but not city transaction evidence. The broader Columbia metro had 1.8 months of supply and year-over-year job growth of 1.2%, which informs market liquidity and demand context without measuring city outcomes. The national Freddie Mac 30-year mortgage rate was 6.58%, a financing benchmark rather than a Columbia borrowing quote.
Underwriting remains limited by citywide aggregates, mixed measurement systems and wider geographies that cannot identify a property’s achievable rent, condition, expenses, taxes, insurance, financing or resale liquidity. Next, verify the target’s legal use, unit mix, lease roll, concessions, utility responsibility, maintenance and capital needs; obtain property-specific tax and insurance quotes; inspect flood and climate exposure; and test debt coverage and cash flow with realistic vacancy, management, repairs and replacement reserves. Comparable closed sales and signed leases should anchor the final decision.