Open: Mon 4:45pm-6:15pm
For salePrice cut: $65K (8/14)
$1,100,000
4beds
6,410sqft
54150 Queensborough Dr, Shelby Township, MI 48315
4beds
6,410sqft
Single family residence
Built in 2000
0.56 Acres
3 Garage spaces
$172 price/sqft
$54/mo HOA
What's special
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. ...
- 74 days |
- 1,766 |
- 43 |
Source: Realcomp II,MLS#: 20261030783
Travel times
Living Room
Kitchen
Primary Bedroom
Zillow last checked:
Listing updated:
Listed by:
Danielle Christoff 586-372-6057,
EXP Realty Romeo 586-372-6057,
Kenneth J Hirschmann 586-531-2751,
EXP Realty
Source: Realcomp II,MLS#: 20261030783
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Primary bedroom
- Level: Second
- Area: 378
- Dimensions: 21 X 18
Bedroom
- Level: Second
- Area: 154
- Dimensions: 14 X 11
Bedroom
- Level: Second
- Area: 156
- Dimensions: 13 X 12
Bedroom
- Level: Second
- Area: 168
- Dimensions: 14 X 12
Primary bathroom
- Level: Second
- Area: 304
- Dimensions: 19 X 16
Other
- Level: Second
- Area: 168
- Dimensions: 14 X 12
Other
- Level: Second
- Area: 140
- Dimensions: 14 X 10
Other
- Level: Entry
Other
- Level: Entry
- Area: 49
- Dimensions: 7 X 7
Other
- Level: Entry
- Area: 36
- Dimensions: 6 X 6
Dining room
- Level: Entry
- Area: 168
- Dimensions: 12 X 14
Dining room
- Level: Entry
- Area: 224
- Dimensions: 16 X 14
Family room
- Level: Entry
- Area: 600
- Dimensions: 20 X 30
Flex room
- Level: Basement
- Area: 2112
- Dimensions: 44 X 48
Great room
- Level: Entry
- Area: 352
- Dimensions: 22 X 16
Kitchen
- Level: Entry
- Area: 280
- Dimensions: 20 X 14
Laundry
- Level: Entry
- Area: 64
- Dimensions: 8 X 8
Library
- Level: Entry
- Area: 182
- Dimensions: 13 X 14
Heating
- ENERGYSTAR Qualified Furnace Equipment, Forced Air, Natural Gas
Cooling
- Ceiling Fans, Central Air, ENERGYSTAR Qualified AC Equipment
Appliances
- Included: Built In Refrigerator, Bar Fridge, Dishwasher, Double Oven, Dryer, Energy Star Qualified Dishwasher, Gas Cooktop, Range Hood, Washer
- Laundry: Laundry Room
Features
- Entrance Foyer, High Speed Internet, Wet Bar
- Basement: Finished,Full,Walk Out Access
- Has fireplace: Yes
- Fireplace features: Basement, Great Room
Interior area
- Total interior livable area: 6,410 sqft
- Finished area above ground: 4,289
- Finished area below ground: 2,121
Property
Parking
- Total spaces: 3
- Parking features: Three Car Garage, Attached, Electricityin Garage, Garage Door Opener, Side Entrance
- Garage spaces: 3
Accessibility
- Accessibility features: Accessible Hallways, Common Area
Features
- Levels: Two
- Stories: 2
- Entry location: GroundLevelwSteps
- Patio & porch: Covered, Patio, Terrace
- Pool features: None
- Fencing: Fencing Requiredwith Pool
- Body of water: Jewell Lake
Lot
- Size: 0.56 Acres
- Dimensions: 142 x 170 x 145 x 170
- Features: Corner Lot, Sprinklers
Details
- Parcel number: 0710277009
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Basement, Poured
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2000
Utilities & green energy
- Sewer: Septic Tank
- Water: Public
- Utilities for property: Cable Available, Underground Utilities
Community & HOA
Community
- Security: Security System Owned
- Subdivision: LAKE IN THE WOODS SUB
HOA
- Has HOA: Yes
- Services included: Snow Removal
- HOA fee: $650 annually
Location
- Region: Shelby Township
Financial & listing details
- Price per square foot: $172/sqft
- Tax assessed value: $310,272
- Annual tax amount: $9,164
- Date on market: 6/8/2026
- Cumulative days on market: 74 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional,Va Loan
Price history
| Date | Event | Price |
|---|---|---|
| 8/14/2026 | Price change | $1,100,000-5.6%$172/sqft |
Source:  Realcomp II #20261030783 Report a problem | ||
| 8/6/2026 | Price change | $1,164,9990%$182/sqft |
Source: eXp Realty #20261030783 Report a problem | ||
| 6/8/2026 | Listed for sale | $1,165,000+1270.6%$182/sqft |
Source: Realcomp II #20261030783 Report a problem | ||
| 3/24/1999 | Sold | $85,000+18.1%$13/sqft |
Source: Public Record Report a problem | ||
| 8/7/1998 | Sold | $72,000+105.7%$11/sqft |
Source: Public Record Report a problem | ||
| 9/23/1997 | Sold | $35,000$5/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $9,017 +5.1% | $440,800 +3.1% |
| 2024 | $8,583 +5.3% | $427,400 +6.9% |
| 2023 | $8,152 +2.8% | $399,700 +8.9% |
| 2022 | $7,929 +0.7% | $367,100 +5.9% |
| 2021 | $7,874 | $346,800 -0.6% |
| 2020 | $7,874 +8.5% | $349,000 -0.4% |
| 2019 | $7,259 +3.1% | $350,500 +12.9% |
| 2018 | $7,042 +2.2% | $310,500 +6.9% |
| 2017 | $6,891 | $290,450 |
| 2016 | $6,891 | $290,450 +12.9% |
| 2015 | $6,891 | $257,250 |
| 2012 | -- | -- |
| 2009 | -- | -- |
| 2001 | $7,419 +125.4% | $267,710 +271.2% |
| 2000 | $3,291 | $72,120 |
Find assessor info on the county website
Monthly payment
Est. payment
$6,937/mo
Principal & interest
$5673
Property taxes
$1210
HOA Fees
$54
Estimated market value
$1,067,300
$1.01M - $1.12M
$5,770/mo
Climate risks
Explore flood, wildfire, and other predictive climate risk information for this property on First Street®️.
Neighborhood: 48315
Nearby schools
Crissman Elementary School
Grades PK-6 • 0.6 miles8/10
GreatSchools® Rating
Test Score Rating
9/10Student Progress Rating
7/10Malow Junior High School
Grades 7-9 • 1.7 miles7/10
GreatSchools® Rating
Test Score Rating
8/10Student Progress Rating
5/10Eisenhower High School
Grades 10-12 • 1.6 miles9/10
GreatSchools® Rating
College Readiness Rating
10/10Student Progress Rating
8/10