Condom
Maison
0 -
Nouvelle recherche Affiner la recherche Enregistrer la recherche
Rechercher un bien
Affiner ma recherche
Nombre de chambres :
Recherche par mots clés

SELECT p.ID, p.post_content, p.post_title, p.post_name, p.post_author, (SELECT meta_value FROM lebondil_postmeta WHERE post_id = p.ID AND meta_key = '_lebondil_hektor_type_bien') AS type_bien, (SELECT meta_value FROM lebondil_postmeta WHERE post_id = p.ID AND meta_key = '_lebondil_hektor_reference') AS reference, (SELECT meta_value FROM lebondil_postmeta WHERE post_id = p.ID AND meta_key = '_lebondil_hektor_cp') AS cp, SUBSTRING((SELECT meta_value FROM lebondil_postmeta WHERE post_id = p.ID AND meta_key = '_lebondil_hektor_cp'), 1, 2) AS departement, LCASE((SELECT meta_value FROM lebondil_postmeta WHERE post_id = p.ID AND meta_key = '_lebondil_hektor_ville')) AS ville, (SELECT meta_value FROM lebondil_postmeta WHERE post_id = p.ID AND meta_key = '_lebondil_hektor_prix') AS prix, (SELECT meta_value FROM lebondil_postmeta WHERE post_id = p.ID AND meta_key = '_lebondil_hektor_surface_habitable') AS surface_habitable, (SELECT meta_value FROM lebondil_postmeta WHERE post_id = p.ID AND meta_key = '_lebondil_hektor_surface_terrain') AS surface_terrain, (SELECT meta_value FROM lebondil_postmeta WHERE post_id = p.ID AND meta_key = '_lebondil_hektor_chambres') AS chambres FROM lebondil_posts AS p WHERE post_status = 'publish' AND post_type = 'bien' HAVING cp IN ("32100") AND ville IN ("condom") AND type_bien IN ("Maison", "Propriete", "Chalet", "Villa", "Maison De Village", "Ferme","Château","Bastide" ) AND (chambres IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) OR chambres > 5 OR chambres = "") AND (prix >= 1)

8 bien(s) trouvés

Trier par

Murielle Riera

193 000 € Ref : M88

Maison de ville au calme avec garage, et jardin- 160m2

Condom
160 m²

Murielle Riera

250 000 € Ref : M104

Prestations de qualité pour cette villa de 1991 . - 220m2

Condom
220 m²

Murielle Riera

136 000 € Ref : M149

A 5 mn de Condom , maison en pierres à restaurer avec ses dépendances , sur une parcelle de 5400 m2 .

Condom
270 m²

Murielle Riera

54 500 € Ref : M207

Centre ville de Condom , maison de 180 m2 habitables .

Condom
180 m²

Dagmar Smeding

390 000 € Ref : DS247

Propriété Gasconne restaurée avec grande dépendance

Condom
375 m²

Nathalie Warenghem

295 000 € Ref : WAR157

PLAIN-PIED, BELLE VUE SUR LA CAMPAGNE - TERRAIN 7756 M2

Condom
132.59 m²

Nadia Kotaya

147 000 € Ref : NAN106

Maison de ville contemporaine

Condom
125 m²

Nathalie Warenghem

1 377 000 € Ref : WAR215

 PROPRIETE PRESERVEE DES REGARDS

Condom
684 m²