Property for sale in Costa Blanca | Lexington Realty
Lexington Realty real estate agency in Costa Blanca, Alicante, Santa Pola, Gran Alacant

Property for sale in Costa Blanca

Lexington Realty is a real estate agency with its headquarters in Alicante. We offer a wide range of properties in and around Alicante, Costa Blanca.  Lexington Realty stands for integrity, trustworthiness and experience.

Read more
Property for sale in Costa Blanca
Property map
All areas (Click to open)

Buying a property in Spain

Read more

Selling property in Spain

Read more

Sold properties

Read more

Trusted property advisor

.... for the professional and personal manner  the selling of no. 104 was carried out Thank you and your members of staff  for the professional and personal manner   the selling of...

Frank Duncan Jones UK Read more

... our demands were taken completely serious,  "........We did not want to be on the inspection trip, but just to find a house alone with a real estate intermediary. We received...

Ellen Cravach Denmark Read more
More happy clients

Latest news

12th February 2025
Living disCONNECTED

Living on the Costa Blanca not only offers you the wonders of the sea and sun but also proximity to the vibrant capital, Madrid. What if I told you that you don't need to take a plane to experience the best of both worlds? The tranquility and beauty of the coast and the energy and cultural...

Read more
29th January 2025
Costa Blanca, living in paradise.

The Costa Blanca, with its stunning beaches and enviable climate, is a destination that has captured the hearts of many families. The region offers a healthy and active lifestyle, thanks to the abundance of outdoor spaces, parks, and nature reserves. From seaside promenades to mountain hiking...

Read more
15th January 2025
Housing = Safe Value

In 2024, the housing market has taken center stage in the economic sphere, both in terms of buying and renting. This year has witnessed a steady increase in prices, driven by high demand and limited supply. For those looking to invest, this scenario presents a unique opportunity. According to...

Read more

2025-02-14T16:37:46+01:00info
Database connected
2025-02-14T16:37:46+01:00sql16 ms
SELECT *, clave FROM lexington_traducciones
2025-02-14T16:37:46+01:00sql1 ms
SELECT clave, valor FROM lexington_config
2025-02-14T16:37:46+01:00sql1 ms
	SELECT id, clave, parent_id, privado, formulario,
					titulo_en AS titulo, banner,
					link_en AS link,
					slug_en AS slug,
					meta_key_en AS meta_key,
					meta_descr_en AS meta_descr,
					art_en AS text
					FROM lexington_articulos 
					WHERE clave = 'inicio'
					
2025-02-14T16:37:46+01:00sql0 ms
	SELECT id, clave, 
					titulo_en AS title,
					link_en AS link,
					slug_en AS slug,
					art_en AS text,
					meta_descr_en 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 = 1
					ORDER BY orden
					
2025-02-14T16:37:46+01:00sql0 ms
SELECT file_name FROM lexington_images_articulos WHERE parent_id = 1 ORDER BY orden
2025-02-14T16:37:46+01:00sql1 ms
SELECT file_name FROM lexington_files_articulos WHERE parent_id = 1 ORDER BY orden
2025-02-14T16:37:46+01:00sql4 ms
 	SELECT *, id, clave, link_en AS link,  titulo_en AS titulo,
					slug_en AS slug, header_menu, footer_menu, parent_id, orden
					FROM lexington_articulos
					ORDER BY orden
					
2025-02-14T16:37:46+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 = 'inicio'
2025-02-14T16:37:46+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 = 'inicio'
2025-02-14T16:37:46+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 = 'inicio'
2025-02-14T16:37:46+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 = 'inicio'
2025-02-14T16:37:46+01:00sql4 ms
  SELECT *, titulo_en AS titulo, descr_en AS descripcion, link_en AS link 
                    FROM lexington_panoramicas 
                    ORDER BY orden
2025-02-14T16:37:46+01:00sql26 ms
SELECT id FROM lexington_viviendas WHERE destacado = 1 AND visible = 1
2025-02-14T16:37:46+01:00sql4 ms
					SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
					sup_parcela, precio_de_venta, main.fecha_creado, precio_desde,
					descripcion_en AS descripcion,
					piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones,
					 
					
					lat, lon, reservado, vendido, reducido, agente,
					main.titulo_en AS titulo, 
					loc.nombre AS localidad,
					tip.nombre_en AS tipo, 
					cla.id AS clase_id, cla.nombre_en AS clase,
					cos.nombre_en 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 ( main.id = 8331 OR  main.id = 11940 OR  main.id = 11991 OR  main.id = 12129 OR  main.id = 12304 OR  main.id = 12343) ORDER BY main.id DESC
2025-02-14T16:37:46+01:00sql5 ms
					SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
					sup_parcela, precio_de_venta, main.fecha_creado, precio_desde,
					descripcion_en AS descripcion,
					piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones,
					 
					
					lat, lon, reservado, vendido, reducido, agente,
					main.titulo_en AS titulo, 
					loc.nombre AS localidad,
					tip.nombre_en AS tipo, 
					cla.id AS clase_id, cla.nombre_en AS clase,
					cos.nombre_en 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 ( main.id = 8331 OR  main.id = 11940 OR  main.id = 11991 OR  main.id = 12129 OR  main.id = 12304 OR  main.id = 12343) ORDER BY main.id DESC LIMIT 0, 18 
2025-02-14T16:37:46+01:00sql8 ms
SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (opciones_json LIKE '%"65"%')
2025-02-14T16:37:46+01:00sql9 ms
SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (opciones_json LIKE '%"83"%')
2025-02-14T16:37:46+01:00sql5 ms
SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (clase_id = 1)
2025-02-14T16:37:46+01:00sql2 ms
SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (localidad_id = 2)
2025-02-14T16:37:46+01:00sql1 ms
SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (localidad_id = 5)
2025-02-14T16:37:46+01:00sql2 ms
SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (localidad_id = 18)
2025-02-14T16:37:46+01:00sql388 ms
					SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
					sup_parcela, precio_de_venta, main.fecha_creado, precio_desde,
					descripcion_en AS descripcion,
					piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones,
					 
					
					lat, lon, reservado, vendido, reducido, agente,
					main.titulo_en AS titulo, 
					loc.nombre AS localidad,
					tip.nombre_en AS tipo, 
					cla.id AS clase_id, cla.nombre_en AS clase,
					cos.nombre_en 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 8
2025-02-14T16:37:46+01:00sql31 ms
	SELECT loc.id AS id, loc.nombre, COUNT(*) AS count
					FROM lexington_viviendas viv
					LEFT JOIN lexington_localidades loc
						ON viv.localidad_id = loc.id 
					GROUP BY loc.nombre
					ORDER BY count DESC

				
2025-02-14T16:37:46+01:00sql2 ms
	SELECT id,
					titulo_en AS titulo,
					descr_en AS descripcion,
					fecha
					
		, (SELECT img.file_name as file_name
		FROM lexington_images_noticias img
		WHERE img.parent_id = main.id
		ORDER BY img.orden ASC
		LIMIT 1) AS img
					FROM lexington_noticias main
					 WHERE fecha <= '2025-02-14' 
					ORDER BY fecha DESC
					 LIMIT 3
2025-02-14T16:37:47+01:00sql5 ms
  
                    SELECT main.*, mensaje_en AS mensaje,
                    pais.nombre_en AS pais,
                    
                    (SELECT img.file_name as file_name
                    FROM lexington_images_testimonios img
                    WHERE img.parent_id = main.id
                    ORDER BY img.orden ASC
                    LIMIT 1) AS file_name
                    FROM lexington_testimonios main
                    LEFT OUTER JOIN lexington_paises pais
                    ON main.pais_id = pais.id
                    AND mensaje_en != ''
                     ORDER BY RAND() 
                     LIMIT 2 
                    
2025-02-14T16:37:47+01:00sql1 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 = 'inicio'
2025-02-14T16:37:47+01:00sql0 ms
SELECT id, nombre_en AS nombre FROM lexington_costas ORDER BY orden
2025-02-14T16:37:47+01:00sql4 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-14T16:37:47+01:00sql5 ms
                    SELECT id, nombre_en 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-14T16:37:47+01:00sql56 ms
                    SELECT id, referencia AS nombre 
                    FROM lexington_viviendas  c
                    WHERE visible = 1
                    ORDER BY nombre
2025-02-14T16:37:47+01:00sql1 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 = 'inicio'