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

11101 Mattes Drive
Williamsburg, MI 49690

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,895,000
Beds: 3
Baths: 4
Status: Active
SqFt: 3336
Agency: Century 21 Northland-Elk Rapids

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1980
Notes: This updated ranch home on Elk lake is a gem and your access to the Chain of Lakes (Torch, Clam Lake Bellaire)! With over 200 feet of frontage, it offers breathtaking views of the lake from the moment you arrive. Upon entering, you're welcomed into a spacious and inviting living area, featuring large windows that flood the space with natural light and offer uninterrupted views. Beautifully crafted cedar in main rooms for that up north feel. The kitchen is a chef's delight with views of the gradual slope to the lake. The primary bedroom is an ensuite and has direct access to a sunroom. The south end of the home hosts another bedroom with a sliding door to deck and lovely view of Elk Lake. Perfect for hosting guests The small rustic dwelling near the water is a great spot for an overnight stay (no water or plumbing) One standout feature of this home is the four-car garage spots providing ample space to store vehicles, as well as outdoor gear for enjoying all that the lakefront lifestyle has to offer. There is a bonus room with possible staircase option. Outside, the property is a haven of relaxation and recreation, with a spacious patio where you can entertain guests or simply unwind while taking in the beauty of the lake. The dock and hoist are included in the sale. The location is ideal with being close to Elk Rapids and a short distance to Traverse City. Overall, this lovely ranch home on Elk Lake offers the perfect blend of luxury, comfort, and natural beauty, providing an idyllic retreat for those seeking a lakeside lifestyle. Please see Documents to view improvements and other valuable information.
MlsNumber: 1921221


Listing Provided By: Century 21 Northland-Elk Rapids, original listing
Name: Century 21 Northland-Elk Rapids
Phone: (231) 264-4500
Office Name: Century 21 Northland-Elk Rapids
Office Phone: (231) 264-4500
Agent Name: Robin Vanderkaay
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