City Hotel Tirana a Tiranë

risparmia_logo
sei_qui 
  •  Home
  •  cat_ostel
  •  Hostells in Albania
  •  Hostells a Tiranë

    • City Hotel Tirana Rruga Ismail Qemali Tirana
    n_photo_gallery Hostell City Hotel Tirana
    Tiranë
    City Hotel Tirana USD44.41   EUR32.50   GBP29.20  
    descr_gen_ost

    no_lingua
    Hostel City Hotel Tirana

     
    City Hotel Tirana - Rruga Ismail Qemali   Nr.8/1,  1001,  Tiranë,  Tirana,  Albania  
    Breakfast Included Internet Access Airport Pick Up Bar
    Luggage Storage 24 hour reception Travel Desk/Travel Info Bureau de Change
    24 Hour Check In WiFi in lobby Web access in lobby Web access in Room
    WiFi in room Air Conditioning Breakfast
     

     

    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 = 2 and id_city = 1492 and perma_village != '' group by Geo_Village