Prázdnin domy Maria Alm, Rakousko

Serazeno podle:   
SELECT sc_object.sc_obj_id, Belegung,sc_geo_reg.RName,Bezeichnung, sc_geo_reg2.Rname_cs as Reg1, sc_geo_reg3.Rname as Reg2, Hauptbild, Minpreis,Maxpreis, Link_cs 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 = 85 and sc_object.status = 1 and Belegung >1 and sc_object.mainreg = '151' and ((sc_geo_reg.sc_geo_reg_id = '63342') or (sc_geo_reg3.parentID = '63342')) ORDER BY Tarif DESC,sc_object.Lastmod
Zobrazení domy 1-36 ( Celkový Domy)
Strana:  
Burgenland | Korutany | Dolní Rakousy | Horní Rakousy | Salcburk okolí | Štýrsko | Tyrolsko | Vorarlbersko | Víde? |


Příjezd: 
Dny: 

  Apartmán
  Vila
  Nocleh se snídaní
  Hotel
  Kemp

  Osob
  Mazlíčci povoleni
  V blízkosti pláže
  Město

  Plavecký bazén
  Vířivka
  Sauna
  Klimatizace
  Wi-fi
  SAT
  Pračka

  Soukromá osoba
  Agentura

  Můj oblíbený
Obejrzyj\edytuj swoje ulubione