Propriétés à vendre | Lexington Realty
Lexington Realty dedicated estate agency in Costa Blanca

Maisons 1 - 18 / 1448

Propriétés à vendre


2025-02-13T17:20:37+01:00info
Database connected
2025-02-13T17:20:37+01:00sql5 ms
SELECT *, clave FROM lexington_traducciones
2025-02-13T17:20:37+01:00sql0 ms
SELECT clave, valor FROM lexington_config
2025-02-13T17:20:37+01:00sql0 ms
	SELECT id, clave, parent_id, privado, formulario,
					titulo_fr AS titulo, banner,
					link_fr AS link,
					slug_fr AS slug,
					meta_key_fr AS meta_key,
					meta_descr_fr AS meta_descr,
					art_fr AS text
					FROM lexington_articulos 
					 WHERE slug_fr = 'proprietes-a-vendre' 
					
2025-02-13T17:20:37+01:00sql0 ms
	SELECT id, clave, 
					titulo_fr AS title,
					link_fr AS link,
					slug_fr AS slug,
					art_fr AS text,
					meta_descr_fr AS meta,
					(SELECT img.file_name as file_name
        FROM lexington_images_articulos img
        WHERE img.parent_id = main.id
        ORDER BY img.orden ASC
        LIMIT 1) AS file_name 
					FROM lexington_articulos main
					WHERE parent_id = 48
					ORDER BY orden
					
2025-02-13T17:20:37+01:00sql0 ms
SELECT file_name FROM lexington_images_articulos WHERE parent_id = 48 ORDER BY orden
2025-02-13T17:20:37+01:00sql0 ms
SELECT file_name FROM lexington_files_articulos WHERE parent_id = 48 ORDER BY orden
2025-02-13T17:20:37+01:00sql1 ms
 	SELECT *, id, clave, link_fr AS link,  titulo_fr AS titulo,
					slug_fr AS slug, header_menu, footer_menu, parent_id, orden
					FROM lexington_articulos
					ORDER BY orden
					
2025-02-13T17:20:37+01:00sql0 ms
SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'viviendas-comprar'
2025-02-13T17:20:37+01:00sql0 ms
SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'viviendas-comprar'
2025-02-13T17:20:37+01:00sql0 ms
SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'viviendas-comprar'
2025-02-13T17:20:37+01:00sql0 ms
SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'viviendas-comprar'
2025-02-13T17:20:37+01:00sql261 ms
					SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
					sup_parcela, precio_de_venta, main.fecha_creado, precio_desde,
					descripcion_fr AS descripcion,
					piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones,
					 
					
					lat, lon, reservado, vendido, reducido, agente,
					main.titulo_fr AS titulo, 
					loc.nombre AS localidad,
					tip.nombre_fr AS tipo, 
					cla.id AS clase_id, cla.nombre_fr AS clase,
					cos.nombre_fr AS costa, loc.costa_id,
					opciones_json,
					
						(SELECT img.file_name as file_name
						FROM lexington_images_viviendas img
						WHERE img.parent_id = main.id
						ORDER BY img.orden ASC, img.id ASC
						LIMIT 1) AS file_name
					FROM lexington_viviendas main
					LEFT JOIN lexington_localidades loc ON main.localidad_id = loc.id
					LEFT JOIN lexington_zonas zon ON main.zona_id = zon.id
					LEFT JOIN lexington_tipos tip ON main.tipo_id = tip.id
					LEFT JOIN lexington_clases cla ON main.clase_id = cla.id
					LEFT OUTER JOIN lexington_costas cos ON loc.costa_id = cos.id
					WHERE 1 = 1
		 AND (visible = 1) ORDER BY main.id DESC
2025-02-13T17:20:37+01:00sql180 ms
					SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
					sup_parcela, precio_de_venta, main.fecha_creado, precio_desde,
					descripcion_fr AS descripcion,
					piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones,
					 
					
					lat, lon, reservado, vendido, reducido, agente,
					main.titulo_fr AS titulo, 
					loc.nombre AS localidad,
					tip.nombre_fr AS tipo, 
					cla.id AS clase_id, cla.nombre_fr AS clase,
					cos.nombre_fr AS costa, loc.costa_id,
					opciones_json,
					
						(SELECT img.file_name as file_name
						FROM lexington_images_viviendas img
						WHERE img.parent_id = main.id
						ORDER BY img.orden ASC, img.id ASC
						LIMIT 1) AS file_name
					FROM lexington_viviendas main
					LEFT JOIN lexington_localidades loc ON main.localidad_id = loc.id
					LEFT JOIN lexington_zonas zon ON main.zona_id = zon.id
					LEFT JOIN lexington_tipos tip ON main.tipo_id = tip.id
					LEFT JOIN lexington_clases cla ON main.clase_id = cla.id
					LEFT OUTER JOIN lexington_costas cos ON loc.costa_id = cos.id
					WHERE 1 = 1
		 AND (visible = 1) ORDER BY main.id DESC LIMIT 0, 18 
2025-02-13T17:20:37+01:00sql0 ms
SELECT meta_descr_fr AS field FROM lexington_articulos WHERE clave = 'inicio'
2025-02-13T17:20:37+01:00sql0 ms
SELECT art_fr AS field FROM lexington_articulos WHERE clave = 'inicio'
2025-02-13T17:20:37+01:00sql0 ms
	SELECT file_name, art.id AS aid
					FROM lexington_images_articulos img
					JOIN lexington_articulos art
						ON img.parent_id = art.id
					WHERE art.clave = 'viviendas-comprar'
2025-02-13T17:20:37+01:00sql0 ms
SELECT id, nombre_fr AS nombre FROM lexington_costas ORDER BY orden
2025-02-13T17:20:37+01:00sql2 ms
                    SELECT id, nombre AS nombre 
                    FROM lexington_localidades  c
                    WHERE c.id IN (SELECT DISTINCT localidad_id FROM lexington_viviendas WHERE visible = 1)
                    ORDER BY nombre
2025-02-13T17:20:37+01:00sql1 ms
                    SELECT id, nombre_fr AS nombre 
                    FROM lexington_tipos  c
                    WHERE c.id IN (SELECT DISTINCT tipo_id FROM lexington_viviendas WHERE visible = 1)
                    ORDER BY nombre
2025-02-13T17:20:37+01:00sql10 ms
                    SELECT id, referencia AS nombre 
                    FROM lexington_viviendas  c
                    WHERE visible = 1
                    ORDER BY nombre