Hotel Aguamarina in Mazatlan

Save up to 50%

Hotel Aguamarina Av. del Mar #110 Mazatlan

Enter your dates to check availability and prices
Check In Nights
Photos Hostel Hotel Aguamarina
Mazatlan
Book this Hostel Hotel Aguamarina From USD30.50   EUR24.62   GBP21.07  
About the hostel

In this page you can find all the information about the hostel Hotel Aguamarina of Mazatlan. With Viamundis.com you can reserve your hostel or cheap accommodation at the best possible price. See the description of the hostel Hotel Aguamarina with the facilities offered, photos, map with directions on how to get to the hostel Hotel Aguamarina, prices, reviews and comments on the hostel Hotel Aguamarina. Make your reservation with a credit card, anticipating only a 10 per cent of the total amount to secure the booking. At the end of the booking you will get the phone number and the email address of hostel Hotel Aguamarina. Also by email you will receive the booking number confirmation with a reminder. Print your reservation and show it at the reception of the hostel on your arrival’s day; the hostel have already the data details of the guests and you just have to start your holiday in Mazatlan!


The Hotel Aguamarina is the best 4 star property located on Mazatlan's seaside avenue, featuring 111 rooms and suites, 7 meeting rooms, swimming pool, Restaurant, Bar, Business Center, Free Wireless Internet and Parking.Accommodations with City, Garden and Oean view and casual atmosphere, the Hotel Aguamarina is excellent for the Business and Leisure Traveler, unparalleled location, 5 minutes to most city attractions such as:Downtown AreaHistoric CenterOpera HouseGolden ZoneBus StationBaseball StadiumTraditional Fishing MarinaStone Island DocksCommercial, Industrial and Tourist PortMazatlan LighthouseGran Plaza MallCity AcuariumCity Park (Bosque de la Ciudad)Mazatlan Marina (8 minutes)

Reviews 93 %
 
AddressHotel Aguamarina - Av. del Mar #110   Col. Palos Prietos,  82010,  Mazatlan,  Sinaloa,  Mexico  
Facilities
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