Franklin city presents a mixed-entry case: Zillow’s 2026-06 median home value rose 2.93% year over year, while FHFA’s repeat-transaction HPI fell 1.71% in annual 2025. These are different vintages and methods, so they should not be blended. Investors needing stable, demonstrable cash flow should be cautious; investigators should test whether Zillow’s direction reflects the property types they could actually buy.
At Zillow’s $237,094 median value, market rent is not published, so gross yield cannot be computed. HUD’s $1,051 FMR is a payment standard, not an asking-rent estimate, and cannot fill that gap. The 0.71% effective property-tax rate provides a county-level tax reference but does not establish a subject property’s assessment, insurance, repairs, financing cost, or net operating income. Rent rolls and property-specific tax and insurance quotes are required before reaching a carrying-cost conclusion.
Demand evidence is narrow rather than uniformly supportive. QCEW’s 2025 annual average recorded 3,901 covered jobs at county workplaces, down 2.03%; this is neither resident employment nor an unemployment measure. Education and health services, the largest disclosed private supersector, represented 39.17% of private covered jobs, a concentration to examine rather than a full-economy description. Tax-return migration was positive by 26 households, and inbound movers’ average income exceeded outbound movers’ by $5,210; those facts do not prove tenant demand. Non-occupant purchase mortgages accounted for 10.67% of 150 purchases, indicating measurable buyer competition but not pricing power.
Hurricane is the dominant hazard, and modeled annual climate loss equals 0.16% of building value; it is a modeled ratio, not a dollar forecast or insurance quote. Realtor.com MLS listing price, active inventory, days on market, and price-reduction data are not published, preventing a read on visible supply, asking-price concessions, and marketing time. Next checks are subject-level flood and wind exposure, coverage terms, current achieved rents and vacancy, and comparable closed transactions; without them, neither exit liquidity nor property-level cash flow is established.