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

7940 Ernst Road
Manchester, MI 48158

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $930,000
Beds: 4
Baths: 3
Status: Active
SqFt: 4405
Agency: Whitetail Properties Real Estate, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 19 acre(s)
Property Type: Residential
Year Built: 1977
Notes: Experience the epitome of country living on a sprawling 34-acre property. This idyllic home is tailor-made for those with a passion for hobby farming, horses and avid hunting. Immerse yourself in the breathtaking beauty of nature as you witness the mesmerizing wildlife gracing the hills in the morning and evening. With utmost seclusion and tranquility, relish in the comforts of privacy and serenity. <br /> <br /> Built in 1977, this home has undergone numerous updates and meticulous maintenance, ensuring a modern and well-appointed living space. Boasting 4 bedrooms, with the possibility of a fifth, and 2.5 bathrooms, this residence offers ample space for the whole family. The living areas include a family room, a living room, and both a small and large dining room, all featuring stunning oak wood floors and carpeting.<br /> <br /> The bathrooms have been thoughtfully upgraded, with the toilets replaced and updated. The heart of the home, the kitchen, has received a complete makeover, featuring beautifully refinished Amish cabinets, new quartz countertops, and a full matching backsplash. Additionally, a fireplace with a wood burner insert adds a cozy touch to the family room.<br /> <br /> Embrace the outdoors with a large, covered cedar deck off the dining room, perfect for entertaining or simply enjoying the serene surroundings. A smaller deck leads to a refreshing 16x32 Kayak pool, complete with a deck and a propane heater for year-round enjoyment. The pool boasts a new liner and walls, ensuring a pristine and inviting swimming experience.<br /> <br /> For your peace of mind, this property is equipped with a Generac standby full house generator, guaranteeing uninterrupted power supply. Stay comfortable year-round with a new Carrier furnace with a humidifier and central air system. Additionally, a new Kinetico water softener with a RO system ensures the highest quality water for you and your family.<br /> <br /> The additional tract of land is teaming with wildlife and is an incredible hunting parcel. Its rolling mature timber borders farm fields and wetland cover creating the perfect habitat for deer and turkey and a very huntable topography for stand locations to intercept big Washtenaw County bucks cruising through this property.<br /> <br /> In summary, this remarkable country property offers a harmonious blend of natural beauty, modern updates, and an array of amenities designed to enhance your lifestyle. Some important bullet points to note:<br /> <br /> 18 miles/30 minutes to Ann Arbor<br /> 35 spacious acres with excellent deer and turkey hunting<br /> Mature timber<br /> Trail system<br /> 2300sf home with 2100sf finished walkout<br /> 4 bedrooms, 2.5 bath, <br /> Oakwood floors<br /> Amish kitchen cabinets with quartz countertops with matching backsplash<br /> Fireplace with woodburning insert in family room<br /> Covered cedar deck with smaller deck attached to pool. Reinforced for possible hot tub<br /> 16x32 Kayak pool with deck and heater (new liner and walls)<br /> Generac full house generator<br /> New 2023 septic field. <br /> Tanks and field inspected and approved for Washtenaw "Time of Sell" inspection.<br /> Duct work cleaned 2019<br /> New Carrier Furnace w/ humidifier<br /> New Carrier central air unit<br /> New dual tank Kinetico water softener with Reverse Osmosis system<br /> Finished Basement with 2 walkout entrances and large windows<br /> Sensor control BT wave system<br /> Extra electric built in furnace<br /> Large cellar for food storage<br /> 500 gallon propane tank (owned)<br /> 5500 Wood Master outside wood burner. Heats garage, house, water heater and large enough to heat barns if opted.<br /> Attached garage has additional seperate propane heater<br /> Large insulated GArage door<br /> 20x20 carport<br /> Asphalt driveway with 4 car cement approach to garage<br /> 36x56 polebarn with cement floor and new metal roof<br /> 42x80 parcial cement floor for animals or equipment<br /> Quonset hut<br /> <br /> Don't miss the opportunity to make this your dream home.
MlsNumber: 23026257


Listing Provided By: Whitetail Properties Real Estate, LLC, original listing
Name: Whitetail Properties Real Estate, LLC
Phone: (231) 330-4107
Office Name: Whitetail Properties Real Estate, LLC
Office Phone: (231) 330-4107
Agent Name: Shawn Kelley
Disclaimer: Copyright © 2024 Michigan Regional Information Center, LLC. 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 = 1315 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;
David Wilson
ASCIIReinhart Realtors
Call Today!: (517) 219-2639

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App