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;

6570 Castle Drive
Bloomfield Hills, MI 48301
Matthew Barker with Max Broock, REALTORS®-Birmingham, original listing - (248) 644-6700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $824,900
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3607 Square Feet
Agency: Max Broock, REALTORS®-Birmingham
Agency Phone: (248) 644-6700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1962
Notes: Over 4,500 square feet on a 1.34 acre lot in the heart of Bloomfield Township! Private, wooded lot with the Rouge River flowing through the very back of the lot. Covered front porch. Great floor plan with the kitchen, breakfast nook and family room all open to each other. Adjacent dining room and front living room. Living room bay window and window bench. Dining room wainscotting and floor to ceiling windows overlooking the backyard. Large granite kitchen, center island, GE & LG stainless steel appliances, doorwall to deck. Family room wall of windows, beamed ceiling and natural fireplace flanked by built-ins. Powder room vessel sink. Entry level home office. Large mud room, plus walk-in coat closet. Hardwood floors in all five upstairs bedrooms. 2015 addition and renovation. Enjoy your morning coffee or watch the sunset from the primary suite balcony! Two primary walk-in closets. Primary bath heated floor, granite dual sink vanity, jetted tub, shower & water closet. Princess suite with walk-in closet. Fifth bedroom currently used as home gym, could be a second home office. Second floor laundry. Walkout lower level features a kitchentte, full bathroom, family room natural fireplace, billiards area and plentry of storage. Bloomfield Hills Schools! A five minute drive to Conant Elementary and South Hills Middle School, ten minute drive to Bloomfield Hills High School. Brand new asphalt circular driveway (September 2024). Oversized, side entry garage. Backyard western exposure. Plenty of room to add a pool. Minutes from all the dining & shopping on Telegraph and Orchard Lake, a short drive to Downtown Birmingham. Castle Drive is a quiet, dead-end street!
MlsNumber: --
ListingId: 20240089672


Listing Provided By: Max Broock, REALTORS®-Birmingham, original listing
Phone: (248) 807-2232
Office Phone: (248) 644-6700
Agent Name: Matthew Barker
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