54564 Queensborough Dr Shelby Township, MI 48315
4
Beds
3
Baths
4,753
Sq Ft
0.44
Acres
Highlights
- Waterfront
- Deck
- Cathedral Ceiling
- Crissman Elementary School Rated A-
- Contemporary Architecture
- Wood Flooring
About This Home
As of February 2023LAKEFRONT! SPRAWLING 4 Bedroom SPLITLEVEL! 3 1/2 Baths, 3 Fireplaces. 4th Full Bath in FINISHED WALKOUT BASEMENT (prepped for 2nd Kitchen & Central Vacuum). Huge Kitchen (Maple Cabs, Oak Floor) Bridge overlooks 2 Story Great Rm & Foyer. Master Ste (Priv. Full Bath, 2 Walk-in Closets, Large Private Covered Balcony) 1st Flr Lndry & 2nd Flr Lndry! 2 Furn., 2 C/A units, 2 sump pumps. Wraparound Deck, Paver Patio. **3% EMD & Pre-Qualification letter REQUIRED w/ ALL offers. POF required with Cash offers.
Last Agent to Sell the Property
Robert Agnello
RE/MAX First License #MISPE-6502368662 Listed on: 02/21/2013
Last Buyer's Agent
. Non Mls Member
NON MLS Member License #MISPE
Home Details
Home Type
- Single Family
Est. Annual Taxes
Year Built
- Built in 1997
Lot Details
- 0.44 Acre Lot
- Lot Dimensions are 125x101x167x175
- Waterfront
- Sprinkler System
HOA Fees
- $79 Monthly HOA Fees
Parking
- 3.5 Car Attached Garage
Home Design
- Contemporary Architecture
- Split Level Home
- Brick Exterior Construction
Interior Spaces
- 4,753 Sq Ft Home
- 1.5-Story Property
- Wet Bar
- Cathedral Ceiling
- Gas Fireplace
- Bay Window
- Great Room with Fireplace
- Living Room with Fireplace
- Den
- Wood Flooring
- Oven or Range
- Laundry on upper level
Bedrooms and Bathrooms
- 4 Bedrooms
- Walk-In Closet
- 3 Full Bathrooms
Finished Basement
- Walk-Out Basement
- Sump Pump
- Fireplace in Basement
Outdoor Features
- Balcony
- Deck
- Patio
- Porch
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Gas Water Heater
Listing and Financial Details
- Assessor Parcel Number 0710227008
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Dec 20, 2022
Closed on
Feb 28, 2023
Sold by
James David A
Bought by
Aldieri Ammar and Hoxha Laura
Seller's Agent
Chandler Nash
Realteam Real Estate
Buyer's Agent
Megan Tooley
Coldwell Banker Professionals-Northville
List Price
$1,075,000
Sold Price
$960,000
Premium/Discount to List
-$115,000
-10.7%
Views
145
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
$137,275
Avg. Annual Appreciation
5.49%
Original Mortgage
$750,000
Outstanding Balance
$724,601
Interest Rate
5.5%
Mortgage Type
New Conventional
Estimated Equity
$372,674
Purchase Details
Listed on
Feb 21, 2013
Closed on
Apr 10, 2013
Sold by
The Bank Of America Na
Bought by
James David A
Seller's Agent
Robert Agnello
RE/MAX First
Buyer's Agent
. Non Mls Member
NON MLS Member
List Price
$539,900
Sold Price
$515,000
Premium/Discount to List
-$24,900
-4.61%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.56%
Original Mortgage
$407,000
Interest Rate
3.39%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jun 15, 2012
Sold by
Maceri Ann Marie and Maceri Anthony
Bought by
Bank Of America Na
Purchase Details
Closed on
May 22, 1995
Sold by
Heatherwood Homes Inc
Bought by
Maceri Ann M and Maceri Anthony
Similar Homes in the area
-
$549,999
- 4 Beds
- 2.5 Baths
- 3,158 Sq Ft
- 11924 Raintree Ct
- Shelby Township, MI
Welcome to our beautifully built 4-bedroom, 2.5-bath colonial featuring a spacious kitchen withwide-plank hardwood floors, maple cabinets, granite counters, large island, ceramic backsplash,and stainless steel appliances including a new refrigerator and dishwasher. The breakfast nookpatio opens to a 9 ft. in-ground heated pool with new pump and heater (2023). The family roomoffers
Aaron Taylor EXP Z Real Estate
-
$475,000
- 4 Beds
- 3.5 Baths
- 3,940 Sq Ft
- 11988 Whispering Oak Ln
- Shelby Township, MI
This 3,100 sq ft home sits on a corner lot with mature trees, giving it a sense of privacy and character. The subdivision features a few man-made lakes, adding to the peaceful setting. The curb appeal is already there, with established landscaping and a welcoming exterior. Inside, you’ll find a wonderful layout with a ton of space to work with. The main living room has vaulted ceilings that bring
Chad Hagar KW Domain
-
$624,900
- 3 Beds
- 4 Baths
- 4,476 Sq Ft
- 53781 Desano Dr
- Shelby Township, MI
Must see this absolutely immaculate all brick ranch located in the heart of Shelby Twp. UPDATED home has too many features to list!!! New White Oak Floors, Paint, Lighting, Roof and much much more!! This Professional Finished Basement is PERFECT for entertaining with HUGE BAR / Workout Room / 4th Bedroom / Full Bath / Gaming Area / & the list is endless!! This home is truly special!!! Must see!!!
Matthew Dababneh Keller Williams Realty Lakeside
-
$399,899
- 4 Beds
- 2.5 Baths
- 3,941 Sq Ft
- 54158 Blue Cloud Dr
- Shelby Township, MI
ALERT! Best priced waterfront home in Shelby!! Located on the Township's largest lake, 3 illuminated fountains; its a water view like no other (day and night). Updates & amenities: 2024 roof, 2022 high efficiency furnace, 2022 central air ... walkout finished basement onto 22' pie-shaped cement patio, ground level cement patio is tiered to lake level patio (solid cement stairway), lake fed
Al Block RE/MAX First
-
$425,000
- 3 Beds
- 3 Baths
- 1,897 Sq Ft
- 54810 Blue Cloud Dr
- Shelby Township, MI
Welcome to this charming 3-bedroom, 3-bathroom home in Shelby Twp, move-in ready and perfectly situated on the water. Step inside and you’ll find spacious living throughout, including a large kitchen with beautiful wood cabinets, abundant countertop space, and an inviting eat-in area. A formal dining room offers the perfect setting for hosting gatherings and special occasions. Each bedroom
Michael Perna EXP Realty Main
-
$524,900
- 4 Beds
- 4 Baths
- 2,947 Sq Ft
- 55138 Lordona Ln
- Shelby Township, MI
Tucked into a quiet, well-kept neighborhood in Shelby Township, this beautifully maintained contemporary home sits on just under a half-acre of mature, landscaped property. Brand-new concrete driveway (2024), 3.5-car garage with 220-volt electrical, insulated garage doors, and a direct entrance to the finished basement, which includes a bathroom, & workshop/storage area. A whole house generator
Brianna Hamilton Team Hamilton Real Estate
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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $960,000 | Allegiance Title | |
| Warranty Deed | $960,000 | Allegiance Title | |
| Deed | $515,000 | Capital Title Insurance Agen | |
| Sheriffs Deed | $548,604 | None Available | |
| Deed | $95,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $750,000 | New Conventional | |
| Closed | $750,000 | New Conventional | |
| Previous Owner | $510,400 | New Conventional | |
| Previous Owner | $174,000 | Credit Line Revolving | |
| Previous Owner | $407,000 | New Conventional | |
| Previous Owner | $249,500 | Credit Line Revolving | |
| Previous Owner | $500,000 | New Conventional | |
| Previous Owner | $499,999 | Unknown | |
| Previous Owner | $322,700 | Balloon | |
| Previous Owner | $249,500 | Credit Line Revolving |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 02/28/2023 02/28/23 | Sold | $960,000 | -10.7% | $101 / Sq Ft |
| 01/30/2023 01/30/23 | Pending | -- | -- | -- |
| 12/20/2022 12/20/22 | For Sale | $1,075,000 | +108.7% | $113 / Sq Ft |
| 05/15/2013 05/15/13 | Sold | $515,000 | -4.6% | $108 / Sq Ft |
| 03/26/2013 03/26/13 | Pending | -- | -- | -- |
| 02/21/2013 02/21/13 | For Sale | $539,900 | -- | $114 / Sq Ft |
Source: Michigan Multiple Listing Service
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 | $14,871 | $497,400 | $0 | $0 |
| 2024 | $8,693 | $477,400 | $0 | $0 |
| 2023 | $5,661 | $432,900 | $0 | $0 |
| 2022 | $9,181 | $420,900 | $0 | $0 |
| 2021 | $8,882 | $387,000 | $0 | $0 |
| 2020 | $5,211 | $366,300 | $0 | $0 |
| 2019 | $8,132 | $376,900 | $0 | $0 |
| 2018 | $7,973 | $339,600 | $0 | $0 |
| 2017 | $7,889 | $332,450 | $58,650 | $273,800 |
| 2016 | $12,512 | $332,450 | $0 | $0 |
| 2015 | $7,882 | $311,150 | $0 | $0 |
| 2012 | -- | $0 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Chandler Nash
Seller's Agent in 2023
Chandler Nash
Realteam Real Estate
(586) 747-4107
17 in this area
152 Total Sales
-
Megan Tooley
M
Buyer's Agent in 2023
Megan Tooley
Coldwell Banker Professionals-Northville
(248) 649-7200
2 in this area
149 Total Sales
-
R
Seller's Agent in 2013
Robert Agnello
RE/MAX
-
.
Buyer's Agent in 2013
. Non Mls Member
NON MLS Member
Map
Source: Michigan Multiple Listing Service
MLS Number: 31137074
APN: 23-07-10-227-008
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.
Source MLS: MiRealSource
Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource.
The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Copyright 2025 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc.
Nearby Homes
- 11924 Raintree Ct
- 11988 Whispering Oak Ln
- 53781 Desano Dr
- 11812 Encore Dr
- 54615 Deadwood Ln
- 54598 Deadwood Ln
- 11731 Encore Ct
- 11851 Ovation Ct
- 11961 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
- 55390 Jewell Rd
- 11357 Embassy Ct
- 54241 Sunderland Dr