At the June 2026 endpoint, this ZIP opens with an important cross-market tension: its reported Zillow ZORI is $1,776 per month, up 1.01% from a year earlier, while the direct Redfin ZIP resale observation reports a $264,840 median sold price that is 6.14% lower than the prior-year reading. Annualizing the ZIP ZORI and dividing by that sold-price median produces an 8.05% cross-source screening ratio. That arithmetic can juxtapose current asking-rent conditions with resale pricing, but it is not a cap rate, net return, expected return, or property yield. The rent index concerns asking rents, whereas Redfin records for-sale closings; neither series supplies rental transaction economics for an individual property.
History frames the split as cooling rather than a proven reversal. Exact same-month annualized ZIP ZORI changes were 1.01% over one year, 3.24% over three years, and 5.69% over five years. Thus, the most recent direction confirms a still-positive longer path but breaks from its faster long-run pace. The backward-looking series has 2.95% annualized monthly-return variability, a -3.19% maximum drawdown, and 99.28% coverage. Its transparent national discovery ranks are 1,475 for momentum, 1,532 for stability, and 1,599 for balance among history-eligible ZIPs, where a lower rank is higher. These are descriptive historical measurements, not forecasts or investment recommendations; the variability and drawdown mean any current rent snapshot needs the surrounding path for context.
The label has a crucial boundary condition: 29229 is both Zillow's ZIP market identifier and the matching Census ZCTA, but a ZCTA is a statistical area and is not identical to a USPS delivery ZIP. Zillow ZORI is a typical observed asking-rent index blended across rental types. In contrast, the ACS 2024 five-year survey reports a $1,640 median gross rent for occupied renter homes, with a $150 margin of error, and gross rent includes selected utilities. The ZIP asking index is 8.29% above that ACS figure. The FY2026 local HUD FMR/SAFMR two-bedroom standard is $1,276, and ZORI is 39.18% above it; this is an administrative bedroom-specific standard, not asking rent.
The local HUD bedroom ladder is the scaling basis for the bedroom view. Scaling ZIP ZORI by that ladder yields modelled monthly ZIP estimates of $1,436 for a studio, $1,620 for one bedroom, $1,776 for two bedrooms, $2,259 for three bedrooms, and $2,660 for four bedrooms. These estimates are modelled allocations of an all-rental-type ZIP index using HUD's local bedroom relationship; they are never measured bedroom rents, advertised comps, or a substitute for an actual unit's quoted rent. The different HUD and ZORI levels therefore do not establish an error in either universe.
Income and burden show a second tension. The ZCTA's ACS median household income is $74,043. Applying a 30% share to annualized ZORI produces a required income of $71,040 and an asking-rent-to-income screen of 28.78% at that ZIP median. This is arithmetic, not advice and not an applicant qualification rule. Yet 60.75% of ACS occupied renter households are recorded above the burden threshold. The screen uses a ZIP-wide median-income benchmark and current asking index; the burden measure covers surveyed occupied renter homes and gross rent. It cannot establish the affordability of a particular household or unit.
Housing stock tempers any broad availability conclusion. The matched ZCTA contains 21,485 housing units, a 6.34% vacancy rate, and a 29.89% renter share; these are area-level counts and shares, not a count of units currently available at a desired rent or bedroom size. In the same sentence, the ZIP's $1,776 ZORI sits above the City of Columbia city-scope rent context at $1,478, the Richland County county-scope rent context at $1,502, and the Columbia, SC metro-scope rent context at $1,555. Those city, county, and metro figures are wider-scope context, not substitutes for the ZIP asking index, ZCTA survey, HUD standard, or a property-level availability measure.
The resale tape also gives direct ZIP liquidity detail without becoming rental evidence. In the rolling three-month Redfin observation, 270 homes sold, median marketing time was 40 days, and inventory was 226 homes, equal to 2.5 months of supply. The average sale-to-list figure was 98.98%, 20.17% of sales closed above list, and 31.65% went off market within two weeks. Each signal belongs to the for-sale/resale universe, not rental transactions. The lower sold-price reading is consistent with the history's cooling interpretation more than a strong-rent-acceleration story, even though ZORI was still up from a year earlier; it does not resolve affordability for any home.
Limits matter most at the property level. A ZCTA survey and ZIP asking index should not be assigned to a specific address; modelled bedroom figures must be checked against actual advertised rent, bedroom count, lease term, included utilities, availability date, and concessions. On the for-sale side, reconcile a candidate property's list price, sale status, close date, home type, and current inventory alternatives with the direct ZIP resale measures. Verify whether a vacancy is offered for rent rather than for sale, seasonal, or otherwise unavailable. Neither area vacancy nor renter burden proves an individual unit's condition, price, or tenant outcome. Which source-defined measure actually matches the decision being examined?