Every real estate consultant knows this situation. You sit with a property owner. You have data. You show them that their apartment is worth €500,000. The owner looks at your market report and says: “Let us try at €600,000 first. We can always lower the price later if nobody calls. The Madrid market is going up anyway, so time is on our side.”
This is the most dangerous logic in real estate. It is completely wrong.
When a property is overpriced, it sits on the market waiting for a buyer so long that it degrades. It accumulates market days. It becomes what professionals call a “burned property”. When it finally sells, it sells below the fair market value.
This week at SIMA 2026 in Madrid, Casafari is presenting two major upgrades to the Spanish real estate industry.
First, we closed a direct partnership with Dato Notarial, the company within the Centro Tecnológico del Notariado. We now feed official closing prices and mortgage information on all registered sales directly into our system. We are the only company that works with the complete database of closing prices of all registered sales in Spain.
Second, our AI Valuations Presentation Builder is live. It transforms real closing prices from registered sales, complete property market data, and comprehensive location intelligence into a complete, professionally written and styled in a company’s brand client advisory document in seconds.
Let us look at the raw facts, the mathematical model of property degradation, and how automated AI text generation stops the overpricing argument with zero manual effort.
The Real Transaction Data: Notaries of Spain versus Portal Noise
Most valuation reports in Spain rely on portal data. This leads to a massive error and confusion. Portals show asking prices of currently active ads (not properties!):
– Portals are not the market – these are just marketing places with ads, not a database with all properties.
– Asking prices represent the expectations of hopeful sellers, not financial reality.
– Portals contain noise: duplicate listings, price bias towards mostly advertised listings, and hence overvalued data.
– Portals do not have information on what was sold. Thus, the data from portals only take the wishful thinking, not reality.
Casafari bypasses portal noise through our
+ Proprietary comprehensive data collection from the entire market and rigorous data technology pipelines aggregating, deduplicating, and cleaning data that ensure the single view on a each property with a complete history of price and status changes.
+ Partnership with the Centro Tecnológico del Notariado with the complete database of real closing prices on all registered sales in Spain. We have integrated real transactional data from deeds (precios de cierre reales escriturados) with basic mortgage information.
This data shows a clear gap. The average property listed with a high overpricing margin takes significantly longer to sell, and its final deed price is drastically lower than the original asking price.
When you combine real notary transaction history with our AI algorithms and complete market intelligence through APIs and MCPs (Model Context Protocol), you get an absolute baseline of truth. You can show a seller exactly what were neighbouring apartments sold for at the notary, not what they were listed for on a portal.
The Three Secret Costs of Time: Madrid 2026 Math
Sellers think time is free because the Madrid market is rising. According to official notary records from 2024 to 2025, the annual market appreciation in Madrid is 8.3%. This looks like a benefit. But it is a financial trap for overpriced listings.
An overpriced property triggers three distinct costs that outpace market growth:
The Carrying Cost (6.5% Annually)
Keeping a property active on the market costs money every month. This includes the property tax (IBI), community fees, maintenance, utility bills, and the opportunity cost of capital. If a €500,000 asset sits empty, that capital is not earning interest elsewhere. In Madrid, this total carrying cost averages 6.5% annually.
Exponential Days on Market (DOM)
Time on market does not grow linearly with overpricing. It grows exponentially. Our engineering team calibrated the Madrid market distribution using thousands of tracked assets. The mathematical formula for expected days until a sale is:
- If you price at 0% over market value, the expected time to sell is 70 days.
- If you price at 10% over market value, the time jumps to 155 days.
- If you price at 20% over market value, the property stays active for 340 days.
- If you price at 30% over market value, the timeline extends to 750 days.
The Buyer “Burned Property” Discount
This is the key metric that standard real estate software misses. A property that is active for a long time loses value because of buyer psychology. Buyers track portals. They see an apartment listed for six months, nine months, or a year. They start to think: “Something is wrong with this house. Nobody wants it.”
When a property is stale, buyers apply a “burned property” discount to the listing’s actual value at the time of the offer. They know the seller is tired, stressed, and paying maintenance fees.
There is something else to this kind of situations – often, such tired owners start to drop prices several times on a row. We call them “desperate sellers”. It is the best timing to negotiate further to drop the property price below the fair market value. Good for a buyer and especially investor, bad for the seller who aimed too high at the start.
The buyer “burned property” discount or deduction scales based on market days:
- 0 to 60 days: 0% deduction.
- 61 to 120 days: 2% deduction.
- 121 to 180 days: 4% deduction.
- 181 to 270 days: 6% deduction.
- 271 to 365 days: 9% deduction.
- More than 365 days: >12% deduction.
The Four Overpricing Zones in Madrid
When you combine these three forces – appreciation, carrying costs, and “burned property” discounts – you get a clear picture of the financial outcome. The market appreciation does not save the seller. The “burned property” discount absorbs the upside of the market growth, while the seller pays the carrying costs on top.
The table below tracks the true financial result based on a standard Madrid property with a starting fair market value of €500,000:
| Metric | Green Zone (0-7% Overpriced) | Yellow Zone (7-15% Overpriced) | Red Zone (15-25% Overpriced) | Dark Zone (25%+ Overpriced) |
| Example Overpricing | 5% | 12% | 20% | 30% |
| Initial List Price | €525,000 | €560,000 | €600,000 | €650,000 |
| Days on Market | 104 Days | 181 Days | 340 Days | 749 Days |
| Market Value at Sale | €512,188 | €521,417 | €540,653 | €592,925 |
| “Burned Property” Discount | 2% | 6% | 9% | 12% |
| Actual Closing Price | €501,944 | €490,132 | €492,000 | €521,774 |
| Accumulated Carrying Cost | €9,389 | €16,344 | €30,694 | €67,618 |
| Net Financial Return | €492,555 | €473,788 | €461,306 | €454,156 |
| Loss vs. Correct Price | -€2,300 | -€21,067 | -€33,549 | -€40,699 |
Green Zone (0-7%): Maximum Net Equity
The property sells in less than three months. There is no buyer “burned property” discount. The negotiation stays within normal boundaries. The seller receives the maximum possible amount of money in the shortest time.
Yellow Zone (7-15%): The Correction Phase
The property requires one or two price drops. It spends up to six months on portals. The buyer senses hesitation and demands a small discount. Carrying costs start to significantly reduce the net return.
Red Zone (15-25%): Vivienda Quemada (The Burned Property)
The listing ad sits on portals for nearly a year. It requires three to four manual price decreases. The buyer applies a heavy “burned property” discount. Look at the numbers closely: even though the Madrid market grew during the 340 days of waiting, the actual closing price (€492,000) falls below the original Day-0 market value (€500,000). The market growth was transferred entirely to the buyer.
Dark Zone (25%+): Virtually Unsellable
The listing ad becomes a permanent fixture on portals. The owner eventually has to delist the property, change agencies, or relist it entirely – best after several months and with a new agency after some time break.
The net equity loss exceeds €40,000 due to massive carrying costs and a mandatory double-digit price discount at closing.
The AI Valuations Presentation Builder as Your Digital Valuation Advisor
An agent cannot just show a table of formulas to a seller. Sellers are emotional. They need clear text, logical arguments, and a deep analysis of their specific neighborhood. Writing a customized 20-page market study for every client takes hours. Agents do not have this time.
The Casafari AI Valuations Presentation Builder solves this problem. It acts as a digital valuation advisor that automates the entire text composition, data entry, and market justification process. All in a language, tone and voice aimed at a seller’s persona, and in an agent’s corporate brand style and format.
How Casafari AI Valuations Presentation Builder works
Step 1. Raw Data Inputs and AI Model Output:
+ Live active and sold comparables from the most complete market data – Casafari’s proprietary property market database;
+ Area Insights of the whole location with trends in time series;
+ Notary closing prices from the most complete database of registered sales – Dato Notarial;
+ POI, socio demographic information, catchment / time to travel, foot traffic, tourist and local visitors from Targomo location intelligence.
Step 2. One-Prompt Persona Instruction:
Just type a single instruction:
Example A: “Target an analytical investor seller – focus on rental yields, vacancy rates and appreciation of the location”,
Example B: “Rewrite all texts for a family, highlight the family friendly features of the house and the location”.
Step 3. End-to-End Presentation Output in a Company Brand:
AI Rewrites a full 20-page comprehensive market study.
Sets precise tone for the reader’s persona and defends property value.
All in a custom company’s brand, style, and format.
When you generate an AI Valuations Presentation, the system does all the work for you –
comparables, registered sales, market charts, and a structured, properly written narrative.
It explains and defends the calculated fair market value using multiple arguments:
- The AI automatically writes texts giving context to comparables – describing why specific local properties were chosen.
- The system automatically inserts POI nearby and creates text highlighting schools, hospitals, parks, and premium commercial zones – or any other POI depending on a target persona.
- The AI calculates and writes out explicit travel timelines. It informs exactly how many minutes it takes to reach Madrid’s center, train stations, or the airport by car and public transport.
- The AI engine can include data on the neighborhood’s average income level, demographic composition, and historical stability. It converts abstract socio-demographic statistics into readable descriptions that justify the pricing strategy.
The One-Prompt Engine: Matching Tone to Client Psychology
Different clients require different arguments. The first-time private seller does not think like an institutional investor. A family searching for a primary home looks at different details than a single professional purchasing a rental unit.
The Casafari AI Valuations Presentation Builder handles this via a single prompt field in a chat. You do not need to write a long text or edit slides manually. You enter one instruction, and the AI instantly rewrites the tone, voice, and narrative framework across the entire 20-page document.
Here is how the narrative automatically shifts based on your target persona:
The Analytical Investor Persona
- Tone: Cold, factual, risk-focused, corporate.
- Focus: The text prioritises capital efficiency, monthly carrying costs, gross and net yields, vacancy rates, socio-demographic profile, and appreciation. It treats the property as a financial asset.
The Private Homeowner / Family Seller Persona
- Tone: Empathetic, reassuring, direct, protective of equity.
- Focus: The AI translates the math into a security narrative. It explains that pricing correctly from the start protects the family from losing control of their timeline. It highlights neighborhood stability and how a clean, confident launch with a fair market value attracts high-quality family buyers quickly.
The Active Buyer Presentation Angle
If you are representing a buyer, you can change the target audience with one click. The AI immediately adjusts the text to identify overpricing errors in active market listings. It writes explicit arguments showing where an asking price is inflated compared to notary closing records, giving your buyer the leverage to demand a “burned property” discount.
Feature-Focused Valuation Defense
Every home has a unique element that price, comparables, and the supporting text need to protect. If an apartment has a premium terrace in Chamberí or a completely renovated interior in Salamanca, you note this feature in the prompt. A rare apartment with city views, roof top terrace, elevator, and a garage in a city center sells very fast even at a premium price per square meter. These features must be highlighted in the descriptions of the AI market study. Comparables will be selected accordingly.
The AI adapts the entire document to focus on property’s specific value drivers.
It automatically modifies the text across the property overview, comparable analysis, and final conclusion to build a defense around that single premium feature. This justifies the optimal green-zone price to the client without sounding like generic marketing copy.
Closing the Loop: Zero Effort, Less Time on Market
The real value of the AI Valuations Presentation Builder is that it connects market data directly to client execution. It removes human friction from the listing process.
When you use the tool, you get a clean workflow:
- Type the address or put a pin on a map.
- The system runs the valuation with the most up-to-date complete comparable data and the closing prices from the Notaries of Spain.
- Set the persona by typing a single sentence describing your client’s character traits or specific focus of the presentation.
- The AI writes, edits, and formats a complete 20-page custom market study with zero manual typing. You can still edit parts of the report manually, if you wish.
Export and share as a webpage. In your company’s brand style and format.
You present to your client a document that looks like it took an analytical and design team five days to create. The text clearly explains why an inflated price tag causes an immediate “burned property” penalty. It proves that a lower, accurate starting price reduces Days on Market and secures more net cash for the seller than a year-long cycle of price reductions.
See the Real Integration Live at SIMA 2026
Real estate is changing. Relying on portal inflated polluted prices and manual text editing is no longer competitive. The agents who win mandates in Madrid are the ones who show absolute data authority with minimal operational delay.
This week, from May 20 to May 23, the entire Casafari Spain team is present at SIMA 2026 inside IFEMA Madrid (Pavillon 4).
Come to our stand for a direct demonstration. We will show you how the Notaries of Spain data pipeline functions in real time. We will generate a complete, 20-page AI valuation advisory presentation for your toughest listing in under two minutes. Bring us a difficult address, and let us run the data together.
