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

358 S Intermediate Lake Drive
Central Lake, MI 49622
Angela DiLorenzo with Berkshire Hathaway Homeservices Michigan - TC, original listing - (231) 947-7777

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,000,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 3015 Square Feet
Agency: Berkshire Hathaway Homeservices Michigan - TC
Agency Phone: (231) 947-7777

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1900
Notes: *Intermediate Lake *10 Acres *418 feet of private frontage! *Just on time for summer! Welcome to this one-of-a-kind waterfront lodge. Step back in time and experience the rich history and natural beauty surrounding this unique waterfront lodge, nestled on a sprawling ten-acre estate with 418 feet of private frontage along the pristine shores of Intermediate Lake. This cherished family home, with its roots dating back to the early 1900s. As you step onto this historic property, you'll be captivated by its timeless charm and rustic elegance. Boasting five spacious bedrooms and two bathrooms, this home is a testament to the enduring craftsmanship of yesteryears. The heart of this home is the inviting three-season sunroom, where you can soak in the panoramic views of the lake and private pond. This sanctuary offers a tranquil escape where you can enjoy leisurely mornings with coffee or evenings filled with laughter and stories shared with loved ones. For those with a penchant for history and preservation, the stand-alone barn, measuring 28x48 feet, provides endless possibilities. (utilize it for storage, restoration, or as a creative space) This cherished estate, which has remained in the same family for generations, is now being sold for the first time. It represents an unparalleled opportunity to own a piece of Northern Michigan, with ten acres of land and 418 feet of private frontage. This property is a haven for outdoor enthusiasts. Enjoy unlimited boating adventures right from your shoreline. This is more than a home; it's a cherished piece of history waiting for the next chapter to be written. It's the perfect spot to summer in Northern Michigan.
MlsNumber: --
ListingId: 1921738


Listing Provided By: Berkshire Hathaway Homeservices Michigan - TC, original listing
Phone: (231) 632-5105
Office Phone: (231) 947-7777
Agent Name: Angela DiLorenzo
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