Tel: 0034 972 77 02 72 / 0034 972 77 00 40

Horario de apertura

50 years of professional experience
Buscar alquileres

calendar

calendar

Facebook
Alquileres destacados
No valid database connection Got error 28 from storage engine SQL=SELECT tp.id, CASE WHEN CHAR_LENGTH(tp.alias) THEN CONCAT_WS(":", tp.id, tp.alias) ELSE tp.id END AS `slug`,tp.ref, tp.title, tp.is_renting ,tp.price AS price, tp.living_space, tp.land_space, tp.advantages, tp.ordering AS ordering, td.value AS `department`, ts.value AS `slogan`, tt.value AS `type`, tto.value AS `town`, tp.date_insert AS date_insert, tpr.low AS `price_low`, tpr.mid AS `price_mid`, tpr.high AS `price_high`, ta.value as `area`, tr.desc as `desc`, td.id AS `id2`, ts.id AS `id3`, tt.id AS `id4`, tto.id AS `id5`, tpr.id AS `id6`, ta.id AS `id7` FROM jos_jea_properties AS tp LEFT JOIN jos_jea_departments AS td ON td.id = tp.department_id LEFT JOIN jos_jea_slogans AS ts ON ts.id = tp.slogan_id LEFT JOIN jos_jea_types AS tt ON tt.id = tp.type_id LEFT JOIN jos_jea_towns AS tto ON tto.id = tp.town_id LEFT JOIN jos_jea_prices AS tpr ON tpr.id = tp.price_id LEFT JOIN jos_jea_areas AS ta ON ta.id = tp.area_id LEFT JOIN jos_jea_rentaltypes AS tr ON tr.id = tp.rental_type_id WHERE tp.emphasis=1 AND tp.published=1 AND tp.is_renting=1 ORDER BY rand() limit 5
Notificación
  • Le informamos que esta propiedad ha sido eliminada de nuestro catálogo o ya no se halla disponible
Nuestra web usa cookies para ofrecerle un mejor servicio. Al visitar nuestra web, acepta el uso que hacemos de las cookies. OK