Metrocuadrado Scraper 🇨🇴 — Colombia Property Data & Real Estate API 🏠

🎉 Turn Metrocuadrado listings into clean structured data — sale & rent, every Colombian city, no API key

Built for real-estate analysts, proptech teams, investors and lead-gen agencies who need Colombia property data at scale

---

📋 Overview

Scrape Metrocuadrado — Colombia's #1 real-estate portal — into ready-to-use datasets. Pull thousands of listings with price (COP), administration fee, stratum (estrato), size, rooms, bathrooms, garages, neighbourhood, agent, GPS coordinates, amenities and photos — as JSON, CSV or Excel.

Why proptech teams and investors choose us:

• ✅ Complete listings: dozens of fields per property — price, admin fee, stratum, area, rooms, baths, garages, agent, amenities, photos
• ⚡ Fast & affordable Overview mode: paginate the portal's own search index for thousands of listings — the cheapest way to harvest volume, and 100% carry a price
• 🎯 Both contracts: sale (venta) and rent (arriendo), in Bogotá, Medellín, Cali and every other city
• 💸 Pay-per-result: only pay for listings you actually extract — generous FREE tier, no credit card to start
• 💎 Detail mode with everything: real GPS coordinates, build age, the listing agent & profile, video, the full amenity list and hi-res gallery — each detail row is also enriched with the overview fields, so you always get a complete record
• ✨ Investor KPIs built in: automatic price-per-m² (COP/m²) and a thumbnail-first row for instant gallery views

---

✨ Features

• 🏠 Sale & rent listings: venta and arriendo in one actor
• 📍 Search by place, URL or listing ID: pick type + contract + city, paste a search URL, or feed exact listing URLs/IDs
• 💵 Full pricing breakdown: sale price, monthly rent and the monthly administration fee — all in Colombian pesos
• 📶 Colombian specifics: the socioeconomic stratum (estrato 1–6) on every row — essential for local market analysis
• 📐 Rich specs: total / built / private area (m²), rooms, bathrooms, garages, build age
• 🧭 Geo data: neighbourhood, zone, city and real latitude & longitude (Detail mode)
• 🏬 Agent & agency: agency name, agency ID and agency profile link, plus contact phone / WhatsApp
• 📸 High-resolution photos: every listing image URL, plus a cover thumbnail
• 🗂️ Amenities: pool, jacuzzi, gym and more — flattened to a clean list
• 📊 Computed KPIs: price-per-m² in COP, ready for comparables and yield models
• 🔢 Filters: narrow by price, rooms, bathrooms and area; cap each run with Max results
• 📤 Clean exports: JSON, CSV and Excel directly from the dataset

---

🎬 Quick Start

Pick a mode (Overview for speed, Detail for full data), tell it where to look (a property type + city, a search URL, or listing IDs), and run. Results stream into your dataset as clean rows you can export to JSON, CSV or Excel.

curl -X POST https://api.apify.com/v2/acts/sian.agency~metrocuadrado-property-scraper/runs?token=YOUR_TOKEN \
-H 'Content-Type: application/json' \
-d '{"scrapeMode":"overview","searchMode":"byPlace","propertyTypes":"apartamento","business":"venta","places":["bogota"],"maxResults":100}'

---

🚀 Getting Started (3 Simple Steps)

Step 1: Choose your mode

Pick Overview (fast & cheap — the search-list fields) or Detail (full fields per listing).

Step 2: Tell it where to look

Pick a property type, contract (Sale or Rent) and optionally a city (e.g. bogota), paste a search URL, or — in Detail mode — paste listing URLs/IDs.

Step 3: Run it

Click Start (or call the API). Listings stream into your dataset in real time.

That's it! In under a minute, you'll have:

• A clean table of Metrocuadrado listings with prices (COP), stratum and specs
• Real GPS, the agent and the full amenity list (Detail mode)
• A JSON / CSV / Excel export ready for your model or CRM

---

📥 Input Configuration

Field	Type	Required	Description
scrapeMode	string	No	overview (fast & cheap) or detail (full fields). Default overview.
searchMode	string	No	byPlace, bySearchUrl, or byListingUrl (detail only).
propertyTypes	string	No	casas-apartamentos, apartamento, casa or apartamento-casa.
business	string	No	venta (sale), arriendo (rent) or arriendo-venta (both). Default venta.
places	array	No	Metrocuadrado city slugs, e.g. bogota, medellin. Empty = all Colombia.
neighborhood	string	No	Neighbourhood slug to narrow a By place search.
searchUrls	array	No	metrocuadrado.com search-results URLs.
listingUrls	array	No	Detail mode: listing URLs or bare IDs (e.g. 20625-M5964176).
maxResults	integer	No	Cap listings per run. FREE: 25. PAID: unlimited.
minPrice / maxPrice	integer	No	Price filters (COP).
minRooms / minBathrooms	integer	No	Minimum rooms / bathrooms.
minArea / maxArea	integer	No	Area range (m²).
proxyCountry	string	No	Empty = direct (default). CO routes through a Colombian residential proxy for very large runs.

Example — by place:

{
  "scrapeMode": "overview",
  "searchMode": "byPlace",
  "propertyTypes": "apartamento",
  "business": "venta",
  "places": ["bogota", "medellin"],
  "minPrice": 200000000,
  "maxResults": 200
}

Example — detail by listing ID:

{
  "scrapeMode": "detail",
  "searchMode": "byListingUrl",
  "listingUrls": ["20625-M5964176", "https://www.metrocuadrado.com/inmueble/.../20625-M5964176"]
}

---

📤 Output

Results are saved to the Apify dataset with dozens of fields including:

Field	Type	Description
listingId	string	Metrocuadrado listing identifier
url	string	Canonical listing URL
propertyTitle	string	Listing title
business_type	string	venta (sale) or arriendo (rent)
sale_price	integer	Sale price (COP)
rent_price	integer	Monthly rent (COP)
admin_fee	integer	Monthly administration fee (COP)
price_per_sqm_cop	integer	Computed price per m² (COP)
area_total / area_built / area_private	integer	Areas (m²)
rooms / bathrooms / garages	integer	Property specs
stratum	integer	Colombian socioeconomic stratum (1–6)
neighborhood / zone / city	string	Location
latitude / longitude	number	GPS coordinates (Detail mode)
agency_name / agency_link / contact_phone	string	Listing agent & agency
amenities	array	Pool, jacuzzi, gym, etc.
photos	array	High-resolution image URLs
thumbnail	string	Cover image

Example:

{
  "listingId": "20625-M5964176",
  "url": "https://www.metrocuadrado.com/inmueble/venta-apartamento-armenia-sector-oro-negro-2-habitaciones-2-banos-1-garajes/20625-M5964176",
  "source": "detail",
  "propertyTitle": "Apartamento en Venta, ORO NEGRO, Armenia",
  "property_type": "Apartamento",
  "business_type": "venta",
  "sale_price": 499000000,
  "admin_fee": 255000,
  "price_per_sqm_cop": 6480519,
  "area_total": 77,
  "rooms": 2,
  "bathrooms": 2,
  "garages": 1,
  "stratum": 5,
  "built_age": "Entre 0 y 5 años",
  "city": "Armenia",
  "neighborhood": "SECTOR ORO NEGRO",
  "latitude": 4.5763583,
  "longitude": -75.64458,
  "agency_name": "INMOBILIARIA L3",
  "agency_link": "https://www.metrocuadrado.com/inmobiliaria/inmobiliaria-l3/11209",
  "amenities": ["Piscina", "Jacuzzi"],
  "image_count": 20,
  "thumbnail": "https://multimedia.metrocuadrado.com/20625-M5964176/...jpg",
  "currency": "COP"
}

---

💼 Use Cases & Examples

1. Rental Yield & Investment Analysis

Investors and proptech analysts modelling returns across Bogotá and Medellín.

Input: A list of city slugs, business = arriendo and venta. Output: Rent, sale price, admin fee and computed COP/m² per listing. Use: Build gross-yield and price-to-rent models for whole cities and strata.

2. Price & Rent Comparables (CMA)

Brokers and appraisers needing fast comparables.

Input: A search URL for a specific area and property type. Output: Comparable listings with price, area, stratum and COP/m². Use: Produce a comparative market analysis in minutes, not hours.

3. Lead Generation

Agencies sourcing seller and landlord inventory.

Input: By-place searches across target cities. Output: Listings with location, specs and the listing agent + contact details. Use: Feed a CRM with fresh, qualified property leads.

4. Market Research & Trend Dashboards

Data teams tracking Colombia's housing market.

Input: Scheduled daily runs across multiple cities. Output: A time series of prices, inventory and admin costs by stratum. Use: Power BI / Looker dashboards on supply and pricing trends.

5. Powering a Real-Estate Data API

Proptech startups building products on Colombia listings.

Input: Programmatic API calls per region. Output: Structured JSON ready to ingest. Use: Back a search app or valuation API with live Metrocuadrado data.

6. Relocation & Site-Selection Tools

Relocation services and corporate housing teams.

Input: Rent searches filtered by rooms and budget. Output: Options with amenities, stratum and GPS. Use: Shortlist properties for employees moving to Colombia.

---

🔗 Integration Examples

JavaScript/Node.js

import { ApifyClient } from 'apify-client';
const client = new ApifyClient({ token: 'YOUR_TOKEN' });

const run = await client.actor('sian.agency/metrocuadrado-property-scraper').call({
  scrapeMode: 'overview',
  searchMode: 'byPlace',
  propertyTypes: 'apartamento',
  business: 'venta',
  places: ['bogota'],
  maxResults: 100,
});

const { items } = await client.dataset(run.defaultDatasetId).listItems();
console.log(items[0]);

Python

from apify_client import ApifyClient
client = ApifyClient('YOUR_TOKEN')

run = client.actor('sian.agency/metrocuadrado-property-scraper').call(
    run_input={
        'scrapeMode': 'overview',
        'searchMode': 'byPlace',
        'propertyTypes': 'apartamento',
        'business': 'venta',
        'places': ['bogota'],
        'maxResults': 100,
    }
)

for item in client.dataset(run['defaultDatasetId']).iterate_items():
    print(item)

cURL

curl -X POST 'https://api.apify.com/v2/acts/sian.agency~metrocuadrado-property-scraper/runs?token=YOUR_TOKEN' \
-H 'Content-Type: application/json' \
-d '{"scrapeMode":"overview","searchMode":"byPlace","propertyTypes":"apartamento","business":"venta","places":["bogota"],"maxResults":100}'

Automation Workflows (N8N / Zapier / Make)

1. Trigger: Schedule (e.g. daily) or webhook
2. HTTP Request: Call the actor API
3. Process: Handle the JSON results
4. Action: Save to a sheet, push to a CRM, or send an alert

---

📊 Performance & Pricing

FREE Tier (Try It Now)

• 25 listings per run — full feature access, same data quality
• No credit card required
• Perfect for testing and small projects

PAID Tier (Production Ready)

• Unlimited listings per run
• Pay-per-result: only charged for listings successfully extracted
• Ideal for dashboards, comparables and data APIs

💰 Transparent pay-per-result pricing — the fast Overview event is the cheapest way to harvest Colombia property data at volume; upgrade to Detail only when you need GPS, the agent and the full feature list.

🔗 View current pricing

---

❓ Frequently Asked Questions

Q: How many listings can I extract? A: FREE tier: 25 per run. PAID tier: unlimited (up to the portal's 10,000-listing depth cap per search).

Q: Does it cover both sale and rent? A: Yes — set business to venta (sale), arriendo (rent) or arriendo-venta (both).

Q: What is the difference between Overview and Detail? A: Overview is the fast, cheap search-list view (and every row carries a price). Detail fetches each property page for real GPS, build age, the agent, video, the full amenity list and hi-res gallery — and is also enriched with the overview fields so each row is complete.

Q: What is "stratum / estrato"? A: Colombia classifies properties into socioeconomic strata 1–6. Every row carries it — it's a key signal for local pricing and comparables.

Q: What output formats are available? A: JSON, CSV and Excel — export directly from the Apify dataset.

Q: Do I need a Metrocuadrado account or API key? A: No. The actor works straight out of the box.

Q: What currency are prices in? A: Colombian pesos (COP), as published on Metrocuadrado.

Q: Is this legal? A: We only extract publicly available listing data. See the legal note below.

---

🐛 Troubleshooting

No results returned

• Check your city slug — open the search on metrocuadrado.com and copy the slug from the URL.
• Make sure business matches what's available in that area (sale vs rent).

A specific listing URL was skipped

• Sold or removed listings return a page with no data and are skipped automatically. Try a currently-live listing.

Fewer rows than expected

• Each search caps at 10,000 listings deep. Add more city slugs or tighten filters to reach more distinct properties.

Large runs slowing down

• Set proxyCountry to CO to route through a Colombian residential proxy and keep the listing-detail geo check happy at scale.

---

⚖️ Is it legal to scrape data?

Our actors are ethical and do not extract any private user data, such as email addresses, gender, or location. They only extract what the user has chosen to share publicly. We therefore believe that our actors, when used for ethical purposes by Apify users, are safe.

However, you should be aware that your results could contain personal data. Personal data is protected by the GDPR in the European Union and by other regulations around the world. You should not scrape personal data unless you have a legitimate reason to do so. If you're unsure whether your reason is legitimate, consult your lawyers.

You can also read Apify's blog post on the legality of web scraping.

Disclaimer: This actor is an independent tool and is not affiliated with, endorsed by, or sponsored by Metrocuadrado or El Tiempo Casa Editorial. "Metrocuadrado" and related marks are trademarks of their respective owners. Use this actor in compliance with Metrocuadrado's terms and all applicable laws.

---

🤝 Support

Join our active support community

• For issues or questions, open an issue in the actor's repository
• Check the SIÁN Agency Store for more automation tools
• 📧 apify@sian-agency.online

---

Built by SIÁN Agency | More Tools