Agen
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 ("47000") AND ville IN ("agen") 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)

6 bien(s) trouvés

Trier par

Élodie Orieux Costa

650 000 € Ref : ELO_2979

Bien d'exception à proximité d'Agen

Agen
460.00 m²

Brigitte Thill

310 000 € Ref : BT_2405

Maison Traditionnelle de 137 m2

Agen
137.00 m²

Patrick Chassard

125 000 € Ref : CH_2218

Emplacement No 1

Agen
80.00 m²

Yannick Octeau

120 000 € Ref : YAN_2594

MAISON AGEN CENTRE

Agen
70.00 m²

Julien Moretto

162 000 € Ref : JU_2728

MAISON AGEN GARAGE ET JARDIN

Agen
125.00 m²

Julien Moretto

146 000 € Ref : JU_2975

 maison jardin et garage agen

Agen
84.00 m²