Appartement in Pilar de la Horadada - Nieuwbouw - Immo Spanje
302.900€
Ref. FSHS100138

Appartement in Pilar de la Horadada, Costa Blanca Zuid, Spanje

  • 3 Slaapkamers
  • 3 Badkamers
  • 104m2 Huis

Omschrijving

Uitstekende Appartementen in Pilar De La Horadada op 400m van het strand, Costa Blanca zuid, Alicante, Spanje

Eigenschappen

Type woning:
Appartement
Verkoopstype:
Nieuwbouw
Locatie:
Pilar de la Horadada
Zwembad:
Geen
  • Pre-installatie airco
  • Dichtbij winkels

Oppervlaktes

  • 104m2 Huis

Afstanden

Meer informatie en foto’s?

*
*
*
For Sale House Spain, Camposol, Mazarrón
For Sale House Spain logo
+31622066248
Ref: FSHS100138
Toegevoegd op 30/04/2020

Locatie

  • Spanje
  • Costa Blanca Zuid
  • Pilar de la Horadada
Vergelijkbare woningen
Bent u een vastgoedmakelaar? Publiceer vandaag nog  uw woningen aanbod
Accept cookies

Immo Spanje maakt gebruik van cookies om u een betere ervaring te bieden Meer info.


2020-10-22T19:26:36+02:00info2048 Kb
Database connected
2020-10-22T19:26:36+02:00info2048 Kb
Database connected
2020-10-22T19:26:36+02:00sql2048 Kb
SELECT *, clave FROM immospanje_traducciones
2020-10-22T19:26:36+02:00sql4096 Kb
SELECT clave, valor FROM immospanje_config
2020-10-22T19:26:36+02:00sql4096 Kb
	SELECT id, clave, parent_id,
					titulo_nl AS titulo,
					link_nl AS link,
					slug_nl AS slug,
					meta_key_nl AS meta_key,
					meta_descr_nl AS meta_descr,
					art_nl AS text
					FROM immospanje_articulos 
					 WHERE slug_nl = 'immo-spanje' 
					
2020-10-22T19:26:36+02:00sql4096 Kb
	SELECT id, clave, 
					titulo_nl AS title,
					link_nl AS link,
					slug_nl AS slug,
					art_nl AS text
					FROM immospanje_articulos
					WHERE parent_id = 2
					ORDER BY orden
					
2020-10-22T19:26:36+02:00sql4096 Kb
SELECT file_name FROM immospanje_images_articulos WHERE parent_id = 2 ORDER BY orden
2020-10-22T19:26:36+02:00sql4096 Kb
SELECT file_name FROM immospanje_files_articulos WHERE parent_id = 2 ORDER BY orden
2020-10-22T19:26:36+02:00sql4096 Kb
 	SELECT *, id, clave, link_nl AS link,  titulo_nl AS titulo,
					slug_nl AS slug, header_menu, footer_menu, parent_id, orden
					FROM immospanje_articulos
					ORDER BY orden
					
2020-10-22T19:26:36+02:00sql4096 Kb
SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'viviendas'
2020-10-22T19:26:36+02:00sql4096 Kb
 	SELECT *, id, clave, link_nl AS link,  titulo_nl AS titulo,
					slug_nl AS slug, header_menu, footer_menu, parent_id, orden
					FROM immospanje_articulos
					ORDER BY orden
					
2020-10-22T19:26:36+02:00sql4096 Kb
SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'viviendas'
2020-10-22T19:26:36+02:00sql4096 Kb
SELECT *, titulo_nl AS titulo, link_nl AS link FROM immospanje_panoramicas ORDER BY orden
2020-10-22T19:26:36+02:00sql4096 Kb
	SELECT main.*, titulo_nl AS titulo,
					main.descripcion_nl AS descripcion,
					loc.nombre as localidad, 
					-- loc.descr_nl AS descripcion_localidad,
					loc.costa_id,
					cla.nombre_nl as clase,
					tip.nombre_nl as tipo, 
					cos.nombre_nl as costa,
					zon.nombre as zona,
					pis.nombre_nl as piscina,
					jar.nombre_nl as jardin,
					ori.nombre_nl as orientacion,
					par.nombre_nl as parking,
					vis.nombre_nl as vistas
					FROM immospanje_viviendas main
					LEFT JOIN immospanje_localidades loc
						ON main.localidad_id = loc.id
					LEFT JOIN immospanje_costas cos
						ON loc.costa_id = cos.id
					LEFT JOIN immospanje_clases cla
						ON main.clase_id = cla.id
					LEFT JOIN immospanje_zonas zon
						ON main.zona_id = zon.id
					LEFT JOIN immospanje_tipos tip
						ON main.tipo_id = tip.id
					LEFT JOIN immospanje_piscinas pis
						ON main.piscina_id = pis.id
					LEFT JOIN immospanje_jardines jar
						ON main.jardin_id = jar.id
					LEFT JOIN immospanje_orientaciones ori
						ON main.orientacion_id = ori.id
					LEFT JOIN immospanje_parkings par
						ON main.parking_id = par.id
					LEFT JOIN immospanje_vistas vis
						ON main.vista_id = vis.id
						
					WHERE main.id = 12959
2020-10-22T19:26:36+02:00sql4096 Kb
SELECT parent_id, file_name FROM immospanje_images_viviendas WHERE parent_id = 12959 ORDER BY orden
2020-10-22T19:26:36+02:00sql4096 Kb
SELECT id, nombre_nl as nombre FROM immospanje_opciones ORDER BY orden
2020-10-22T19:26:36+02:00sql4096 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:26:36+02:00sql6144 Kb
 	SELECT *, id, clave, link_nl AS link,  titulo_nl AS titulo,
					slug_nl AS slug, header_menu, footer_menu, parent_id, orden
					FROM immospanje_articulos
					ORDER BY orden
					
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'viviendas'
2020-10-22T19:26:36+02:00sql6144 Kb
                    SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
                    sup_parcela, precio_de_venta, precio_anterior, precio_desde, main.fecha_creado AS fecha_creado,
                    main.descripcion_nl AS descripcion, agente,
                    piscina_id AS piscina,
                    main.lat, main.lon, reservado, vendido,
                    main.titulo_nl AS titulo, loc.nombre AS localidad,
                    tip.nombre_nl AS tipo, cla.id AS clase_id,
                    cla.nombre_nl AS clase,
                    cos.nombre_nl AS costa,
                    age.nombre_comercial AS agente_nombre, age.telefono AS agente_telefono, age.email AS agente_email,
                    age.logo AS agente_logo,
                    
                        (SELECT img.file_name as file_name
                        FROM immospanje_images_viviendas img
                        WHERE img.parent_id = main.id
                        ORDER BY img.orden ASC
                        LIMIT 1) AS file_name
                    FROM immospanje_viviendas main
                    LEFT JOIN immospanje_localidades loc ON main.localidad_id = loc.id
                    LEFT JOIN immospanje_tipos tip ON main.tipo_id = tip.id
                    LEFT JOIN immospanje_clases cla ON main.clase_id = cla.id
                    LEFT JOIN immospanje_costas cos ON loc.costa_id = cos.id
                    LEFT JOIN immospanje_agentes age ON main.agente_id = age.id
                    WHERE 1 = 1
         AND (precio_de_venta >= 242320) AND (precio_de_venta <= 363480) AND (main.id != 12959) ORDER BY main.score DESC LIMIT 3
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 12
2020-10-22T19:26:36+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 13367
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 12
2020-10-22T19:26:36+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 17344
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 10
2020-10-22T19:26:36+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 15732
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT meta_descr_nl AS field FROM immospanje_articulos WHERE clave = 'inicio'
2020-10-22T19:26:36+02:00sql6144 Kb
	SELECT file_name, art.id AS aid
					FROM immospanje_images_articulos img
					JOIN immospanje_articulos art
						ON img.parent_id = art.id
					WHERE art.clave = 'viviendas'
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT nombre_nl AS nombre FROM immospanje_costas WHERE id = 2
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT nombre_nl AS nombre FROM immospanje_tipos WHERE id = 1
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT nombre_nl AS nombre FROM immospanje_costas WHERE id = 2
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT nombre_nl AS nombre FROM immospanje_tipos WHERE id = 1
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT nombre_fr AS nombre FROM immospanje_costas WHERE id = 2
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT nombre_fr AS nombre FROM immospanje_tipos WHERE id = 1
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT nombre_en AS nombre FROM immospanje_costas WHERE id = 2
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT nombre_en AS nombre FROM immospanje_tipos WHERE id = 1
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT nombre_fr AS nombre FROM immospanje_costas WHERE id = 2
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT nombre_fr AS nombre FROM immospanje_tipos WHERE id = 1
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT nombre_en AS nombre FROM immospanje_costas WHERE id = 2
2020-10-22T19:26:36+02:00sql6144 Kb
SELECT nombre_en AS nombre FROM immospanje_tipos WHERE id = 1