×

DroomHuisSpanje
Avda. Príncipe de Asturias 92
30858 Paretón, Totana
Murcia, Spanje

3 slaapkamer design villa op luxueus resort - DroomHuisSpanje 3 slaapkamer design villa op luxueus resort - DroomHuisSpanje 3 slaapkamer design villa op luxueus resort - DroomHuisSpanje 3 slaapkamer design villa op luxueus resort - DroomHuisSpanje 3 slaapkamer design villa op luxueus resort - DroomHuisSpanje 3 slaapkamer design villa op luxueus resort - DroomHuisSpanje 3 slaapkamer design villa op luxueus resort - DroomHuisSpanje 3 slaapkamer design villa op luxueus resort - DroomHuisSpanje 3 slaapkamer design villa op luxueus resort - DroomHuisSpanje 3 slaapkamer design villa op luxueus resort - DroomHuisSpanje 3 slaapkamer design villa op luxueus resort - DroomHuisSpanje 3 slaapkamer design villa op luxueus resort - DroomHuisSpanje 3 slaapkamer design villa op luxueus resort - DroomHuisSpanje
Video
13 Afbeeldingen

3 slaapkamer design villa op luxueus resort

Prijs vanaf 419.000€

La Finca Golf - Costa Blanca Zuid
Ref: TRAN-1
  • Slaapkamers
  • Badkamers
  • 132,95 m2
Energie certificaat: In afwachting

3 slaapkamer design villa met eigen zwembad op luxueus resort.

Deze vrijstaande villa´s liggen in een gesloten complex, inclusief groot zwembad en tuin in het centrum van het complex, waarvan alle bewoners kunnen genieten. De villa´s zijn gebouwd op percelen van 500m2 en hebben 3 slaapkamers en 2 badkamers. De hoofdslaapkamer heeft een eigen badkamer en inloopkast. De ruime zitkamer, met dubbel hoog plafond, omvat een eethoek en een keuken in Amerikaanse stijl. Vanuit de woonkamer heeft u prachtig zicht op het eigen zwembad. 

Alle villa´s zijn inclusief volledig geïnstalleerde airco, vloerverwarming in de badkamers, privézwembad, en parkeergelegenheid op het terrein. Tegen meerprijs is het mogelijk een kelder te bouwen.

Download brochure

Vraag meer info aan

Nynke Betten - DroomHuisSpanje
Nynke Betten
Verkoopadviseur
*
*
*

Specificaties

Zwembad
Ja
Tuin
Ja
Oriëntatie
-
Uitzicht
-
Parking
Parkeerplaats

Oppervlaktes

Opp. woning
132,95 m2
Opp. terrein
500 m2
Opp. terras
56,35 m2

Afstanden

Luchthaven Alicante
55 km
Luchthaven Murcia - Corvera
72 km
Strand
21 km
Golf
100 m

Details

  • Rolluiken
  • Vloerverwarming badkamers
  • Inbouwkasten
  • Terras
  • Extra bergruimte
  • Airconditioning

La Finca Golf

La Finca is een exclusieve woonwijk die zich uitstrekt rond de gelijknamige golfbaan La Finca Golf. Het biedt hoge kwaliteit diensten zoals het 5-sterren Hotel met Spa, een groot clubhuis, golfschool, sport voorzieningen en een winkelcentrum met vele opties voor vrije tijds besteding. De huizen...

Lees meer

Vergelijkbare woningen

Nieuw

450.000€

Villa in Totana

Totana , Costa Cálida
  • 8
  • 4
  • 304,42m2
  • 20810m2
Sleutelklaar

359.000€

Appartement in Las Colinas Golf

Las Colinas Golf , Costa Blanca Zuid
  • 2
  • 2
  • 104m2

380.500€

Moderne vrijstaande villa met privé zwembad vlakbij het strand

Los Alcázares , Costa Cálida
  • 3
  • 3
  • 121,97m2
  • 261,50m2
Whatsapp icon Whastapp

2021-10-21T07:30:11+02:00info
Database connected
2021-10-21T07:30:11+02:00sql5 ms
SELECT *, clave FROM droom_traducciones
2021-10-21T07:30:11+02:00sql0 ms
SELECT clave, valor FROM droom_config
2021-10-21T07:30:11+02:00sql0 ms
	SELECT id, clave, parent_id, privado, formulario,
					titulo_nl AS titulo, banner,
					link_nl AS link,
					slug_nl AS slug,
					video,
					meta_key_nl AS meta_key,
					meta_descr_nl AS meta_descr,
					art_nl AS text
					FROM droom_articulos 
					 WHERE slug_nl = 'woningen' 
					
2021-10-21T07:30:11+02:00sql0 ms
	SELECT id, clave, 
					titulo_nl AS title,
					link_nl AS link,
					slug_nl AS slug,
					art_nl AS text,
					meta_descr_nl AS meta,
					(SELECT img.file_name as file_name
        FROM droom_images_articulos img
        WHERE img.parent_id = main.id
        ORDER BY img.orden ASC
        LIMIT 1) AS file_name 
					FROM droom_articulos main
					WHERE parent_id = 2
					ORDER BY orden
					
2021-10-21T07:30:11+02:00sql0 ms
SELECT file_name FROM droom_images_articulos WHERE parent_id = 2 ORDER BY orden
2021-10-21T07:30:11+02:00sql0 ms
SELECT * FROM droom_files_articulos WHERE parent_id = 2 ORDER BY orden
2021-10-21T07:30:11+02:00sql1 ms
 	SELECT *, id, clave, link_nl AS link,  titulo_nl AS titulo,
					slug_nl AS slug, header_menu, footer_menu, parent_id, orden
					FROM droom_articulos
					ORDER BY orden
					
2021-10-21T07:30:11+02:00sql0 ms
SELECT slug_es, slug_en, slug_nl FROM droom_articulos WHERE clave = 'viviendas'
2021-10-21T07:30:11+02:00sql0 ms
SELECT slug_es, slug_en, slug_nl FROM droom_articulos WHERE clave = 'viviendas'
2021-10-21T07:30:11+02:00sql0 ms
        SELECT equ.*, car.nombre_nl AS cargo,
        equ.id AS main_id,
        equ.idioma_id AS idiomas
        
        , (SELECT img.file_name as file_name
        FROM droom_images_equipo img
        WHERE img.parent_id = equ.id
        ORDER BY img.orden ASC, img.id ASC
        LIMIT 1) AS file_name 
        FROM droom_equipo equ
        LEFT OUTER JOIN droom_cargos car
            ON equ.cargo_id = car.id
        
2021-10-21T07:30:11+02:00sql2 ms
	SELECT main.*, titulo_nl AS titulo,
					main.descripcion_nl AS descripcion,
					loc.nombre as localidad, cos.provincia, fecha_creado,
					loc.costa_id,
					zon.nombre as zona,
					loc.codigo_postal AS codigo_postal,
					cla.nombre_nl as clase,
					tip.nombre_nl as tipo,
					cos.nombre_nl as costa,
					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 droom_viviendas main
					LEFT JOIN droom_localidades loc
						ON main.localidad_id = loc.id
					LEFT JOIN droom_zonas zon
						ON main.zona_id = zon.id
					LEFT OUTER JOIN droom_costas cos
						ON loc.costa_id = cos.id
					LEFT JOIN droom_clases cla
						ON main.clase_id = cla.id
					LEFT JOIN droom_tipos tip
						ON main.tipo_id = tip.id
					LEFT JOIN droom_piscinas pis
						ON main.piscina_id = pis.id
					LEFT JOIN droom_jardines jar
						ON main.jardin_id = jar.id
					LEFT JOIN droom_orientaciones ori
						ON main.orientacion_id = ori.id
					LEFT JOIN droom_parkings par
						ON main.parking_id = par.id
					LEFT JOIN droom_vistas vis
						ON main.vista_id = vis.id

					WHERE main.id = 410
2021-10-21T07:30:11+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'in' AND used != 2
2021-10-21T07:30:11+02:00sql0 ms
SELECT nombre, descripcion_nl AS descripcion FROM droom_localidades WHERE id = 14
2021-10-21T07:30:11+02:00sql0 ms
SELECT parent_id, file_name FROM droom_images_localidades WHERE parent_id = 14 ORDER BY orden
2021-10-21T07:30:11+02:00sql13 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'precio_desde' AND used != 2
2021-10-21T07:30:11+02:00sql4 ms
SELECT parent_id, file_name FROM droom_images_viviendas WHERE parent_id = 410 ORDER BY orden
2021-10-21T07:30:11+02:00sql0 ms
SELECT parent_id, file_name FROM droom_files_viviendas WHERE parent_id = 410 ORDER BY orden
2021-10-21T07:30:11+02:00sql0 ms
SELECT id, nombre_nl as nombre FROM droom_opciones ORDER BY orden
2021-10-21T07:30:11+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'pendiente' AND used != 2
2021-10-21T07:30:11+02:00sql0 ms
SELECT slug_es, slug_en, slug_nl FROM droom_articulos WHERE clave = 'viviendas'
2021-10-21T07:30:11+02:00sql9 ms
					SELECT main.id AS main_id, referencia, dormitorios, banos,
					sup_vivienda, sup_parcela, piscina_id,
					sup_parcela, precio_de_venta, fecha_creado, precio_desde,
					main.descripcion_nl AS descripcion,
					pisc.id AS piscina_id, pisc.nombre_nl as piscina, zon.nombre as zona, main.opciones_json AS opciones,
					 
					
					lat, lon, reservado, vendido, reducido, keyready, exclusiva,
					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,
					opciones_json,
					
						(SELECT img.file_name as file_name
						FROM droom_images_viviendas img
						WHERE img.parent_id = main.id
						ORDER BY img.orden ASC, img.id ASC
						LIMIT 1) AS file_name
					FROM droom_viviendas main
					LEFT JOIN droom_localidades loc ON main.localidad_id = loc.id
					LEFT JOIN droom_zonas zon ON main.zona_id = zon.id
					LEFT JOIN droom_tipos tip ON main.tipo_id = tip.id
					LEFT JOIN droom_clases cla ON main.clase_id = cla.id
					LEFT JOIN droom_costas cos ON loc.costa_id = cos.id
					LEFT JOIN droom_piscinas pisc ON main.piscina_id = pisc.id
					WHERE 1 = 1
		 AND (precio_de_venta >= 335200) AND (precio_de_venta <= 502800) AND (main.id != 410) AND (visible = 1) ORDER BY main.id DESC LIMIT 3
2021-10-21T07:30:11+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'in' AND used != 2
2021-10-21T07:30:11+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'nuevo' AND used != 2
2021-10-21T07:30:11+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'in' AND used != 2
2021-10-21T07:30:11+02:00sql13 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'precio_desde' AND used != 2
2021-10-21T07:30:11+02:00sql13 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'keyready' AND used != 2
2021-10-21T07:30:11+02:00sql14 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'precio_desde' AND used != 2
2021-10-21T07:30:11+02:00sql1 ms
        SELECT equ.*, car.nombre_nl AS cargo,
        equ.id AS main_id,
        equ.idioma_id AS idiomas
        
        , (SELECT img.file_name as file_name
        FROM droom_images_equipo img
        WHERE img.parent_id = equ.id
        ORDER BY img.orden ASC, img.id ASC
        LIMIT 1) AS file_name 
        FROM droom_equipo equ
        LEFT OUTER JOIN droom_cargos car
            ON equ.cargo_id = car.id
        
2021-10-21T07:30:11+02:00sql0 ms
SELECT meta_descr_nl AS field FROM droom_articulos WHERE clave = 'inicio'
2021-10-21T07:30:11+02:00sql0 ms
SELECT art_nl AS field FROM droom_articulos WHERE clave = 'inicio'
2021-10-21T07:30:11+02:00sql0 ms
	SELECT file_name, art.id AS aid
					FROM droom_images_articulos img
					JOIN droom_articulos art
						ON img.parent_id = art.id
					WHERE art.clave = 'viviendas'
2021-10-21T07:30:11+02:00sql0 ms
SELECT nombre_nl AS nombre FROM droom_costas WHERE id = 2
2021-10-21T07:30:11+02:00sql0 ms
SELECT nombre_nl AS nombre FROM droom_tipos WHERE id = 5
2021-10-21T07:30:11+02:00sql0 ms
SELECT nombre_es AS nombre FROM droom_costas WHERE id = 2
2021-10-21T07:30:11+02:00sql0 ms
SELECT nombre_es AS nombre FROM droom_tipos WHERE id = 5
2021-10-21T07:30:11+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'in' AND used != 2
2021-10-21T07:30:11+02:00sql0 ms
SELECT nombre_en AS nombre FROM droom_costas WHERE id = 2
2021-10-21T07:30:11+02:00sql0 ms
SELECT nombre_en AS nombre FROM droom_tipos WHERE id = 5
2021-10-21T07:30:11+02:00sql0 ms
SELECT nombre_nl AS nombre FROM droom_costas WHERE id = 2
2021-10-21T07:30:11+02:00sql0 ms
SELECT nombre_nl AS nombre FROM droom_tipos WHERE id = 5
2021-10-21T07:30:11+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'espana' AND used != 2
2021-10-21T07:30:11+02:00sql0 ms
SELECT nombre_es AS nombre FROM droom_costas WHERE id = 2
2021-10-21T07:30:11+02:00sql0 ms
SELECT nombre_es AS nombre FROM droom_tipos WHERE id = 5
2021-10-21T07:30:11+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'in' AND used != 2
2021-10-21T07:30:11+02:00sql0 ms
SELECT nombre_en AS nombre FROM droom_costas WHERE id = 2
2021-10-21T07:30:11+02:00sql0 ms
SELECT nombre_en AS nombre FROM droom_tipos WHERE id = 5
2021-10-21T07:30:12+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'video' AND used != 2
2021-10-21T07:30:12+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'imagenes' AND used != 2
2021-10-21T07:30:12+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'precio_desde' AND used != 2
2021-10-21T07:30:12+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'dormitorios' AND used != 2
2021-10-21T07:30:12+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'banos' AND used != 2
2021-10-21T07:30:12+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'certificado_energia' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'descargar_pdf' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'requerir_informacion' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'nombre' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'email' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'telefono' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'mensaje' AND used != 2
2021-10-21T07:30:12+02:00sql1 ms
SELECT art_nl AS art_sin FROM droom_traducciones WHERE clave = 'politica_privacidad'
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'enviar_pregunta' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'especificaciones' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'piscina' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'jardin' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'orientacion' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'vistas' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'garaje' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'superficies' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'sup_vivienda' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'sup_parcela' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'sup_terrazas' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'distancias' AND used != 2
2021-10-21T07:30:12+02:00sql7 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'distancia_aeropuerto_alicante' AND used != 2
2021-10-21T07:30:12+02:00sql10 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'distancia_aeropuerto_murcia' AND used != 2
2021-10-21T07:30:12+02:00sql10 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'distancia_playa' AND used != 2
2021-10-21T07:30:12+02:00sql10 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'distancia_golf' AND used != 2
2021-10-21T07:30:12+02:00sql10 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'detalles' AND used != 2
2021-10-21T07:30:12+02:00sql10 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'leer_mas' AND used != 2
2021-10-21T07:30:12+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'propiedades_similares' AND used != 2
2021-10-21T07:30:12+02:00sql10 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'empresa' AND used != 2
2021-10-21T07:30:12+02:00sql2 ms
SELECT art_nl AS art_sin FROM droom_traducciones WHERE clave = 'empresa'
2021-10-21T07:30:12+02:00sql10 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'contactenos' AND used != 2
2021-10-21T07:30:12+02:00sql10 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'espana' AND used != 2
2021-10-21T07:30:12+02:00sql10 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'horario' AND used != 2
2021-10-21T07:30:12+02:00sql10 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'lunes' AND used != 2
2021-10-21T07:30:12+02:00sql10 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'viernes' AND used != 2
2021-10-21T07:30:12+02:00sql1 ms
SELECT art_nl AS art_sin FROM droom_traducciones WHERE clave = 'horario'
2021-10-21T07:30:12+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'nuestro_equipo' AND used != 2