REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.

In-PersonVirtual Tour

Brian Cook

bcook@c21metrobrokers.com +1(810) 240-1383

$ 1,165,000

Est. payment | -/mo

4 Beds

5 Baths

4,289 SqFt

Save

$ 1,165,000

Est. payment | -/mo

Save

4 Beds

5 Baths

4,289 SqFt

Key Details

Property Type Single Family Home

Sub Type SingleFamilyResidence

Listing Status Active

Purchase Type For Sale

Square Footage 4,289 sqft

Price per Sqft $271

Subdivision Lake In The Woods Sub

MLS Listing ID 20261030783

Style Colonial

Bedrooms 4

Full Baths 4

Half Baths 1

HOA Fees $650/ann

Year Built 2000

Lot Size 0.560 Acres

Acres 0.56

Property Sub-Type SingleFamilyResidence

Property 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 refrigerator, gas cooktop, double ovens, and a convenient butler's pantry. The luxurious primary suite serves as a private retreat, complete with a spa-inspired bath and generous closet space. The finished walk-out lower level provides exceptional additional living space with a fireplace, wet bar, and versatile recreation areas perfect for entertaining guests. Step outside to enjoy multiple patios, covered outdoor living spaces, professional landscaping, and a full sprinkler system. Residents enjoy annual HOA services include snow removal for added convenience. Meticulously maintained by its original owners, this home showcases true pride of ownership throughout. Recent improvements include updated ENERGY STAR forced air and central air systems (2023/2024), exterior repainting completed in 2025, and a Macomb County septic inspection passed in May 2026, providing peace of mind for the next owner. Completing the package is a side-entry 3-car garage and an ideal location within the award-winning Utica Community Schools district, just minutes from shopping, dining, and major commuter routes. This extraordinary residence offers the perfect blend of timeless elegance, modern efficiency, and luxury living.

Location

State MI

County Macomb

Area Area03071Shelbytwp

Rooms

Basement Finished, Full, Walk Out Access

Interior

Interior Features EntranceFoyer, HighSpeedInternet, WetBar

Heating E N E R G Y S T A R Qualified Furnace Equipment, Forced Air, Natural Gas

Cooling Ceiling Fans, Central Air, E N E R G Y S T A R Qualified A C Equipment

Fireplaces Type Basement, GreatRoom

Fireplace Yes

Laundry LaundryRoom

Exterior

Parking Features ThreeCarGarage, Attached, ElectricityinGarage, GarageDoorOpener, SideEntrance

Garage Spaces 3.0

Fence Fencing Requiredwith Pool

Pool None

Utilities Available CableAvailable, UndergroundUtilities

View Y/N No

Roof Type Asphalt

Garage true

Building

Lot Description CornerLot, Sprinklers

Foundation Basement, Poured

Sewer Septic Tank

Water Public

New Construction No

Schools

School District Utica

Others

Senior Community false

Acceptable Financing Cash, Conventional, VaLoan

Listing Terms Cash, Conventional, VaLoan

Special Listing Condition ShortSaleNo, Standard

Pets Allowed Yes

Listed by Danielle Christoff of EXP Realty Romeo

Brian Cook

General Manager | License ID: 6501348888

+1(810) 240-1383 | bcook@c21metrobrokers.com

54150 Queensborough DR Shelby Charter Township, MI 48315

Brian Cook

Key Details

Location

Rooms

Interior

Exterior

Building

Schools

Others

GET MORE INFORMATION

Go tour this home

54150 Queensborough DR