No valid database connection Unknown column 'none' 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,1 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 = none ) AND a.persones >= 1 AND c.country_id = 1 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 Barcelona
Aspasios offers a wide range of apartments for rent in Barcelona, 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 Barcelona according to your needs (name, number of guests, bedrooms, and area), just clicking the arrows on top of the list.