How we curate.

Here's what FlipMedellín does and how we do it. We scan three Colombian property portals every 72 hours, normalize the data, and surface listings priced below the 25th percentile of price per m² for their specific neighborhood. We exclude common red flags, publish editorial scores and condition observations, and estimate a remodel range. We never tell you a property is a deal. We show you the math.

We scrape active listings every 72 hours from Finca Raíz, Metrocuadrado, and Ciencuadras. We dedupe across portals where the same unit is posted at different prices, normalize neighborhood names that vary in spelling and accent across sources, and verify each listing is still live before it surfaces.

Active listings only. We do not republish stale inventory, and we retire listings that go dark on the source portal.

Editorial selection over algorithmic ranking. From the active inventory below each neighborhood's 25th percentile of price per m², we apply human judgment about condition, building character, and neighborhood liquidity. We also exclude properties without an elevator in buildings above three floors, buildings built before 1995 without renovation evidence, units with HOA fees disproportionate to area, and listings older than 180 days at the same price.

From active asking prices in our database at curation time. Median not average, because real estate has long tails. One outlier listing skews averages but barely moves medians.

Each listing carries a snapshot date so you can see exactly when the curator set the comparison value. Mo verifies the median before each issue, especially for thin sub-zones where small sample sizes make the live computation noisy.

Three editorial scores per listing, 1 to 10. Flip rates the renovate-and-resell math. BnB rates short and medium-term rental potential. Home rates the property as an owner-occupier home.

Scores are editorial assessments based on our curation framework, not algorithmic predictions. We rarely publish below 4. Anything that low would not be curated. We reserve 10 for no-brainers and expect to publish one or two per year.

Cost ranges only, never single numbers. Ranges are based on comparable renovations in the area and current local construction pricing for kitchens, bathrooms, flooring, electrical, and finishes.

Our remodel range is a starting point, not a substitute for a contractor estimate. Treat it as an envelope, not a quote.

We work from public listings. Public listings have errors. Sub-neighborhood tagging is inconsistent across portals, especially for Provenza where the same building gets tagged El Poblado, Provenza, or Manila depending on the broker. Our normalization catches most but not all. Where our coverage of a sub-zone is thin enough that the bottom-quartile math is noisy, we flag it on the listing.

Asking prices are not transaction prices. Colombian transaction prices are not publicly available. We report what units are listed at, with editorial judgment about whether the asking price is reasonable. We are not RAA-licensed appraisers.

We do not assign deal scores. We do not predict appreciation. We do not forecast rental yield as a specific number. We do not claim a property is undervalued or below market value. Markets decide what things are worth. We surface the inputs and explain the property. The offer is yours.