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;

3501 Bradway Boulevard
Bloomfield Hills, MI 48301

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,250,000
Beds: 4
Baths: 5
Status: Pending
SqFt: 3236
Agency: Five Star Real Estate LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1954
Notes: Step into the timeless elegance of Bloomfield Village, where this meticulously updated Traditional Colonial beckons with refined charm at every turn.<br /> <br /> Cross the threshold and be greeted by the allure of pristine hardwood floors, complemented by intricate moldings that whisper of craftsmanship. The heart of the home, a professional-grade kitchen, boasts sumptuous granite counters, a spacious island, and a delightful breakfast nook—perfect for culinary endeavors and casual dining alike.<br /> <br /> Enhanced with convenience in mind, a mudroom off both the back door and the garage provides the perfect space to remove shoes and coats upon returning home. Meanwhile, a first-floor laundry room ensures practicality and ease of access for day-to-day chores.<br /> <br /> Entertain in style within the formal dining room, while the living and family rooms, graced by cozy fireplaces and bespoke built-ins, invite intimate gatherings and relaxed evenings alike. Find solace in the mahogany-paneled library, a sanctuary of peace amidst the hustle and bustle of daily life.<br /> <br /> Retreat to the expansive master suite, where luxury abounds with a private en-suite bath and a generous walk-in closet. Three additional spacious bedrooms offer versatility and comfort, ensuring ample space for family and guests to feel at home.<br /> <br /> Step outside into your own private oasis, enveloped by mature landscaping and centered around a refreshing in-ground pool on a sprawling half-acre treed lot. Explore backyard renderings included for inspiration on future enhancements to further elevate your outdoor living experience.<br /> <br /> Perfectly situated within the coveted Birmingham school district and just a leisurely stroll away from shops, restaurants, and groceries, this residence epitomizes sophisticated suburban living at its finest. Embrace the epitome of luxury and convenience in this idyllic haven known as Bloomfield Village.
MlsNumber: 20240025308


Listing Provided By: Five Star Real Estate LLC, original listing
Name: Five Star Real Estate LLC
Phone: (616) 791-1500
Office Name: Five Star Real Estate-Commerce
Office Phone: (248) 313-2880
Agent Name: Marcy Soufrine
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