NOT LISTED FOR SALE

54777 Queens Row Shelby Township, MI 48316

Estimated Value: $400,223 - $455,000

4 Beds
2.5 Baths
2,300 Sq Ft
$188/Sq Ft Est. Value

Last Sold March 06, 2020

Last sale price $300,000 $130 Per Sq Ft

Est. 44% increase in value since last sale

Current estimated payment $2,749/month

15 Days on Market

Highlights

  • Colonial Architecture
  • No HOA
  • Stainless Steel Appliances
  • Malow Junior High School Rated A-
  • Covered Patio or Porch
  • 2.5 Car Attached Garage

About This Home

As of March 2020

There is so much to say about this Fabulous home, Many updates! Very inviting home greeted with its 26x6 covered front porch, New beveled glass entry door and side panels, New (Mertkes) Driveway 2010, Very Generous sized 4 Bedrooms , 3 with Walk in closets, 2 1/2 Baths (updated) , Perfect Family room for entertaining, open to kitchen area, Fireplace with custom mantel and built in shelving, office/den , 12 x 12 Laundry room/Mud room with Ample cabinets and closet space, perfect to add lockers or built Coat/shoe bench ? , Plus 90 Bryant Furnace, Hot water tank 2014, Newer Anderson Windows (per previous owner) with Marble sills , Side-turned Oversized 2.5 Car Garage with extra 11x6 storage area, 132.41 across and 140 deep lot (irregular size) Fenced with Black coated fencing and large double gate off driveway, newer 3D Architectural Roof, Almost a stones throw away from Macomb Orchard Trails and Stony Creek park and so much more to offer.

Last Agent to Sell the Property

Carolyn Muha

Keller Williams Paint Creek License #6501283515 Listed on: 01/21/2020

Keller Williams Paint Creek

Last Buyer's Agent

Jeanne Schleede

Real Estate One Inc-Shelby License #6501393249

Real Estate One Inc-Shelby

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1972 | Remodeled in 2010

Lot Details

  • 0.34 Acre Lot
  • Lot Dimensions are 90x130x90x130
  • Fenced

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Block Foundation
  • Asphalt Roof
  • Chimney Cap

Interior Spaces

  • 2,300 Sq Ft Home
  • 2-Story Property
  • Ceiling Fan
  • Gas Fireplace
  • Awning
  • Family Room with Fireplace
  • Unfinished Basement
  • Sump Pump

Kitchen

  • Free-Standing Gas Oven
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Dryer
  • Washer

Parking

  • 2.5 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Covered Patio or Porch
  • Exterior Lighting

Location

  • Ground Level

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 0708127025

Community Details

Overview

  • No Home Owners Association
  • Lake Royale Subdivision

Amenities

  • Laundry Facilities

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,404

Year Built

Built in 1972 | Remodeled in 2010

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Colonial
  • Architecture Level: 2 Story
  • Warranty: Yes
  • Year Built: 1972
  • State Equalized Value: 124700.0000
  • Year Renovated: 2010
  • Foundation Features: Sump Pump
  • Entry Location: Ground Level w/Steps
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Humidifier
  • Fireplace: Yes
  • Fireplace Fuel: Natural
  • Fireplace Locations: Family Room
  • Room Count: 14
  • Total Bedrooms: 4
  • Total Bathrooms: 2.10
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Unfinished
  • Kitchen Appliances: Dishwasher, Disposal, Dryer, Microwave, Free-Standing Gas Oven, Free-Standing Refrigerator, Stainless Steel Appliance(s), Washer
  • Sq Ft Combined: 2300
  • Total Sq Ft: 2300
  • Sq Ft Total Bsmt: 1053

Exterior Features

  • Roof Material: Asphalt
  • Foundation Details: Basement
  • Construction Materials: Aluminum, Brick
  • Exterior Features: Awning/Overhang(s), Chimney Cap(s), Fenced, Lighting
  • Foundation Materials: Block
  • Frontage Feet: 130
  • Porch Type: Patio, Porch - Covered
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 2.5 Car
  • Garage Features: Attached, Door Opener, Electricity
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Forced Air
  • Sewer: Septic Tank (Existing)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: Yes

Condo/Co-op/Association

  • Association Fee: No

Schools

  • School District: Utica

Lot Info

  • Homestead: Yes
  • Lot Size Area: 0.34
  • Lot Dimensions: 90X130X90X130
  • Parcel Number: 0708127025

Tax Info

  • Tax Amount Summer: 2062.0000
  • Tax Amount Winter: 1342.0000
  • Total Tax: 3404.0000
  • Taxable Value: 124700.0000

MLS Schools

  • School District: Utica

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 21, 2020
Closed on
Mar 6, 2020
Sold by
Williamson Theresa L
Bought by
Siter Robert
Seller's Agent
Carolyn Muha
Keller Williams Paint Creek
Buyer's Agent
Jeanne Schleede
Real Estate One Inc-Shelby
List Price
$300,000
Sold Price
$300,000
Current Estimated Value
$432,556

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$132,556
Avg. Annual Appreciation
6.66%
Original Mortgage
$291,000
Outstanding Balance
$258,906
Interest Rate
3.4%
Mortgage Type
New Conventional
Estimated Equity
$169,334

Purchase Details

Listed on
Feb 28, 2018
Closed on
Apr 9, 2018
Sold by
Beacom Matthew W
Bought by
Williamson Theresa L
Seller's Agent
Taleya Kelly
Keller Williams Realty-Great Lakes
Buyer's Agent
Jim Lawson
RE/MAX First
List Price
$279,900
Sold Price
$287,000
Premium/Discount to List
$7,100
2.54%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
2.35%
Original Mortgage
$227,200
Interest Rate
4.46%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 8, 2015
Sold by
Anthony Christo and Anthony Pamela S
Bought by
Beacom Matthew W

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$237,500
Interest Rate
3.96%
Mortgage Type
New Conventional
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
Siter Robert $300,000 Liberty Title
Williamson Theresa L $287,000 Fidelity National Title
Beacom Matthew W $250,000 Seaver Title Agency
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Stier Robert $34,000
Open Stier Robert Joseph $291,000
Previous Owner Williamson Theresa L $227,200
Previous Owner Beacom Matthew W $237,500
Previous Owner Anthony Christo $150,000
Previous Owner Anthony Christo $150,000
Previous Owner Anthony Christo $100,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/06/2020 03/06/20 Sold $300,000 0.0% $130 / Sq Ft
02/05/2020 02/05/20 Pending -- -- --
01/21/2020 01/21/20 For Sale $300,000 +4.5% $130 / Sq Ft
04/10/2018 04/10/18 Sold $287,000 +2.5% $125 / Sq Ft
03/06/2018 03/06/18 Pending -- -- --
02/28/2018 02/28/18 For Sale $279,900 -- $122 / Sq Ft
Source: Realcomp

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 $4,926 $183,900 $0 $0
2024 $2,916 $174,600 $0 $0
2023 $2,761 $157,900 $0 $0
2022 $4,558 $146,300 $0 $0
2021 $4,333 $140,600 $0 $0
2020 $2,330 $133,600 $0 $0
2019 $3,635 $124,700 $0 $0
2018 $3,102 $117,100 $0 $0
2017 $3,046 $102,100 $30,000 $72,100
2016 $3,024 $102,100 $0 $0
2015 $2,457 $92,800 $0 $0
2013 $1,427 $84,100 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Realcomp

MLS Number: 2200001637

Realcomp

APN: 23-07-08-127-025