Kuće za odmor Mährisch-Schlesien, ?eška Republika

Sortirati :   
SELECT sc_object.sc_obj_id, Belegung,sc_geo_reg.RName,Bezeichnung, sc_geo_reg2.Rname_hr as Reg1, sc_geo_reg3.Rname as Reg2, Hauptbild, Minpreis,Maxpreis, Link_hr 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 = 97 and sc_object.status = 1 and Belegung >1 and sc_object.mainreg = '4224' ORDER BY Tarif DESC,sc_object.Lastmod
Prikaz kuća za odmor 1-36 ( ukupno kuća za odmor)
Stranica:  


Dolazak: 
Dana: 

  Apartman
  Vila
  Bed & Breakfast
  Hotel
  Kampiranje

  Osobe
  Kucni ljubimci dozvoljeni
  Direktno na plaži/moru
  Grad

  Bazen
  Whirlpool
  Sauna
  Klima uredaj
  Wi-fi
  SAT-prijem
  Stroj za pranje rublja

  Privatni vlasnik
  Agencija

  Moja bilježnica
Prikaži / uredi svoje favorite