SELECT ann.*, ann.id as aid, pro_type.value_fr FROM announcement ann, country,property_type pro_type WHERE ann.type_of_property=pro_type.id AND ann.active_status='Y' AND ann.expiry_date >= now() AND ann.payment_status = 'Y' AND member_active_status = 'Y' AND country.id = ann.country AND pro_type.id = ann.type_of_property AND ann.country = 3 and (region in('89','1014') AND (( `city` LIKE "Nantes" ) OR ( `postal_code` LIKE "Nantes%" ) )) and type_of_property in(7,8,10,11,54,89,54) AND type_of_announcement='1' ORDER BY ann.id desc LIMIT 0, 10 Vente, (44) Loire-Atlantique, Nantes, France - NOVEMO

Nos Annonces

Novemo immobilier > Vente > France > (44) Loire-Atlantique > Nantes

44300 Nantes

229 000 €
Appartement

Nantes (44) : Vente appartement T3, situe a Nantes-Est, au 3 eme etage / 4 d'un immeuble construit fin du 1er trimestre 2016 (avec ascenseur) securise et bie

Surface: 61 m²
2
3

44000 Nantes

508 000 €
Appartement

Nantes (44) : Particulier vend appartement T4, tres bien situe dans l'hyper centre (Hotel Dieu), au 4 eme et dernier etage, d'une residence recente, de stand

Surface: 86 m²
2
4

Modifier la recherche