Ferienhäuser Alájar Aljaraque, Spanien

Sortiere Ergebnisse nach :   
SELECT sc_object.sc_obj_id, Belegung,sc_geo_reg.RName,Bezeichnung, sc_geo_reg2.Rname_de as Reg1, sc_geo_reg3.Rname as Reg2, Hauptbild, Minpreis,Maxpreis, Link_de 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 = 96 and sc_object.status = 1 and Belegung >1 and sc_object.mainreg = '80' and ((sc_geo_reg.sc_geo_reg_id = '55439') or (sc_geo_reg3.parentID = '55439')) ORDER BY Tarif DESC,sc_object.Lastmod
Anzeige Ferienhäuser 1-36 ( Total Ferienhäuser)
Seite:  
Andalusien | Aragonien | Asturien | Balearische Inseln | Baskenland | Kantabrien | Castilla La Mancha | Kastilien-León | Extramadura | Galizien | Kanarische Inseln | Katalonien | La Rioja - Aragón | Madrid | Murcia | Navarra | Valencia |


Anreise: 
Tage: 

  Ferienwohnung
  Ferienhaus
  Bed & Breakfast
  Hotel
  Camping site

  Personen
  Haustiere erlaubt
  Strandnah
  Urlaub in der Stadt

  Swimmingpool
  Whirlpool
  Sauna
  Klimaanlage
  WLAN
  Sat Tv
  Waschmaschine

  Privat Vermieter
  Büro

  Meine Favoritten
Meine Favoritten bearbeiten