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 = 2 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 = 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
Alquiler de apartamentos en Barcelona
Aspasios le propone una amplia oferta de apartamentos en alquiler en Barcelona. Alquileres en Barcelona, por días, semanas o meses, en diferentes barrios, cada uno con características, ambiente y estilo propios. A continuación se muestran todos los apartamentos de alquiler en Barcelona gestionados por Aspasios. Puede ordenar los apartamentos según el criterio que le interese, ajustando las flechas del encabezado.