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;

8635 Clam Lake Road
Bellaire, MI 49615
Jeanette Gillespie with Schmidt Realtors, original listing - (231) 533-8641

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,985,000
Beds: 4
Baths: Full: 1, ¾: 1
Status: Active
SqFt: 2891 Square Feet
Agency: Schmidt Realtors
Agency Phone: (231) 533-8641

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1960
Notes: Is 2025 the year you begin lake life living? This exquisite home was reconstructed and designed in 2022 the initial cottage was taken down to the studs, rebuilt, with 2/3 of the home being completely new! This manicured parcel has 100 feet of private frontage with an expansive sea wall on Clam Lake, a stunning yard with ample room for entertaining, and professional landscaping. The modern kitchen and dining area includes Viking appliances, JennAir Dual Zone Wine Cooler, and a considerable amount of storage. The vaulted ceilings extend up to the second level allowing for plenty of natural light and the fireplace makes for a cozy atmosphere during chilly evenings! Located just outside the kitchen the lighted covered porch is the perfect place to grill, share a meal, or watch your favorite game on the large tv. Other outdoor living spaces include a gathering space by the gas fire pit table, sizable front porch, and fire pit in the yard. Down by the water the tiki hut is a great spot to plan your next adventure whether its water skiing or tubing, cruising over to the prestigious blue and turquoise waters of Torch Lake, or meandering down Grass River into Lake Bellaire! The tiki hut also has a tv so you wont miss a thing in-between adventures! The primary ensuite includes large windows with privacy shades offering expanded views of the lake. On the upper level you will find two bedrooms and a comfortable sitting area which is ideal for an office or reading nook. Two bonus sleeping areas are situated above the enormous attached garage with space for cars, storage, and large boats due to the 13 foot high ceiling. Sellers are offering $30,000 at closing for new owners to add an additional bathroom in the location of their choice!
MlsNumber: --
ListingId: 1929716


Listing Provided By: Schmidt Realtors, original listing
Phone: (231) 676-8023
Office Phone: (231) 533-8641
Agent Name: Jeanette Gillespie
Disclaimer: Copyright © 2024 Coldwell Banker Schmidt REALTORS. 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