Villa in Moraira - Herverkoop - Immo Spanje
599.000€
Ref. BPBP2863

Villa in Moraira, Costa Blanca Noord, Spanje

  • 4 Slaapkamers
  • 3 Badkamers
  • 383m2 Huis
  • 1300m2 Terrein

Omschrijving

Villa te koop in Pla del mar, Moraira.  Deze villa is verdeeld over twee niveaus met elkaar verbonden via een externe trap en ligt op een vlak, 1.300 meter, perceel gelegen in een rustige doodlopende straat in het populaire gebied van Pla del mar op slechts een paar minuten lopen van het centrum van Moraira met al zijn voorzieningen en zandstranden langs de Middellandse Zee. De toegang tot het pand is gemaakt via het voertuig poorten openen naar een oprit die leidt naar de garage. Op de bovenste verdieping van de villa vinden we de belangrijkste accommodatie, bestaande uit een woon / eetkamer, ingerichte keuken, in-gesloten naya, drie slaapkamers en twee badkamers. De externe trap leidt naar het lagere niveau waar we een gastenappartement vinden dat bestaat uit een ruime woon / eetkamer, ingerichte keuken, naya, dubbele slaapkamer met kantoorruimte en een eigen badkamer.  Deze zeer grote villa is de perfecte gezinswoning en ook een huurinvestering. Buiten vinden we het 10x5 meter zwembad met zijn terrassen en prachtige mediterrane tuinen rondom het pand. Extra's zijn inbegrepen: Centrale verwarming op gas, Air-con in het onderste gedeelte, Doble beglazing in het onderste gedeelte, open haard, Alarm, Sat TV/ADSL, Garage, Berging, Bijkeuken, Zwembad douche.

Eigenschappen

Type woning:
Villa
Verkoopstype:
Herverkoop
Locatie:
Moraira
Zwembad:
Ja
  • Barbecue
  • Garage
  • Satelliet TV
  • Open haard
  • Overdekt terras
  • Bergruimte
  • Tuin
  • Dichtbij de zee
  • Dichtbij alle voorzieningen
  • Garage of parkeerplaats
  • Dubbele beglazing
  • Centrale verwarming op gas

Oppervlaktes

  • 383m2 Huis
  • 1300m2 Terrein

Afstanden

Meer informatie en foto’s?

*
*
*
Bindley Properties, Moraira
Bindley Properties logo
+34 965 049 701
Ref: BPBP2863
Toegevoegd op 16/07/2020

Locatie

  • Spanje
  • Costa Blanca Noord
  • Moraira
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-22T20:00:32+02:00info2048 Kb
Database connected
2020-10-22T20:00:32+02:00info2048 Kb
Database connected
2020-10-22T20:00:32+02:00sql2048 Kb
SELECT *, clave FROM immospanje_traducciones
2020-10-22T20:00:32+02:00sql4096 Kb
SELECT clave, valor FROM immospanje_config
2020-10-22T20:00:32+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-22T20:00:32+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-22T20:00:32+02:00sql4096 Kb
SELECT file_name FROM immospanje_images_articulos WHERE parent_id = 2 ORDER BY orden
2020-10-22T20:00:32+02:00sql4096 Kb
SELECT file_name FROM immospanje_files_articulos WHERE parent_id = 2 ORDER BY orden
2020-10-22T20:00:32+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:00:32+02:00sql4096 Kb
SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'viviendas'
2020-10-22T20:00:32+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:00:32+02:00sql4096 Kb
SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'viviendas'
2020-10-22T20:00:32+02:00sql4096 Kb
SELECT *, titulo_nl AS titulo, link_nl AS link FROM immospanje_panoramicas ORDER BY orden
2020-10-22T20:00:32+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 = 19640
2020-10-22T20:00:32+02:00sql4096 Kb
SELECT parent_id, file_name FROM immospanje_images_viviendas WHERE parent_id = 19640 ORDER BY orden
2020-10-22T20:00:32+02:00sql4096 Kb
SELECT id, nombre_nl as nombre FROM immospanje_opciones ORDER BY orden
2020-10-22T20:00:32+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 = 18
2020-10-22T20:00:32+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:00:32+02:00sql6144 Kb
SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'viviendas'
2020-10-22T20:00:32+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 >= 479200) AND (precio_de_venta <= 718800) AND (main.id != 19640) ORDER BY main.score DESC LIMIT 3
2020-10-22T20:00:32+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 = 2
2020-10-22T20:00:32+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 16605
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T20:00:32+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 = 1
2020-10-22T20:00:32+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 18359
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T20:00:32+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:00:32+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 13674
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T20:00:32+02:00sql6144 Kb
SELECT meta_descr_nl AS field FROM immospanje_articulos WHERE clave = 'inicio'
2020-10-22T20:00:32+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-22T20:00:32+02:00sql6144 Kb
SELECT nombre_nl AS nombre FROM immospanje_costas WHERE id = 1
2020-10-22T20:00:32+02:00sql6144 Kb
SELECT nombre_nl AS nombre FROM immospanje_tipos WHERE id = 5
2020-10-22T20:00:32+02:00sql6144 Kb
SELECT nombre_nl AS nombre FROM immospanje_costas WHERE id = 1
2020-10-22T20:00:32+02:00sql6144 Kb
SELECT nombre_nl AS nombre FROM immospanje_tipos WHERE id = 5
2020-10-22T20:00:32+02:00sql6144 Kb
SELECT nombre_fr AS nombre FROM immospanje_costas WHERE id = 1
2020-10-22T20:00:32+02:00sql6144 Kb
SELECT nombre_fr AS nombre FROM immospanje_tipos WHERE id = 5
2020-10-22T20:00:32+02:00sql6144 Kb
SELECT nombre_en AS nombre FROM immospanje_costas WHERE id = 1
2020-10-22T20:00:32+02:00sql6144 Kb
SELECT nombre_en AS nombre FROM immospanje_tipos WHERE id = 5
2020-10-22T20:00:32+02:00sql6144 Kb
SELECT nombre_fr AS nombre FROM immospanje_costas WHERE id = 1
2020-10-22T20:00:32+02:00sql6144 Kb
SELECT nombre_fr AS nombre FROM immospanje_tipos WHERE id = 5
2020-10-22T20:00:32+02:00sql6144 Kb
SELECT nombre_en AS nombre FROM immospanje_costas WHERE id = 1
2020-10-22T20:00:32+02:00sql6144 Kb
SELECT nombre_en AS nombre FROM immospanje_tipos WHERE id = 5