Columbia County’s tension is a usable pre-cost yield screen against MLS conditions that require transaction-level checks. Investors able to test rent, taxes and flood exposure should investigate; buyers relying on quick resale or a county average should be cautious. In Zillow’s 2026-06 county observation, median home value was $334,870 and median asking rent $1,792 per month, for the supplied 6.42% gross yield; value and rent rose 1.76% and 1.19%. FHFA’s annual 2025 repeat-transaction HPI rose 4.71%. It confirms positive direction, but is not a home value and cannot be merged with Zillow into one growth rate.
Yield uses measured market asking rent before costs. HUD’s two-bedroom FMR is a payment standard, not an asking-rent estimate; it cannot support rent or yield inference. The effective property-tax rate is 0.82%, a recurring cost. Insurance, flood premiums, maintenance, financing, vacancy, collections and parcel assessments are not published, preventing net-yield, debt-service and property-specific tax conclusions.
Realtor.com’s matching-period MLS evidence shows softer visible supply, not closed-sale demand: 795 active listings were up 27.61%, median listing prices were down 4.42%, and 17.18% of listings had price reductions. These are inventory, asking-price and seller-concession measures; closed sales and buyer absorption are not published. QCEW’s annual series shows covered employment at county workplaces increased; Trade, transportation, and utilities is the largest disclosed private supersector, not the whole economy or resident labor market. Net migration was positive, but incoming moving households had lower average AGI than outgoing households. The record reports 2,577 purchases and a 6.21% investor share, neither identifies competition for a particular neighborhood or property type.
Inland flood is the dominant hazard, and modeled climate loss equals 0.13% of building value per year. That model aligns the risk screen with the stated hazard but is not a parcel damage history, flood-zone determination, insurance quote or coverage-availability finding. Next checks are parcel flood elevation and history, insurance terms, executed lease comparables, closed sales, and assessment records; without them, rent resilience, exit pricing and net carrying cost cannot be underwritten.