Active vs Sold Comps: When to Use Each

If you've been doing CMAs for any length of time, you already know that pulling comps isn't the hard part. The hard part is knowing which comps to lean on — and being able to defend that choice to a seller who just Zillow'd their house and came in $40,000 higher than your number.

Active and sold comps each tell a different story. Using the wrong one at the wrong time doesn't just weaken your CMA — it can cost your client a sale or leave money on the table. Here's how to think about each one strategically.

What Sold Comps Actually Tell You

Sold comps are the backbone of any defensible CMA. They represent what buyers actually paid — not what sellers hoped for, not what an algorithm estimated, but real, closed transactions with real financing, real appraisals, and real negotiation behind them.

When a home closes at $485,000, that number survived a lot of scrutiny: the buyer's offer, the seller's counteroffer, the inspection, and — critically — the appraisal. That's why lenders, appraisers, and courts all rely on sold data. It's verified market behavior.

When Sold Comps Should Drive Your Pricing

Listing appointments in stable or cooling markets. If appreciation has been flat or declining over the past 90 days, sold comps from the last 3–6 months are your most reliable anchor.
When your seller needs a defensible number for financing or estate purposes. Appraisers will use sold data. Your CMA should mirror that methodology.
Luxury or unique properties with low turnover. In a neighborhood where only 4 homes sold last year, you may need to go back 9–12 months. That's fine — just adjust for time.
Buyer representation. When writing an offer, sold comps tell your buyer what the market has actually supported. This is non-negotiable data for offer strategy.

The limitation: Sold comps are backward-looking. In a fast-moving market, a comp that closed 60 days ago might already be stale. A neighborhood where values jumped 8% in a quarter will make your sold data feel like ancient history.

What Active Comps Actually Tell You

Active listings show you where sellers think the market is right now. They reflect current seller sentiment, current inventory pressure, and current competition for buyers' attention.

Think of active comps as the market's asking price ceiling — or floor, depending on conditions. They don't tell you what buyers will pay, but they tell you what your listing will be competing against the day it goes live.

When Active Comps Should Influence Your Strategy

Rapidly appreciating markets. If homes in a subdivision went from $420K to $460K in 90 days, active listings priced at $465K–$475K may actually be conservative. Your sold comps are lagging reality.
Setting list price in a low-inventory environment. If there are only 2 comparable actives in the area and both are priced at $550K, pricing your listing at $510K based on sold data alone could leave real money behind.
Positioning conversations with sellers. Showing a seller what they're competing against helps frame price reductions, staging investments, and days-on-market expectations.
Pre-listing strategy. Before you advise on repairs or updates, knowing what active competition looks like tells you what level of finish the market is currently rewarding.

The limitation: Active listings haven't been tested. A home sitting at $625,000 for 47 days isn't a comp — it's a warning. Price reductions, extended DOM, and relisted properties are all signals that active pricing is disconnected from what buyers will actually close on.

The Real-World Formula: Use Both, Weight Appropriately

The most accurate CMAs don't choose between active and sold — they use both with intentional weighting based on market conditions.

Here's a practical framework:

In a Balanced Market (4–6 months of inventory)

Weight sold comps at roughly 70–75% of your pricing rationale. Use active comps to validate that your price point isn't wildly out of step with current competition. If your sold-data price lands at $398,000 and active comps are clustered between $390K–$415K, you're in a defensible range.

In a Seller's Market (under 2 months of inventory)

Shift toward 50/50 or even active-heavy weighting, especially if appreciation has been rapid. Sold comps from 60–90 days ago may undervalue the property. Use active comps to identify where buyer demand is currently absorbing inventory, and look at pending sales if your MLS makes that data available.

In a Buyer's Market (over 6 months of inventory)

Lean heavily on sold comps — 80% or more. Active listings in a soft market are frequently overpriced, and using them as anchors will set your seller up for disappointment. The homes that actually closed are telling you what buyers were willing to commit to.

The Conversation Your Sellers Need to Hear

One of the most common CMA mistakes isn't analytical — it's presentational. Agents show sellers a range without explaining why the numbers differ or which data point carries more weight.

When you walk a seller through your CMA, be explicit:

"These three sold comps tell us what buyers have actually paid for homes like yours in the last 90 days. These two active listings show us what you'll be competing against when we go live. Based on current inventory levels and how quickly homes in this price range are going under contract, I'm recommending we price at $___. Here's why that number wins in this market."

That framing accomplishes two things: it builds trust in your process, and it pre-empts the seller who wants to price $30,000 higher because their neighbor's house is listed at that number — even though it's been sitting for 62 days.

How AI-Powered CMA Tools Change the Game

One of the reasons agents struggle with the active vs. sold question is data volume. Manually pulling, filtering, and weighting comps across multiple criteria — square footage, lot size, age, condition, location adjustments — takes time and introduces human bias.

This is where AI-driven tools like CMAGPT add real value. Instead of eyeballing which comps are most relevant, you get data-driven comp selection that accounts for market velocity, price-per-square-foot trends, and days-on-market patterns simultaneously. The tool doesn't replace your judgment — it sharpens it by surfacing the comps that actually matter and flagging outliers that could skew your analysis.

The result is a CMA you can walk into any listing appointment with confidence, knowing the numbers are defensible, current, and strategically weighted for the market you're actually working in.

Bottom Line

Active comps show you the competition. Sold comps show you the reality. Your job as the agent is to read the market conditions and decide how much weight each deserves — then communicate that reasoning clearly to your client.

Get that balance right, and your CMAs stop being documents you present and start being tools that win listings and close deals.