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('100','1012') AND (( `city` LIKE "La Palmyre" ) OR ( `postal_code` LIKE "La Palmyre%" ) )) AND type_of_announcement='3' ORDER BY ann.id desc LIMIT 0, 10 Location Vacances, (17) Charente-Maritime, La Palmyre, France - NOVEMO

Nos Annonces

Novemo immobilier > Location Vacances > France > (17) Charente-Maritime > La Palmyre

17570 La Palmyre

310-650 €
Maison traditionnelle

La Palmyre – Les Mathes (17 – Charente maritime) : Maison de vacances pour 4 personnes, à 4 km de la mer. Maison indépendante de 6

Surface: 60 m²
2
3

17570 La Palmyre

200-1 150 €
Mobil home

La Palmyre : Mobil home tout confort année 2012, de 36 m² composé de 3 chambres soit 6 à 8 personnes. Au bord de la baie de Bonne Anse Plage, dans un camping

Surface: 36 m²
3
4

Modifier la recherche