Vacation homes Positano, Italy

Sort results by :   
SELECT sc_object.sc_obj_id, Belegung,sc_geo_reg.RName,Bezeichnung, sc_geo_reg2.Rname_en as Reg1, sc_geo_reg3.Rname as Reg2, Hauptbild, Minpreis,Maxpreis, Link_en 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 = 73 and sc_object.status = 1 and Belegung >1 and sc_object.mainreg = '586' and ((sc_geo_reg.sc_geo_reg_id = '84569') or (sc_geo_reg3.parentID = '84569')) ORDER BY Tarif DESC,sc_object.Lastmod
Displaying vacation homes 1-36 ( Total vacation rentals)
Page:  
Abruzzi | Aosta Valley | Apulia | Basilicata | Calabria | Campania | Lake Como | Emilia - Romagna | Friuli Venice Giulia | Lake Garda | Lake Maggiore | Latium | Liguria | Lombardia | Marken | Molise | Lake Orta | Piemont | Sardinia | Sicily | South Tyrol | Tuscany | Umbria | Venetia |


Arrival: 
Days: 

  Apartment
  Villa
  Bed & Breakfast
  Hotel
  Camping site

  Adults
  Pets allowed
  Near beach
  City holiday

  Swimmingpool
  Whirlpool
  Sauna
  Aircondition
  Wi-fi
  Sat Tv
  Washingmachine

  Private owner
  Agency

  My favorites
View/edit my favorites