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
You must enter dates to see the best prices.
Ranked #36 of 41 hotels in Mackinaw City
  • Overview
  • Reviews (146)
  • Photos (48)
  • Amenities
  • Q&A
  • Room tips (21)
  • Location
  • More
Write a Review

146 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 (21)
Date | Rating
  • English first
  • Any
English first
1 review
1 of 5 stars Reviewed yesterday NEW

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
Jackson, MI
1 review
1 of 5 stars Reviewed 1 week ago NEW 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
Carrollton, Ohio
Senior Reviewer
8 reviews 8 reviews
4 of 5 stars Reviewed 1 week ago

I think this place is nice. It's no 5 star resort, but they don't pretend to be. Room was clean. Did have a chemical smell but it's clean. Fixtures are a little chinsy, but beds are comfy. (Except for the flat pillows) The in room fridge is a nice plus. The staff upgraded us for free after they learned that... More

Was this review helpful? Yes
Troy, MI
12 reviews 12 reviews
10 hotel reviews
24 helpful votes 24 helpful votes
4 of 5 stars Reviewed 1 week ago

I have traveling many places around the world, and already posted over 10 reviews at Tripadvisor. I am a picky person, but was satisfied with this hotel, despite all the negative reviews other people posted. I booked 5 rooms for a group of 14 people, including 9 adults and 5 children for 7/13/2014 night. Four reasons made me to book... More

Was this review helpful? Yes
Muskegon, Michigan
1 review
1 helpful vote 1 helpful vote
1 of 5 stars Reviewed 2 weeks ago via mobile

I booked this hotel based on the price. I figured how bad can the hotel possibly be,I mean it is located off the beach. When checking into our room I noticed the lobby was filthy. Walking up to room we literally had to jump over a pile of dead fish flies in front of the door. Once in the room... More

Was this review helpful? Yes 1
Pearl City, Illinois, United States
3 reviews 3 reviews
1 helpful vote 1 helpful vote
3 of 5 stars Reviewed 2 weeks ago

I was very concerned due to all the negative reviews for this hotel. However, the hotel was awesome, including the hot tub-kids play area indoors. They have an indoor pool but we didn't use it. The actual 2nd fl room was great even though I asked for 1st fl beachfront walk out. Come to find out they only have one... More

Was this review helpful? Yes 1
Houghton, Michigan
Senior Reviewer
10 reviews 10 reviews
9 hotel reviews
2 helpful votes 2 helpful votes
3 of 5 stars Reviewed 3 weeks ago

We booked a one night stay based on my sister's recommendation. Then, we read the reviews...Geez! We arrived expecting a mud hut. For only 80+ dollars we knew ther could be some issues. So, the room was clean, my most important requirement. It was also spacious and the decor was fine. The view of the lake was a bonus! Ok,... More

Was this review helpful? Yes 2
Menominee, Michigan
2 reviews
4 helpful votes 4 helpful votes
4 of 5 stars Reviewed 3 weeks ago

We've been staying here for years...new management this year-I would have given this place a 5 but this year the hot tub area looked a bit run down in comparison to past years and the small hot tub in the pool area was completely shut down. The sunrise and sunsets are picture perfect from the 3rd floor balconys. This is... More

Was this review helpful? Yes
Wyandotte, Michigan
1 review
3 helpful votes 3 helpful votes
1 of 5 stars Reviewed 3 weeks ago

Rooms are outdated, still have the picture tube televisions, rooms not very clean. Breakfast is served at another hotel, just a walk down the path through the trees to another hotel? Water park wasn't operating. Beach is full of weeds, if you want to walk down to the waters edge you have to go the hotel next door, or walk... More

Was this review helpful? Yes 3
Senior Contributor
49 reviews 49 reviews
20 hotel reviews
21 helpful votes 21 helpful votes
3 of 5 stars Reviewed June 19, 2014

The hotel was a good value for the money. Our grandchildren loved it. The beds were comfortable and clean, rest of room, not so much so. The breakfast was exstensive, with gravy, biscuit, eggs, sausage, creal, bagels, and on and on! All hot and ready to eat. People were super friendly, great staff!

Was this review helpful? Yes 1
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, Booking.com, Orbitz, Expedia, Travelocity, Tingo, BookingOdigeoWL, Priceline, Venere and Agoda 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)


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

Enter your question for this accommodation's staff to answer. Other travelers may answer as well.
    Posting guidelines

    See which rooms travelers prefer