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;

254 S Carolyn Drive
Lake City, MI 49651
Tamara McLeod Helsel with City2Shore Real Estate Northern Michigan, original listing - (231) 839-0077

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $390,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: City2Shore Real Estate Northern Michigan
Agency Phone: (231) 839-0077

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Land-Other
Year Built: --
Notes: One of kind lot that overlooks the undeveloped part of Lake Missaukee, the perfect spot to enjoy all that waterfront living has to offer. This almost .5 acre waterfront lot with 75 ft. of private waterfront with sandy beach and wooded evergreens is a peaceful retreat to the water's edge, with a well appointed pavilion to store your kayaks and paddleboards, this is truly a place to make memories of a lifetime. The ample 60 x 40 pole barn has concrete floors with drain, infrared heat to comfortably work in throughout the year, large storage closets to organize all your stuff and enough room to store boats, snowmobiles, jet skis, side by sides and more. Upstairs you will find a area framed for a 30 x 16 room with gas line to finish off for more living or storage space. Large 12 foot walls with pull through doors for convenience. This central location in Northern Michigan offers easy day trips to Traverse City, Lake Michigan, ski resorts and is very close to miles of ORV/snowmobiling trails to enjoy. Lake Missaukee's clear waters and sandy shoreline is perfect for swimming and with the city dock located downtown, take a short boat ride and unload to enjoy the restaurants, shopping, and the famous Tasty Treat for ice cream. Enjoy the west end of our lake at the sandbar or watch from your boat July 4th to enjoy the fireworks display for the Greatest Fourth in the North celebration. Our Northern Michigan town has so many events to enjoy all four seasons, check out the video to see. See Additional MLS# 1931228 for adjacent log cabin home with garage.
MlsNumber: --
ListingId: 1931229


Listing Provided By: City2Shore Real Estate Northern Michigan, original listing
Phone: (231) 920-6422
Office Phone: (231) 839-0077
Agent Name: Tamara McLeod Helsel
Disclaimer: Copyright © 2025 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