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

11774 N Mac Road
Irons, MI 49644

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,850,000
Beds: 6
Baths: 5
Status: Active
SqFt: 6813
Agency: Coldwell Banker Schmidt Family Of Companies

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 76 acre(s)
Property Type: Residential
Year Built: 1990
Notes: Welcome to your luxurious retreat in NW Michigan! This stunning property spans 76 acres with a private 7-acre Fairbanks Lake & 100' of frontage on Cool Lake. The ranch-style home boasts over 6,000 sq ft of living space with knotty pine and stain-glass accents creating a rustic yet elegant feel. The gourmet kitchen features quartz countertops, stainless appliances and large pantry perfect for culinary adventures (check out the variety of cooking/baking areas). Cozy up by one of the 6 fireplaces scattered throughout the home and take in the lake views throughout. The primary main floor suite engulfs one whole side of the house and offers relaxation with a heart-shaped tub, double sliders offering a whole wall of lake & sunrise views. Spacious elevated deck and separate balcony overlooks the grounds. Enjoy the in-ground pool, hot tub & fire pit amidst the tranquility. This property has an abundance of amazing outdoor spaces including a covered front patio perfect for being outside & grilling in any weather. A large pole barn provides ample storage or workspace: there's an equipment/garden shed area, storage area, workshop, office & half bath inside. Barn is heated and has hot/cold water & drain plus upgraded LED lighting. Outside the barn is a 100' shooting range. Take your ATV around the property to check on your blinds as the owner has some trails that just need a little bit of refreshening to be the perfect walking path. Take in nature amidst the woods, lake & ravines plus continue your adventure onto the National Forest off the east border of the property! There are many areas for expansion should you wish to add additional outbuildings or cabins or another home for extended family/guests. There are so many amenities both inside and out - be sure to review the floor plan in the photos. This estate would make a wonderful family or corporate retreat, perhaps a hunt club or an investment property with lots of growth possibilities. 4-seasons of fun awaits you!
MlsNumber: 1920278


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) 775-1737
Agent Name: Daniella Bell
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