Discover our wide range of apartments and villas for every budget:
Medvilla Spanje

MedVilla, your real estate agent for properties in Spain

MedVilla Spain is a company with more than 10 years experience in new construction and second hand sales in Costa Blanca and Costa Calida, 

We specialize in the sale of new and second hand properties, luxury properties, properties on golf courses, rural properties in the Hondon Valley and in areas such as Ciudad Quesada, Orihuela Costa (La Zenia, Campoamor, Playa Flamenca ...), Torrevieja (Punta Prima, Los Balcones ...) and the areas of Guardamar and Santa Pola.

In our portfolio you can find all types of properties with the best value for money: apartments, bungalows, townhouses, duplexes, plots, etc always with the lowest price guarantee!

Buy a property in Spain through MedVilla, then we will take care of your NIE number !!

Recommended houses in Spain

Discover our new apartments, villas and properties for sale in Spain

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

Download our glossy MED Magazine for free

Medvilla Spanje
*
*
*

2019-12-09T06:58:06+00:00info1280 KbDatabase connected
2019-12-09T06:58:06+00:00sql1280 KbSELECT *, clave FROM medvilla_traducciones
2019-12-09T06:58:06+00:00sql4864 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 WHERE clave = 'inicio'
2019-12-09T06:58:06+00:00sql4864 Kb SELECT id, clave, titulo_en AS title, link_en AS link, slug_en AS slug, art_en AS text FROM medvilla_articulos WHERE parent_id = 1 ORDER BY orden
2019-12-09T06:58:06+00:00sql4864 KbSELECT file_name FROM medvilla_images_articulos WHERE parent_id = 1 ORDER BY orden
2019-12-09T06:58:06+00:00sql4864 KbSELECT file_name FROM medvilla_files_articulos WHERE parent_id = 1 ORDER BY orden
2019-12-09T06:58:06+00:00sql4864 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 ORDER BY orden
2019-12-09T06:58:06+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'inicio'
2019-12-09T06:58:06+00:00sql4864 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 ORDER BY orden
2019-12-09T06:58:06+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'inicio'
2019-12-09T06:58:06+00:00sql4864 KbSELECT *, titulo_en AS titulo, link_en AS link FROM medvilla_panoramicas ORDER BY orden
2019-12-09T06:58:06+00:00sql4864 KbSELECT nombre_en AS nombre, enlace_en AS enlace FROM medvilla_quicklinks2 ORDER BY orden
2019-12-09T06:58:06+00:00sql4864 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 ORDER BY orden
2019-12-09T06:58:06+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'inicio'
2019-12-09T06:58:06+00:00sql4864 Kb SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda, sup_parcela, sup_terrazas, precio_de_venta, precio_anterior, precio_desde, precio_consultar, fecha_creado, oferta, descripcion_en AS descripcion, intro_en as intro, piscina_id AS piscina, lat, 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 WHERE 1 = 1 ORDER BY main.id DESC
2019-12-09T06:58:06+00:00sql14848 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 ORDER BY orden
2019-12-09T06:58:06+00:00sql14848 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'inicio'
2019-12-09T06:58:06+00:00sql14848 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 ORDER BY orden
2019-12-09T06:58:06+00:00sql14848 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'inicio'
2019-12-09T06:58:06+00:00sql14848 Kb SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda, sup_parcela, sup_terrazas, precio_de_venta, precio_anterior, precio_desde, precio_consultar, fecha_creado, oferta, descripcion_en AS descripcion, intro_en as intro, piscina_id AS piscina, lat, 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 WHERE 1 = 1 AND (destacado = 1) ORDER BY RAND() LIMIT 8
2019-12-09T06:58:06+00:00sql14848 Kb SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda, sup_parcela, sup_terrazas, precio_de_venta, precio_anterior, precio_desde, precio_consultar, fecha_creado, oferta, descripcion_en AS descripcion, intro_en as intro, piscina_id AS piscina, lat, 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 WHERE 1 = 1 AND (super_destacado = 1) ORDER BY RAND() LIMIT 8
2019-12-09T06:58:06+00:00sql14848 KbSELECT file_name FROM medvilla_images_articulos WHERE parent_id = 1 ORDER BY orden
2019-12-09T06:58:06+00:00sql14848 KbSELECT id FROM medvilla_articulos WHERE clave = 'apartamentos'
2019-12-09T06:58:06+00:00sql14848 KbSELECT file_name FROM medvilla_images_articulos WHERE parent_id = 13 ORDER BY orden
2019-12-09T06:58:06+00:00sql14848 KbSELECT id FROM medvilla_articulos WHERE clave = 'villas'
2019-12-09T06:58:06+00:00sql14848 KbSELECT file_name FROM medvilla_images_articulos WHERE parent_id = 14 ORDER BY orden
2019-12-09T06:58:07+00:00sql14848 Kb SELECT cos.nombre_en AS costa, loc.nombre AS localidad, loc.id AS localidad_id, loc.costa_id FROM medvilla_localidades loc LEFT JOIN medvilla_costas cos ON loc.costa_id = cos.id WHERE loc.id IN (SELECT DISTINCT localidad_id FROM medvilla_viviendas WHERE visible = 1) ORDER BY loc.costa_id, loc.nombre
2019-12-09T06:58:07+00:00sql14848 KbSELECT titulo_en AS field FROM medvilla_articulos WHERE clave = 'apartamentos'
2019-12-09T06:58:07+00:00sql14848 KbSELECT art_en AS field FROM medvilla_articulos WHERE clave = 'apartamentos'
2019-12-09T06:58:07+00:00sql14848 KbSELECT titulo_en AS field FROM medvilla_articulos WHERE clave = 'villas'
2019-12-09T06:58:07+00:00sql14848 KbSELECT art_en AS field FROM medvilla_articulos WHERE clave = 'villas'
2019-12-09T06:58:07+00:00sql14848 KbSELECT titulo_en AS field FROM medvilla_articulos WHERE clave = 'zelf-huis-bouwen-in-spanje'
2019-12-09T06:58:07+00:00sql14848 KbSELECT file_name FROM medvilla_files_articulos WHERE parent_id = 1 ORDER BY orden
2019-12-09T06:58:07+00:00sql14848 KbSELECT titulo_en AS field FROM medvilla_articulos WHERE clave = 'ebook-modal'
2019-12-09T06:58:07+00:00sql14848 KbSELECT art_en AS field FROM medvilla_articulos WHERE clave = 'ebook-modal'
2019-12-09T06:58:07+00:00sql14848 Kb SELECT file_name, art.id AS aid FROM medvilla_images_articulos img JOIN medvilla_articulos art ON img.parent_id = art.id WHERE art.clave = 'ebook-modal'