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.
New! Find and book your ideal hotel on TripAdvisor — and get the lowest prices

Fairview Beachfront Inn & Waterpark

Show Prices
Book on TripAdvisor
Trusted partner. We work with to make your booking as easy as possible.
Secure payments. We use industry-leading practices to keep your information secure.
Enter dates for best prices
powered by PriceFinder
1 room
Check In Check Out
Please enter your travel dates to continue
Check Availability
Compare best prices from top travel sites
and 3 more sites!
Professional photos
Fairview Beachfront Inn & Waterpark
View Map
{"widget":{"name":"ibex_photo_carousel","template":"ibex_photo_carousel__widget","dust":{"nav_controls":"ibex_photo_carousel__nav_controls"},"js":{"handlers":"(ta.prwidgets.getjs(this,'handlers'))"},"moduleList":["handlers"],"divClasses":"prw_rup prw_ibex_photo_carousel"},"containerClass":null,"scriptFlags":null}
Add Photo Write a Review

207 Reviews from our TripAdvisor Community

Traveller rating
Traveller type
Time of year
There are newer reviews for Fairview Beachfront Inn & Waterpark
See the most recent reviews
Showing 207: English reviews
1 review
Reviewed 31 July 2012

No sandy beach, swamp like conditions at the waterfront. Disgusting rooms. Found an open bag of Doritos and other food left overs under our beds. Balcony door broken. No hot breakfast. Bumped from Super 8 that was close to town, had wifi and offered breakfast. Rude help at Fairview from manager. Was prompted for review from Mackinac Chamber of hotels... More 

Thank HonestReviewer7
Southgate, Michigan
Level Contributor
74 reviews
10 hotel reviews
common_n_hotel_reviews_1bd8 19 helpful votes
Reviewed 27 July 2012

Stayed 2 nights with my family, and the rate is what attracted us. 2 nights in Mackinaw City during peak season for under $200 with breakfast included is great. Parts of the property could be considered dated, and some could use some TLC, but I also considered the rate. I tend to be rather picky, and there wasn't anything that... More 

Thank rf2316
Oshkosh, Wisconsin
2 reviews
common_n_hotel_reviews_1bd8 2 helpful votes
Reviewed 25 July 2012

We stayed at this hotel unfortunately for 3 days. The room was dirty and had not been updated for years the way it looked. I wrote "Wash Me" on the mirror and it stayed there for the 3 days we were stuck! There was mold around the tub and sink and they both had no drain plugs in them (if... More 

2 Thank Nancy D

Travellers are raving about these Mackinaw City hotels

New London, Wisconsin
Level Contributor
25 reviews
10 hotel reviews
common_n_hotel_reviews_1bd8 16 helpful votes
Reviewed 23 July 2012

First of all, I booked 2 nights of stay at an alternative motel (Days Inn) through the Mackinaw City Tourism and Chamber of Commerce website. When I arrived at the motel at check in time, they don't have my reservations, tell me the computer was "froze" and couldn't get into reservations, gets on the phone and starts calling local motels... More 

Thank Mrs_H_AreN
1 review
common_n_hotel_reviews_1bd8 1 helpful vote
Reviewed 21 July 2012

The A/C was not sufficient to cool the room, it was comprised of two old window units mounted into holes cut into the walls. The toilette didn't work and I had to constantly adjust the float, while doing this I found mold growing all over the wall behind the tank. The shower went from ice cold water to dangerous scalding... More 

1 Thank frd845
Level Contributor
5 reviews
3 hotel reviews
common_n_hotel_reviews_1bd8 6 helpful votes
Reviewed 20 July 2012

The "resort" was dated, damp and dirty. I wished we had sleeping bags as the first thought in my mind was bedbugs. Dirty, dirty, dirty. Also, we came back from a perfect day on Mackinac Island to our room that didn't get cleaned. The boy at the front desk was friendly enough but completely unhelpful. And, when we went to... More 

2 Thank Deezingaround
Swartz Creek
Level Contributor
21 reviews
5 hotel reviews
common_n_hotel_reviews_1bd8 4 helpful votes
Reviewed 14 July 2012

"The hotel was very accommodating both times we have stayed there this summer. The rooms were clean and spacious (we had a three bedroom suite the second time we stayed as there were four adults and four children in our party). The breakfast was delicious and filling. The newest indoor water-park was so much fun, our grandchildren loved it!" I... More 

Thank Judson H
Galena, Ohio, United States
Level Contributor
3 reviews
common_n_hotel_reviews_1bd8 2 helpful votes
Reviewed 14 July 2012

We booked through AAA and got what I thought was a great rate. We upgraded to a beachfront room for an additional $20.00 when we arrived. The room was dirty and spelled very musty and there was sand everywhere. The screen door had holes in it so you couldn't use it because of the bugs. The workers were not professional.... More 

2 Thank cabridges
Grand Rapids
Level Contributor
60 reviews
22 hotel reviews
common_n_hotel_reviews_1bd8 26 helpful votes
Reviewed 3 July 2012

We got a fabulous price during the week for our 1 night stay here. The room was clean and the breakfast (which you eat at one of 2 neighboring hotels) was beyond the standard fare and pretty tasty for hotel food. The hotel was also very quiet during our stay, and the waterpark was a nice diversion for the kids... More 

Thank Ann T
Level Contributor
40 reviews
10 hotel reviews
common_n_hotel_reviews_1bd8 18 helpful votes
Reviewed 21 June 2012

This is a nice hotel old but nice the beach is not that great look a little brown when walking in it and lots of seaweed floating around. Kids loved the sea gulls and frogs. The water park on there site is for little kids had to go down about 5 more hotels to get to bigger kids one and... More 

1 Thank jeannie10kids

58 photos of this hotel

Traveller photos: See what travellers like you saw

All Traveller Photos (52)
Room/Suite (6)
Hotel & Grounds (7)
Pool/Beach Area (7)
Dining (1)
Bathroom (10)
View from Room (2)
Other (19)

Management photos: Courtesy of the property manager

All Management Photos (6)
Hotel & Grounds (1)
Other (5)
Check In Check Out
Hotels you might also like...
Travellers also viewed these Mackinaw City hotels
0.4 km away
Bridge Vista Beach Hotel & Convention Center
0.1 km away
Clarion Hotel Beachfront
Clarion Hotel Beachfront
#15 of 39 in Mackinaw City
577 reviews
0.2 km away
Mackinaw Beach and Bay - Inn & Suites
Show Prices
Show Prices
Show Prices
0.6 km away
Comfort Inn Lakeside
Comfort Inn Lakeside
#17 of 39 in Mackinaw City
195 reviews
0.3 km away
Thunderbird Inn
Thunderbird Inn
#14 of 39 in Mackinaw City
183 reviews
1.1 km away
Baymont Inn & Suites Mackinaw City
Show Prices
Show Prices
Show Prices


  • Pool
  • Free Parking
  • Beachfront
  • Free Internet
  • Free Breakfast
About the property
  • Beachfront
  • Wheelchair Access
  • Pets Allowed ( Dog / Pet Friendly )
Things to do
  • Pool
  • Hot Tub
Room types
  • Non-Smoking Rooms
  • Kitchenette
  • Family Rooms
  • Free Internet
  • Free Parking
  • Free Breakfast
  • Self-Serve Laundry

Additional Information about Fairview Beachfront Inn & Waterpark

Address: 907 S Huron Ave, Mackinaw City, MI 49701-9500 (Formerly Aqua Grand Inn & Waterpark)
Region: United States > Michigan > Cheboygan County > Mackinaw City
Price Range: $86 - $320 (Based on Average Rates for a Standard Room)
Hotel Class:2 star — Fairview Beachfront Inn & Waterpark 2*
Number of rooms: 60
Reservation Options:
TripAdvisor is proud to partner with Expedia, Orbitz, Hotels.com, Booking.com, Priceline and Travelocity so you can book your Fairview Beachfront Inn & Waterpark reservations with confidence. We help millions of travellers each month to find the perfect hotel for both holiday and business trips, always with the best discounts and special offers.
Also Known As:
Fairview Beachfront Inn & Waterpark Hotel Mackinaw City
Fairview Beachfront Inn And Waterpark
Aqua Grand Hotel Waterpark
Aqua Grand Motel Waterpark
Hotel Style:
#13 On the Beach Hotel in Mackinaw City
Is This Your TripAdvisor Listing?
Own or manage this property? Claim your listing for free to respond to reviews, update your profile and much more.
Claim Your Listing

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 travellers prefer

“Good place if you're just going to the Island or touring and not spending lots of time in your room.”
 of 5 bubbles majill45, 5 Oct 2016 | Read review
“The XL "suite" on the first floor does have beach access from the room.”
 of 5 bubbles claudettez2016, 8 Sep 2016 | Read review
“Beachfront view from balcony 👍”
 of 5 bubbles mtrethewey80, 30 Aug 2016 | Read review
“Ask for a room facing the beach. Those are a bit better.”
 of 5 bubbles 591annettev, 11 Oct 2015 | Read review
“Don't get a room on the two storie sides”
 of 5 bubbles 823lorir, 3 Oct 2015 | Read review
5 of 5
Enter dates for best prices
Check In Check Out
Price Your Stay