We have not found properties that exactly match your criteria. No problem, MedVilla has access to ALL new build properties on the Costa Blanca, Costa Calida, Costa de Almeria and Costa del Sol. Contact us

Viewing trip

Do you dream of buying a house in Spain?

For three or more days, we will be happy to visit the homes of your dreams with you, we will introduce you to the region, make contacts, explain the financial and tax aspects when purchasing a second home in Spain.

If you find the villa or apartment of your dreams, together with your lawyer we will take care of the complete handling off, from purchase contract to key transfer.

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í.

Aceptar

2022-09-29T18:14:54+00:00info2048 KbDatabase connected
2022-09-29T18:14:54+00:00sql4096 KbSELECT *, clave FROM medvilla_traducciones_vidando
2022-09-29T18:14:54+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 = 'new-contruction-apartments-costa-blanca-spain'
2022-09-29T18:14:54+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 = 13 ORDER BY orden
2022-09-29T18:14:54+00:00sql4096 KbSELECT file_name FROM medvilla_images_articulos_vidando WHERE parent_id = 13 ORDER BY orden
2022-09-29T18:14:54+00:00sql4096 KbSELECT file_name FROM medvilla_files_articulos_vidando WHERE parent_id = 13 ORDER BY orden
2022-09-29T18:14:54+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-29T18:14:54+00:00sql4096 KbSELECT slug_en, slug_nl, slug_fr FROM medvilla_articulos_vidando WHERE clave = 'apartamentos'
2022-09-29T18:14:54+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-29T18:14:54+00:00sql4096 KbSELECT slug_en, slug_nl, slug_fr FROM medvilla_articulos_vidando WHERE clave = 'apartamentos'
2022-09-29T18:14:54+00:00sql4096 KbSELECT nombre_en AS nombre, enlace_en AS enlace FROM medvilla_quicklinks_vidando ORDER BY orden
2022-09-29T18:14:54+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-29T18:14:54+00:00sql4096 KbSELECT slug_en, slug_nl, slug_fr FROM medvilla_articulos_vidando WHERE clave = 'apartamentos'
2022-09-29T18:14:54+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-29T18:14:54+00:00error4096 KbMySql Error (Err_no: 1052) Column 'referencia' in field list is ambiguous
2022-09-29T18:14:55+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-29T18:14:55+00:00sql30720 KbSELECT slug_en, slug_nl, slug_fr FROM medvilla_articulos_vidando WHERE clave = 'apartamentos'
2022-09-29T18:14:55+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 (main.visible = 1) AND (tipo_id = 1) AND (clase_id = 1) AND (precio_de_venta >= MAX_PRICE) ORDER BY clase_id ASC, precio_de_venta ASC
2022-09-29T18:14:55+00:00error30720 KbMySql Error (Err_no: 1052) Column 'referencia' in field list is ambiguous
2022-09-29T18:14:55+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 (main.visible = 1) AND (tipo_id = 1) AND (clase_id = 1) AND (precio_de_venta >= MAX_PRICE) ORDER BY clase_id ASC, precio_de_venta ASC LIMIT 0, 10
2022-09-29T18:14:55+00:00error30720 KbMySql Error (Err_no: 1052) Column 'referencia' in field list is ambiguous
2022-09-29T18:14:55+00:00sql30720 Kb SELECT id, nombre_en AS nombre FROM medvilla_tipos c WHERE c.id IN (SELECT DISTINCT tipo_id FROM medvilla_viviendas WHERE visible = 1) ORDER BY nombre
2022-09-29T18:14:55+00:00sql30720 Kb SELECT id, referencia AS nombre FROM medvilla_viviendas c WHERE visible = 1 ORDER BY nombre