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

63 W Traverse Lake Road
Maple City, MI 49664
Ranae Ihme with LVR Realty, LLC, original listing - (231) 218-2714

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,850,000
Beds: 3
Baths: Full: 4
Status: Active
SqFt: 2405 Square Feet
Agency: LVR Realty, LLC
Agency Phone: (231) 218-2714

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1955
Notes: Absolutely beautiful, charming, cozy, and unique Craftsman cottages along the “gold coast” of Little Traverse Lake and in the heart of the Sleeping Bear Dunes National Lakeshore. This enclave of Little Traverse Lake has sweeping views of Sugar Loaf mountain, clear waters, and a soft, sandy entrance. There’s also a path just across from the home that leads to unobstructed, park owned Lake Michigan beaches on Good Harbor Bay and winding, hiking trails throughout the area, allowing for the best of both waterfront worlds in northern Michigan. This is one “home” with several fun, different spaces. The main home has lovely views of the lake, houses a living room with wood burning fireplace, dining area, spacious kitchen, den, three bedrooms, two full bathrooms, and an oversized mudroom. There is also central heat and air, with the heating being run by a boiler system. The second space is a charming guest cottage with living space, half bathroom, and a loft with ladder. The third space is an oversized, two car garage with separate door/entry to an additional living space with a full bathroom/shower. The fourth space is our favorite part – the “boathouse”! Set along the lakeshore, it has a modernized, glass garage door that opens to the water, and has a fantastic aesthetic. Currently, it is used for dining, relaxing, and entertaining, with another half bathroom and outdoor shower, perfect for hosting! Finally, there is a tool shed and additional space behind the guest house that could also serve as a workout space/gym, or home office. The lot of this home is deep, and there’s a long driveway through the woods, which is actually two separate parcels (each part of this sale). There are so many other wonderful attributes to note, including 16 solar panels, mini heat and air splits in the additional buildings, wood stoves in the out-buildings, tankless water heaters, programmable thermostats, rain water collection, and more! Don't miss out on this incredible opportunity!
MlsNumber: --
ListingId: 1931046


Listing Provided By: LVR Realty, LLC, original listing
Phone: (231) 218-2714
Office Phone: (231) 218-2714
Agent Name: Ranae Ihme
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