VALO How to Price a Property When the Market Data Contradicts Itself
You pull five comparable sales for a two-bedroom apartment in a central neighbourhood. Two sold at 3,200 per square metre. One sold at 2,700. Another at 3,600. The fifth was withdrawn after 120 days at 3,400. The average says 3,220, but the average is lying to you. It blends a distress sale, a premium renovation, and an overpriced failure into a single number that describes none of them accurately.
This is the daily reality of property pricing. Market data rarely tells a clean story. The skill is not in calculating the average — any online tool can do that. The skill is in knowing which data points to trust, which to discard, and how to build a pricing recommendation that holds up when the homeowner challenges it.
Why does comparable sales data contradict itself?
Comparable sales data contradicts itself because no two properties are truly comparable. Even units in the same building sell at different prices due to floor level, orientation, renovation quality, seller motivation, and negotiation dynamics. A study by the Royal Institution of Chartered Surveyors (RICS) found that professional valuers assessing the same property independently produced valuations that differed by an average of 11.4%. If trained professionals with full access cannot agree, raw data points from different properties will naturally diverge.
The contradiction is not a flaw in the data. It is a feature of real estate markets where every transaction involves unique circumstances. Your job is to read those circumstances, not just the numbers.
The five reasons comps diverge
| Reason | What Happens | How to Detect |
|---|---|---|
| Condition gap | Renovated vs. original condition creates 15-30% price variance | Check listing photos and descriptions for renovation mentions |
| Motivation gap | Distress sales (divorce, debt, inheritance) sell 10-20% below market | Look for quick sale timelines, price drops, or “motivated seller” language |
| Time gap | Market shifts during the comp period change reference points | Weight recent sales (last 3 months) more heavily than older ones |
| Negotiation gap | Listed price vs. sold price varies by 5-15% depending on market conditions | Compare asking price to transaction price where data is available |
| Micro-location gap | Same neighbourhood, different street quality or exposure | Walk the area or verify on satellite imagery |
How do you decide which comparables to trust?
Start by establishing a hierarchy of relevance. The most trustworthy comparable is a recent sale of a similar-sized property in the same building or street, in similar condition, with a normal (non-distressed) sale timeline. As you move away from this ideal, each step reduces reliability.
According to the Appraisal Institute’s guidelines, the three strongest adjustment factors in residential valuation are: location proximity (same street or building beats same neighbourhood), recency (last 90 days beats last 12 months), and physical similarity (same size and condition beats same building with different configuration).
The trust hierarchy
Tier 1 — High trust: Same building or adjacent, sold within 90 days, similar size (within 10%), similar condition. Use these as primary anchors.
Tier 2 — Moderate trust: Same neighbourhood, sold within 6 months, similar size (within 20%), condition can be adjusted. Use these to confirm or adjust your Tier 1 range.
Tier 3 — Low trust but useful: Different neighbourhood with similar character, sold within 12 months, requires significant adjustments. Use these only to set outer boundaries.
Discard: Sales older than 12 months in a moving market, properties with fundamentally different characteristics (commercial, land, luxury vs. standard), or transactions between related parties.
For more on how AI-assisted valuation conversations handle this complexity, see AI Property Valuation: How It Changes the Seller Conversation.
How do you adjust for condition and renovation quality?
Condition adjustments are the most subjective part of a comparative market analysis and the area where most brokers get it wrong. The mistake is treating renovation as a binary — “renovated” or “not renovated.” In reality, renovation quality exists on a spectrum, and the return on renovation investment is not linear.
Research by Remodeling Magazine’s annual Cost vs. Value Report shows that kitchen renovations recoup an average of 62-75% of their cost at resale, while bathroom renovations recoup 55-70%. Full-home renovations with high-end finishes in mid-range neighbourhoods often over-capitalize — the owner spent more than the market will reward.
The condition adjustment framework
| Condition Level | Description | Typical Adjustment |
|---|---|---|
| Original (needs work) | Original kitchen and bathrooms, functional but dated | -15% to -25% from renovated comps |
| Partially updated | Some rooms refreshed, cosmetic improvements | -5% to -15% from renovated comps |
| Fully renovated (standard) | Modern kitchen and bathrooms, good-quality materials | Baseline — no adjustment |
| Premium renovation | Designer finishes, high-end appliances, smart home features | +5% to +10% over standard renovated |
| Over-renovated | Luxury finishes in a mid-range neighbourhood | +0% to +5% — market caps the premium |
When your comparables include both renovated and original-condition properties, apply these adjustments before averaging. A 3,200 per square metre sale for a renovated unit and a 2,700 sale for an original-condition unit are not contradictory — they are consistent once you account for a 15-18% condition gap.
What do you do when the market is moving and your comps are stale?
In a rising market, your best comparable from 6 months ago undervalues the property. In a falling market, it overvalues it. The European Central Bank’s Residential Property Price Index showed that some EU markets moved 8-12% in a single year during 2022-2023, meaning a comp from January could be meaningfully different from current value by July.
The solution is to apply a time adjustment based on the trend direction and velocity. Track the local price index for the neighbourhood (most portal aggregators publish this quarterly). If the market moved 6% upward in the past 12 months, a comp from 6 months ago needs a 3% upward adjustment.
Time adjustment method
- Identify the trend: Is the local market rising, falling, or flat over the past 12 months?
- Quantify the velocity: What is the percentage change per quarter?
- Calculate the gap: How many months old is each comparable?
- Apply proportional adjustment: If the market rose 2% per quarter and the comp is 6 months old, add 4% to the comp price
This is not precision science. You are estimating direction and magnitude, not calculating to the euro. But a 4% adjustment on a sale from 6 months ago in a moving market is the difference between a credible and an outdated valuation.
How do you present conflicting data to the homeowner?
Transparency wins. Do not hide the contradictions or present a false sense of precision. Homeowners who discover that you cherry-picked favourable comparables lose trust immediately. Instead, present all the data, explain why it diverges, and then walk the homeowner through your reasoning for the recommended price range.
Use the framework: “Here are the five most relevant recent sales. They range from X to Y. Here is why they differ — this one was in original condition, this one sold during a slower period, this one was a premium renovation. When I adjust for those factors, the data points toward a range of A to B for your property.”
This approach works because it positions you as an analyst, not an advocate. You are reading the market, not selling a number. For more on building trust through valuation conversations, see Why a Valuation Conversation Beats an Online Form Every Time.
The three-number framework
Present three numbers, not one:
- Competitive price: The price that generates immediate interest and likely sells within 30 days
- Market price: The price that reflects fair value and likely sells within 60-90 days
- Aspirational price: The price the homeowner wants to try, acknowledging it may require a price reduction after 60 days
This framework respects the homeowner’s autonomy while anchoring expectations in data. According to a survey by the National Association of Realtors, properties initially priced within 5% of their eventual sale price sell in an average of 34 days, compared to 94 days for properties that required one or more price reductions.
How do you handle data-poor markets?
Some neighbourhoods simply lack recent comparable sales. Rural areas, luxury segments, and newly developed zones often have fewer than 3 transactions in 12 months. In these cases, expand your radius methodically: first to adjacent streets, then to the broader neighbourhood, then to comparable neighbourhoods in terms of character and price level.
When expanding, document your reasoning. A homeowner will accept a comparable from 2 kilometres away if you explain: “There have been no sales in your immediate street this year, so I have used the three closest sales in similar streets within the wider area, which share the same property type and buyer profile.”
Also consider listing data — properties currently on the market at known prices. While asking prices are not transaction prices, they establish the ceiling of current market expectations. A cluster of similar properties listed at a consistent price point is a signal, even if none have sold yet.
For how this data feeds into effective listing campaigns, see Valuation Campaigns That Convert Ad Clicks to Listings.
Frequently asked questions
Should you ever use an average of all comparables as your valuation?
No. A simple average treats a distress sale and a premium renovation as equally valid reference points. Always filter and adjust your comparables before aggregating. Use the median of your adjusted Tier 1 and Tier 2 comparables as your starting point, then apply professional judgment based on the specific property’s position within that range. The average is a starting point for analysis, not a conclusion.
How many comparable sales do you need for a reliable valuation?
A minimum of 3 comparable sales is the industry standard, but 5-7 gives you a more robust analysis and better credibility with homeowners. If you cannot find 3 comparables within a reasonable radius and timeframe, expand your search area and document the adjustments. Presenting fewer than 3 comparables looks thin and invites challenge.
What if the homeowner’s online valuation estimate differs from yours?
Online valuation tools use automated models that cannot account for condition, renovation quality, or micro-location nuances. The margin of error for automated valuations ranges from 5% to 15% depending on market data availability. Acknowledge the estimate, explain the limitations, and then walk through your adjusted comparables. The specificity of your data will outweigh the generality of theirs.