Upptäck vårt brett utbud av lägenheter och villor för varje budget:
Medvilla Spanje

MedVilla, din fastighetsmäklare i Spanien

Som partner i en grupp med 20 års erfarenhet av försäljning av högkvalitativa fastigheter har MedVilla Spanien byggt upp ett brett utbud med lägenheter, villor och fastigheter till salu i Spanien, alltid med lägsta prisgaranti.

Genom vår unika lokala kunskap och omfattande erfarenhet bör du inte leta efter en annan fastighetsmäklare, hos oss finner ni någon som kan hjälpa er att hitta den perfekta bostad i de vackraste miljöerna Spanien har att erbjuda. 

Vår specialitet är att göra inköpsprocessen av en fastighet i Spanien lätt och bekymmersfri. Vi försäkrar dig om ett säkert köp som uppfyller alla dina behov.

Vi kanske inte är den största fastighetsmäklare ... Men för dig blir vi den bästa

Våra senaste bostäder i Spanien

Upptäck våra lägenheter, villor och hus till salu i Spanien

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

Ladda ner vår GRATIS glänsande MED Magazine

Medvilla Spanje
*
*
*

2019-12-09T11:09:45+00:00info1280 KbDatabase connected
2019-12-09T11:09:45+00:00sql1280 KbSELECT *, clave FROM medvilla_traducciones
2019-12-09T11:09:45+00:00sql4864 Kb SELECT id, clave, parent_id, titulo_se AS titulo, link_se AS link, slug_se AS slug, meta_key_se AS meta_key, meta_descr_se AS meta_descr, art_se AS text FROM medvilla_articulos WHERE clave = 'inicio'
2019-12-09T11:09:45+00:00sql4864 Kb SELECT id, clave, titulo_se AS title, link_se AS link, slug_se AS slug, art_se AS text FROM medvilla_articulos WHERE parent_id = 1 ORDER BY orden
2019-12-09T11:09:45+00:00sql4864 KbSELECT file_name FROM medvilla_images_articulos WHERE parent_id = 1 ORDER BY orden
2019-12-09T11:09:45+00:00sql4864 KbSELECT file_name FROM medvilla_files_articulos WHERE parent_id = 1 ORDER BY orden
2019-12-09T11:09:45+00:00sql4864 Kb SELECT id, clave, link_se AS link, titulo_se AS titulo, slug_se AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos ORDER BY orden
2019-12-09T11:09:45+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'inicio'
2019-12-09T11:09:45+00:00sql4864 Kb SELECT id, clave, link_se AS link, titulo_se AS titulo, slug_se AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos ORDER BY orden
2019-12-09T11:09:45+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'inicio'
2019-12-09T11:09:45+00:00sql4864 KbSELECT *, titulo_se AS titulo, link_se AS link FROM medvilla_panoramicas ORDER BY orden
2019-12-09T11:09:45+00:00sql4864 KbSELECT nombre_se AS nombre, enlace_se AS enlace FROM medvilla_quicklinks2 ORDER BY orden
2019-12-09T11:09:45+00:00sql4864 Kb SELECT id, clave, link_se AS link, titulo_se AS titulo, slug_se AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos ORDER BY orden
2019-12-09T11:09:45+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'inicio'
2019-12-09T11:09:45+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_se AS descripcion, intro_se as intro, piscina_id AS piscina, lat, lon, reservado, vendido, main.titulo_se AS titulo, loc.nombre AS localidad, tip.nombre_se AS tipo, cla.id AS clase_id, cla.nombre_se AS clase, cos.nombre_se 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-09T11:09:46+00:00sql13824 Kb SELECT id, clave, link_se AS link, titulo_se AS titulo, slug_se AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos ORDER BY orden
2019-12-09T11:09:46+00:00sql13824 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'inicio'
2019-12-09T11:09:46+00:00sql13824 Kb SELECT id, clave, link_se AS link, titulo_se AS titulo, slug_se AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos ORDER BY orden
2019-12-09T11:09:46+00:00sql13824 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'inicio'
2019-12-09T11:09:46+00:00sql13824 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_se AS descripcion, intro_se as intro, piscina_id AS piscina, lat, lon, reservado, vendido, main.titulo_se AS titulo, loc.nombre AS localidad, tip.nombre_se AS tipo, cla.id AS clase_id, cla.nombre_se AS clase, cos.nombre_se 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-09T11:09:46+00:00sql13824 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_se AS descripcion, intro_se as intro, piscina_id AS piscina, lat, lon, reservado, vendido, main.titulo_se AS titulo, loc.nombre AS localidad, tip.nombre_se AS tipo, cla.id AS clase_id, cla.nombre_se AS clase, cos.nombre_se 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-09T11:09:46+00:00sql13824 KbSELECT file_name FROM medvilla_images_articulos WHERE parent_id = 1 ORDER BY orden
2019-12-09T11:09:46+00:00sql13824 KbSELECT id FROM medvilla_articulos WHERE clave = 'apartamentos'
2019-12-09T11:09:46+00:00sql13824 KbSELECT file_name FROM medvilla_images_articulos WHERE parent_id = 13 ORDER BY orden
2019-12-09T11:09:46+00:00sql13824 KbSELECT id FROM medvilla_articulos WHERE clave = 'villas'
2019-12-09T11:09:46+00:00sql13824 KbSELECT file_name FROM medvilla_images_articulos WHERE parent_id = 14 ORDER BY orden
2019-12-09T11:09:46+00:00sql13824 Kb SELECT cos.nombre_se 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-09T11:09:46+00:00sql13824 KbSELECT titulo_se AS field FROM medvilla_articulos WHERE clave = 'apartamentos'
2019-12-09T11:09:46+00:00sql13824 KbSELECT art_se AS field FROM medvilla_articulos WHERE clave = 'apartamentos'
2019-12-09T11:09:46+00:00sql13824 KbSELECT titulo_se AS field FROM medvilla_articulos WHERE clave = 'villas'
2019-12-09T11:09:46+00:00sql13824 KbSELECT art_se AS field FROM medvilla_articulos WHERE clave = 'villas'
2019-12-09T11:09:46+00:00sql13824 KbSELECT titulo_se AS field FROM medvilla_articulos WHERE clave = 'zelf-huis-bouwen-in-spanje'
2019-12-09T11:09:46+00:00sql14080 KbSELECT file_name FROM medvilla_files_articulos WHERE parent_id = 1 ORDER BY orden
2019-12-09T11:09:46+00:00sql14080 KbSELECT titulo_se AS field FROM medvilla_articulos WHERE clave = 'ebook-modal'
2019-12-09T11:09:46+00:00sql14080 KbSELECT art_se AS field FROM medvilla_articulos WHERE clave = 'ebook-modal'
2019-12-09T11:09:46+00:00sql14080 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'