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

18417 Westchester Drive
Livonia, MI 48152

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $670,000
Beds: 4
Baths: 4
Status: Pending
SqFt: 2716
Agency: New Century and Beyond

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1998
Notes: Exceptional 4 Bedroom, 3.5 Bath Colonial with 3 Car Garage, Finished Lower Level, and Fabulous In-Ground Pool situated in Desirable Woodbury Park in NW Livonia! This Impressive Home Features a 2-Story Foyer & Beautiful Wood Staircase w/ Wrought Iron. Expansive Living Room & Dining Room w/ Cathedral Ceiling, Gas Fireplace & Hardwood Floors. Library w/ French Doors. Gourmet Island Kitchen w/ Custom 2-Toned Wood Cabinetry, Marble Countertops & Premium Stainless Appliances Including a 5-Burner Gas Cooktop and Built-In Oven. Breakfast Nook w/ Large Bay Window & Doorwall Leading to Beautiful Private Fenced Backyard with an In-Ground Swimming Pool & Huge Patio. Large Family Room w/ Hardwood Floors, Gas Fireplace, Recessed Lights & Lots of Windows Overlooking Backyard. Elegant Powder Room w/ Custom Mirror & Vanity with Marble. Upper Level features an Amazing Primary Suite w/ Cathedral Ceiling and Huge Luxurious Bath w/ Dual Vanities, Jetted Spa Tub, Separate Shower, Water Closet, and 2 Walk-In Closets with Organizers. 3 Additional Bedrooms and Full Bath on Upper Level. Finished Lower Level is Perfect for Entertaining and Features a 2-Sided Fireplace, 2nd Full Kitchen, Theater Room or Media Room, Wine Cellar, Full Bath, Flex Room, and Storage Room. Beautiful Landscaping, 3 Car Side-Entry Garage w/ Insulated Doors. Prime Location Close to Shopping, Restaurants, Entertainment, Golf Courses, and Easy Access to Major Freeways! Immediate Occupancy Available. All M & D Approx. BATVAI.
MlsNumber: 20240023157


Listing Provided By: New Century and Beyond, original listing
Name: New Century and Beyond
Phone: (248) 553-5050
Office Name: RE/MAX New Trend
Office Phone: (248) 553-5050
Agent Name: Michael Hermiz
Disclaimer: Copyright © 2024 Realcomp Limited II. 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 = 3459 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;
Real Estate Expert Photo for Melissa Beebe
Melissa Beebe
ASCIIeXp Realty, LLC.
Call Today!: (734) 347-8542

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App