Save
Ask
Tour
Hide
$1,035,000
70 Days On Site
54182 Queensborough DriveShelby Charter Township, MI 48315
For Sale|Single Family Residence|Active
5
Beds
5
Total Baths
3
Full Baths
2
Partial Baths
6,400
SqFt
$162
/SqFt
1997
Built
Subdivision:
LAKE IN THE WOODS SUB
County:
Macomb
Call Now: 810-360-3488
Is this the listing for you? We can help make it yours.
810-360-3488
Save
Ask
Tour
Hide
Mortgage Calculator
Monthly Payment (Est.)
Enter an interest rate to see your estimated monthly payment.Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.
Highly Desired Lake In The Woods Sub with lake access 6340 square foot brick colonial with 5 bedrooms, 4.5 bathrooms, fully finished walk out lower level or possible in-law or au pair suite with full kitchen, bathroom, bedroom and living area. Two gas fireplaces, one in entry level great room and one in finished walk out lower level. Large upper deck and large lower brick paver patio that leads out to a beautifully landscaped yard with inground pool, stamped concrete pool deck, gas fire pit, exterior timer lighting and sprinkling system.
Save
Ask
Tour
Hide
Listing Snapshot
Price
$1,035,000
Days On Site
70 Days
Bedrooms
5
Inside Area (SqFt)
6,400 sqft
Total Baths
5
Full Baths
3
Partial Baths
2
Lot Size
0.51 Acres
Year Built
1997
MLS Number
20261068602
Status
Active
Property Tax
$14,168
HOA/Condo/Coop Fees
$50 monthly
Sq Ft Source
Estimated
Friends & Family
Recent Activity
| 2 weeks ago | Price changed to $1,035,000 | |
| 2 weeks ago | Listing updated with changes from the MLS | |
| 2 months ago | Listing first seen on site |
General Features
Acres
0.51
Attached Garage
Yes
Cross Street
Jewell Road and 24 Mile Road
Disclosures
No Restrictions, Taxes Not Homestead Exempt
Garage
Yes
Garage Spaces
3.5
Levels
Two
Parking
AttachedDirect AccessGarage Door Opener
Property Sub Type
Single Family Residence
Security
Carbon Monoxide Detector(s)Smoke Detector(s)
Sewer
Public Sewer
Special Circumstances
Standard
SqFt Above
4100
SqFt Below
2300
Style
Colonial
Water Source
Public
Interior Features
Appliances
RefrigeratorOvenGas Water HeaterBuilt-In RefrigeratorDishwasherDisposalDouble OvenDryerFree-Standing Gas OvenFree-Standing Gas RangeMicrowaveRange HoodSelf Cleaning OvenStainless Steel Appliance(s)WasherWine Cooler
Basement
FinishedFullWalk-Out Access
Cooling
Ceiling Fan(s)Central Air
Electric
Circuit Breakers
Fireplace
Yes
Fireplace Features
GasGreat Room
Furnished
Negotiable
Heating
Forced AirNatural Gas
Interior
Central VacuumEntrance FoyerSound SystemSmart Thermostat
Window Features
ENERGY STAR Qualified Windows
BathFull
Dimensions - 7 X 8Level - Second
BathLav
Bedroom
Dimensions - 13 X 12Level - Second
Save
Ask
Tour
Hide
Exterior Features
Construction Details
BrickWood Siding
Fencing
Back Yard
Patio And Porch
CoveredDeckPatio
Pool Features
In Ground
Roof
Asphalt
Waterfront Features
Lake Privileges
Windows/Doors
ENERGY STAR Qualified Windows
Community Features
Association Fee
$600.0
Association Fee Frequency
Annually
MLS Area
Area03071ShelbyTwp
School District
Utica
Financing Terms Available
CashConventional
Building Access
GroundLevel
Roads
Paved
Schools
School District
Utica
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of 21 United Realty: [email protected]
IDX provided courtesy of Realcomp II Ltd. via RealcompIILtd. Copyright © 2026 Realcomp II Ltd. Shareholders.
IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing and that the data is deemed reliable but not guaranteed accurate by the MLS.
IDX provided courtesy of Realcomp II Ltd. via RealcompIILtd. Copyright © 2026 Realcomp II Ltd. Shareholders.
IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing and that the data is deemed reliable but not guaranteed accurate by the MLS.
Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.