* Adults & children > 2 years old
No valid database connection Unknown column 'Array' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS a.id,a.nom,a.fotos,a.city_id,a.persones,a.num_habs,a.type_id,a.short_desc, a.rango_piso,a.banos,a.PrecioCleaningMensual,a.TarifaBajaDia,a.TarifaBajaMes, a.TarifaLongTerm, a.EstanciaMinima, a.MonthlyRent,a.Descuento6DiasBaja, a.gps1,a.gps2,co.total_apartments ,a.superficie AS superficieconstruida,c.city, co.country, ty.type as type_name, IF(a.TarifaBajaDiaBis > 0, a.TarifaBajaDiaBis, a.TarifaBajaDia) AS TarifaBajaDiaBis, IF(a.EstanciaMinimaBis > 0, a.EstanciaMinimaBis, a.EstanciaMinima) AS EstanciaMinimaBis,(SELECT AVG( com.valor_global ) AS rating FROM jos_apartments_encuestas AS com WHERE com.apartment_id = a.id AND com.publish = 1 ) AS puntuacion ,CASE WHEN a.TarifaLongTerm > 0 THEN a.TarifaLongTerm WHEN a.MonthlyRent > 0 THEN a.MonthlyRent WHEN a.TarifaBajaDia > 0 THEN a.TarifaBajaDia END AS precio_por_dia , (SELECT GROUP_CONCAT(fac.nom, '#', fac.icon ) FROM jos_apartments_facilities AS fac JOIN jos_apartments_apartment_facilities AS af ON af.id_facility = fac.id WHERE af.id_apartment = a.id AND af.id_facility IN(12,32,35)) AS facilities_show,(SELECT DISTINCT value FROM jos_jf_content WHERE reference_table = 'apartments_apartments' AND reference_field = 'short_desc' AND reference_id = a.id AND language_id = 4 LIMIT 1) AS short_desc FROM jos_apartments_apartments as a LEFT JOIN jos_apartments_cities as c ON c.id = a.city_id LEFT JOIN jos_apartments_countries as co ON co.id = c.country_id LEFT JOIN jos_apartments_types as ty ON ty.id = a.type_id LEFT JOIN jos_apartments_apartment_facilities as fac ON fac.id_apartment = a.id WHERE ( a.num_habs = Array ) AND a.persones >= 1 AND c.country_id = 2 AND a.publish = 1 AND a.Activo = 1 GROUP BY a.id ORDER BY CASE WHEN precio_por_dia = 0 THEN 999999 ELSE precio_por_dia END ASC

Apartments for rent in Madrid

Aspasios offers a wide range of apartments for rent in Madrid, all with their specific characteristics, atmosphere and style. Hereunder you will find them listed. If you want to rapidly locate an apartment that suits you best. Find your apartment in Madrid according to your needs (name, number of guests, bedrooms, and area), just clicking the arrows on top of the list.

1 rental apartments in Madrid

Ver en listado
Mostrar
per page
Ordenar resultados por
Ver en mapa


Find information about apartments for rent on Aspasios' blog in spanish Find apartments for rent on Flickr Aspasios' profile Find apartments for rent on LinkedIn Aspasios' company page Find apartments for rent on Pinterest Aspasios' boards Find apartments for rent on Google+ Aspasios' business page Find information about apartments for rent on Aspasios' blog in english Call us through Skype for apartments for rent in Barcelona Find apartments for rent on Twitter Aspasios' profile Find apartments for rent on Facebook 's Aspasios fan page