Airbnb market data · 202612 months to October 2026
Madrid, Colombia Airbnb Market Data: Revenue, Occupancy & Trends
The average Airbnb in Madrid brought in COP 21,644,372 over the 12 months through October 2026, across just 24 active listings, so a single property can move that figure.
The short answer
Madrid Airbnb Market at a Glance
Madrid is cheaper but busier than the Cundinamarca average. Listings averaged COP 311,265 a night and were booked on 30% of available nights, against COP 419,000 and 23% for the Cundinamarca average.
Timing matters: in September, usually the best month, the average listing earns about three times as much as in April, usually the slowest. With only 24 active listings, a few bookings can reorder the months.
With 24 active listings, Madrid is the 21st-largest of 32 Cundinamarca markets AirROI tracks.
Browse the live Madrid Airbnb market See Every Madrid ListingRevenue
How Much Do Airbnb Hosts Make in Madrid?
Gross bookings per Madrid listing averaged COP 21,644,372 over the 12 months to October 2026 (Cundinamarca average: COP 22,395,403), before cleaning, platform and management costs and taxes.
In a typical year, the average Madrid listing brings in COP 5,200,000 in September, its best month, and COP 1,770,000 in April, its slowest. The three strongest months bring in 34% of a full year's revenue, where an even calendar would give any three months 25%.
Across Madrid's 24 active listings, monthly revenue by tier:
- Best-in-class properties (top 10%) earn COP 8,270,000+ a month, about 8.3 times the typical property.
- Strong performers (top 25%) earn COP 2,290,000 or more, roughly COP 1,300,000 a month above the median.
- Typical properties (median) earn about COP 999,000 a month.
- Entry-level properties (bottom 25%) earn COP 587,000 or less, about 59% of the median.
These are monthly figures for listings active in each month. The annual average above also counts listings that operated for only part of the year, so it runs below twelve times these figures.
September earns about three times what April does
Average revenue per active listing, by month, October 2024 to September 2026
The dashed line is the average of the months shown, COP 2,690,000. Each point is one month as recorded, averaged over the listings active in it. The best and slowest months in the text average each calendar month over the past two years, so they can differ from the highest and lowest points here.
Madrid Airbnb Data by Month
Latest 12 months in the October 2026 data. October's figures are still coming in, so the rows run to September.
September 2026 led on revenue and nightly rate; bookings peaked in June 2026.
| Month | Avg. Revenue | Occupancy | Avg. Nightly Rate | RevPAR | Booking Lead Time | Avg. Length of Stay |
|---|---|---|---|---|---|---|
| Oct 2025 | COP 2,726,612 | 15.9% | COP 260,480 | COP 87,955 | 12 days | 3.9 nights |
| Nov 2025 | COP 2,254,195 | 28.7% | COP 256,230 | COP 75,140 | 14 days | 4.7 nights |
| Dec 2025 | COP 4,175,177 | 33.0% | COP 261,035 | COP 134,683 | 37 days | 5.2 nights |
| Jan 2026 | COP 4,237,180 | 30.4% | COP 261,422 | COP 136,683 | 12 days | 4.8 nights |
| Feb 2026 | COP 2,746,550 | 22.5% | COP 259,998 | COP 98,091 | 13 days | 4.8 nights |
| Mar 2026 | COP 2,929,548 | 33.0% | COP 268,048 | COP 94,502 | 21 days | 3.8 nights |
| Apr 2026 | COP 1,473,882 | 29.5% | COP 278,013 | COP 49,129 | 7 days | 4.7 nights |
| May 2026 | COP 3,070,503 | 34.9% | COP 275,542 | COP 99,048 | 20 days | 6.1 nights |
| Jun 2026 | COP 3,130,750 | 36.0% | COP 309,669 | COP 104,358 | 18 days | 3.3 nights |
| Jul 2026 | COP 2,608,157 | 34.4% | COP 293,773 | COP 84,134 | 25 days | 5.8 nights |
| Aug 2026 | COP 2,493,583 | 27.2% | COP 304,912 | COP 80,438 | 26 days | 4.1 nights |
| Sep 2026 | COP 5,196,512 | 32.9% | COP 310,178 | COP 173,217 | 20 days | 2.8 nights |
Averages per active listing in each month. Highlighted: the highest-revenue month of the 12. RevPAR is the month's revenue spread over its nights, booked or not. Booking lead time is the days between booking and check-in, and length of stay the nights per booking, for stays in that month.
The typical Madrid listing earns about COP 999,000 a month, but one property can land well above or below that. The free Airbnb calculator gives a range for a specific address, built from the comparable listings around it.
Profit
Is an Airbnb in Madrid Profitable?
Yes, when it's run well. The average Madrid Airbnb took in COP 21,644,372 in the 12 months to October 2026, an average that counts every active listing, including those open only part of the year. A listing in the top quarter took in about COP 49,630,000, and run by its owner at everyday costs, about COP 2,970,000 a month of that is left after running costs, so a home that costs less than that to own or rent makes money.
These amounts come before housing costs. Where the mortgage or rent is less each month, the difference is profit; a home owned outright keeps it all after property tax, home insurance and any building or condo fees.
Madrid Airbnb Income, Expenses and Profit per Year
| Line | Average listing | Top-quarter listing |
|---|---|---|
| Money in | ||
| Nightly bookings | COP 20,654,372 | COP 47,350,000 |
| Cleaning fees guests pay5% of Madrid bookings | COP 990,000 | COP 2,280,000 |
| Gross bookings | COP 21,644,372 | COP 49,630,000 |
| Running costs | ||
| Airbnb's feeAbout 13%: 15.5% for the 79% of Madrid listings on Simplified Pricing, 3% for the rest | −COP 2,790,000 | −COP 6,400,000 |
| Cleaning and laundryPaid for by the cleaning fee; COP 0 if you clean yourself | −COP 990,000 | −COP 2,280,000 |
| Utilities and internetAbout 5% of bookings | −COP 1,080,000 | −COP 2,480,000 |
| Guest suppliesToiletries, coffee, paper goods: about 2% | −COP 430,000 | −COP 990,000 |
| Repairs and upkeepIncluding linens and small replacements: about 3% | −COP 650,000 | −COP 1,490,000 |
| Short-term rental insuranceOne policy, on top of Airbnb's free AirCover | −COP 220,000 | −COP 220,000 |
| Permit and registrationWhere one is required | −COP 110,000 | −COP 110,000 |
| ManagementCOP 0 when you run it; co-hosts charge from about 10% of nightly bookings | COP 0 | COP 0 |
| Pricing and messaging toolsOptional; Airbnb's own tools are free | COP 0 | COP 0 |
| Lodging taxesAdded to the guest's bill and passed on | COP 0 | COP 0 |
| Total running costsAbout 24% of bookings, plus cleaning paid for by the cleaning fee | −COP 6,270,000 | −COP 13,970,000 |
| Left for housing costs, then profit | COP 15,374,372about COP 1,280,000 a month | COP 35,660,000about COP 2,970,000 a month |
| Housing costs | ||
| Mortgage or rent, property tax, home insurance, building or condo fees | Depend on the home | |
Estimate Your Own Madrid Airbnb Profit
The estimate starts from Madrid's average listing, run by its owner. Change how the listing performs, who runs it and who cleans to see what is left for the mortgage or rent.
To work out the profit on one Madrid home, with its price, its mortgage or rent and your own costs, use the Airbnb profit calculator. It starts from the comparable listings around the address.
How Madrid's Top Earners Get There
- More nights booked. The busiest quarter of Madrid listings are booked on 41% or more of their nights, against 22% for the median listing. Ten more booked nights a year at the median rate of COP 135,000 adds about COP 1,350,000 in bookings.
- Prices that follow demand. Ranked by price, the top quarter charge COP 187,000 a night or more, against a median of COP 135,000. That is a separate ranking from the busiest quarter, so the two marks don't multiply into one listing's takings. For the average listing, a 10% higher rate on the nights it already books adds about COP 2,070,000 a year.
- Open for the busy months. In a typical year, September brings the average listing about COP 5,200,000, against COP 1,770,000 in April, so a calendar that is open and full in the busy months carries the year.
- Reviews that stand out. Madrid listings average 4.74 stars, and 21% carry Airbnb's Guest Favorite badge, which guests can filter for.
What a listing keeps comes down to the figures this page measures: nightly rate, nights booked and the months it's open. A listing at the top-quarter mark takes in about COP 4,140,000 a month, against COP 1,800,000 for the average one.
Occupancy
What Is the Airbnb Occupancy Rate in Madrid?
Madrid listings were booked on 30% of the nights they were open over the past year, 7 percentage points above the Cundinamarca average (23%) and 3 points below the Colombia average (33%). In a typical year, occupancy climbs to 33% in September and falls to 16% in October.
Across Madrid's 24 active listings, the share of open nights booked by tier:
- Best-in-class properties (top 10%) are booked 62%+ of open nights, 40 points above the median.
- Strong performers (top 25%) fill 41% or more, roughly three nights a week.
- Typical properties (median) fill about 22% of open nights.
- Entry-level properties (bottom 25%) fill 13% or less, less than one night a week.
September is usually the busiest month in Madrid, October the quietest
Share of open nights booked, by month, October 2024 to September 2026
The 12-month rate of 30% averages each listing's whole year, slow months included; each month here counts only the listings booked in it.
Nightly rates
How Much Does an Airbnb Cost per Night in Madrid?
The average nightly rate in Madrid, known as ADR (average daily rate), was COP 311,265 over the past year, about 26% below the Cundinamarca average of COP 419,000 and about 17% below the Colombia average of COP 374,000. Averaged month by month over the past two years, rates peak in September at about COP 310,000 and bottom out in December at about COP 219,000.
Across Madrid's 24 active listings, nightly rates by tier:
- Best-in-class properties (top 10%) charge COP 455,000+ a night, about 3.4 times the median.
- Strong performers (top 25%) charge COP 187,000 or more, about COP 52,000 above the median.
- Typical properties (median) charge about COP 135,000 a night.
- Entry-level properties (bottom 25%) charge COP 94,400 or less, about two-thirds of the median.
September rates run 41% above December's
Average nightly rate (ADR), by month, October 2024 to September 2026
The dashed line is the average of the months shown, COP 255,000. The 12-month ADR of COP 311,265 averages each listing's own rate across its whole year; the monthly points average listings month by month, so the two differ.
What Is the RevPAR for Airbnb in Madrid?
RevPAR, or revenue per available night, divides a listing's income by every night it was open to book, so it rises with both price and bookings. In Madrid it averaged COP 80,500 over the past year, from about COP 59,100 in a typical April to about COP 173,000 in a typical September.
Across Madrid's 24 active listings, RevPAR by tier:
- Best-in-class properties (top 10%) earn COP 103,000+ per open night, about 2.8 times the median.
- Strong performers (top 25%) earn COP 57,500 or more, about COP 21,000 a night above the median.
- Typical properties (median) earn about COP 36,400 per open night.
- Entry-level properties (bottom 25%) earn COP 27,300 or less, about three-quarters of the median.
September RevPAR is about three times April's
Revenue per open night (RevPAR), by month, October 2024 to September 2026
The dashed line is the average of the months shown, COP 88,300. The 12-month RevPAR of COP 80,500 averages each listing's whole year, slow months included; each month here counts only the listings booked in it.
Seasonality
Best and Worst Months for Airbnb in Madrid
With only 24 active listings, the monthly pattern in Madrid is noisy, since a few long or pricey stays can lift a month; revenue has tended to peak in September and bottom out in April.
Average revenue by month in Madrid
Average revenue per active listing, each calendar month averaged over the past two years
The dashed line is the average of the 12 calendar months, COP 2,790,000.
Revenue by month in Madrid in numbers
| Month | Revenue per listing |
|---|---|
| January | COP 3,010,000 |
| February | COP 2,040,000 |
| March | COP 2,890,000 |
| April | COP 1,770,000 |
| May | COP 2,340,000 |
| June | COP 2,850,000 |
| July | COP 2,460,000 |
| August | COP 2,740,000 |
| September | COP 5,200,000 |
| October | COP 2,730,000 |
| November | COP 2,250,000 |
| December | COP 3,220,000 |
How Far in Advance Do Guests Book Airbnb in Madrid?
Guests book Madrid stays 18 days ahead on average (about three weeks), so many trips are booked close to arrival. December stays are booked furthest out, about 32 days ahead, and April stays closest to arrival, about 7 days. A typical December booking is made in mid-November.
December stays are booked furthest ahead
Average days between booking and check-in, by month of stay, October 2024 to September 2026
Permits
Airbnb Permits and Registration in Madrid
96% of the 24 active listings in Madrid display a registration, permit or license number. The share shows what hosts display, not what local rules allow: it can't show whether new permits are still issued, or whether limits on nights, zones or property types apply.
Registration, permit, zoning and tourist-tax rules vary by address and change often, so confirm them with the local authority before buying or listing in Madrid.
Neighborhoods
Best Neighborhoods for Airbnb in Madrid
AirROI's area guide picks eight Madrid neighborhoods that draw short-term rental guests, led by La Candelaria, Chapinero and Teusaquillo. The picks reflect guest appeal, not earnings data or permit eligibility, so check local permit rules for a specific address before buying.
| Area | Who it suits | Landmarks nearby |
|---|---|---|
| La Candelaria | Historic heart of Madrid, known for its colonial architecture, museums, and cultural institutions. Attracts tourists interested in history and culture with close proximity to major landmarks. | Gold Museum, Botero Museum, Plaza de Bolívar, Palacio de Justicia, Museo del Oro |
| Chapinero | Trendy neighborhood with a vibrant nightlife and dining scene. Popular with locals and tourists alike, known for its eclectic shops and cultural diversity. | Parque de la 93, Andino Shopping Mall, Zona T, La Universidad de Los Andes, Parque El Chicó |
| Teusaquillo | Residential area with a rich architectural heritage and green spaces. Offers a mix of tranquility and urban convenience, ideal for families and long-term visitors. | Parque Simón Bolívar, Museo Nacional de Colombia, Estadio El Campín, Café del Museo, Teatro Jorge Eliécer Gaitán |
| Usaquén | Charming neighborhood with cobblestone streets and a vibrant flea market. Known for its restaurants and artisan shops, ideal for tourists seeking a local experience. | Usaquén Flea Market, Parque Usaquén, Colonial architecture, Diners and cafes, Shopping boutiques |
| La Macarena | Cultural hotspot with a mix of art galleries, restaurants, and theaters. Attracts artists and young people looking for a creative atmosphere. | Teatro La Mama, Museo de Arte Moderno, Cafés and bars, Street art, Cultural events |
| Centro Internacional | Business district with modern buildings and amenities. Ideal for business travelers and those attending conferences in the area. | Corferias, Parque de la 93, National Library of Colombia, Cinemas and theaters, Restaurants and cafes |
| Santa Fe | Up-and-coming neighborhood with a mix of residential and commercial spaces. Offers affordable lodging and proximity to universities and tech companies. | Centro Comercial Calle 170, Parque de Los Novios, University of La Sabana, Restaurants and coworking spaces, Cultural events |
| El Chicó | Upscale residential area with parks and luxury shopping. Popular among affluent travelers seeking a comfortable and sophisticated stay. | El Chicó Park, Santa Ana Mall, Cafés and gourmet restaurants, High-end boutiques, Cultural institutions |
Area descriptions are AI-assisted from public sources and are not checked against zoning.
Nearby markets
Madrid vs. Nearby Airbnb Markets
Of the eight nearby markets in the table, all within 28 km, La Vega (28 km away) earned the most per listing, about 67% more than Madrid. Mosquera was the busiest, booked on 38% of nights against 30% in Madrid.
| Market | Listings | Avg. annual revenue | Avg. nightly rate | Occupancy |
|---|---|---|---|---|
| Mosquera 8 km | 35 | COP 16,119,708 | COP 158,596 | 38% |
| Cota 16 km | 47 | COP 16,885,394 | COP 317,851 | 24% |
| Subachoque 20 km | 52 | COP 29,601,646 | COP 454,759 | 22% |
| Bogota Capital District - Municipality 22 km | 5,267 | COP 18,211,606 | COP 179,002 | 37% |
| Casco urbano de Chía 24 km | 134 | COP 12,078,790 | COP 176,621 | 31% |
| San Francisco 24 km | 103 | COP 20,911,658 | COP 438,310 | 20% |
| Tabio 26 km | 49 | COP 16,119,708 | COP 385,847 | 17% |
| La Vega 28 km | 169 | COP 36,078,837 | COP 657,941 | 21% |
Other Airbnb Markets in Cundinamarca
- Cajicá Airbnb data 67 listings
- Fusagasugá Airbnb data 59 listings
- Choachí Airbnb data 49 listings
- Guaduas Airbnb data 32 listings
- Machetá Airbnb data 32 listings
- Sopó Airbnb data 31 listings
See all 32 Cundinamarca Airbnb markets
Markets Similar to Madrid
Markets elsewhere in Colombia with a similar nightly rate and occupancy to Madrid:
- Pereira Airbnb data Colombia · COP 306,971/night · 31.9%
- Salento Airbnb data Colombia · COP 341,738/night · 29.8%
- Palmira Airbnb data Colombia · COP 349,578/night · 29.3%
- Armenia Airbnb data Colombia · COP 274,694/night · 31.1%
- Santa Marta Airbnb data Colombia · COP 357,894/night · 31.3%
- AMCO, Area Metropolitana Centro Occidente Airbnb data Area Metropolitana Centro Occidente, Colombia · COP 347,600/night · 33.1%
FAQ
Madrid Airbnb FAQ
How much do Airbnb hosts make in Madrid?
An active Madrid Airbnb grossed COP 21,644,372 on average in the 12 months to October 2026, according to AirROI's tracking of 24 active listings. That is before cleaning, management, taxes and financing. Busier, better-run listings do far better: the top quarter took in COP 2,290,000 or more in a typical month.
How much can I make on Airbnb in Madrid?
It depends most on the home's size, location and how it's run. The middle half of Madrid listings earn between COP 587,000 and COP 2,290,000 in a typical month, and the top tenth COP 8,270,000 or more. For one home, enter its address and bedroom count in the Airbnb income calculator: it compares the home with similar listings nearby.
What is the average Airbnb occupancy rate in Madrid?
Listings in Madrid were booked on 30% of available nights over the past year. That compares with 23% for the Cundinamarca average. September is usually the busiest month.
How much does an Airbnb cost per night in Madrid?
The average booked night in Madrid cost COP 311,265 before fees. Half of listings charge between COP 94,400 and COP 187,000; a few high-priced homes pull the average above that range.
Do you need a permit for an Airbnb in Madrid?
In Madrid, 96% of active listings display a registration, permit or license number. The share shows what hosts display, not what the rules allow, so confirm registration, permit and tourist-tax rules with the local authority before buying.
Is Airbnb profitable in Madrid?
Yes, when it's run well. The average Madrid Airbnb grossed COP 21,644,372 in the 12 months to October 2026, in line with the Cundinamarca average, though with only 24 active listings a single property can move that figure, counting listings open only part of the year. A listing at the top-quarter mark, run by its owner with the cleaning fee covering the cleaner and everyday costs for Airbnb's fee, utilities, supplies, upkeep and insurance, has about COP 2,970,000 a month left before the mortgage or rent, so a home that costs less than that to own or rent makes a profit. Check a specific home in the Airbnb calculator.
When is Airbnb peak season in Madrid?
September usually pays best, averaging COP 5,200,000 per active listing, and April usually pays least. The month-by-month table above shows how the latest 12 months played out.
What is the Airbnb RevPAR in Madrid?
Each night a Madrid listing was open to book earned COP 80,500 on average over the past year, booked or not. That figure, revenue per available night (RevPAR), folds price and occupancy into one number; the top 10% of listings made COP 103,000 or more.
How far in advance do guests book Airbnbs in Madrid?
Madrid stays were booked 18 days (about three weeks) before arrival on average over the past year, so a listing can still fill close to the date.
How long do guests stay at Airbnbs in Madrid?
The average Madrid Airbnb stay lasted 5.8 nights over the past year. A listing took 12 reservations over the year on average.
How are Airbnbs in Madrid rated?
Guests rate Madrid Airbnbs 4.74 out of 5 on average. Guests score communication highest and cleanliness lowest.
What are the best neighborhoods for Airbnb in Madrid?
La Candelaria, Chapinero and Teusaquillo draw the most short-term rental interest in Madrid. The neighborhood guide explains what brings guests to each.
How many Airbnbs are there in Madrid?
AirROI counted 24 active Airbnb listings in Madrid as of October 2026. The closest tracked market is Mosquera, 8 km away.
How much are Airbnb cleaning fees in Madrid?
In Madrid, about seven in ten listings add a cleaning fee. The median fee is COP 51,290; a handful of extreme values pull the simple average far above that, so the median is the better guide.
How many tourists visit Madrid, Colombia?
All of Colombia had 6,696,835 visitors in 2024, Ministerio de Comercio, Industria y Turismo (MinCIT) reports. AirROI estimates 282 Airbnb stays in Madrid, Colombia in the 12 months to October 2026, which counts bookings and not tourists. See Colombia tourism statistics.
Method
About This Data
Figures on this page cover 24 active Airbnb listings in Madrid from November 2025 to October 2026 (trailing twelve months). AirROI refreshes them monthly from listing-level booking and calendar data covering 20+ million properties worldwide. AirROI measures bookings in US dollars; this page shows them in Colombian pesos at COP 3,664 per US$, the typical rate from November 2025 to October 2026. Annual revenue averages every listing active during the period, including those listed for only part of it; monthly figures average the listings active in each month; the tier lists show the spread. Neighborhood descriptions are AI-assisted. See the methodology for definitions.
Need this programmatically? The same metrics are available through the AirROI Airbnb Data API and bulk downloads in the data portal.