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;

5904 Mackenzie
Kewadin, MI 49648

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,850,000
Beds: 5
Baths: 4
Status: Active
SqFt: 4550
Agency: Joseph Walter Realty, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2016
Notes: Custom Lake Michigan Home on East Bay. Once you walk through the double entry doors you will understand why this will become your forever home. 100' feet of sugar sand and bonus private sunbathing cutout gives you surreal privacy. Home faces west towards the Old Mission Peninsula, so get ready to enjoy the most amazing sunsets. Traverse city is just a short drive away, yet this amazing property is located just outside the quaint Village of Elk Rapids- so you will have amazing privacy. Custom kitchen boasts solid natural quartz countertops and hardwood flooring. Highly sought after open floor plan with many upgrades. Cozy up to the natural gas fireplace and sip on your favorite drink while gazing out at Lake Michigan splendor! Soak in a solid granite tub in the master bathroom and let your worries wash away. Yes, I did say solid one piece of granite and it weighs 2700 pounds. Heated flooring awaits you in the master bath and double headed walk-in shower. The home boasts of four bedrooms on the main level and 3 full bathrooms, which allows your family and friends to be comfortable on the same level. This investment includes a home gym that is truly large enough for all your equipment and still has room to sprawl out and do yoga. After a hard workout you might want to enjoy the outdoor hot-tub and watch the waves. Your kids or grandkids can enjoy playing in the ninja gym and scamper up the climbing walls! Enjoy elevated ceilings in the basement with standard walls 10 foot high! Unfinished large workshop for woodworking or your other hobbies and plenty of secondary storage in the basement level. Walkout through the French Doors from the basement and a sea of beach sand meets you in a manicured micro valley that creates an oasis hidden from your neighbors. Natural Rock landscaping surrounds this sugar sand privacy area. Sit back in a bank of Adirondack chairs with your family and let the lapping waves melt away your stress!
MlsNumber: 1917979


Listing Provided By: Joseph Walter Realty, LLC, original listing
Name: Joseph Walter Realty, LLC
Phone: (888) 227-1009
Office Name: Joseph Walter Realty, LLC
Office Phone: (888) 227-1009
Agent Name: Scott Fader
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