×

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

Magnifiek appartement op de begane grond in de Costa Blanca Zuid - DroomHuisSpanje Magnifiek appartement op de begane grond in de Costa Blanca Zuid - DroomHuisSpanje Magnifiek appartement op de begane grond in de Costa Blanca Zuid - DroomHuisSpanje Magnifiek appartement op de begane grond in de Costa Blanca Zuid - DroomHuisSpanje Magnifiek appartement op de begane grond in de Costa Blanca Zuid - DroomHuisSpanje Magnifiek appartement op de begane grond in de Costa Blanca Zuid - DroomHuisSpanje Magnifiek appartement op de begane grond in de Costa Blanca Zuid - DroomHuisSpanje Magnifiek appartement op de begane grond in de Costa Blanca Zuid - DroomHuisSpanje Magnifiek appartement op de begane grond in de Costa Blanca Zuid - DroomHuisSpanje Magnifiek appartement op de begane grond in de Costa Blanca Zuid - DroomHuisSpanje
10 Afbeeldingen

Magnifiek appartement op de begane grond in de Costa Blanca Zuid

Prijs vanaf 180.000€

Torrevieja - Costa Blanca Zuid
Ref: UMBR-1
  • Slaapkamers
  • Badkamers
  • 68 m2
Energie certificaat: In afwachting

Nieuw project van moderne woningen in de woonwijk van Aguas Nuevas, in Torrevieja. Een rustig omgeving met veel dienstverleningen, zoals scholen, grote supermarkten en recreatieve voorzieningen. Het ligt dicht bij het bekende winkelcentrum Habaneras en op slechts 2 km van de fantastische stranden van La Mata in Torrevieja.

Beschikbare appartementen; op de begane grond met tuin en boven verdieping met eigen solarium. De appartementen bestaan uit 2 slaapkamers en 2 badkamers, appartementen op de begane grond bieden de mogelijkheid een derde slaapkamer te realiseren. De residentie heeft een groot gemeenschappelijk terrein met tuinen, gemeenschappelijk zwembad met jacuzzi en een apart zwembad voor kinderen, evenals parkeerplaatsen voor bewoners. 

Download brochure

Vraag meer info aan

Nynke Betten - DroomHuisSpanje
Nynke Betten
Verkoopadviseur
*
*
*

Specificaties

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

Oppervlaktes

Opp. woning
68 m2
Opp. tuin
21 m2
Opp. terras
10 m2

Afstanden

Luchthaven Alicante
43 km
Luchthaven Murcia - Corvera
61 km
Strand
2 km
Golf
11 km

Details

  • Rolluiken
  • Inbouwkasten
  • Terras
  • Keuken apparatuur
  • Pre-installatie airco

Torrevieja

Torrevieja is een stad in de zuidoostelijke provincie Alicante van Spanje, aan de Costa Blanca. Het staat bekend om zijn mediterrane klimaat en kustlijn. Promenades lopen langs zandstranden die door resorts worden ondersteund. In het kleine Museo del Mar y de la Sal huizen tentoonstellingen over de...

Lees meer

Vergelijkbare woningen

Sleutelklaar
Exclusief

165.000€

Vrijstaande 3 slaapkamer villa in het rustieke El Pareton

Paretón , Costa Cálida
  • 3
  • 2
  • 110m2

189.000€

2 slaapkamer penthouse met privé solarium

La Finca Golf , Costa Blanca Zuid
  • 2
  • 2
  • 68,65m2

177.000€

Mooi ruim gelijkvloers appartement

La Finca Golf , Costa Blanca Zuid
  • 2
  • 2
  • 69,11m2
Whatsapp icon Whastapp

2021-10-21T07:30:57+02:00info
Database connected
2021-10-21T07:30:57+02:00sql4 ms
SELECT *, clave FROM droom_traducciones
2021-10-21T07:30:57+02:00sql0 ms
SELECT clave, valor FROM droom_config
2021-10-21T07:30:57+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:57+02:00sql1 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:57+02:00sql0 ms
SELECT file_name FROM droom_images_articulos WHERE parent_id = 2 ORDER BY orden
2021-10-21T07:30:57+02:00sql0 ms
SELECT * FROM droom_files_articulos WHERE parent_id = 2 ORDER BY orden
2021-10-21T07:30:57+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:57+02:00sql0 ms
SELECT slug_es, slug_en, slug_nl FROM droom_articulos WHERE clave = 'viviendas'
2021-10-21T07:30:57+02:00sql0 ms
SELECT slug_es, slug_en, slug_nl FROM droom_articulos WHERE clave = 'viviendas'
2021-10-21T07:30:57+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:57+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 = 365
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'in' AND used != 2
2021-10-21T07:30:57+02:00sql0 ms
SELECT nombre, descripcion_nl AS descripcion FROM droom_localidades WHERE id = 1
2021-10-21T07:30:57+02:00sql0 ms
SELECT parent_id, file_name FROM droom_images_localidades WHERE parent_id = 1 ORDER BY orden
2021-10-21T07:30:57+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'precio_desde' AND used != 2
2021-10-21T07:30:57+02:00sql3 ms
SELECT parent_id, file_name FROM droom_images_viviendas WHERE parent_id = 365 ORDER BY orden
2021-10-21T07:30:57+02:00sql0 ms
SELECT parent_id, file_name FROM droom_files_viviendas WHERE parent_id = 365 ORDER BY orden
2021-10-21T07:30:57+02:00sql0 ms
SELECT id, nombre_nl as nombre FROM droom_opciones ORDER BY orden
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'pendiente' AND used != 2
2021-10-21T07:30:57+02:00sql0 ms
SELECT slug_es, slug_en, slug_nl FROM droom_articulos WHERE clave = 'viviendas'
2021-10-21T07:30:57+02:00sql10 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 >= 144000) AND (precio_de_venta <= 216000) AND (main.id != 365) AND (visible = 1) ORDER BY main.id DESC LIMIT 3
2021-10-21T07:30:57+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'precio_desde' AND used != 2
2021-10-21T07:30:57+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'keyready' AND used != 2
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'exclusiva' AND used != 2
2021-10-21T07:30:57+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'precio_desde' AND used != 2
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'precio_desde' AND used != 2
2021-10-21T07:30:57+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:57+02:00sql0 ms
SELECT meta_descr_nl AS field FROM droom_articulos WHERE clave = 'inicio'
2021-10-21T07:30:57+02:00sql0 ms
SELECT art_nl AS field FROM droom_articulos WHERE clave = 'inicio'
2021-10-21T07:30:57+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:57+02:00sql0 ms
SELECT nombre_nl AS nombre FROM droom_costas WHERE id = 2
2021-10-21T07:30:57+02:00sql0 ms
SELECT nombre_nl AS nombre FROM droom_tipos WHERE id = 1
2021-10-21T07:30:57+02:00sql0 ms
SELECT nombre_es AS nombre FROM droom_costas WHERE id = 2
2021-10-21T07:30:57+02:00sql0 ms
SELECT nombre_es AS nombre FROM droom_tipos WHERE id = 1
2021-10-21T07:30:57+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'in' AND used != 2
2021-10-21T07:30:57+02:00sql0 ms
SELECT nombre_en AS nombre FROM droom_costas WHERE id = 2
2021-10-21T07:30:57+02:00sql0 ms
SELECT nombre_en AS nombre FROM droom_tipos WHERE id = 1
2021-10-21T07:30:57+02:00sql0 ms
SELECT nombre_nl AS nombre FROM droom_costas WHERE id = 2
2021-10-21T07:30:57+02:00sql0 ms
SELECT nombre_nl AS nombre FROM droom_tipos WHERE id = 1
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'espana' AND used != 2
2021-10-21T07:30:57+02:00sql0 ms
SELECT nombre_es AS nombre FROM droom_costas WHERE id = 2
2021-10-21T07:30:57+02:00sql0 ms
SELECT nombre_es AS nombre FROM droom_tipos WHERE id = 1
2021-10-21T07:30:57+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'in' AND used != 2
2021-10-21T07:30:57+02:00sql0 ms
SELECT nombre_en AS nombre FROM droom_costas WHERE id = 2
2021-10-21T07:30:57+02:00sql0 ms
SELECT nombre_en AS nombre FROM droom_tipos WHERE id = 1
2021-10-21T07:30:57+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'imagenes' AND used != 2
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'precio_desde' AND used != 2
2021-10-21T07:30:57+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'dormitorios' AND used != 2
2021-10-21T07:30:57+02:00sql19 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'banos' AND used != 2
2021-10-21T07:30:57+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'certificado_energia' AND used != 2
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'descargar_pdf' AND used != 2
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'requerir_informacion' AND used != 2
2021-10-21T07:30:57+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'nombre' AND used != 2
2021-10-21T07:30:57+02:00sql14 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'email' AND used != 2
2021-10-21T07:30:57+02:00sql13 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'telefono' AND used != 2
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'mensaje' AND used != 2
2021-10-21T07:30:57+02:00sql1 ms
SELECT art_nl AS art_sin FROM droom_traducciones WHERE clave = 'politica_privacidad'
2021-10-21T07:30:57+02:00sql16 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'enviar_pregunta' AND used != 2
2021-10-21T07:30:57+02:00sql12 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'especificaciones' AND used != 2
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'piscina' AND used != 2
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'jardin' AND used != 2
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'orientacion' AND used != 2
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'vistas' AND used != 2
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'garaje' AND used != 2
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'superficies' AND used != 2
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'sup_vivienda' AND used != 2
2021-10-21T07:30:57+02:00sql14 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'sup_jardin' AND used != 2
2021-10-21T07:30:57+02:00sql14 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'sup_terrazas' AND used != 2
2021-10-21T07:30:57+02:00sql11 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'distancias' AND used != 2
2021-10-21T07:30:57+02:00sql5 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'distancia_aeropuerto_alicante' AND used != 2
2021-10-21T07:30:57+02:00sql5 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'distancia_aeropuerto_murcia' AND used != 2
2021-10-21T07:30:57+02:00sql5 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'distancia_playa' AND used != 2
2021-10-21T07:30:57+02:00sql5 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'distancia_golf' AND used != 2
2021-10-21T07:30:57+02:00sql5 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'detalles' AND used != 2
2021-10-21T07:30:58+02:00sql5 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'leer_mas' AND used != 2
2021-10-21T07:30:58+02:00sql5 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'propiedades_similares' AND used != 2
2021-10-21T07:30:58+02:00sql5 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'empresa' AND used != 2
2021-10-21T07:30:58+02:00sql0 ms
SELECT art_nl AS art_sin FROM droom_traducciones WHERE clave = 'empresa'
2021-10-21T07:30:58+02:00sql5 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'contactenos' AND used != 2
2021-10-21T07:30:58+02:00sql5 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'espana' AND used != 2
2021-10-21T07:30:58+02:00sql5 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'horario' AND used != 2
2021-10-21T07:30:58+02:00sql5 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'lunes' AND used != 2
2021-10-21T07:30:58+02:00sql5 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'viernes' AND used != 2
2021-10-21T07:30:58+02:00sql0 ms
SELECT art_nl AS art_sin FROM droom_traducciones WHERE clave = 'horario'
2021-10-21T07:30:58+02:00sql5 ms
UPDATE droom_traducciones SET used = 1 WHERE clave = 'nuestro_equipo' AND used != 2