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 = 1306 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 = 1306 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 = 1306 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;

5968 W Houghton Lake Drive
Houghton Lake, MI 48629
Renee Waverly with Brookstone Realtors, original listing - (248) 963-0505

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: --
Baths: --
Status: Active
SqFt: 1407 Square Feet
Agency: Brookstone Realtors
Agency Phone: (248) 963-0505

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Commercial Sale-Other
Year Built: 1975
Notes: South Shore Marina with 100 feet of sandy beach waterfront, offering a versatile range of established and potential income opportunities. Primary home has been fully remodeled, top of the line finishes, with no expenses spared (just needs finishing touches to complete). Home boasts a main-floor, water-view master suite and updated kitchen and a water-facing patio. Two, water-view studio cottages have been completely remodeled and are fully-furnished with kitchenettes for two-person, couple functionality including shaded, water-view patios. These cottages have not been rented since the completion of remodel and were previously grossing $1000/month for 12-month rental and are estimated to be capable of $180 to $250 per night on short-term rental. Primary home could similarly be used as a primary home and/or could be rented on short-term rental for sleeping an estimated 10 to 12 people. Walk-out lower level could be finished into an additional unit maybe for a caretaker/owner residence. Western portion of property holds potential for additional construction --- possibly for additional rental cottages or another house. Launch a kayak, paddle board, and canoe rental business. Offer pontoon rentals for short-term rental clientele. Commercial zoning. Property currently sustains 36 boat slips with an annual gross rental income of $45,000 for seasonal slip rental. Gross income conservatively at $93,500 but could far exceed this number with vision and care. More financials available upon request.
MlsNumber: --
ListingId: 1929171


Listing Provided By: Brookstone Realtors, original listing
Phone: (231) 499-5090
Office Phone: (248) 963-0505
Agent Name: Renee Waverly
Disclaimer: Copyright © 2024 Northern Great Lakes Realtors MLS. 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