Loui Hostel Gardens a Haifa

risparmia_logo
sei_qui 
  •  Home
  •  cat_ostel
  •  Hostells in Israel
  •  Hostells a Haifa

    • Loui Hostel Gardens He Khaluts st 35 A Haifa
    n_photo_gallery Hostell Loui Hostel Gardens
    Haifa
    Loui Hostel Gardens USD31.35   EUR25.31   GBP21.65  
    descr_gen_ost

    no_lingua
    Loui Hostel Gardens

     
    Loui Hostel Gardens - He Khaluts st 35 A   ,  ,  Haifa,  ,  Israel  
    Laundry Wheelchair Friendly Luggage Storage Telephone/Fax Facilities
    24 hour reception Travel Desk/Travel Info Key Card Access Lift / Elevator
    Free Carpark Breakfast Not Included 24 Hour Check In Air Conditioning
     

     

    1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'viamundi_viamundis.imp_hotels.perma_village' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
    select Geo_Village, perma_village from imp_hotels where id_country = 96 and id_city = 17046 and perma_village != '' group by Geo_Village