S
Seller's Agent in 2022
Sal Impastato
The Agency Hall & Hunter
(248) 763-2223
1 in this area
95 Total Sales
54516 Queensborough Dr Shelby Township, MI 48315
Estimated Value: $990,000 - $1,261,000
4
Beds
5.5
Baths
5,080
Sq Ft
$217/Sq Ft
Est. Value
Highlights
- 86 Feet of Waterfront
- Built-In Refrigerator
- Jetted Tub in Primary Bathroom
- Crissman Elementary School Rated A-
- Colonial Architecture
- Terrace
About This Home
As of December 2022Stunning lake views from this stately Lake In The Woods home w/walkout LL set on the best lot in the sub. Double story marble foyer boasts a sweeping staircase w/bridge overlooking a great room w/FP and triple arched windows capturing views of the lake and yard. Vaulted library w/bay window and hardwood floors off the foyer. Bayed dining rm has butler's pantry off island kitchen complete w/granite, hardwoods, walk-in pantry, snack bar, and BF rm w/sliders to the upper terrace. 1st-floor primary suite w/private bath and WIC has tray ceilings and displays lake views. The upper level offers 3 bedrooms all w/WICs and 2 full baths. Amazing walkout LL w/2nd full kitchen, SS prof appliances, granite tops and backsplash, huge walk-in pantry, plus 6-stool wet bar w/wine cooler and built-in shelving. Family room w/two-sided FP and living rm/theater rm. Two sliders take you to the lakeside patio w/built-in Viking grill. Other LL features include a full bath w/steam shower, exercise rm, billiard rm, craft room, workshop, and cedar closet.
Last Agent to Sell the Property
The Agency Hall & Hunter License #6501231455 Listed on: 07/22/2022
Home Details
Home Type
- Single Family
Est. Annual Taxes
Year Built
- Built in 1998
Lot Details
- 0.42 Acre Lot
- Lot Dimensions are 125x179x86x182
- 86 Feet of Waterfront
- Lake Front
- Sprinkler System
HOA Fees
- $92 Monthly HOA Fees
Home Design
- Colonial Architecture
- Brick Exterior Construction
- Poured Concrete
- Asphalt Roof
- Cedar
Interior Spaces
- 5,080 Sq Ft Home
- 2-Story Property
- Wet Bar
- Central Vacuum
- Bar Fridge
- Ceiling Fan
- Double Sided Fireplace
- Gas Fireplace
- Family Room with Fireplace
- Great Room with Fireplace
- Living Room with Fireplace
- Security System Owned
Kitchen
- Double Self-Cleaning Convection Oven
- Built-In Electric Oven
- Gas Cooktop
- Down Draft Cooktop
- Range Hood
- Microwave
- Built-In Refrigerator
- Dishwasher
- Wine Refrigerator
- Trash Compactor
- Disposal
Bedrooms and Bathrooms
- 4 Bedrooms
- Jetted Tub in Primary Bathroom
Laundry
- Dryer
- Washer
Finished Basement
- Sump Pump
- Fireplace in Basement
Parking
- 3.5 Car Attached Garage
- Garage Door Opener
Accessible Home Design
- Stair Lift
- Standby Generator
Outdoor Features
- Patio
- Terrace
- Exterior Lighting
Location
- Ground Level
Utilities
- Forced Air Zoned Heating and Cooling System
- Heating System Uses Natural Gas
- Programmable Thermostat
- Natural Gas Water Heater
Listing and Financial Details
- Assessor Parcel Number 0710227009
Community Details
Overview
- Association Phone (586) 718-2509
- Lake In The Woods Subdivision
Amenities
- Community Barbecue Grill
- Laundry Facilities
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jul 22, 2022
Closed on
Dec 20, 2022
Sold by
Charles E Pankratz Marital Trust
Bought by
Bamo Noel and Bamo Moufida
Seller's Agent
Sal Impastato
The Agency Hall & Hunter
Buyer's Agent
Saba Katto
Realty Solutions of Michigan Inc
List Price
$1,200,000
Sold Price
$930,000
Premium/Discount to List
-$270,000
-22.5%
Views
55
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$174,129
Avg. Annual Appreciation
5.54%
Purchase Details
Closed on
Sep 1, 2020
Sold by
Lorenz Cathleen S and Pankratz Charles E
Bought by
Lorenz Cathleen S and Pankratz Charles E
Purchase Details
Closed on
Sep 11, 2007
Sold by
Casasanta Lucy and Casasanta Enio
Bought by
Charles E Pankratz Revocable Trust
Purchase Details
Closed on
May 12, 1995
Sold by
Heatherwood Homes Inc
Bought by
Casasanta Enio and Casasanta Lucy
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Bamo Noel | $930,000 | Devon Title | |
| Lorenz Cathleen S | -- | None Available | |
| Charles E Pankratz Revocable Trust | $875,000 | Chirco Title Company | |
| Casasanta Enio | $95,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | Casasanta Enio | $600,000 | |
| Closed | Casasanta Enio | $0 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 12/20/2022 12/20/22 | Sold | $930,000 | -11.4% | $183 / Sq Ft |
| 12/08/2022 12/08/22 | Pending | -- | -- | -- |
| 10/25/2022 10/25/22 | Price Changed | $1,050,000 | -4.5% | $207 / Sq Ft |
| 09/09/2022 09/09/22 | Price Changed | $1,100,000 | -8.3% | $217 / Sq Ft |
| 07/22/2022 07/22/22 | For Sale | $1,200,000 | -- | $236 / Sq Ft |
Source: Realcomp
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $15,299 | $518,300 | $0 | $0 |
| 2024 | $9,055 | $497,300 | $0 | $0 |
| 2023 | $8,590 | $474,400 | $0 | $0 |
| 2022 | $9,752 | $459,700 | $0 | $0 |
| 2021 | $9,741 | $422,700 | $0 | $0 |
| 2020 | $5,565 | $406,100 | $0 | $0 |
| 2019 | $8,684 | $419,300 | $0 | $0 |
| 2018 | $8,756 | $371,200 | $0 | $0 |
| 2017 | $8,426 | $363,800 | $57,800 | $306,000 |
| 2016 | $8,364 | $363,800 | $0 | $0 |
| 2015 | $8,243 | $340,950 | $0 | $0 |
| 2012 | -- | $0 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Sal Impastato
-
Mark Bess
Seller Co-Listing Agent in 2022
Mark Bess
The Agency Hall & Hunter
(248) 425-3778
1 in this area
81 Total Sales
-
Saba Katto
Buyer's Agent in 2022
Saba Katto
Realty Solutions of Michigan Inc
(248) 835-5008
6 in this area
81 Total Sales
Map
Source: Realcomp
MLS Number: 20221020980
APN: 23-07-10-227-009
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
Copyright 2025 Realcomp II Ltd. Shareholders
IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393
Nearby Homes
- 53781 Desano Dr
- 11924 Raintree Ct
- 11988 Whispering Oak Ln
- 54615 Deadwood Ln
- 54598 Deadwood Ln
- 11812 Encore Dr
- 11731 Encore Ct
- Pinehurst II Plan at Encore of Shelby - Encore at Shelby
- Pinehurst Plan at Encore of Shelby - Encore at Shelby
- Devonshire Plan at Encore of Shelby - Encore at Shelby
- Barclay II Plan at Encore of Shelby - Encore at Shelby
- 11948 Encore Ct
- 11982 Encore Ct
- 11762 Encore Dr
- 11695 Encore Dr
- 54241 Sunderland Dr
- 55390 Jewell Rd
- 11357 Embassy Ct
- 55420 Jewell Rd
- 54158 Blue Cloud Dr
- 54564 Queensborough Dr
- 54462 Queensborough Dr
- 54622 Queensborough Dr
- 54521 Queensborough Dr
- 54563 Queensborough Dr
- 54400 Queensborough Dr
- 54605 Queensborough Dr
- 11427 Scarborough Dr
- 54459 Queensborough Dr
- 11454 Heatherwood Ct
- 11315 Westbury Dr
- 11470 Heatherwood Ct
- 11455 Scarborough Dr
- 54647 Queensborough Dr
- 54405 Queensborough Dr
- 11498 Heatherwood Ct
- 11481 Scarborough Dr
- 54363 Queensborough Dr
- 54679 Queensborough Dr
- 11522 Heatherwood Ct