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

214 Main Street
Lake City, MI 49651
RUTH CLEMENS with COLDWELL BANKER SCHMIDT REALTORS-HL, original listing - (989) 366-5522

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: --
Baths: --
Status: Active
SqFt: 6554 Square Feet
Agency: COLDWELL BANKER SCHMIDT REALTORS-HL
Agency Phone: (989) 366-5522

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Commercial Sale-Other
Year Built: 1965
Notes: Discover the perfect investment opportunity with the Lake View Motel & Gift Shop, family owned and operated for 40 years and situated on the picturesque shores of Lake Missaukee. The only resort remaining on Lake Missaukee, along with the only gas on the lake with easy access via the fuel dock. This property offers 178.5 feet of prime lakefront, complete with a paved boat ramp and gas pump, making it an ideal spot for water enthusiasts and vacationers alike. The property offers 11 immaculate units, each beautifully maintained and thoughtfully decorated, offering guests a comfortable and stylish stay with breathtaking lake views. The charming gift shop is perfect for showcasing local crafts, souvenirs, and essentials. This well-positioned shop complements the motel, creating additional revenue streams and enhancing guest experience. The owner/manager’s apartment is a two bedroom, two bath comfortable residence, providing convenience and privacy while overseeing the operations. Lake View Motel sits immediately adjacent Miltner Park and Public Beach with 100’s of feet of beautiful sandy beach. Additional recreational amenities offered directly across the street include Veterans Memorial Park, the public library, tennis, pickleball and basketball courts. This is a unique opportunity to own a well-positioned motel that offers both a serene lakeside setting and proximity to community facilities. Enjoy the lifestyle of lakefront living while managing a profitable business with three revenue streams generated by the motel, gift shop and boat fueling station. Perfect for investors, those looking to expand their real estate portfolio or those simply looking for a lifestyle change. ** The two story motel with seven units was built in 2011; four units attached to the main building were built in 2009; the owners/manager's living area was built in 1987 and the store was updated in appx 2014. All in excellent condition and perfectly maintained.
MlsNumber: --
ListingId: 1926562


Listing Provided By: COLDWELL BANKER SCHMIDT REALTORS-HL, original listing
Phone: (989) 429-3100
Office Phone: (989) 366-5522
Agent Name: RUTH CLEMENS
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