Address
54182 Queensborough Drive, Shelby Twp, MI
Price
$ 1,075,000
Property Attributes
  • MLS#61024872
  • TypeSingle Family
  • Listing Status Active
  • CountyMACOMB
  • CityShelby Twp
  • AreaShelby Twp
  • NeighborhoodLake In The Woods Sub
  • Zip48315
  • StyleColonial
  • Year Built1997
  • Taxes$ 14168
  • Price$ 1,075,000
  • Bedrooms5
  • Full Bathrooms3
  • Half Bathrooms2
  • Sqr Footage4100
  • Lot Size0.51 Acres
Data Source:
MiRealSource (MIRS)
Property Description

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.

Price History
8/26/2026 Listed $1,075,000

General Features

Heating Forced Air
Cooling Ceiling Fan(s),Central A/C
Possession At Close
Fireplaces Gas Fireplace,Grt Rm Fireplace
Garage Attached Garage,Electric in Garage,Gar Door Opener,Direct Access
Water Public Water
Appliances Dishwasher,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Washer
Status Active
Full Baths 3
Half Baths 2
Bathrooms 5
Year Built 1997
Subdivision Lake In The Woods Sub
Water Heater Gas
Style Colonial
County Macomb
Class RESIDENTIAL
Type Single Family
Ownership Private
Associated Document Count 1
Status Active
Subdivision MI
Sale/Rent For Sale
Manufactured Y/N No
Fee Amount 600
Fee Schedule Yearly
Structure Style 2 Story
Subj to Short Sale Apprvl No
Home Warranty Y/N No
Area Shelby Twp (50007)
Primary City Shelby Twp
Virtual Tour https://www.propertypanorama.com/instaview/nocbor/20261068602
Directions Off Jewell Road between 24 and 25 Mile Road
City Shelby Twp
School District Utica Community Schools
Lease Y/N No
Originating MLS RealComp
Source MLS MI Real Source
Financial Terms Cash,Conventional
Legal Description L 58 V LAKE IN THE WOODS SUB LOT 58 LIBER 6616 PAGES 737-767
DOM 22
Postal Code 48315
Price Per Sq Ft Total AG 262.2
Public Remarks Highly Desired Lake In The Woods Sub with lake access 6340 square foot brick colonial with 5 bedrooms,4.5 bathrooms

Interior Features

Interior Amenities Sound System
Basement Finished,Walk Out
Bedroom 3 Level Second
Bedroom 1 Level Second
Bedroom 2 Level Second
Bedroom 4 Width 12
Bedroom 2 Width 12
Bedroom 3 Width 12
Bedroom 4 Length 14
Bedroom 2 Length 13
Bedroom 3 Length 12
Bedroom 5 Length 18
Beds 5
Fireplace? Yes
Total Rooms 10
Bedroom 5 Width 16
Bedroom 1 Length 18
Bedroom 1 Width 17
Below Grade SqFt 2300
Above Grade SqFt 4100
Basement Y/N Yes
Total SqFt Finished 6400
Bathroom 1 Length 7
Bathroom 1 Width 8
Bathroom 2 Length 18
Bathroom 2 Width 7

Exterior Features

Exterior Brick,Wood
Exterior Amenities Deck,Fenced Yard,Inground Pool,Patio
Frontage 130
Body of Water Jewell Lake
Lot Size Area 0.51
Pool (Y/N) Yes
Lot Dimensions 130X170
Garage # of Car 3.5
Water Features Lake/River Access
Roads Paved Street
FOUNDATION TYPE Basement
Waterfront Y/N No
Garage Y/N Yes

Amenities

  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Primary On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Property vs Single Family Average in 48315

Price
AVG $730K
$1.08M
Taxes
AVG $6,332
$14,168
Year Built
AVG 2004
1997
Visits
AVG 56
9
Data Provided by Inside Real Estate®

Areas We Cover