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

3263 W Maple Road
Bloomfield Hills, MI 48301

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,999
Beds: 4
Baths: 2
Status: Active
SqFt: 2200
Agency: Real Estate One

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1960
Notes: Conveniently located just minutes from downtown Birmingham, this Bloomfield Tri-Level home boasts numerous updates and features. Welcome to this magnificent 4 bedroom, two-full-bath, brick home located in the highly coveted Westchester Village. Large circular driveway, this lovely residence boasts a beautifully updated kitchen featuring white cabinets with soft close, stainless steel appliances, and a cozy breakfast nook area. The spacious dining room opens to a family room with a door-wall to a large patio. 1st floor offers ample natural light through large front windows and rear sliding door wall. Upstairs, discover three bedrooms with an updated bath. Enjoy a quiet large family rm in the lower level, complete with natural fireplace open to a large 4th bedroom that could be closed off with a private full updated bath. The two full baths have been tastefully remodeled, adding to the home's charm and functionality. This expansive floor plan has been updated with newer tri-paned windows helping keep the home quiet, newer kitchen, French drain system & newer garage roof. This home offers a comfortable and modern living experience. Outside, the circular driveway giving way to privacy from the road, large private lot (120X150), and fence add to the property's appeal providing ample space for outdoor activities and relaxation. Quiet backyard perfect for your afternoon quiet enjoyment. Within walking distance to shopping and schools, this home is a perfect blend of comfort, convenience, and style with easy access to Detroit Country Day School, Oakland Hills and Bloomfield Hills Country Clubs, Brother Rice High School, Lincoln Hills and Birmingham Golf Courses, and the Cranbrook School campus. Don't miss out on this fantastic opportunity! With its prime location, ample space, and numerous amenities, this home is a true gem waiting to be discovered.
MlsNumber: 20240027232


Listing Provided By: Real Estate One, original listing
Name: Real Estate One
Phone: (248) 644-6700
Office Name: Max Broock, REALTORS®-Birmingham
Office Phone: (248) 644-6700
Agent Name: Tonya Newberry
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App