Sun Hall Hotel a Larnaca

risparmia_logo
sei_qui 
  •  Home
  •  cat_ostel
  •  Hostells in Cyprus
  •  Hostells a Larnaca

    • Sun Hall Hotel Athens Avenue 6 Larnaca
    n_photo_gallery Hostell Sun Hall Hotel
    Larnaca
    Sun Hall Hotel USD83.03   EUR60.77   GBP54.59  
    descr_gen_ost

    no_lingua
    Hostel Sun Hall Hotel

     
    Sun Hall Hotel - Athens Avenue 6   P.O.Box 40300,  6302,  Larnaca,  ,  Cyprus  
    Breakfast Included Restaurant Internet Access Bicycle Hire
    Bar Luggage Storage Swimming Pool Telephone/Fax Facilities
    24 hour reception Bureau de Change Lift / Elevator 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 = 43 and id_city = 5044 and perma_village != '' group by Geo_Village