Semesterbostäder Saint-Avit-Rivière, Frankrike

Sortera resultat efter :   
SELECT sc_object.sc_obj_id, Belegung,sc_geo_reg.RName,Bezeichnung, sc_geo_reg2.Rname_sv as Reg1, sc_geo_reg3.Rname as Reg2, Hauptbild, Minpreis,Maxpreis, Link_sv as Link, sc_object.CURR FROM sc_object left join sc_obj_general on sc_obj_general.sc_obj_id = sc_object.sc_obj_id left join sc_obj_equipment on sc_obj_equipment.sc_obj_id = sc_object.sc_obj_id left join sc_obj_location on sc_obj_location.sc_obj_id = sc_object.sc_obj_id left join sc_geo_reg on sc_geo_reg.sc_geo_country_id = sc_object.land and sc_geo_reg.sc_geo_reg_id = sc_object.region left join sc_geo_reg sc_geo_reg3 on sc_geo_reg3.sc_geo_country_id = sc_object.land and sc_geo_reg3.sc_geo_reg_id = sc_geo_reg.parentID left join sc_geo_reg sc_geo_reg2 on sc_geo_reg2.sc_geo_country_id = sc_object.land and sc_geo_reg2.sc_geo_reg_id = sc_object.Mainreg where sc_object.land = 68 and sc_object.status = 1 and Belegung >1 and sc_object.mainreg = '1670' and ((sc_geo_reg.sc_geo_reg_id = '64763') or (sc_geo_reg3.parentID = '64763')) ORDER BY Tarif DESC,sc_object.Lastmod
Visar semesterbostäder 1-36 ( Total Semesterbostäder)
Sida:  
Alsace | Aquitaine | Auvergne | Basse-Normandie | Bretagne | Burgund | Centre | Champagne-Ardennerna | Franche-Comtè | Haute-Normandie | Île-de-France | Korsika | Languedoc-Roussillon | Limousin | Lorraine | Midi-Pyrénées | Norra Pas-de-Calais | Pays de la Loire | Picardie | Poitou-Charentes | Provence Alpes Cote dAzur | Rhône-Alpes |


Ankomst: 
Dage: 

  Lägenhet
  Villa
  Bed & Breakfast
  Hotel
  Campingplats

  Personer
  Husdjur tillåtet
  Nära stranden
  Stad

  Swimming pool
  Whirlpool
  Sauna
  Air condition
  Wi-fi
  Satellit-TV
  Tvättmaskin

  Privat ägare
  Byrå

  Mina favoriter
Visa / redigera mina favoriter