Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1255 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1255 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1255 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

15600 17th
Garden, MI 49835

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: --
Baths: 1
Status: Pending
SqFt: 2065
Agency: GROVER REAL ESTATE

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 17 acre(s)
Property Type: Residential
Year Built: 2003
Notes: The famous Bay Ridge RV Park and Dock Bar and Grill have attracted visitors from far and wide for several years; luring in guests with an incredible full service restaurant/tavern, Luxurious 42 site RV Park, and once in a lifetime location which enjoys seductive views to the Garden Bay, Lake Michigan, and beyond. Imagine the possibilities, transforming this incredible property into your dream home! Attached to the restaurant space is a state of the art private marina which provides additional opportunities to create a truly one of a kind Up North experience that most could only dream of. From camping, boating, dining, and socializing, this incredibly unique commercial opportunity truly offers it all, and more. The RV Park sits perched above the restaurant and marina, and drinks in colorful sunset views over the water night after night. The bookings are full all summer long, and many reach out years in advance to secure some of the most sought after sites. The park features a separate office building, with showers, laundry, and restroom facilities for the campers, and each site enjoys access to sewer and water hookups, electric, and WIFI. Just a short stroll down the hill, the campers can enjoy the famous “Dock Bar and Grill”, which has been serving up elevated food, classy cocktails, and an atmosphere that can not be beat. Seating options are abundant, with a massive dining room, pub/bar area, and a sprawling outdoor covered patio perched up to the water’s edge. If you have dreamt of a truly once in a lifetime opportunity such as this to come along, this very well could be it.
MlsNumber: 50133283


Listing Provided By: GROVER REAL ESTATE, original listing
Name: GROVER REAL ESTATE
Phone: (906) 341-2131
Office Name: GROVER REAL ESTATE
Office Phone: (906) 341-2131
Agent Name: TRAVIS WOOD
Disclaimer: Copyright © 2024 Upper Peninsula Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App