- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
$1,050,000
Monthly Est:$5,226
4 Beds
4 full baths + 1 half bath
6,410sqft
54150 Queensborough Dr, Shelby Charter Township Macomb, MI 48315
$1,050,000
$5,226/moEst:
Single Family Residence
Built in 2000
$54.17/mo HOA
24,393.6 sqft lot
$164/sq.ft
Description
PRESTIGIOUS HOME IN LAKE OF THE WOODS! A custom-built home on over half an acre, this home offers exceptional living space & impressive architectural details that are truly hard to find in new construction. Enter the grand foyer with winding staircase and discover generously sized rooms designed for everyday living & entertaining. The enormous two-story great room with expansive windows & gas fireplace. A spacious kitchen featuring custom cabinetry, granite countertops, an oversized island, a direct-vent cooktop and walk-in pantry. Formal living & dining rooms provide additional entertaining space, while a private office is tucked away for quiet productivity. The massive primary suite is a luxurious retreat featuring a spacious private bath with both a tub & shower. Three additional generously sized bedrooms and two full bathrooms complete the upper level. The huge walk-out lower level has an expansive recreation area with a fireplace, a large wet bar, plenty of room for a pool table or game room & a full bathroom. Enjoy the expansive backyard with a generous patio area, perfect for peaceful relaxation. Located in the highly acclaimed Utica Community School District, this extraordinary home combines space, elegance, privacy, and an exceptional location.
- Houzeo last checked: 9 minutes ago
- Listing updated: November 21, 2026 at 8:14 am
- Listing Provided by: Kimberly Drescher Tanascu , Robert Drescher | Real Estate One Inc-Shelby (586) 532-5500
- Source: Realcomp MLS-MI | MLS#:

- Originating MLS: MiRealSource
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
24,393.6 sqft lot
Basement Area
- sqft
MLS Name
Realcomp MLS
MLS Number
58050227807
MLS Status
Active
Days on Market
4
Cumulative Days on Market
153
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
HOA Management
N/A
HOA Fees
$650/ Annually
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
Interior Features
Balcony, Cathedral Ceilings, High Speed Internet, Pantry, Wet Bar, Walk In Closets
Window Features
Window Treatments
Heating
Forced Air, Natural Gas
Flooring
Hardwood
Exterior Features
Balcony
Cooling
Central Air
Appliances
Dishwasher, Dryer, Microwave, Oven, Refrigerator, Range, Washer
Sewer
Septic Tank
Construction
Year Built
Year Built: 2000
Home type
Single Family Residence
Foundation Details
Basement
Architectural Style
Colonial
Construction Materials
Brick
Utilities & Energy
Security Features
Security System
Basement
Concrete, Finished, Full, Sump Pump, Walk Out Access
Parking Features
Three Car Garage, Attached, Electricityin Garage, Off Street, Garage Door Opener
Water Source
Public
Pool Features
None
Fireplace Features
Basement, Gas, Great Room
Other Features
Lot Features
Decorative Pond, Water View, Sprinklers
Patio And Porch Features
Patio
Disclosures
Flood Ins Not Reqd, Flood Plain None, Taxes Homestead Exempt
Subdivision Name
Lake In The Woods Sub
Price History
| Date | Event | Price |
|---|---|---|
11/21/2026 Source: | Listed for Sale | $1,050,000 $164/sqft |
11/17/2026 Source: | Coming Soon | $1,050,000 $164/sqft |
11/01/2026 Source: | Listing Removed | $1,050,000 $164/sqft |
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 |
Show more
Find Homes by Property Features in Shelby Charter Township Macomb, MI
Nearby New Homes For Sale
Based on information from the Board/Association of REALTORS® (alternatively, from the Realcomp II Ltd. MLS) through Nov 22, 2026, 02:15AM. 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













