Costa De Oro Beach Hotel a Mazatlan

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

    • Costa de Oro Beach Hotel Av. Camaron Sabalo 710 Mazatlan
    n_photo_gallery Hostell Costa de Oro Beach Hotel
    Mazatlan
    Costa de Oro Beach Hotel USD23.76   EUR18.26   GBP15.62  
    descr_gen_ost

    no_lingua
    Hostel Costa de Oro Beach Hotel
    Hostel Costa de Oro Beach Hotel

     
    Costa de Oro Beach Hotel - Av. Camaron Sabalo 710   Zona Dorada,  82110,  Mazatlan,  Sinaloa,  Mexico  
    Restaurant Laundry Airport Pick Up Wheelchair Friendly
    Bar Luggage Storage Swimming Pool Telephone/Fax Facilities
    24 hour reception Travel Desk/Travel Info Bureau de Change Lift / Elevator
    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