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

5622 Springbrook Drive
Troy, MI 48098

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $985,000
Beds: 4
Baths: 6
Status: Pending
SqFt: 4164
Agency: Real Estate One

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1990
Notes: **SPECTACULAR EXECUTIVE HOME in NORTHWEST TROY w/FINISHED WALK-OUT BASEMENT **ENTERTAINERS DREAM** This beautifully maintained and updated home is located in the highly sought after BEACH FOREST neighborhood and can accommodate a multi-generation family with 5 private bedrooms, 4 Full Baths, 2 Powder Rooms - located within the HIGHLY sought after BLUE RIBBON WEST TROY SCHOOLS! Simply marvel as you enter into the stunning Grand Foyer with dual Staircases and Hardwood Floors. The refreshed Kitchen boasts Newer Maple Cabinetry, Tiled Back Splash, Granite Counters, and Center Island. Enjoy a formal Living/Dining Room w/crowned moldings, traverse arched windows, gas fireplace - plus a private first floor Library accented w/judges paneling & coffered ceilings. Great Room has vaulted ceilings, fireplace, wet-bar, plus large windows w/arched traverse tops adding light throughout the home - all newer PREMIUM high-end Marvin Windows - throughout home! The first floor Laundry Area/Mudroom has an adjacent powder room. **Journey UPSTAIRS via one of TWO staircases and discover an oversized PRIMARY BEDROOM suite w/expansive private Bathroom, dual vanities, garden tub and double walk-in closets. A second Bedroom suite also boasts a private en-suite full bathroom and walk-in closets. Don't miss 2 additional Jack & Jill bedrooms sharing a full bath before you journey downstairs -- to the CUSTOM FINISHED "WALK-OUT" BASEMENT w/premium wet bar w/Cherry Cabinets, granite counters, plenty of room for Entertaining w/fireplace, dining area, family lounge and a GUEST SUITE or FLEX ROOM w/egress windows - which can be use as a Gym/In-law Quarters (5th Bedroom) plus a Full Bath in the lower level. **STUNNING OUTSIDE OASIS** Enjoy beautiful summer nights on the New Composite Deck overlooking an-ground Swimming Pool w/attached Hot Tub. BONUS: 3 Car Garage , professionally Landscaped yard w/Stone Patio in both front/rear of the home. ** TONS OF UPDATES - CALL: FOR FULL LIST of UPGRADES - MOVE-IN READY **3D VIDEO TOUR** BATVAI
MlsNumber: 20240022303


Listing Provided By: Real Estate One, original listing
Name: Real Estate One
Phone: (248) 304-6700
Office Name: Real Estate One-Troy
Office Phone: (248) 813-4900
Agent Name: Jennifer A Toomajian
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 = 1297 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 Sherry Gillen
Sherry Gillen
ASCIILiberty Way Realty
Call Today!: (248) 842-4017

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App