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.

Fairview Beachfront Inn & Waterpark

907 South Huron, Mackinaw City, MI 49701 (Formerly Aqua Grand Inn & Waterpark)
Hotel amenities
Fairview Beachfront Inn & Waterpark
Book on
TripAdvisor
Trusted partner. We work with Tingo to make your booking as easy as possible.
Secure payments. We use industry-leading practices to keep your information secure.
Best prices for: 1 room 1 guest
Enter dates for best prices
Check In Check Out
Show Prices
Compare best prices from top travel sites
and 5 more sites!
Add Photo Write a Review

166 Reviews from our TripAdvisor Community

Rate and write a review
Roll over, then click to rate
  Click to rate
Traveler rating
    24
    21
    21
    23
    77
See reviews for
94
21
1
1
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 (25)
Date | Rating
  • English first
  • Any
English first
  • All months
    (166)
  • Mar-May only
    (12)
  • Jun-Aug only
    (126)
  • Sep-Nov only
    (26)
  • Dec-Feb only
    (2)
All months
5 of 5 stars Reviewed 1 week ago NEW

This room was great! Beautiful room and comfy beds. Clean room and bathroom. Balcony with screen door. Mini fridge and coffee pot. Clean sheets. Truly a wonderful experience! Im so glad we didnt believe the bad reviews and went with it anyway.

Was this review helpful? Yes
Franklin, Indiana
1 review
1 of 5 stars Reviewed 1 week ago

1: very few of the rooms are "beach front". 2: "Beach front and SPA" meaning a small pool heated so hot it burns your skin. Not the luxury you're thinking of. 3: The "water park" is awful. Many of them didn't work and the ones that did sprayed so hard it hurt your skin. 4: The pool was so chlorinated... More 

Was this review helpful? Yes

Travelers are raving about these Mackinaw City hotels

Spring Lake, Michigan
1 review
1 of 5 stars Reviewed 1 week ago

Terrible, terrible experience! The rooms are extremely damp and musty. Our 1 year old encountered respiratory issues from how musty the rooms were and we needed to check out a day early. I stopped in to talk to management and they apologized and offered a de-humidifier (as if they already know the moisture is an issue) and when I indicated... More 

Was this review helpful? Yes
Marquette, Michigan
Level Contributor
3 reviews
common_n_hotel_reviews_1bd8 2 helpful votes
2 of 5 stars Reviewed 3 weeks ago

We did not stay here but did use their splash pad/ indoor pool area. The splash pad was very fun for our four year old son, and the bonus was that the water used was very warm. However the entire inside pool area was filthy! The ceilings and walls were moldy and dirty and the extremely large hot tub was... More 

Was this review helpful? Yes 1
Stanton, Michigan
common_n_hotel_reviews_1bd8 1 helpful vote
1 of 5 stars Reviewed 4 weeks ago

cum stains on the sheets, ants in the room, poor service, rude people, didn't get the room we booked. we asked for lakeside and got courtside, we had rude neighbors, didn't get our own parking spot. we were told to find somewhere else to park and walk. just one of the worst place to go!

Was this review helpful? Yes 1
Alpena, Michigan
Level Contributor
48 reviews
16 hotel reviews
common_n_hotel_reviews_1bd8 16 helpful votes
3 of 5 stars Reviewed June 18, 2015

Hotel was a great deal and was right on the beach with a view of the bridge. Close to the boat docks and all kinds of attractions. Staff was friendly and helpful. Room was very large and beds were comfortable. The decor is out of date and the pool and water park (only fun for young children) need some freshening... More 

Was this review helpful? Yes
Prescott, Arizona
Level Contributor
112 reviews
29 hotel reviews
common_n_hotel_reviews_1bd8 64 helpful votes
4 of 5 stars Reviewed June 13, 2015

We got smokin deal, nice room, and a breakfast. But: there was only one bath towels for the three of us (we could have called the front desk, but did not really notice till it was time to go) and the breakfast left allot to be desired (the meat looked like Armidillo) But the price was fine and we were... More 

Was this review helpful? Yes
Level Contributor
10 reviews
3 hotel reviews
4 of 5 stars Reviewed June 13, 2015 via mobile

I am surprised at the horrible reviews, we were quite happy with our stay. The price was right. Actually got the room $10 cheaper directly through the hotel than Booking.com. We had a delux two queen room with balcony. The room appeared as though it had just recently been remodeled and was very clean. Breakfast was a little crowded, but... More 

Was this review helpful? Yes
lake jackson
Level Contributor
9 reviews
5 hotel reviews
common_n_hotel_reviews_1bd8 11 helpful votes
4 of 5 stars Reviewed June 6, 2015 via mobile

I had read the reviews AFTER I had booked. I must say the people with previous reviews must have expected 5 star catering. The hotel was great. My kids Loved the watermark. Only 2 things were wrong, hot tub wasn't hot at all.... And these tiny black fly things had made their way into our room (don't worry they are... More 

Was this review helpful? Yes 2
Lansing, Michigan
1 review
common_n_hotel_reviews_1bd8 3 helpful votes
5 of 5 stars Reviewed May 30, 2015

For only $67, we booked a room with two queens. Upon arrival, they told us they had freely upgraded us to a beachfront room. The furniture was old, but clean, and the free breakfast was pretty good. We also enjoyed going to the waterfront a couple hotels down (access was free). I thought for $67 our experience was very good!!

Was this review helpful? Yes 3
Questions? Get answers from hotel staff and past guests. Ask a question

51 photos of this hotel

Traveler photos: See what travelers like you saw

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

Management photos: Courtesy of the property manager

Viewed
All management photos (6)
Viewed
Hotel & grounds (1)
Viewed
Other (5)
Check In Check Out
Prices are for 1 room, 2 adults
Show Prices
Hotels you might also like...
Travelers also viewed these Mackinaw City hotels
0.0 mi away
Clarion Hotel Beachfront
Clarion Hotel Beachfront
#12 of 41 in Mackinaw City
3.5 of 5 stars 455 reviews
0.1 mi away
Mackinaw Beach and Bay - Inn & Suites
0.2 mi away
Bridge Vista Beach Hotel & Convention Center
Show Prices
Show Prices
Show Prices
1.1 mi away
Parkside Inn -  Bridgeside
Parkside Inn - Bridgeside
#23 of 41 in Mackinaw City
3.5 of 5 stars 114 reviews
0.4 mi away
BEST WESTERN PLUS Dockside Waterfront Inn
0.3 mi away
Hamilton Inn Select - Beachfront
Hamilton Inn Select - Beachfront
#17 of 41 in Mackinaw City
3.0 of 5 stars 562 reviews
Show Prices
Show Prices
Show Prices
Questions? Get answers from hotel staff and past guests. Ask a question

Amenities

Enter dates for best prices
Check In Check In Check Out Check Out
Prices are for 1 room, 2 adults
Price Your Stay