Hét portaal voor huizen in Spanje

nl
Zoeken
Prijs Prijs
Slaapkamers
Badkamers
Meer opties
Meer opties

184 huizen te koop in Spanje Resultaten

Sorteren:
Grid Lijst

Pilar de la Horadada

Pilar de la Horadada is één van de meest populaire gebieden van de Vega Baja aan de Costa Blanca zuid geworden. Het is een geweldige omgeving voor gezinnen, stelletjes en ook een geweldige keuze voor gepensioneerden die willen genieten van de rustige levensstijl welke deze regio de bieden heeft. Pilar de la Horadada heeft prachtige stranden met helder blauw water, talrijke bars en restaurants om van uw verblijf te genieten, populaire en culturele tentoonstellingen en tal van mooie gebieden om te bezoeken.

Meer info

Huizen te koop in Pilar de la Horadada

Bent u makelaar? Publiceer vandaag nog uw aanbod woningen te koop

Hét portaal voor huizen in Spanje

Hoewel beschouwd als accuraat, wijzen wij elke verantwoordelijkheid voor de hier ingevoerde informatie af. Deze gegevens zijn niet contractueel.

© Copyright 2020 Immo Spanje vastgoed portaal - Alle rechten voorbehouden

Accept cookies

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

Akkoord

2020-10-22T20:05:24+02:00info2048 Kb
Database connected
2020-10-22T20:05:24+02:00info2048 Kb
Database connected
2020-10-22T20:05:24+02:00sql2048 Kb
SELECT *, clave FROM immospanje_traducciones
2020-10-22T20:05:24+02:00sql4096 Kb
SELECT clave, valor FROM immospanje_config
2020-10-22T20:05:24+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 = 'huis-kopen-in-spanje'
2020-10-22T20:05:24+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 = 10
					ORDER BY orden
2020-10-22T20:05:24+02:00sql4096 Kb
SELECT file_name FROM immospanje_images_articulos WHERE parent_id = 10 ORDER BY orden
2020-10-22T20:05:24+02:00sql4096 Kb
SELECT file_name FROM immospanje_files_articulos WHERE parent_id = 10 ORDER BY orden
2020-10-22T20:05:24+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-22T20:05:24+02:00sql4096 Kb
SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'localidades'
2020-10-22T20:05:24+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-22T20:05:24+02:00sql4096 Kb
SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'localidades'
2020-10-22T20:05:24+02:00sql4096 Kb
SELECT *, titulo_nl AS titulo, link_nl AS link FROM immospanje_panoramicas ORDER BY orden
2020-10-22T20:05:24+02:00sql4096 Kb
	SELECT loc.*, loc.corto_nl AS corto, 
					loc.descripcion_nl AS descripcion,
					cos.nombre_nl AS costa
					FROM immospanje_localidades loc
					LEFT OUTER JOIN immospanje_costas cos
						ON loc.costa_id = cos.id
					WHERE loc.id = '39'
2020-10-22T20:05:24+02:00sql4096 Kb
	SELECT parent_id, file_name 
					FROM immospanje_images_localidades 
					WHERE parent_id = 39 
					ORDER BY orden
2020-10-22T20:05:24+02:00sql4096 Kb
SELECT id FROM immospanje_articulos WHERE clave = 'localidades'
2020-10-22T20:05:24+02:00sql4096 Kb
SELECT file_name FROM immospanje_images_articulos WHERE parent_id = 10 ORDER BY orden
2020-10-22T20:05:24+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-22T20:05:24+02:00sql4096 Kb
SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'localidades'
2020-10-22T20:05:24+02:00sql4096 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 (visible = 1) AND (main.localidad_id = 39) ORDER BY score DESC
2020-10-22T20:05:24+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 (visible = 1) AND (main.localidad_id = 39) ORDER BY score DESC LIMIT 0, 15
2020-10-22T20:05:24+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 = 9
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 13674
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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 = 11
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 14532
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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 = 9
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 15316
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 15798
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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 = 9
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 15298
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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 = 5
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 3393
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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 = 20
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 20540
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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 = 9
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 13692
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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 = 5
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 1520
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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 = 16
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 18979
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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 = 11
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 13648
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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 = 9
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 17720
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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 = 20
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 20372
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 15537
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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 = 16
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 18908
                    ORDER BY orden
                     LIMIT 3
2020-10-22T20:05:24+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 = 'localidades'
2020-10-22T20:05:24+02:00sql6144 Kb
SELECT slug_nl AS field FROM immospanje_articulos WHERE clave = 'viviendas'
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT id, nombre_nl AS nombre 
                    FROM immospanje_clases  c
                    WHERE c.id IN (SELECT DISTINCT clase_id FROM immospanje_viviendas WHERE visible = 1)
                    ORDER BY nombre
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT id, nombre_nl AS nombre 
                    FROM immospanje_tipos  c
                    WHERE c.id IN (SELECT DISTINCT tipo_id FROM immospanje_viviendas WHERE visible = 1)
                    ORDER BY nombre
2020-10-22T20:05:24+02:00sql6144 Kb
                    SELECT id, nombre AS nombre 
                    FROM immospanje_localidades  c
                    WHERE c.id IN (SELECT DISTINCT localidad_id FROM immospanje_viviendas WHERE visible = 1)
                    ORDER BY nombre
2020-10-22T20:05:24+02:00sql6144 Kb
SELECT titulo_nl AS field FROM immospanje_articulos WHERE clave = 'newsletter'
2020-10-22T20:05:24+02:00sql6144 Kb
SELECT art_nl AS field FROM immospanje_articulos WHERE clave = 'newsletter'