Villa de plain-pied avec solarium à vendre Pilar de la Horadada

Pilar de la Horadada, Costa Blanca sud, Espagne
À partir de 199.000€

Ref: MVS-916 MED BEA ONE LEV VIL

Prix estimé, frais compris (Estimation inclut TVA, Notaire, Avocat, Taxe de Transfert et Frais d'enregistrement cadastraux...) : 226.860€

  • icon
    Salles de bains: 2
  • icon
    Chambres: 3
  • icon
    Surface habitable: 75m2
  • icon
    Surface du terrain: 123m2
  • icon
    Piscine: Privé
  • icon
    énèrgie certificat: En attendant
  • À distance de marche du village
  • Internet et téléphone
  • Chauffage par le sol
  • Paquet d'éclairage
  • Espace de stationnement privé
  • Jardin privé
  • Terrasse couverte
  • Pré-installation de la clima
  • Armoires encastrées
  • Electro de cuisine
  • Solarium
  • Terrasse
  • Près de la plage
Pilar de la Horadada

Découvrez plus sur la région et les maisons à Pilar de la Horadada ici

Maison à vendre à Pilar de la Horadada - Achetez ou vendez votre maison à Pilar de la Horadada par votre agent immobilier IPI à Pilar de la Horadada.

Pilar de la HoradadaMedvilla Spanje

Souhaitez-vous plus d'informations ou un rendez-vous? Entrez la demande d'information ci-dessous!

Nous ne vous appellerons jamais sans permission! Vous allez d'abord recevoir un email ou un court WhatsApp avec des informations supplémentaires.

*
*
*

Comment souhaitez-vous être contacté?

Quand nous vous contacterons le mieux?

Medvilla Spanje

L'emplacement de cette maison est approximatif

FAITES-MOI SAVOIR SI LE PRIX BAISSE

Nous ne vous appellerons jamais sans permission! Vous allez d'abord recevoir un email ou un court WhatsApp avec des informations supplémentaires.

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

Téléchargez gratuitement notre MED Magazine

Medvilla Spanje
*
*
*

2019-12-06T20:09:20+00:00info1280 KbDatabase connected
2019-12-06T20:09:20+00:00sql1280 KbSELECT *, clave FROM medvilla_traducciones
2019-12-06T20:09:20+00:00sql4864 Kb SELECT id, clave, parent_id, titulo_fr AS titulo, link_fr AS link, slug_fr AS slug, meta_key_fr AS meta_key, meta_descr_fr AS meta_descr, art_fr AS text FROM medvilla_articulos WHERE slug_fr = 'maison-en-espagne'
2019-12-06T20:09:20+00:00sql4864 Kb SELECT id, clave, titulo_fr AS title, link_fr AS link, slug_fr AS slug, art_fr AS text FROM medvilla_articulos WHERE parent_id = 2 ORDER BY orden
2019-12-06T20:09:20+00:00sql4864 KbSELECT file_name FROM medvilla_images_articulos WHERE parent_id = 2 ORDER BY orden
2019-12-06T20:09:20+00:00sql4864 KbSELECT file_name FROM medvilla_files_articulos WHERE parent_id = 2 ORDER BY orden
2019-12-06T20:09:20+00:00sql4864 Kb SELECT id, clave, link_fr AS link, titulo_fr AS titulo, slug_fr AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos ORDER BY orden
2019-12-06T20:09:20+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'viviendas'
2019-12-06T20:09:20+00:00sql4864 Kb SELECT id, clave, link_fr AS link, titulo_fr AS titulo, slug_fr AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos ORDER BY orden
2019-12-06T20:09:20+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'viviendas'
2019-12-06T20:09:20+00:00sql4864 KbSELECT *, titulo_fr AS titulo, link_fr AS link FROM medvilla_panoramicas ORDER BY orden
2019-12-06T20:09:20+00:00sql4864 KbSELECT nombre_fr AS nombre, enlace_fr AS enlace FROM medvilla_quicklinks2 ORDER BY orden
2019-12-06T20:09:20+00:00sql4864 Kb SELECT id, clave, link_fr AS link, titulo_fr AS titulo, slug_fr AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos ORDER BY orden
2019-12-06T20:09:20+00:00sql4864 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'viviendas'
2019-12-06T20:09:20+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_fr AS descripcion, intro_fr as intro, piscina_id AS piscina, lat, lon, reservado, vendido, main.titulo_fr AS titulo, loc.nombre AS localidad, tip.nombre_fr AS tipo, cla.id AS clase_id, cla.nombre_fr AS clase, cos.nombre_fr 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-06T20:09:20+00:00sql14592 Kb SELECT main.*, titulo_fr AS titulo, descripcion_fr AS descripcion, loc.nombre as localidad, cos.provincia, loc.descr_fr AS descripcion_localidad, loc.codigo_postal AS codigo_postal, cla.nombre_fr as clase, tip.nombre_fr as tipo, cos.nombre_fr as costa, pis.nombre_fr as piscina, jar.nombre_fr as jardin, ori.nombre_fr as orientacion, par.nombre_fr as parking, vis.nombre_fr as vistas FROM medvilla_viviendas main LEFT JOIN medvilla_localidades loc ON main.localidad_id = loc.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 WHERE main.id = 1231
2019-12-06T20:09:20+00:00sql14592 Kb SELECT parent_id, file_name FROM medvilla_images_viviendas WHERE parent_id = 1231 ORDER BY orden
2019-12-06T20:09:20+00:00sql14592 Kb SELECT parent_id, file_name FROM medvilla_images_localidades WHERE parent_id = 46 ORDER BY orden
2019-12-06T20:09:20+00:00sql14592 KbSELECT id, nombre_fr as nombre FROM medvilla_opciones ORDER BY orden
2019-12-06T20:09:20+00:00sql14592 Kb SELECT id, clave, link_fr AS link, titulo_fr AS titulo, slug_fr AS slug, header_menu, footer_menu, parent_id, orden FROM medvilla_articulos ORDER BY orden
2019-12-06T20:09:20+00:00sql14592 KbSELECT slug_en, slug_nl, slug_fr, slug_se FROM medvilla_articulos WHERE clave = 'viviendas'
2019-12-06T20:09:20+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_fr AS descripcion, intro_fr as intro, piscina_id AS piscina, lat, lon, reservado, vendido, main.titulo_fr AS titulo, loc.nombre AS localidad, tip.nombre_fr AS tipo, cla.id AS clase_id, cla.nombre_fr AS clase, cos.nombre_fr 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 (precio_de_venta >= 159200) AND (precio_de_venta <= 238800) AND (clase_id = 1) AND (main.id != 1231) ORDER BY main.id DESC LIMIT 4
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_fr AS nombre FROM medvilla_costas WHERE id = 2
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_fr AS nombre FROM medvilla_tipos WHERE id = 5
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_en AS nombre FROM medvilla_costas WHERE id = 2
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_en AS nombre FROM medvilla_tipos WHERE id = 5
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_nl AS nombre FROM medvilla_costas WHERE id = 2
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_nl AS nombre FROM medvilla_tipos WHERE id = 5
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_fr AS nombre FROM medvilla_costas WHERE id = 2
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_fr AS nombre FROM medvilla_tipos WHERE id = 5
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_se AS nombre FROM medvilla_costas WHERE id = 2
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_se AS nombre FROM medvilla_tipos WHERE id = 5
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_en AS nombre FROM medvilla_costas WHERE id = 2
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_en AS nombre FROM medvilla_tipos WHERE id = 5
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_nl AS nombre FROM medvilla_costas WHERE id = 2
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_nl AS nombre FROM medvilla_tipos WHERE id = 5
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_fr AS nombre FROM medvilla_costas WHERE id = 2
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_fr AS nombre FROM medvilla_tipos WHERE id = 5
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_se AS nombre FROM medvilla_costas WHERE id = 2
2019-12-06T20:09:20+00:00sql14592 KbSELECT nombre_se AS nombre FROM medvilla_tipos WHERE id = 5
2019-12-06T20:09:20+00:00sql14592 KbSELECT file_name FROM medvilla_files_articulos WHERE parent_id = 2 ORDER BY orden
2019-12-06T20:09:20+00:00sql14592 KbSELECT titulo_fr AS field FROM medvilla_articulos WHERE clave = 'ebook-modal'
2019-12-06T20:09:20+00:00sql14592 KbSELECT art_fr AS field FROM medvilla_articulos WHERE clave = 'ebook-modal'
2019-12-06T20:09:20+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'