New build villas Spain

Prefer to live in a modern or classic new build villa?

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

Download our glossy MED Magazine for free

Want to receive our Glossy Med Magazine packed with lifestyle information for free? Soon also available in English - Subscribe to receive when available!

Click HERE to download the magazine
Medvilla Spanje
*
*
*

2019-12-06T23:33:54+00:00info1280 KbDatabase connected
2019-12-06T23:33:54+00:00sql1280 KbSELECT *, clave FROM medvilla_traducciones
2019-12-06T23:33:54+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 slug_en = 'new-build-villas-costa-blanca-spain'
2019-12-06T23:33:54+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 = 14 ORDER BY orden
2019-12-06T23:33:54+00:00sql4864 KbSELECT file_name FROM medvilla_images_articulos WHERE parent_id = 14 ORDER BY orden
2019-12-06T23:33:54+00:00sql4864 KbSELECT file_name FROM medvilla_files_articulos WHERE parent_id = 14 ORDER BY orden
2019-12-06T23:33:54+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-06T23:33:54+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'villas'
2019-12-06T23:33:54+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-06T23:33:54+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'villas'
2019-12-06T23:33:54+00:00sql4864 KbSELECT *, titulo_en AS titulo, link_en AS link FROM medvilla_panoramicas ORDER BY orden
2019-12-06T23:33:54+00:00sql4864 KbSELECT nombre_en AS nombre, enlace_en AS enlace FROM medvilla_quicklinks2 ORDER BY orden
2019-12-06T23:33:54+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-06T23:33:54+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'villas'
2019-12-06T23:33:54+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-06T23:33:55+00:00sql14592 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-06T23:33:55+00:00sql14592 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'villas'
2019-12-06T23:33:55+00:00sql14592 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 (visible = 1) AND (tipo_id = 5) AND (clase_id = 1) AND (clase_id = 1) ORDER BY RAND()
2019-12-06T23:33:55+00:00sql14592 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 (visible = 1) AND (tipo_id = 5) AND (clase_id = 1) AND (clase_id = 1) ORDER BY RAND() LIMIT 0, 10
2019-12-06T23:33:55+00:00sql14592 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-06T23:33:55+00:00sql14592 KbSELECT file_name FROM medvilla_files_articulos WHERE parent_id = 14 ORDER BY orden
2019-12-06T23:33:55+00:00sql14592 KbSELECT titulo_en AS field FROM medvilla_articulos WHERE clave = 'ebook-modal'
2019-12-06T23:33:55+00:00sql14592 KbSELECT art_en AS field FROM medvilla_articulos WHERE clave = 'ebook-modal'
2019-12-06T23:33:55+00:00sql14592 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'