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;

6903 Cathedral
Bloomfield Hills, MI 48301

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $639,800
Beds: 4
Baths: 3
Status: Pending
SqFt: 2317
Agency: Advantage Realty Incorporated

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1961
Notes: HIGHEST & BEST OFFERS DUE TONIGHT 04/14/24 BY 9PM. Gorgeous, updated, and move in ready best describes this sprawling colonial with Bloomfield Hills Schools. Updated landscaping and covered front porch greet you and as you walk in, you will see the updates right away. Re-finished hardwood floors throughout except bathrooms & laundry, large den/sitting area with loads of windows, cozy open concept family room with custom stone electric fireplace, kitchen updated with 42” upper cabinets, soft close with pull outs, center island with waterfall quartz, subway tile backsplash, and newer stainless steel appliances. Huge laundry/mudroom off kitchen with loads of cabinets, ceramic tile floor, & sink with granite counters. Bedroom (has closet) or den on the main floor along with updated ½ bath, upstairs features huge master bedroom with walk in closet, crown molding and private updated bathroom with large shower, euro door, double sinks & decorative ledgerstone wall. 2 other spacious bedrooms upstairs & updated main bathroom. Basement is ready for your finishing touches. Door wall off eating area leads to fenced backyard with new multi-level paver patio and built in firepit for those upcoming summer evenings. Other updates include newer windows & door wall, high efficiency furnace, and updated electrical. Features also include custom blinds, new lighting fixtures, sprinkler system, dual water meters, all appliances including washer & dryer to stay.
MlsNumber: 50138361


Listing Provided By: Advantage Realty Incorporated, original listing
Name: Advantage Realty Incorporated
Phone: (586) 598-1400
Office Name: Real Estate One Chesterfield
Office Phone: (586) 598-1400
Agent Name: Jennifer Caira-Lauff
Disclaimer: Copyright © 2024 Multiple Listing Service MiRealSource. 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