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;

750 W Lincoln Street
Birmingham, MI 48009

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $900,000
Beds: 3
Baths: 4
Status: Pending
SqFt: 2354
Agency: Real Estate One

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2005
Notes: Welcome to this charming colonial home nestled in the heart of Downtown Birmingham, Michigan. Boasting 2354 square feet of comfortable living space, this meticulously maintained residence offers an ideal blend of elegance and functionality. As you step inside, you'll be greeted by the warm ambiance of cherry hardwood flooring that flows seamlessly throughout the main level. Tall ceilings and abundant natural light create an inviting atmosphere, perfect for both relaxation and entertaining. The spacious kitchen is a chef's delight, featuring custom cabinetry, granite countertops, and stainless steel appliances. Adjacent to the kitchen, the 2-car attached garage leads to a convenient mudroom with ample storage space, keeping clutter at bay. Upstairs, the expansive master bedroom awaits, complete with trey ceilings, a private balcony, and a luxurious ensuite bathroom featuring separate his and hers vanities and closets. Additionally, the upper level boasts the convenience of a second-floor laundry room. The fully finished basement is a haven for entertainment, offering a large gathering area, a full bathroom, and a generously sized office with elegant French doors. Descend a couple of steps further to discover the pièce de résistance—a sprawling theater room, showcasing the builder's commitment to quality craftsmanship. Outside, enjoy the vibrant community of Downtown Birmingham, with its array of shops, restaurants, and amenities just blocks away. Take advantage of nearby Crestview Park and Barnum Park, offering tennis courts, open fields for leisurely strolls or playing with pets, and baseball diamonds for outdoor recreation. Don't miss your chance to make this exceptional Birmingham residence your new home. Schedule a showing today and experience the epitome of luxury living in a coveted urban setting. *BATVAM*
MlsNumber: 20240026998


Listing Provided By: Real Estate One, original listing
Name: Real Estate One
Phone: (248) 304-6700
Office Name: Real Estate One-W Blmfld
Office Phone: (248) 851-4100
Agent Name: Stephen J Kashat
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