Location Vacances, La Tour sur Orb, France - NOVEMO

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

Novemo immobilier > Location Vacances > France > La Tour sur Orb

34260 La Tour sur Orb

290-390 €

Maison traditionnelle

La Tour sur Orb : Maison accueillant 7 personnes, dans village situé à 1h des plages de Vias, Portiragnes et de Valras. RDC: cellier (lave-lin

Surface: 70 m²

3

4

Modifier la recherche