Are Madrid’s 110-day detached listings a market signal or survivor bias?

G

grain.brisk

Seller
Established
The 110-day figure is driving the choice, but I do not yet trust what it represents. My saved Madrid detached homes are priced from €482,100 to €723,100, and their listing histories vary widely. Some of the largest outliers appear to be associated with rental regulation.

For deciding whether to act now, should completed transactions take priority over the live sample? Homes that sell quickly disappear from view, while stale or withdrawn properties can distort the apparent marketing period. I also need to define the neighbourhood boundaries and check seller motivation before treating 110 days as a useful benchmark.
 
Completed sales would be more useful, but only if you can compare similar neighbourhoods, condition and initial asking dates. Your live sample has survivor bias: the attractive or correctly priced homes disappear, leaving the stubborn ones to dominate the 110-day figure.
 
What does “Madrid” mean in the sample: the municipality, the wider urban area, or the whole region? Detached homes are especially sensitive to that boundary. Combining very different neighbourhoods could produce a number that describes none of them particularly well.
 
I’d be cautious about attributing the outliers to rental regulation. Unless these are properties aimed at landlords, the link may be indirect. Seller expectations, condition or an awkward location could explain the same pattern without regulation being the cause.
 
Withdrawn stock is the missing piece. A listing that vanishes may have sold, been paused, switched agent or simply failed to attract an acceptable offer. Counting every disappearance as a completed deal would make the market look faster than it is.
 
Condition could split this price band into two markets. A detached house needing substantial work asks buyers to price uncertainty as well as the building itself. A ready-to-occupy home at the same asking price may move on a completely different timetable.
 
The boundary question is probably the first one to settle. I’d group by small, consistent areas rather than calculate one Madrid-wide average. Then compare detached homes only, since adding other property types would further blur the result.
 
Buyer financing can also create misleading listing histories. A home can appear effectively sold, return after financing fails, and then look unusually old. Do your saved listings show interruptions or only the current publication period?
 
Also separate initial asking price from current asking price. A house online for 110 days after an early unrealistic price is not evidence that a sensibly priced house needs 110 days. The timing of the first meaningful cut matters.
 
That suggests tracking price-cut timing rather than just the latest price. I’d note the first-seen date, every reduction, disappearance date and any return. Even a modest sample becomes more informative when you can see whether activity follows a cut.
 
The detail that complicates this is the number of comparable homes entering the market during the period. An older-looking pool may simply reflect a quiet month, not weaker demand. Conversely, if plenty of similar houses appeared and the strongest ones disappeared quickly, a 110-day average would mostly describe the survivors.

That makes me sceptical of averaging everything currently visible. Grouping homes by first-listing period, while recording reductions and disappearances, would give a cleaner comparison.
 
Would a cohort approach solve that? Take only homes first listed within the same period and follow them forward, instead of averaging everything currently online. That should reduce the tendency for long-running listings to overwhelm the result.
 
Yes, although recent cohorts need time to mature. For the current month, report how many remain active, disappear, get cut or return rather than forcing an early average. Older cohorts can provide the fuller time-to-disappearance picture.
 
Seller motivation is another distinction you cannot see directly from price. Two similar homes may have very different deadlines. Repeated small reductions might indicate testing, while a decisive adjustment may suggest a seller who genuinely wants a transaction.
 
One more complication: duplicate listings. The same house can appear through more than one agent or be republished with altered wording. Deduplicate by the property itself where possible, otherwise both listing volume and days online become unreliable.
 
A practical spreadsheet could use one row per home: precise area, first seen, original and current price, condition, reductions, withdrawn date, relisting and final known outcome. Leave the outcome as unknown when it is unknown; that is better than treating every removal as sold.
 
I’d add a simple category for apparent buyer type only when the advert makes it clear. Otherwise the rental-regulation explanation risks becoming circular: the unusual listings are labelled regulation-related, then used as proof that regulation created the unusual timing.
 
Actually, it may be cleaner to analyse those suspected regulation-linked outliers separately first. If the remaining detached homes still cluster around 110 days, the estimate has some resilience. If it changes sharply, the headline figure needs a large caveat.
 
Completed transactions still have a limitation: the recorded completion date is not necessarily the date buyer and seller agreed terms. So they can confirm price and that a sale occurred, but may not map neatly onto the marketing period visible in adverts.
 
I disagree slightly with dismissing 110 days as mostly a data problem. It can still be useful to a buyer as a negotiating clue on a specific long-listed house. It just should not be treated as the normal selling time for every detached home in the price range.
 
You must log in or register to reply here.
Back
Top