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.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
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.
Aspasios offers a wide selection of apartments for rent in Barcelona and Madrid. Our guests may book our apartments for stays of some days or weeks and extend their stay to several months. Our apartments have been totally furnished and equipped to make our client’s stay as comfortable and agreeable as possible (with audiovisual equipment, adsl, electric devices…) and to avoid him any possible worry. High standing apartments decorated according to the most recent fashion trends. Aspasios team in Barcelona and Madrid, will always be eager to help its clients solve any problem or satisfy their needs. Our guests will enjoy special advantages offered through “Aspasios Select”, a careful selection of boutiques, restaurants, services, etc. where they will usually get special price and receive a neat and speacial service.