We noticed that you're using an unsupported browser. The TripAdvisor website may not display properly.
We support the following browsers:
Windows: Internet Explorer, Mozilla Firefox, Google Chrome. Mac: Safari.
All 41 Mackinaw City hotels

Fairview Beachfront Inn & Waterpark

2.0 of 5 Hotel   |   907 South Huron, Mackinaw City, MI 49701 (Formerly Aqua Grand Inn & Waterpark)
Hotel amenities
Save Saved
You added Fairview Beachfront Inn & Waterpark to your Saves list
Fairview Beachfront Inn & Waterpark
Best prices for your stay
Enter dates for best prices
Check In Check Out
Show Prices
Compare best prices from top travel sites
and 4 more sites!
Ranked #37 of 41 hotels in Mackinaw City
  • Overview
  • Reviews (154)
  • Photos (48)
  • Similar Hotels
  • Amenities
  • Q&A
  • Room tips (23)
  • Location
  • More
Write a Review

154 people have reviewed this hotel

Traveler rating
See reviews for
Rating summary
  • Location
    3.5 of 5 stars
  • Sleep Quality
    2.5 of 5 stars
  • Rooms
    2.5 of 5 stars
  • Service
    2.5 of 5 stars
  • Value
    2.5 of 5 stars
  • Cleanliness
    2.5 of 5 stars
Traveler tips help you choose the right room.   Room tips (23)
Date | Rating
  • English first
  • Any
English first
Toledo, Ohio
4 reviews 4 reviews
4 of 5 stars Reviewed 5 days ago NEW

I read some of the more recent reviews and was a little afraid of staying but I am glad we booked here. The rate was quite a bit less than others. We had a waterfront room that was clean with comfortable beds and a nice hot shower! The staff was nice and it was great! If you're looking for a... More

Was this review helpful? Yes
Temperance, Michigan, United States
3 reviews 3 reviews
1 of 5 stars Reviewed 1 week ago

We made the reservations on the internet without seeing the facility. Bad choice! Reserved two nights and by the time we got into our room it was too late to cancel for either day. Nothing like it looks on they website. Our room was filthy, food or something on the walls. Stains on our bedding. TV from the 70's sitting... More

Was this review helpful? Yes
London, Canada
Senior Reviewer
7 reviews 7 reviews
3 hotel reviews
3 helpful votes 3 helpful votes
1 of 5 stars Reviewed 1 week ago

We requested a non-smoking courtyard view room. The first room we were assigned, we could not even enter it for the entire room was saturated with the smell of cigarettes. We were assigned a second room, which did not have the stench of tobacco, but the 'courtyard' view, was down an alley, when we asked for an actual 'courtyard' view,... More

Was this review helpful? Yes
1 review
1 of 5 stars Reviewed 1 week ago via mobile

We stayed for 3 nights. beds were Rock hard, most outlets didn't work. Had the suite, place was covered in spiders. Terrible water park. We found it comfier on the floor. Only good thing was the shower.

Was this review helpful? Yes
Byron Center, Michigan
3 reviews 3 reviews
1 of 5 stars Reviewed 2 weeks ago via mobile

My husband and I stayed there for 3 nights. When we walked in the room, it had a bad odor, the floors were filthy, and there were bugs and cob webs in every corner. We chose this place because it looked nice in the pictures and the outside looked nice from the beach view, I regret that decision. I would... More

Was this review helpful? Yes
Ogdensburg, New York
19 reviews 19 reviews
7 hotel reviews
19 helpful votes 19 helpful votes
3 of 5 stars Reviewed 3 weeks ago

Clean room, balcony overlooking lake Heron. Breakfast shared w/ Clarion Hotel was a madhouse . We left. Pricy. Nothing to write home about. Indoor water pool looked great for kids!! Seagulls a little annoying ! O.K. Beach not many chairs. Staff was pleasant , room in good condition. Not the best or worst.

Was this review helpful? Yes
New Baltimore, Michigan
19 reviews 19 reviews
4 hotel reviews
4 helpful votes 4 helpful votes
3 of 5 stars Reviewed 4 weeks ago

This hotel was nice and quiet at night. The beds and pillows were average. The decor was out of the 60's/70's... Which we found amusing because we are kids of the 70's. The sink was next to the 2nd queen bed. The toilet and shower were in a small room. The bath decor was 70's too! The room seemed clean... More

Was this review helpful? Yes
Grand Rapids, Michigan
1 review
2 helpful votes 2 helpful votes
2 of 5 stars Reviewed 4 weeks ago

Thought this would be a decent hotel, for the price, but waaaay wrong. When we finally got into our room it had a terrible odor, called the front desk to ask to be switched- no extra rooms. They sent a cleaning person to sprinkle arm and hammer on the carpet and vacuum--a cleaning person who just decided to try and... More

Was this review helpful? Yes 2
1 review
1 helpful vote 1 helpful vote
1 of 5 stars Reviewed 4 weeks ago

Hindsight: the Fairview Inn is only worth it if you pay less than $59 per night for a weekend night. But even $59 per night is generous. The Good: Staff was polite and went out of their way to help. Breakfast is free, and they provide milk, instant oatmeal, d.i.y. waffles, eggs from powder mix, sausage patties, OJ, apple juice,... More

Was this review helpful? Yes 1
Jackson, MI
1 review
2 helpful votes 2 helpful votes
1 of 5 stars Reviewed July 24, 2014 via mobile

This was the worst hotel experience my family and I have ever had... First my niece twists her ankle on a ramp the first night we are here. If it was her own fault that's one thing but the ramp was completely unmarked, no sign, no paint on the ground, nothing. When brought to the attention of the staff their... More

Was this review helpful? Yes 2
Owners: What's your side of the story?
If you own or manage Fairview Beachfront Inn & Waterpark, register now for free tools to enhance your listing, attract new reviews, and respond to reviewers.
Manage your listing

Been to Fairview Beachfront Inn & Waterpark? Share your experiences!

Write a Review Add Photos & Videos

Additional Information about Fairview Beachfront Inn & Waterpark

Address: 907 South Huron, Mackinaw City, MI 49701 (Formerly Aqua Grand Inn & Waterpark)
Location: United States > Michigan > Cheboygan County > Mackinaw City
Price Range (Based on Average Rates): $
Hotel Class:2 star — Fairview Beachfront Inn & Waterpark 2*
Reservation Options:
TripAdvisor is proud to partner with Hotels.com, Travelocity, Booking.com, Orbitz, Tingo, Priceline and BookingOdigeoWL so you can book your Fairview Beachfront Inn & Waterpark reservations with confidence. We help millions of travelers each month to find the perfect hotel for both vacation and business trips, always with the best discounts and special offers.
Also Known As:
Fairview Beachfront Inn And Waterpark
Fairview Beachfront Inn & Waterpark Hotel Mackinaw City
Aqua Grand Hotel Waterpark
Aqua Grand Motel Waterpark

48 photos of this hotel

Traveler photos: See what travelers like you saw

All traveler photos (43)
Hotel & grounds (7)
Pool/beach area (7)
Room/suite (6)
Dining (1)
Bathroom (10)
View from room (2)
Other (10)

Management photos: Courtesy of the property manager

All management photos (6)
Hotel & grounds (1)
Other (5)
Hotels you might also like...
Check In Check Out
Price Your Stay
Select tags to find the hotel that's right for you.
hotels in Mackinaw City with
any amenities


Beach Free Breakfast Free Parking Kitchenette Pets Allowed ( Dog / Pet Friendly ) Room Service Swimming Pool Wheelchair access
Hotel Style
#13 On the Beach Hotel in Mackinaw City
Hotel Class
Number of rooms

Questions & Answers

Questions? Get answers from Fairview Beachfront Inn & Waterpark staff and past guests.
Posting guidelines
Typical questions asked:
  • Can tickets for local attractions be purchased at the front desk?
  • Do you have to pay extra for a mini-fridge?
  • At what time does the pool open each day?

See which rooms travelers prefer