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;

1230 Latham
Birmingham, MI 48009
Eric Bloomingdale with Max Broock, REALTORS®-Birmingham, original listing - (248) 644-6700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,900,000
Beds: 5
Baths: Full: 6, ½: 2
Status: Active
SqFt: 5543 Square Feet
Agency: Max Broock, REALTORS®-Birmingham
Agency Phone: (248) 644-6700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Captivating New Construction by premier builder Bloomingdale Homes presents this modern masterpiece on one on the best lots in Birmingham. Enjoy over 7200 sqft of living space featuring 5 beds & 5.2 baths nestled in a rare location backing up to the Rouge River. Enjoy an awesome finished walk-out lower level which includes a 2nd kitchen, multiple flex spaces and showcased by an infinity pool, hot tub, outdoor fireplace and multi-tiered patios plus a covered lanai embracing breathtaking views from every angle of this 285 ft deep lot, truly an entertainers dream. Be amazed as you step into this creatively designed open concept home filled with the finest of designer finishes throughout that exudes living the life of luxury and style only one could expect in this modern treasure. The main level features a chef's kitchen with quartz counters, large sitting island, luxe fixtures, premium appliances, custom cabinets and flowing perfectly into the formal dining room. The great room has dramatic soaring windows with sunshine views you can only imagine. Also located on the main level is a handsome library, great for the at home executive and a huge covered lanai off the family room, a perfect spot for dining al' fresco . The impressive, and grand floating staircase will lead you to the exceptional primary suite with spa bath, dual walk-in closets, gas fireplace and Juliet balcony capturing views of a serene and manicured backyard. Additionally upstairs are 4-ensuites with full baths and walk-in closets plus an office and laundry room. So if you are looking for something truly special and haven't found it, well you just did! Completion is late December 2024, but just in time to make your own personal touches so take a look soon. Photos are for illustrative and inspirational purposes along with some in progress. Please note specifications and features may vary and are subject to change.
MlsNumber: --
ListingId: 20240084951


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