Hotel Aguamarina a Mazatlan

risparmia_logo
sei_qui 
  •  Home
  •  cat_ostel
  •  Hostells in Mexico
  •  Hostells a Mazatlan

    • Hotel Aguamarina Av. del Mar #110 Mazatlan
    n_photo_gallery Hostell Hotel Aguamarina
    Mazatlan
    Hotel Aguamarina USD30.50   EUR24.62   GBP21.07  
    descr_gen_ost

    no_lingua
    Hostel Hotel Aguamarina

    giudizi 93 %
     
    Hotel Aguamarina - Av. del Mar #110   Col. Palos Prietos,  82010,  Mazatlan,  Sinaloa,  Mexico  
    Restaurant Airport Pick Up Bar Luggage Storage
    Swimming Pool 24 hour reception Travel Desk/Travel Info Bureau de Change
    Free Carpark Non Smoking 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 = 126 and id_city = 12644 and perma_village != '' group by Geo_Village