GemHausNew report
Boundary of ZIP code 29223

Market Snapshot

Median listing price
$233K

The median listing price in Columbia, SC ZIP 29223 is $233,450 as of November 2026.

Median rent
$1,675/mo

The median market rent in Columbia, SC ZIP 29223 is $1,675/month as of November 2026.

Days on market
33 days

The median days on market in Columbia, SC ZIP 29223 is 33 days as of November 2026. The market is currently cold.

Gross rental yield
8.61%

At a median list price of $233,450 and a median rent of $1,675/month, the gross rental yield in Columbia, SC ZIP 29223 is 8.61% as of November 2026.

STR vs LTR
$1,589/mo STR · $1,675/mo LTR

In Columbia, SC ZIP 29223, median Airbnb revenue is $1,589/month compared to median long-term rent of $1,675/month as of November 2026.

Columbia, SC 29223 Real Estate Market Report

ZIP Code: 29223

Report Date: November 2026

Market Temperature:COLD

Scope: This ZIP code analysis focuses on single-family residential (SFR) properties. Metrics are calculated from recent sales and active listings within the past 90 days.


Market Overview

This analysis is based on a sample of properties from this ZIP code (up to 200 sold properties and up to 100 active properties). The median prices below are calculated from all available properties in the sample, while trend analysis uses properties from the selected analysis window.

Analysis Window
90 Days
Total Properties Analyzed
152
Active Listings
152
Sold Properties
0

Market Metrics

Median Listing Price
$233,450
Median Sold Price
$229,500
Median Price per Sqft
$135/sqft

The property counts shown above represent only the properties analyzed in this report sample, not the total inventory for this ZIP code. Median prices are calculated from all available properties in the sample, while trend analysis uses properties from the selected analysis window.


Rental Market

Median Market Rent
$1,675

Property Taxes

Property Tax Rate
0.01%

Liquidity & Velocity

Median Days on Market
33
Sale-to-List Ratio
97.6%

Market Trends & Context

Understanding Market Temperature

A Cold market indicates weak buyer demand relative to available inventory, typically characterized by declining or flat prices, extended days on market, and elevated inventory levels relative to sales.

Price YoY Trend
down
Market Temperature
cold
Interest Rate Pressure
elevated

Current Mortgage Rate Context

Market-level mortgage rate comparison for this area:

Current market rates for 30-year fixed loans in Columbia SC are averaging 7.11%, reflecting a higher interest rate environment compared to earlier 2026 levels.

Note: Interest rate comparisons provide market context. The existing "Interest Rate Pressure" metric above shows the qualitative market impact.


Key Findings

  1. The median sold price of $229,500 is the primary indicator of recent market value and transaction activity in 29223; the down price year-over-year trend suggests pricing is softening.
  2. The median days on market of 33 indicates slower sales velocity, while the cold market temperature suggests buyers may have greater negotiating leverage and sellers may need realistic pricing and strong presentation.
  3. The median listing price of $233,450 is above the median sold price, which may indicate pricing friction between seller expectations and achieved transaction values; sellers should monitor buyer response and adjust positioning when necessary.
  4. The elevated inventory levels relative to sales activity suggest excess supply and slower liquidity across single-family residential and condominium properties; buyers may have more selection, while sellers should prioritize accurate pricing and market readiness.
  5. The elevated interest rate pressure, with current 30-year fixed loan rates averaging 7.11%, continues to constrain affordability and may dampen transaction activity; buyers should stress-test monthly payment capacity and sellers should account for rate-sensitive demand.

Notable Properties

The following 8 properties represent notable market examples and recent transactions that illustrate key market dynamics. These are illustrative examples selected for their significance (top sales, market benchmarks, quick sales) and are not the basis for the statistical calculations shown above.

Recent Transactions

112 Cricket Hill Rd, Columbia, SC 29223Top Sale

Highest sale in the past 90 days. Fully renovated with modern finishes and premium lot positioning.

4 beds3.5 baths3,864 sqft
$632,500
Oct 2026
$164/sqft
137 days on market
17 Olde Springs Rd, Columbia, SC 29223Premium

Sold above market average

4 beds3 baths3,234 sqft
$529,000
Oct 2026
$164/sqft
62 days on market
349 Oakbrook Village Rd, Columbia, SC 29223Market Benchmark

Representative market sale establishing baseline for properties in the core neighborhood.

4 beds2 baths1,992 sqft
$260,000
Oct 2026
$131/sqft
45 days on market
334 Liliana Dr, Columbia, SC 29223Market Benchmark

Representative market sale establishing baseline for properties in the core neighborhood.

3 beds2 baths1,912 sqft
$248,000
Oct 2026
$130/sqft
43 days on market
216 Olde Springs Rd, Columbia, SC 29223Market Benchmark

Representative market sale establishing baseline for properties in the core neighborhood.

3 beds2 baths1,768 sqft
$239,000
Oct 2026
$135/sqft
95 days on market
1027 Majestic Cir, Columbia, SC 29223Market Benchmark

Representative market sale establishing baseline for properties in the core neighborhood.

5 beds2 baths2,140 sqft
$210,000
Sep 2026
$98/sqft
15 days on market
306 Forestwood Dr, Columbia, SC 29223Value

Sold below market average

4 beds1 baths977 sqft
$82,000
Oct 2026
$84/sqft
93 days on market
309 Foxhunt Rd, Columbia, SC 29223Value

Below-market acquisition. Investor purchase with value-add potential through renovation.

4 beds1 baths1,184 sqft
$53,500
Oct 2026
$45/sqft
10 days on market

Investment Analysis

Compare rental income potential against ownership costs and benchmark against market averages.

Rent vs Cost to Own

Monthly rental income vs estimated ownership cost

$372/mo
29223 Avg Rent
29223 Cost to Own
Rent$1,675
Own$1,303

20% down, 7.11% rate, 0.0% tax

Short-Term Rental

Avg nightly rate and occupancy for this ZIP

29223 Avg nightly rate
29223 Avg occupancy (days/year)
Nightly rate$153/night
Occupancy201 of 365 days

Data Sources

Real estate market data & public records, and GemHaus® proprietary models.

Report generated: 11/13/2026

GemHaus

Get personalized market intelligence

Analyze properties in Columbia, SC with valuations, rental estimates, highest-and-best-use signals, and operating costs.

Nearby Market Reports