G
Don Guillermo
Madrid · Property Intelligence
Real estate investment counsel

Every flat in Madrid has a fair price.
Don Guillermo knows it.

A data-driven second opinion on any Madrid property. Trained on thousands of real listings, cross-checked against current rental data, and delivered as a one-page investment brief in under a minute.

Madrid
G

Awaiting your property

Enter the listing details on the left. Don Guillermo will run the numbers and issue a BUY, HOLD, or PASS verdict.

01 Price prediction
02 Rental analysis
03 Written verdict
I.
The process

How Don Guillermo thinks

01

You describe the property

Five inputs: address, district, asking price, size, and rooms. That's all the signal the ML model needs.

~10 seconds
02

The model predicts fair value

A BigML ensemble (10 decision trees, trained on 4,198 Madrid listings) outputs what the property should cost based on its features alone.

BigML · R² = 0.90
03

The Knowledge Base adds context

A curated Google Sheet with Q1-2026 rental yields, sale prices, and growth rates for 11 Madrid districts is queried for the matching row.

Idealista 2025/26
04

Claude writes the brief

Given both the prediction and the district data, Claude Sonnet 4.6 writes a five-section investment brief and issues a BUY / HOLD / PASS verdict.

Claude · ~20 seconds
II.
Under the hood

Methodology & data

The model

BigML Ensemble

A Random Decision Forest trained on 4,198 Madrid listings from Idealista (April 2019 snapshot). Features include size, number of rooms and bathrooms, and district. The ensemble averages across 10 decision trees, which reduces variance and handles non-linear relationships between location and price.

We trained several model types (linear regression, single tree, boosted trees) and chose the ensemble because it delivered the highest R² on the held-out test set.

0.90
R² score
€84k
Mean abs. error
4,198
Training rows
The knowledge base

Madrid District Intelligence

A curated Google Sheet covering 11 Madrid districts across three market tiers: Premium (Salamanca, Centro), Mid-market (Tetuán, San Blas), and Value (Usera, Villaverde, Vicálvaro, plus the outlying Pinto zones).

For each district we store the 2026 average rent per m², 2026 average sale price per m², estimated gross rental yield, year-over-year rent growth, and a qualitative context note used by Claude when drafting the brief.

11
Districts
Q1 '26
Data freshness
3 tiers
Market segments
The request pipeline
From form submission to written verdict — orchestrated in n8n
Webhook
n8n · HTTPS
Price prediction
BigML API
District lookup
Google Sheets
§
Synthesis
Claude Sonnet 4.6
Response
JSON → Browser
III.
The counsel

About Don Guillermo

G
Don Guillermo
Real Estate Investment Counsel · Madrid

"I have been watching this city buy and sell itself for forty years. The numbers always know first."

A second opinion, engineered.

Don Guillermo is not a single tool — he is a small committee of specialists wearing one coat. A statistical model that has read thousands of listings and knows what they cost. A reference book of current district data, kept up to date. An analyst who can read both and write the verdict in plain language.

The architecture is a classic Retrieval-Augmented Generation pattern: the ML prediction provides quantitative intuition, the Knowledge Base provides current market context, and a large language model synthesizes the two into a decision. None of the components can do the job alone. Together, they produce a brief that is grounded in real data and written like a human would write it.

Transparent
Every number in the brief traces back to either the model output or a cited district row. No hallucinations.
Current
District data is refreshed from Idealista market reports each quarter. The model can be retrained on demand.
Unbiased
No listing fees. No referral agreements. Don Guillermo has no reason to tell you a property is good.
Fast
From form submission to written verdict in under 45 seconds — faster than a first call with any real broker.
↑ Back to the top — analyze another property