img

de dormitorios en

Referencia

  • m2
  • Dormitorios
  • Baños
Piscina:
Certificado energético:
Exento

Descripción

Mapa

Enviar consulta sobre esta vivienda

Especificaciones

Dormitorios:

Baños:

Localidad:

Zona:

Piscina:

Más detalles


2020-07-16T02:53:43+02:00info2048 KbDatabase connected
2020-07-16T02:53:43+02:00sql4096 Kb SELECT id, clave, link_es AS link, titulo_es AS titulo, slug_es AS slug, header_menu, footer_menu, parent_id, orden FROM casasymar_articulos ORDER BY orden
2020-07-16T02:53:43+02:00sql4096 Kb SELECT id, clave, link_es AS link, titulo_es AS titulo, slug_es AS slug, header_menu, footer_menu, parent_id, orden FROM casasymar_articulos ORDER BY orden
2020-07-16T02:53:43+02:00sql4096 Kb select v.*, v.titulo_es AS titulo,v.descripcion_es AS descripcion, l.nombre as ciudad, cla.nombre_es as clase, t.nombre_es as tipo, j.nombre_es as jardin, ori.nombre_es as orientacion, cos.nombre_es AS costa, ori.nombre_es AS orientacion, titulo_es,titulo_en,titulo_fr,titulo_de,titulo_se, pis.nombre_es as piscina, vis.nombre_es as vistas, par.nombre_es as parking, z.nombre as zona from casasymar_viviendas as v left join casasymar_localidades as l on l.id = v.localidad_id left join casasymar_zonas as z on z.id = v.zona_id left join casasymar_costas as cos on cos.id = v.costa_id left join casasymar_clases as cla on cla.id = v.clase_id left join casasymar_tipos as t on t.id = v.tipo_id left join casasymar_piscinas as pis on pis.id = v.piscina_id left join casasymar_jardines as j on j.id = v.jardin_id left join casasymar_orientaciones as ori on ori.id = v.orientacion_id left join casasymar_vistas as vis on vis.id = v.vista_id left join casasymar_parkings as par on par.id = v.parking_id where v.visible is true and v.id = 938
2020-07-16T02:53:43+02:00sql4096 Kbselect SQL_CALC_FOUND_ROWS v.id as vid,v.piscina_id, v.titulo_es as titulo,v.referencia, v.vendido, v.reservado, v.localidad_id, l.nombre as ciudad, v.tipo_id, t.nombre_es as tipo, v.sup_vivienda, v.banos, v.dormitorios, v.precio_de_venta, v.precio_anterior, v.precio_desde, c.nombre_es AS costa, s.nombre_es AS clase,v.descripcion_es as descr from casasymar_viviendas as v left join casasymar_localidades as l on l.id = v.localidad_id left join casasymar_tipos as t on t.id = v.tipo_id left join casasymar_costas as c on c.id = v.costa_id left join casasymar_clases as s on s.id = v.clase_id where v.visible is TRUE and v.id != and v.tipo_id = and v.clase_id = and v.precio_de_venta >= -25000 and v.precio_de_venta <= 25000 ORDER BY RAND() limit 2
2020-07-16T02:53:43+02:00error4096 KbMySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and v.tipo_id = and v.clase_id = and v.precio_de_venta >= -25000 and ' at line 10