Apartment El Raso Guardamar del Segura

El Raso, Costa Blanca South, Spain
Sold

Ref: MVS-309 CBZAREBEAII

Currently, this property does not yet have a description in your own language. We will gladly send you the description as well as the included extras.

Vidando has access to all homes on Costa Blanca North, Costa Blanca South, Costa Calida, Costa de Almeria and Costa del Sol. Our real estate experts are happy to help you finding your dreamhouse for sale in Spain.

Estimated price incl. Costs (Estimate includes VAT or transfer tax, notary, lawyer, registration fee, ...) : 255,360€

New construction project: Area Beach II

  • icon
    Bathrooms: 2
  • icon
    Bedrooms: 2
  • icon
    House area: 77,88m2
  • icon
    Terrace surface: 20,11m2
  • icon
    Swimming pool: communal
  • icon
    Completed: 09 / 2023
  • icon
    Energy certificate: Coming soon

More info and photos?

*
*
El Raso

El Raso property for sale - Buy or sell your Spanish properties in El Raso through MedVilla, your Safe Buy Spain Real Estate agent in El Raso, Alicante.

With an experienced multilingual team that speaks Dutch, English, French, Swedish and of course Spanish, At MedVilla we can offer our services in the language of your preference. Do you want to visit these or similar houses in El Raso? MedVilla offers FREE INSPECTION TRIPS for serious candidates.

If you purchase a property through MedVilla, we will provide your NIE number for FREE

El RasoVidando, Luxury Homes for Life

Would you like more information or an appointment? Enter the information request below!

We will never call you without permission! You will first receive an email with further information.

*
*

How do you wish to be contacted?

When do we contact you the best?

Vidando, Luxury Homes for Life

The location of this property is approximate

GIVE ME THE FULL INFORMATION

We will never call you without permission! You will first receive an email with further information.

*
*
Estoy de acuerdo

Utilizamos cookies propias y de terceros para realizar análisis de uso y de medición de nuestra web para mejorar nuestros servicios. Si continua navegando, consideramos que acepta su uso. Para obtener más información aquí.


2022-09-29T17:47:46+00:00info2048 KbDatabase connected
2022-09-29T17:47:46+00:00sql4096 KbSELECT *, clave FROM medvilla_traducciones_vidando
2022-09-29T17:47:46+00:00sql4096 Kb SELECT id, clave, parent_id, titulo_en AS titulo, link_en AS link, slug_en AS slug, meta_key_en AS meta_key, meta_descr_en AS meta_descr, art_en AS text FROM medvilla_articulos_vidando WHERE slug_en = 'house-for-sale-Spain'
2022-09-29T17:47:46+00:00sql4096 Kb SELECT id, clave, titulo_en AS title, link_en AS link, slug_en AS slug, art_en AS text FROM medvilla_articulos_vidando WHERE parent_id = 2 ORDER BY orden
2022-09-29T17:47:46+00:00sql4096 KbSELECT file_name FROM medvilla_images_articulos_vidando WHERE parent_id = 2 ORDER BY orden
2022-09-29T17:47:46+00:00sql4096 KbSELECT file_name FROM medvilla_files_articulos_vidando WHERE parent_id = 2 ORDER BY orden
2022-09-29T17:47:46+00:00sql4096 Kb SELECT id, clave, link_en AS link, titulo_en AS titulo, slug_en AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos_vidando ORDER BY orden
2022-09-29T17:47:46+00:00sql4096 KbSELECT slug_en, slug_nl, slug_fr FROM medvilla_articulos_vidando WHERE clave = 'viviendas'
2022-09-29T17:47:46+00:00sql4096 Kb SELECT id, clave, link_en AS link, titulo_en AS titulo, slug_en AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos_vidando ORDER BY orden
2022-09-29T17:47:46+00:00sql4096 KbSELECT slug_en, slug_nl, slug_fr FROM medvilla_articulos_vidando WHERE clave = 'viviendas'
2022-09-29T17:47:46+00:00sql4096 KbSELECT nombre_en AS nombre, enlace_en AS enlace FROM medvilla_quicklinks_vidando ORDER BY orden
2022-09-29T17:47:46+00:00sql4096 Kb SELECT id, clave, link_en AS link, titulo_en AS titulo, slug_en AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos_vidando ORDER BY orden
2022-09-29T17:47:46+00:00sql4096 KbSELECT slug_en, slug_nl, slug_fr FROM medvilla_articulos_vidando WHERE clave = 'viviendas'
2022-09-29T17:47:46+00:00sql4096 Kb SELECT main.id AS main_id, referencia, dormitorios, banos, main.video, sup_vivienda, sup_parcela, promo_start, promo_end, promo_en AS promo, sup_terrazas, precio_de_venta, precio_anterior, precio_desde, precio_consultar, main.fecha_creado, oferta, descripcion_en AS descripcion, intro_en as intro, proy.nombre_en AS proyecto, piscina_id AS piscina, promo_en AS promo_texto, main.lat, main.lon, reservado, vendido, main.titulo_en AS titulo, loc.nombre AS localidad, tip.nombre_en AS tipo, cla.id AS clase_id, cla.nombre_en AS clase, cos.nombre_en AS costa , (SELECT img.file_name as file_name FROM medvilla_images_viviendas img WHERE img.parent_id = main.id ORDER BY img.orden ASC LIMIT 1) AS file_name FROM medvilla_viviendas main LEFT JOIN medvilla_localidades loc ON main.localidad_id = loc.id LEFT JOIN medvilla_tipos tip ON main.tipo_id = tip.id LEFT JOIN medvilla_clases cla ON main.clase_id = cla.id LEFT JOIN medvilla_costas cos ON main.costa_id = cos.id LEFT JOIN medvilla_proyectos proy ON main.proyecto_id = proy.id WHERE 1 = 1 ORDER BY clase_id ASC, precio_de_venta ASC
2022-09-29T17:47:46+00:00error4096 KbMySql Error (Err_no: 1052) Column 'referencia' in field list is ambiguous
2022-09-29T17:47:48+00:00sql30720 Kb SELECT main.*, main.titulo_en AS titulo, main.descripcion_en AS descripcion, loc.nombre as localidad, loc.descr_en AS descripcion_localidad, loc_vid.nombre as localidad_vidando, loc_vid.descr_en AS descripcion_localidad_vidando, loc.codigo_postal AS codigo_postal, cos.provincia, cla.nombre_en as clase, tip.nombre_en as tipo, cos.nombre_en as costa, pis.nombre_en as piscina, jar.nombre_en as jardin, ori.nombre_en as orientacion, par.nombre_en as parking, vis.nombre_en as vistas, pro.nombre_en as proyecto, main.promo_en AS promo_texto FROM medvilla_viviendas main LEFT JOIN medvilla_localidades loc ON main.localidad_id = loc.id LEFT JOIN medvilla_localidades_vidando loc_vid ON main.localidad_id = loc_vid.id LEFT JOIN medvilla_costas cos ON main.costa_id = cos.id LEFT JOIN medvilla_clases cla ON main.clase_id = cla.id LEFT JOIN medvilla_tipos tip ON main.tipo_id = tip.id LEFT JOIN medvilla_piscinas pis ON main.piscina_id = pis.id LEFT JOIN medvilla_jardines jar ON main.jardin_id = jar.id LEFT JOIN medvilla_orientaciones ori ON main.orientacion_id = ori.id LEFT JOIN medvilla_parkings par ON main.parking_id = par.id LEFT JOIN medvilla_vistas vis ON main.vista_id = vis.id LEFT JOIN medvilla_proyectos pro ON main.proyecto_id = pro.id WHERE main.id = 3010
2022-09-29T17:47:48+00:00sql30720 Kb SELECT parent_id, file_name FROM medvilla_images_viviendas WHERE parent_id = 3010 ORDER BY orden
2022-09-29T17:47:48+00:00sql30720 Kb SELECT parent_id, file_name FROM medvilla_images_localidades_vidando WHERE parent_id = 260 ORDER BY orden
2022-09-29T17:47:48+00:00sql30720 KbSELECT id, nombre_en as nombre FROM medvilla_opciones ORDER BY orden
2022-09-29T17:47:48+00:00sql30720 Kb SELECT id, clave, link_en AS link, titulo_en AS titulo, slug_en AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos_vidando ORDER BY orden
2022-09-29T17:47:48+00:00sql30720 KbSELECT slug_en, slug_nl, slug_fr FROM medvilla_articulos_vidando WHERE clave = 'viviendas'
2022-09-29T17:47:48+00:00sql30720 Kb SELECT main.id AS main_id, referencia, dormitorios, banos, main.video, sup_vivienda, sup_parcela, promo_start, promo_end, promo_en AS promo, sup_terrazas, precio_de_venta, precio_anterior, precio_desde, precio_consultar, main.fecha_creado, oferta, descripcion_en AS descripcion, intro_en as intro, proy.nombre_en AS proyecto, piscina_id AS piscina, promo_en AS promo_texto, main.lat, main.lon, reservado, vendido, main.titulo_en AS titulo, loc.nombre AS localidad, tip.nombre_en AS tipo, cla.id AS clase_id, cla.nombre_en AS clase, cos.nombre_en AS costa , (SELECT img.file_name as file_name FROM medvilla_images_viviendas img WHERE img.parent_id = main.id ORDER BY img.orden ASC LIMIT 1) AS file_name FROM medvilla_viviendas main LEFT JOIN medvilla_localidades loc ON main.localidad_id = loc.id LEFT JOIN medvilla_tipos tip ON main.tipo_id = tip.id LEFT JOIN medvilla_clases cla ON main.clase_id = cla.id LEFT JOIN medvilla_costas cos ON main.costa_id = cos.id LEFT JOIN medvilla_proyectos proy ON main.proyecto_id = proy.id WHERE 1 = 1 AND (precio_de_venta >= 179200) AND (precio_de_venta <= 268800) AND (clase_id = 1) AND (main.id != 3010) ORDER BY clase_id ASC, precio_de_venta ASC LIMIT 4
2022-09-29T17:47:48+00:00error30720 KbMySql Error (Err_no: 1052) Column 'referencia' in field list is ambiguous
2022-09-29T17:47:48+00:00sql30720 KbSELECT nombre_en AS nombre FROM medvilla_costas WHERE id = 2
2022-09-29T17:47:48+00:00sql30720 KbSELECT nombre_en AS nombre FROM medvilla_tipos WHERE id = 1
2022-09-29T17:47:48+00:00sql30720 KbSELECT nombre_en AS nombre FROM medvilla_costas WHERE id = 2
2022-09-29T17:47:48+00:00sql30720 KbSELECT nombre_en AS nombre FROM medvilla_tipos WHERE id = 1
2022-09-29T17:47:48+00:00sql30720 KbSELECT nombre_nl AS nombre FROM medvilla_costas WHERE id = 2
2022-09-29T17:47:48+00:00sql30720 KbSELECT nombre_nl AS nombre FROM medvilla_tipos WHERE id = 1
2022-09-29T17:47:48+00:00sql30720 KbSELECT nombre_fr AS nombre FROM medvilla_costas WHERE id = 2
2022-09-29T17:47:48+00:00sql30720 KbSELECT nombre_fr AS nombre FROM medvilla_tipos WHERE id = 1
2022-09-29T17:47:48+00:00sql30720 KbSELECT nombre_en AS nombre FROM medvilla_costas WHERE id = 2
2022-09-29T17:47:48+00:00sql30720 KbSELECT nombre_en AS nombre FROM medvilla_tipos WHERE id = 1
2022-09-29T17:47:48+00:00sql30720 KbSELECT nombre_nl AS nombre FROM medvilla_costas WHERE id = 2
2022-09-29T17:47:48+00:00sql30720 KbSELECT nombre_nl AS nombre FROM medvilla_tipos WHERE id = 1
2022-09-29T17:47:48+00:00sql30720 KbSELECT nombre_fr AS nombre FROM medvilla_costas WHERE id = 2
2022-09-29T17:47:48+00:00sql30720 KbSELECT nombre_fr AS nombre FROM medvilla_tipos WHERE id = 1
2022-09-29T17:47:48+00:00sql30720 KbSELECT art_en AS field FROM medvilla_articulos_vidando WHERE clave = 'default-description'