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
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.
1 room 1 guest
Check In Check Out
Show Prices
Compare best prices from top travel sites
and 4 more sites!
Professional photos
Fairview Beachfront Inn & Waterpark
View Map
Add Photo Write a Review

169 Reviews from our TripAdvisor Community

Rate and write a review
Roll over, then click to rate
  Click to rate
Traveler rating
    24
    21
    23
    23
    78
See reviews for
96
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
    (169)
  • Mar-May only
    (12)
  • Jun-Aug only
    (129)
  • Sep-Nov only
    (26)
  • Dec-Feb only
    (2)
All months
2 reviews
3 of 5 stars Reviewed 1 week ago

After being lied to by another hotel in the area this establishment was able to honor our rates and give us rooms on a busy weekend. The rooms were very clean and quiet. They were a little outdated but reminded me of a bed and breakfast in St. Augustine. Enjoyable time and friendly staff. Thankful for the hospitality and being... More 

Was this review helpful? Yes
Jenison, Michigan
2 reviews
1 of 5 stars Reviewed 1 week ago

I will never stay there again! The room was so dirty, outdated and gross. I would rather of stayed in my car!! I can't believe a place with a view to the lake would be so under maintained and filthy! There was a candy bar wrapper that was left in the room from a previous guest, tub looked like it... More 

Was this review helpful? Yes

Travelers are raving about these Mackinaw City hotels

Level Contributor
10 reviews
common_n_hotel_reviews_1bd8 1 helpful vote
3 of 5 stars Reviewed 3 weeks ago via mobile

First the good...clean rooms, nice view of the lake, helpful staff. Then the not so good... Not a lot of parking, no elevators so if you get the top floor you have to drag your luggage up quite a few flights of stairs, not a great breakfast situation; you have to go to another hotel and it's quite crowded.

Was this review helpful? Yes
1 review
5 of 5 stars Reviewed July 26, 2015

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 July 25, 2015

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
Spring Lake, Michigan
1 review
1 of 5 stars Reviewed July 24, 2015

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 3 helpful votes
2 of 5 stars Reviewed July 12, 2015

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
1 review
common_n_hotel_reviews_1bd8 1 helpful vote
1 of 5 stars Reviewed July 5, 2015

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 65 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
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 473 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
#21 of 41 in Mackinaw City
3.5 of 5 stars 120 reviews
0.4 mi away
BEST WESTERN PLUS Dockside Waterfront Inn
0.3 mi away
Hamilton Inn Select - Beachfront
Hamilton Inn Select - Beachfront
#14 of 41 in Mackinaw City
3.0 of 5 stars 602 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