NOT LISTED FOR SALE

54564 Queensborough Dr Shelby Township, MI 48315

Estimated Value: $974,000 - $1,219,000

4 Beds
4 Baths
9,506 Sq Ft
$115/Sq Ft Est. Value

Last Sold February 28, 2023

Last sale price $960,000 $101 Per Sq Ft

Est. 14% increase in value since last sale

Current estimated payment $7,403/month

41 Days on Market

Highlights

  • Waterfront
  • Colonial Architecture
  • Porch
  • Crissman Elementary School Rated A-
  • Deck
  • 3.5 Car Attached Garage

About This Home

As of February 2023

*Accepting back up offers*Welcome to Lake in the Woods! With 103' of lake frontage, make your dream home a reality with this beautiful 4 bedroom/4.5 bathroom colonial in Shelby Twp. The living room has sky high ceilings and is filled with natural light. Enjoy pouring a drink at the wet bar and cozying up by the fire place. The kitchen has custom Kraftmaid cabinetry and a marble island, stainless steel appliances, and granite counters. All spare bathrooms were renovated in 2020. The first floor primary bedroom has a massive custom closet with built-ins, an additional washer/dryer, and a center island. The luxury of the primary bedroom extends into the fully loaded bathroom filled with Italian Carrera Marble, a double vanity sink, spa-like tub, and double headed stand up shower. Open the double doors to a private balcony overlooking the lake. The basement is finished with a full kitchen, full bathroom, a fireplace, tons of space for entertaining, and walks out to the newly rocked edged beach along Jewell Lake. The 3.5 car garage is fully tiled with crown moulding. The deck off the exterior of the home provides great views and stairs leading down to the brick paver patio.

Last Agent to Sell the Property

Chandler Nash

Realteam Real Estate License #MISPE-6501389129 Listed on: 12/20/2022

Realteam Real Estate

Last Buyer's Agent

Megan Tooley

Coldwell Banker Professionals-Northville License #6501415077

Coldwell Banker Professionals-Northville

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1997

Lot Details

  • 0.44 Acre Lot
  • Lot Dimensions are 126x169x103x179
  • Waterfront

HOA Fees

  • $104 Monthly HOA Fees

Parking

  • 3.5 Car Attached Garage

Home Design

  • Colonial Architecture
  • Brick Exterior Construction

Interior Spaces

  • 1.5-Story Property
  • Living Room with Fireplace
  • Finished Basement
  • Fireplace in Basement

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 4 Full Bathrooms

Outdoor Features

  • Deck
  • Patio
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Community Details

  • Giovan Aggazzi HOA
  • Lake In The Woods Sub Subdivision

Listing and Financial Details

  • Assessor Parcel Number 23-07-10-227-008

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,182

Year Built

Built in 1997

Lot Details

0

HOA Fees

$104 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL
  • Type Of Property: Single Family
  • Architecture Style: Colonial
  • Structure Style: 1 1/2 Story
  • Total Tax Amount: 9181.85
  • Total Tax Year: 2022
  • Year Built: 1997
  • Mail City: Shelby Twp
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Fireplace: Yes
  • Fireplaces: Basement Fireplace, LivRoom Fireplace
  • Basement: Yes
  • Basement: Finished
  • Bedrooms: 4
  • Bedroom 1: On Entry Level, Dimensions: 19 x 17
  • Bedroom 2: On Upper Floor, Dimensions: 18 x 12
  • Bedroom 3: On Upper Floor, Dimensions: 16 x 14
  • Bedroom 4: On Upper Floor, Dimensions: 16 x 12
  • Full Bathrooms: 4
  • Total Bathrooms: 5
  • Bathroom 1: On Level: Entry
  • Bathroom 2: On Level: Upper
  • Bathroom 3: On Level: Upper
  • Bathroom 4: On Level: Basement
  • Below Grade Sq Ft: 4753
  • Finished Below Grade Sq Ft: 4753
  • Half Bathrooms: 1
  • Above Grade Finished Sq Ft: 4753
  • Total Finished Sq Ft: 9506

Exterior Features

  • Exterior: Brick
  • Exterior Features: Deck, Patio, Porch
  • Foundation: Basement
  • Frontage: 126
  • Road: Paved Street
  • Water Features: Lake Frontage, Waterfront
  • Waterfront: Yes

Garage/Parking

  • Garage: Attached Garage
  • Garage Spaces: 3.5
  • Parking: Garage
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water
  • Cooling: Central A/C

Condo/Co-op/Association

  • HOA Fees: 1250
  • HOA Fee Frequency: Yearly
  • Association Contact: Giovan Aggazzi
  • Association Phone: 5867182509
  • Association Fee: Yes

Lot Info

  • Assessor Parcel Number: 23-07-10-227-008
  • Lot Dimensions: 126x169x103x179
  • Acreage: 0.44
  • Geo Subdivision: MI

Rental Info

  • Pets Allowed: Yes

Tax Info

  • Summer Tax: Year: 2022, Amount: $5,392.00
  • Winter Tax: Year: 2022, Amount: $3,789.85
  • Total Tax: Year: 2022, Amount: $9,181.85

MLS Schools

  • School District: Utica Community Schools

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
$1,097,275

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
4.59%
Original Mortgage
$750,000
Outstanding Balance
$726,463
Interest Rate
5.5%
Mortgage Type
New Conventional
Estimated Equity
$344,712

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
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Aldieri Ammar $960,000 Allegiance Title
Aldieri Ammar $960,000 Allegiance Title
James David A $515,000 Capital Title Insurance Agen
Bank Of America Na $548,604 None Available
Maceri Ann M $95,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Aldieri Ammar $750,000
Closed Aldieri Ammar $750,000
Previous Owner James David A $510,400
Previous Owner James David A $174,000
Previous Owner James David $407,000
Previous Owner Maceri Anthony $249,500
Previous Owner Maceri Anthony $500,000
Previous Owner Maceri Anthony $499,999
Previous Owner Maceri Anthony $322,700
Previous Owner Maceri Anthony $249,500
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

Source: Public Records

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

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 50098026

Michigan Multiple Listing Service

APN: 23-07-10-227-008