For sale

$1,075,000

54182 Queensborough Dr, Shelby Township, MI 48315

5beds

6,340sqft

$6,955/mo

Get pre-qualified

Single Family Residence

Built in 1997

0.51 Acres Lot

$1,034,600 Zestimate^®

$170/sqft

$50/mo HOA

What's special

Inground poolBeautifully landscaped yardGas fire pitSprinkling systemLarge upper deckExterior timer lightingTwo gas fireplaces

Seller is Listing Agent and Licensed Real Estate Broker in the state of Michigan. 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.

8 days

819

44

Facts & features

Interior

Bedrooms & bathrooms

Bedrooms: 5
Bathrooms: 5
Full bathrooms: 4
1/2 bathrooms: 1

Rooms

Room types: Den/Study/Lib, Laundry, Great Room, In-Law/auPair/Ste, Living Room, Loft, Master Bedroom, Master Bathroom, Basement Full Bath, First Flr Lavatory, Second Flr Full Bathroom, Breakfast Nook/Room, Dining Room

Bedroom 1

Features: Carpet
Level: Second
Area: 306
Dimensions: 18 x 17

Bedroom 2

Features: Carpet
Level: Second
Area: 156
Dimensions: 13 x 12

Bedroom 3

Features: Carpet
Level: Second
Area: 144
Dimensions: 12 x 12

Bedroom 4

Features: Carpet
Level: Second
Area: 168
Dimensions: 14 x 12

Bedroom 5

Features: Carpet
Level: Lower
Area: 288
Dimensions: 18 x 16

Bathroom 1

Features: Ceramic
Level: Second

Bathroom 2

Features: Ceramic
Level: Second

Bathroom 3

Features: Ceramic
Level: Second

Bathroom 4

Features: Ceramic
Level: Lower

Dining room

Features: Wood
Level: Entry
Area: 182
Dimensions: 14 x 13

Great room

Level: Entry
Area: 396
Dimensions: 22 x 18

Kitchen

Features: Wood
Level: Entry
Area: 420
Dimensions: 28 x 15

Living room

Features: Wood
Level: Entry
Area: 224
Dimensions: 16 x 14

Heating

Forced Air, Natural Gas

Cooling

Central Air

Appliances

Included: Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator, Washer, Gas Water Heater
Laundry: First Floor Laundry, Entry

Features

Pantry, Eat-in Kitchen
Flooring: Ceramic Tile, Wood, Carpet
Basement: Finished,Full,Walk-Out Access,Concrete,Sump Pump
Number of fireplaces: 2
Fireplace features: Basement, Gas, Great Room

Interior area

Total structure area: 6,340
Total interior livable area: 6,340 sqft
Finished area above ground: 4,060
Finished area below ground: 2,280

Property

Parking

Total spaces: 3.5
Parking features: 3 or More Spaces, Garage, Driveway, Attached
Attached garage spaces: 3.5

Accessibility

Accessibility features: Main Floor Laundry

Features

Levels: Two
Stories: 2
Patio & porch: Patio, Porch
Has private pool: Yes
Pool features: In Ground
Waterfront features: Lake/River Access
Body of water: Jewell Lake
Frontage type: Road
Frontage length: 130

Lot

Size: 0.51 Acres
Dimensions: 130 x 170

Details

Parcel number: 230710277008
Zoning description: Residential
Special conditions: Private

Construction

Type & style

Home type: SingleFamily
Architectural style: Colonial
Property subtype: Single Family Residence

Materials

Brick, Wood Siding
Foundation: Basement, Concrete Perimeter

Condition

New construction: No
Year built: 1997

Utilities & green energy

Electric: 200+ Amp Service
Sewer: Septic Tank
Water: Public Water at Street
Utilities for property: Cable Available, Cable Connected, Electricity Available, Electricity Connected, Natural Gas Available, Natural Gas Connected, Underground Utilities, Water Available, Water Connected, Internet DSL Available, Internet Fiber Available

Community & HOA

Community

Subdivision: Lake In The Woods

HOA

Has HOA: Yes
HOA fee: $600 annually
HOA name: Lake In The Woods
HOA phone: 586-718-2509

Location

Region: Shelby Township

Financial & listing details

Price per square foot: $170/sqft
Tax assessed value: $847,600
Annual tax amount: $14,168
Date on market: 8/8/2026
Cumulative days on market: 9 days
Listing agreement: Exclusive Right To Sell
Listing terms: Cash,Conventional
Road surface type: Paved

Estimated market value

$1,034,600

$983,000 - $1.09M

$5,773/mo

Price history

Date	Event	Price
8/8/2026	Listed for sale	$1,075,000-2.3%$170/sqft
Source: MiRealSource #50217851 Report a problem
8/7/2026	Listing removed	$1,100,000$174/sqft
Source: Realcomp II #20261055417 Report a problem
7/20/2026	Price change	$1,100,000-4.3%$174/sqft
Source: Realcomp II #20261055417 Report a problem
7/17/2026	Listed for sale	$1,150,000$181/sqft
Source: Realcomp II #20261055417 Report a problem
7/17/2026	Listing removed	$1,150,000$181/sqft
Source: Realcomp II #20261024326 Report a problem
6/15/2026	Price change	$1,150,000-4.2%$181/sqft
Source: Realcomp II #20261024326 Report a problem
4/27/2026	Listed for sale	$1,200,000+139.5%$189/sqft
Source: Realcomp II #20261024326 Report a problem
10/28/2010	Sold	$501,000-11.3%$79/sqft
Source: MiRealSource #924208 Report a problem
6/19/2010	Listed for sale	$565,000+3.7%$89/sqft
Source: Coldwell Banker Weir Manuel #29156889 Report a problem
6/5/1998	Sold	$545,000+1457.1%$86/sqft
Source: Public Record Report a problem
2/3/1997	Sold	$35,000$6/sqft
Source: Public Record Report a problem

Public tax history

Year	Property taxes	Tax assessment
2025	$12,710 +59%	$423,800 +2.9%
2024	$7,992 +5.3%	$411,700 +6.8%
2023	$7,591 +2.8%	$385,600 +8.8%
2022	$7,383 +0.7%	$354,400 +5.8%
2021	$7,332	$334,900 -0.6%
2020	$7,332 +8.5%	$337,000 +4.2%
2019	$6,759 +3.1%	$323,500 +12.7%
2018	$6,557 +2.2%	$287,100 +6.7%
2017	$6,416	$269,150
2016	$6,416	$269,150 +12.5%
2015	$6,416 -15.6%	$239,150 +6.8%
2013	$7,600	$223,950
2012	--	--
2009	--	--
2001	$5,727 +6.8%	$206,660 +6.5%
2000	$5,362	$194,090