Skip main navigation
Off market
  • $452,300

    54754 Queens Row, Shelby Township, MI 48316

    4beds
    2,311sqft
    SingleFamily
    Built in 1971
    0.27 Acres Lot
    $452,300 Zestimate®
    $196/sqft
    $2,923 Estimated rent

    Home value

    $452,300

    $430,000 - $475,000

    $2,923/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $2,923/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $2,923/mo

    Rent Zestimate®

    Refinance and save

    $2,952/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $2,952/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Charming 4 Bedroom, 2 1/2 Baths, Brick Colonial. Gorgeous Covered Deck and Patio with Gazebo off the back.. Newly Renovated Formal Dining Room, Family room, Large Kitchen with Granite, all appliances included.. Great Mud Room off garage with First Floor Laundry. Award Winning School and near Stony Creek and new Amazon distribution center. Extra Features: Pool table, New Windows, New Siding with Insulation Wrap, New HE Furnace and AC, New HE HWH, Composite Deck with Roof , Gazebo on Patio, Extra Shed, Insulated Garage Door, New Front Door, New Gas Fireplace, Updated Kitchen featuring: New Cabinets, New Flooring, Granite Countertops. All Furniture Negotiable.

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    Heating
    • Forced air, Gas
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Dryer, Garbage disposal, Microwave, Range / Oven, Refrigerator, Washer
    Features
    • Pets Allowed, High Spd Internet Avail
    • Flooring: Tile, Carpet, Hardwood, Laminate
    • Basement: Partially finished
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 2,311 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage - Attached
    Features
    • Exterior features: Vinyl, Brick
    • Has view: Yes
    • View description: None
    Lot
    • Size: 0.27 Acres
    Details
    • Parcel number: 230708129005

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • Roof: Shake / Shingle
    Condition
    • Year built: 1971

    Utilities & green energy

    • Sewer: Sewer-Sanitary
    • Water: Municipal Water

    Community & neighborhood

    Location
    • Region: Shelby Township

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $13 monthly

    Other

    Other facts
    • Architecture Level: 2 Story
    • Construction Materials: Brick, Vinyl
    • Cooling: Ceiling Fans 2+
    • Exterior Features: Sprinkler(s), Fenced
    • Garage Size: 2 Car
    • Interior Features: Pets Allowed, High Spd Internet Avail
    • Last Change Type: Price Decrease
    • Road Frontage Type: Paved
    • Sewer: Sewer-Sanitary
    • Title: Private - Owned
    • Water Source: Municipal Water
    • Buildings List: Shed
    • MLS Area Major: Shelby Twp
    • School District: Utica
    • Foundation Materials: Poured
    • Warranty: Yes
    • Transaction Type: Sale
    • Parcel Number: 0708129005
    • Tax Legal Description: L 79 LAKE ROYALE SUBDIVISION LOT 79. LIBER 59 PAGE

    Price history

    DateEventPrice
    10/17/2018Sold$318,000-3.3%$138/sqft
    Source: Public Record Report a problem
    8/12/2018Price change$329,000-2.9%$142/sqft
    Source: Anderson Realty Group LLC #218072148 Report a problem
    8/5/2018Price change$339,000-2.9%$147/sqft
    Source: Anderson Realty Group LLC #218072148 Report a problem
    7/22/2018Listed for sale$349,000+95%$151/sqft
    Source: Owner Report a problem
    4/24/2012Listing removed$179,000$77/sqft
    Source: Remax Metropolitan #212037750 Report a problem
    4/16/2012Listed for sale$179,000-5.7%$77/sqft
    Source: RE/MAX Metropolitan #212037750 Report a problem
    3/7/2012Listing removed$189,900$82/sqft
    Source: Homes.com #30753474 Report a problem
    3/6/2012Listed for sale$189,900+5.6%$82/sqft
    Source: Homes.com #30753474 Report a problem
    3/29/2011Listing removed$179,900$78/sqft
    Source: CLIENTS FIRST, REALTORS #211004685 Report a problem
    3/25/2011Price change$179,900-5.3%$78/sqft
    Source: CLIENTS FIRST, REALTORS #211004685 Report a problem
    2/22/2011Price change$189,900-5%$82/sqft
    Source: CLIENTS FIRST, REALTORS #211004685 Report a problem
    1/27/2011Listed for sale$199,900-23.1%$86/sqft
    Source: Clients First, Realtors Report a problem
    11/24/2004Sold$260,000+63.5%$113/sqft
    Source: Public Record Report a problem
    5/18/1995Sold$159,000$69/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$4,726 +6.3%$192,700 +5.2%
    2024$4,446 +5.3%$183,100 +10.8%
    2023$4,223 +2.8%$165,200 +8.1%
    2022$4,107 +0.7%$152,800 +3.9%
    2021$4,079 $147,100 +6.4%
    2020$4,079 +8.5%$138,300 +7.2%
    2019$3,760 +43.5%$129,000 +5.2%
    2018$2,620 +2.2%$122,600 +15.5%
    2017$2,564 $106,150
    2016$2,564 $106,150 +9.4%
    2015$2,564 +72.1%$97,000 +10.5%
    2013$1,490 $87,800
    2012-- --
    2009-- --
    2001$2,460 +3.5%$88,770 +3.2%
    2000$2,377 $86,020

    Find assessor info on the county website

    Neighborhood: 48316

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • District: Utica

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $452,300
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $452,300