Skip main navigation
Off market
  • $420,900

    54777 Queens Row, Shelby Township, MI 48316

    4beds
    2,300sqft
    SingleFamily
    Built in 1972
    0.34 Acres Lot
    $420,900 Zestimate®
    $183/sqft
    $2,916 Estimated rent

    Home value

    $420,900

    $400,000 - $442,000

    $2,916/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $2,916/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,916/mo

    Rent Zestimate®

    Refinance and save

    $2,738/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,738/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

    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.

    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
    Features
    • Humidifier
    • Flooring: Tile, Carpet, Slate
    • Basement: Unfinished, Basement
    • Has fireplace: Yes
    • Fireplace features: Family Room, Natural
    Interior area
    • Total interior livable area: 2,300 sqft
    • Finished area below ground: 1053

    Property

    Parking
    • Total spaces: 5
    • Parking features: Garage - Attached
    Features
    • Patio & porch: Patio, Porch - Covered
    • Exterior features: Brick
    • Fencing: Fenced
    • Frontage length: Frontage Feet: 130
    Lot
    • Size: 0.34 Acres
    Details
    • Parcel number: 230708127025
    • Special conditions: Sale

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    Materials
    • Roof: Asphalt
    Condition
    • Remodeled
    • Year built: 1972
    • Major remodel year: 2010

    Utilities & green energy

    • Gas: Natural Gas
    • Sewer: Septic Tank
    • Water: Municipal Water

    Community & HOA

    HOA
    • Has HOA: Yes
    • HOA fee: $13 monthly
    Location
    • Region: Shelby Township

    Financial & listing details

    • Price per square foot: $183/sqft
    • Tax assessed value: $367,800
    • Annual tax amount: $4,926
    • Exclusions: No Exclusions
    • Road surface type: Paved

    Price history

    DateEventPrice
    3/26/2020Sold$300,000$130/sqft
    Source: Public Record Report a problem
    2/7/2020Pending sale$300,000$130/sqft
    Source: Keller Williams Realty Rochester #2200001637 Report a problem
    1/21/2020Listed for sale$300,000+4.5%$130/sqft
    Source: Keller Williams Paint Creek #2200001637 Report a problem
    5/3/2018Sold$287,000+2.5%$125/sqft
    Source: Public Record Report a problem
    3/6/2018Pending sale$279,900$122/sqft
    Source: Great Lakes #218016210 Report a problem
    3/2/2018Listed for sale$279,900+12%$122/sqft
    Source: Keller Williams Realty-Great Lakes #218016210 Report a problem
    12/22/2015Sold$250,000-1.1%$109/sqft
    Source: Public Record Report a problem
    9/23/2015Price change$252,900-3.8%$110/sqft
    Source: Owner #24044602 Report a problem
    9/15/2015Price change$263,000+2%$114/sqft
    Source: Owner #24044602 Report a problem
    9/5/2015Price change$257,900-1.9%$112/sqft
    Source: American Real Estate Services #10264426 Report a problem
    9/1/2015Listed for sale$263,000$114/sqft
    Source: Owner Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$4,926 +5%$183,900 +5.3%
    2024$4,690 +2.9%$174,600 +10.6%
    2023$4,558 +5.2%$157,900 +7.9%
    2022$4,333 +9.9%$146,300 +4.1%
    2021$3,943 $140,600 +5.2%
    2020$3,943 +8.5%$133,600 +7.1%
    2019$3,635 +19.3%$124,700 +6.5%
    2018$3,046 +24%$117,100 +14.7%
    2017$2,457 $102,100
    2016$2,457 $102,100 +10%
    2015$2,457 +72.2%$92,800 +10.3%
    2013$1,427 $84,100
    2012-- --
    2009-- --
    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
    $420,900
    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
    $420,900