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;

4133 Shadynook Road
Central Lake, MI 49622

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,853,000
Beds: 4
Baths: 3
Status: Active
SqFt: 1997
Agency: Coldwell Banker Schmidt Family Of Companies

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 16 acre(s)
Property Type: Residential
Year Built: 2009
Notes: This incredible 16 acre estate boasts the most breathtaking, panoramic water views in all of Antrim County! Multiple vantage points allow you the unique opportunity to soak in the beauty of Torch Lake, Lake Michigan, and hundreds of peaceful acres from this impeccable 3 bedroom oasis. The newly constructed outdoor patio includes a gorgeous fireplace, pergola, and bar with refrigeration that all face the western setting sun. The adjacent carport also serves as a covered dining area for the spectacular events and family gatherings you'll be eager to host! The upper level living space includes the primary bedroom and bath, as well as an open concept living room, kitchen, and dining space. The upper deck has unobstructed views of the rolling countryside making it the premiere location to enjoy sensational sunsets over the water. The ground floor level offers an additional bathroom, two bedrooms, family room and laundry. Landscaping for this property is nothing shy of amazing! The tree lined paved driveway leads to the ridgetop through a variety of maples that explode in color each autumn. The included acreage on either side of the house offers excellent view building sites OR additional privacy if you desire. This exclusive estate also includes one of the finest insulated pole barns/barndominiums you will ever see! Featuring double 12X12 drive through doors, polished concrete floors and finished interior, it also includes a luxurious one bedroom/one bath apartment to offer your guests or to utilize for rental income. This one-of-a-kind offering is currently a single family home but it could also serve as a spectacular event space for those looking for a potential business venture. Every square inch of this immaculate property shines with pride of ownership and the quiet, pristine setting is waiting for you to relax and drink in unmatched views each and every day!
MlsNumber: 1923239


Listing Provided By: Coldwell Banker Schmidt Family Of Companies, original listing
Name: Coldwell Banker Schmidt Family Of Companies
Office Name: Schmidt Realtors
Office Phone: (231) 533-8641
Agent Name: David Ciganick
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