- 0
- 1
- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
Street View
$1,050,000
Monthly Est:$5,226
4 Beds
5 Baths4 full baths + 1 half bath
6,410sqft
54150 Queensborough Dr, Shelby Township, MI 48315
$1,050,000
$5,226/moEst:
Get Pre-Approved
Single Family Residence
Built in 2000
$54.17/mo HOA
0.56 acre lot
$164/sq.ft
Description
Welcome to this exceptional luxury estate nestled within the prestigious Lake in the Woods community of Shelby Township. Situated on a premium corner lot, this impressive brick colonial offers over 6,400 square feet of finished living space, including a beautifully finished walk-out lower level designed for both entertaining and everyday enjoyment. A grand two-story foyer welcomes you into a thoughtfully designed floor plan featuring 4 spacious bedrooms, 4.1 baths, a private library, formal dining room, and an expansive great room highlighted by a natural fireplace and soaring ceilings. The gourmet kitchen is appointed with premium appliances, including a built-in refrige...
Continue Reading- Houzeo last checked: 11 minutes ago
- Listing updated: September 18, 2026 at 7:19 pm
- Listing Provided by: Danielle Christoff (586) 255-7397 , Kenneth J Hirschmann | EXP Realty Romeo (586) 372-6057
- Source: Realcomp MLS-MI | MLS#: 20261030783
- Originating MLS: Realcomp II Ltd
Property Details
Status
Active
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
2000
HOA Fees
$54.17/mo
Finished Area
6,410 sqft
Lot Size
0.56 acre lot
Basement Area
- sqft
MLS Name
Realcomp MLS
MLS Number
20261030783
MLS Status
Active
Days on Market
138
Cumulative Days on Market
106
Open House
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
HOA Management
N/A
HOA Fees
$650/ Annually
Amenities
Amenities and services may be covered by one or multiple associations and service providers.
Snow Removal
Disclaimer: Amenities are based on third-party information and may vary; buyers must independently verify all amenities, as information is deemed reliable but not guaranteed.
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 5
Interior
Sewer
Septic Tank
Interior Features
Entrance Foyer, High Speed Internet, Wet Bar
Appliances
Built In Refrigerator, Bar Fridge, Dishwasher, Double Oven, Dryer, Energy Star Qualified Dishwasher, Gas Cooktop, Range Hood, Washer
Heating
Energystar Qualified Furnace Equipment, Forced Air, Natural Gas
Cooling
Ceiling Fans, Central Air, Energystar Qualified Ac Equipment
Construction
Year Built
Year Built: 2000
Home type
Single Family Residence
Construction Materials
Brick
Architectural Style
Colonial
Roof
Asphalt
Foundation Details
Basement, Poured
Utilities & Energy
Pool Features
None
Utilities
Cable Available, Underground Utilities
Basement
Finished, Full, Walk Out Access
Security Features
Security System Owned
Parking Features
Three Car Garage, Attached, Electricityin Garage, Garage Door Opener, Side Entrance
Water Source
Public
Laundry Features
Laundry Room
Fireplace Features
Basement, Great Room
Other Features
Lot Features
Corner Lot, Sprinklers
Patio And Porch Features
Covered, Patio, Terrace
Subdivision Name
Lake In The Woods Sub
Disclosures
Taxes Homestead Exempt
Price History
| Date | Event | Price |
|---|---|---|
09/18/2026 Source: | Price Decreased | $1,050,000 -4.55% $164/sqft |
08/14/2026 Source: | Price Decreased | $1,100,000 -5.58% $172/sqft |
06/08/2026 Source: | Listed for Sale | $1,165,000 $182/sqft |
06/05/2026 Source: | Coming Soon | $1,165,000 $182/sqft |
Nearby Homes
Find Homes by Property Features in Shelby Township, MI
Nearby New Homes For Sale
Based on information from the Board/Association of REALTORS® (alternatively, from the Realcomp II Ltd. MLS) through Sep 19, 2026, 03:00AM. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified. IDX provided courtesy of Realcomp II Ltd. via Andover Real Estate & Houzeo, Copyright 2026 Realcomp II Ltd. Shareholders Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Listing Information presented by local MLS brokerage: Andover Real Estate, local REALTOR®- Scott Rubin - (248)206-3666 . Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. © 2024 Realcomp II Ltd. MLS. All Rights Reserved.
Advertising Broker: Andover Real Estate | Andover Real Estate
Love this home?
Here's 4 things you can do
Your local real estate expert. Speak directly with agent about the home & pricing.
Book your private tour
as early as Tomorrow at 09:00 AM
Rates starting from 6.3%. Secure financing early to move quickly when you're ready.
Fastest way to get your offer in. Speak directly with agent to negotiate the offer.
Houzeo Corp. holds real estate brokerage licenses in Alabama (License No. 000157023 - 0) and Texas (License No. 9013396)
TREC: Info About Brokerage Services, Consumer Protection Notice.
§ 442‑H New York Standard Operating Procedure.
New York State Fair Housing Notice.
