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

5990 Zimmer Road
Williamston, MI 48895

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $500,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3131
Agency: Coldwell Banker Hubbell BriarWood

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11 acre(s)
Property Type: Residential
Year Built: 1989
Notes: A rare gem! Well -maintained classic 4 bedroom/ 3 full bath colonial home tucked in 11 wooded acres in the award-winning Williamston school district with easy access to the I-69 and I -96 corridor. This delightful home strikes the perfect balance between openness and coziness, modern convenience and vintage charm. The spacious open-concept living area is perfect for large gatherings. Ample flexibility for an extended dining table and comfortable sitting area to enjoy a special meal, movie or the big game by the wood burning fireplace with reclaimed barn wood mantel. Kitchen with large windows overlooking the back yard, designed for multiple cooks in mind: custom cabinetry with numerous drawers, stone countertops, large island with prep sink, and a marvelous butler's pantry. See more A glorious large screened porch and large deck is a favorite staycation spot to linger over a cup of coffee in the morning and listen to the frog singers at twilight. Conveniently bathe young ones while cleaning up after dinner or get the older ones off to school on time after breakfast in a thoughtfully designed first floor full bath. Get away for a quiet conversation or a good book in the den with built-in bookcases and cabinets which could be used as a main floor 5th bedroom. A wide staircase leads to four bedrooms in the upper level with reclaimed hardwood floors, numerous closets, full compartmentalized bathroom, whole-house attic fan, and space for a future ensuite primary bathroom. Enjoy game night and your favorite hobby in the lower level that stays comfortably warm in the chilly months with radiant heated floors, wood burning fireplace, high quality pine paneling reminiscent of a northern Michigan lodge. Hardwood floors and curated vintage light fixture shades throughout along with large windows bring in abundant natural light and take full advantage of a park-like setting with mature landscaping, trees, pond and trails. Two+ garage and large outbuilding with concrete floor and electricity for workshop and all your toys. Newer roof and Anderson replacement windows. Agriculture-residential zoning for possible hobby farm.
MlsNumber: 280728


Listing Provided By: Coldwell Banker Hubbell BriarWood, original listing
Name: Coldwell Banker Hubbell BriarWood
Phone: (517) 492-3398
Office Name: Coldwell Banker Realty-Okemos
Office Phone: (517) 349-4406
Agent Name: Melissa Itsell
Disclaimer: Copyright © 2024 Greater Lansing Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 3328 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;
Feldpausch Brewster Team
Call Today!: (517) 668-6705

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App