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;

5645 Winslow Court
Ypsilanti, MI 48197

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $575,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2474
Agency: Century 21 Affiliated

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1984
Notes: An opportunity to purchase an owner/builder custom built home with a wonderful layout that impeccably flows. The owner has spared no expense to provide a comfort and quality that endures. Upon arrival, the striking lines of the exterior catch your eye. As you step onto the Canadian limestone front steps, you know you've come home. Inside, the two-story foyer welcomes you. To your right is a formal living and dining room filled with sunshine and ideal for hosting gatherings and creating memories. The kitchen boasts granite counters, ceramic tile floors, and a suite of stainless-steel appliances from Viking, Bosch, and GE Monogram. The breakfast bar can be utilized as a buffet for sharing food with friends. In the cooler months you will appreciate the wood burning fireplace adorned with bookshelves - lose yourself in the pages of a George R. R. Martin novel while the fire provides warmth. During summers, retreat to your sunroom oasis, enjoying your morning coffee while watching birds, squirrels, and the occasional rabbit. Ascending to the second floor reveals the primary bedroom is large, with abundant light streaming in from multiple windows. There is an expansive walk-in closet with storage galore! The primary bath features beautiful tile floors, and a Schluter no-leak shower and floor system, ensuring both style and functionality. There are three additional bedrooms of good size; each versatile enough to serve as an office or media room. There is also another full bath on the second floor as well. The basement is an opportunity for storage, or finish to create a rec room or media room. Then step outside to your private retreat - the large deck with grilling station is sure to provide you with countless hours of enjoyment with friends. One corner of the lot has been designated a vegetable garden; the owners are leaving rain barrels so you can easily water your tomatoes, peppers and potatoes. Additional storage is provided by two sheds for storing gardening tools, storing your smoker, or whatever suits you. There is also an enclosed space for storing your fireplace wood. Finally, revel in the meticulously landscaped grounds adorned with mature trees, manicured hedges, lush bushes and perennial flowers, completing your personal sanctuary. <br /> <br /> If you can be persuaded to leave your retreat, there is a neighborhood park to visit. A little further is Hickory Woods Park. Or visit Wiard's Orchard or Rolling Hills Water Park. Markets include Meijer, Kroger, Whole Foods, Aldi, Sam's Club and more. And minutes from Easter Michigan University, the University of Michigan, Briarwood mall, Metro Airport and just a bit more travel time to get to downtown Ann Arbor or Detroit. This is a home you should not miss!
MlsNumber: 24017633


Listing Provided By: Century 21 Affiliated, original listing
Name: Century 21 Affiliated
Phone: (734) 930-6150
Office Name: Century 21 Affiliated
Office Phone: (734) 930-6150
Agent Name: Alexsandra Anteau
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