NOT LISTED FOR SALE

28457 Queens Ct Warren, MI 48093

Northeast Warren Neighborhood

Estimated Value: $153,000 - $176,262

3 Beds
1 Bath
1,240 Sq Ft
1973 Built

Sale Details

Date Sold: March 12, 2014

Last sale price $57,000 $46 Per Sq Ft

Est. 183% increase in value since last sale

Current estimated payment $1,249 / mo

84 Days on Market

About This Home

As of March 2014

Beautiful condo with car port and complex with pool. Big partially finished basement, very nice quiet location. 3 bedroom, 1.5 bath... Newer furnace and AC.... ALL APPLIANCES INCLUDED.LAND CONTRACT TERMS-$25000.00 @8% ,36 MONTHS

Last Agent to Sell the Property

Tariq Herish

Brookstone, Realtors LLC License #MISPE-6501293554 Listed on: 11/25/2013

Brookstone, Realtors LLC

Last Buyer's Agent

Rimon Hanna

Stars Realty LLC License #MISPE-6502330775

Property Details

Home Type

  • Condominium

Year Built

  • Built in 1973

HOA Fees

  • $217 Monthly HOA Fees

Parking

  • Carport

Home Design

  • 1,240 Sq Ft Home
  • Brick Exterior Construction

Kitchen

  • Oven or Range
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 1 Full Bathroom

Laundry

  • Dryer
  • Washer

Pool

Utilities

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

Additional Features

  • Partially Finished Basement

Listing and Financial Details

  • Assessor Parcel Number 1314176022

Community Details

Overview

  • Association fees include gas, lawn maintenance, snow removal, water/sewer, exterior maintenance, grounds maintenance, community pool, water

Recreation

  • Community Spa

Pet Policy

  • Pets Allowed

Property Details

Home Type

Condominium

Year Built

Built in 1973

Lot Details

0 Sq Ft Lot

HOA Fees

$217 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL CONDO
  • Type Of Property: Condominium
  • Year Built: 1973
  • Special Features: None
  • Property Sub Type: Condos

Interior Features

  • Appliances: Dishwasher, Disposal, Dryer, Range/Oven, Refrigerator, Washer
  • Basement: Yes
  • Basement: Partially Finished
  • Bedrooms: 3
  • Bedroom 1: On 2nd Floor, Dimensions: 16 x 11
  • Bedroom 2: On 2nd Floor, Dimensions: 12 x 11
  • Bedroom 3: On 2nd Floor, Dimensions: 11 x 10
  • Bathrooms Description: First Flr Lavatory, Second Flr Lavatory
  • Full Bathrooms: 1
  • Total Bathrooms: 2
  • Kitchen: On Entry Level, Dimensions: 14 x 12
  • Kitchen Features: Eat-In Kitchen
  • Half Bathrooms: 1
  • Above Grade Finished Sq Ft: 1240
  • Total Finished Sq Ft: 1240

Exterior Features

  • Pool: Yes
  • Exterior: Brick
  • Foundation: Basement
  • Road: Paved Street

Garage/Parking

  • Garage: Carport

Utilities

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

Condo/Co-op/Association

  • HOA Fee Includes: Gas, Lawn Maintenance, Snow Removal, Water/Sewer
  • HOA Fees: 217
  • HOA Fee Frequency: Monthly
  • HOA Fee Includes: Exterior Maintenance, Gas, Grounds Maintenance, Community Pool, Water
  • Community Features: Pool/Hot Tub, Pets-Allowed, Some Pet Restrictions, Private Entry
  • Association Fee: Yes

Lot Info

  • Assessor Parcel Number: 1314176022
  • Map Side Numeric: 4
  • Map Top Alpha: E
  • Geo Subdivision: MI
  • Land Contract: Yes

Tax Info

  • Summer Tax: Amount: $1,870.00
  • Winter Tax: Amount: $171.00

MLS Schools

  • School District: Warren Woods Public Schools

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Closed on
Dec 27, 2016
Sold by
Bought by
Current Estimated Value
$161,066

Purchase Details

Listed on
Nov 25, 2013
Closed on
Feb 28, 2014
Sold by
Bought by
Seller's Agent
Tariq Herish
Brookstone, Realtors LLC
Buyer's Agent
Rimon Hanna
Stars Realty LLC
List Price
$69,900
Sold Price
$57,000
Premium/Discount to List
-$12,900
-18.45%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.75%

Purchase Details

Listed on
May 27, 2013
Closed on
Jun 13, 2013
Sold by
Bought by
Seller's Agent
Carol Lukity
Berkshire Hathaway HomeServices Kee Realty
Buyer's Agent
Tariq Herish
Brookstone, Realtors LLC
List Price
$50,000
Sold Price
$50,500
Premium/Discount to List
$500
1%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
17.52%
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
-- None Available
$57,000 Century Title Agency Svcs
$50,500 Premier Title Agency
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
03/12/2014 03/12/14 Sold $57,000 -18.5% $46 / Sq Ft
02/17/2014 02/17/14 Pending -- -- --
11/25/2013 11/25/13 For Sale $69,900 0.0% $56 / Sq Ft
09/05/2013 09/05/13 Rented $1,000 0.0% --
08/30/2013 08/30/13 Under Contract -- -- --
07/27/2013 07/27/13 For Rent $1,000 0.0% --
06/13/2013 06/13/13 Sold $50,500 +1.0% $41 / Sq Ft View Prior Sale
06/05/2013 06/05/13 Pending -- -- --
05/27/2013 05/27/13 For Sale $50,000 -- $40 / Sq Ft
Source: Michigan Multiple Listing Service

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2026 $1,857 $77,820 $0 $0
2025 $1,805 $65,200 $0 $0
2024 $18 $62,300 $0 $0
2023 $1,664 $55,650 $0 $0
2022 $1,631 $50,560 $0 $0
2021 $1,601 $49,420 $0 $0
2020 $1,534 $41,630 $0 $0
2019 $1,466 $33,640 $0 $0
2018 $1,480 $29,590 $0 $0
2017 $1,400 $29,370 $3,150 $26,220
2016 $1,390 $29,370 $0 $0
2015 -- $27,110 $0 $0
2012 -- $28,210 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Tariq Herish

    Seller's Agent in 2014

    Tariq Herish

    Brookstone, Realtors LLC

    (810) 459-9217

    2 in this area

    100 Total Sales

    Tariq Herish
    Section Image

  • R

    Buyer's Agent in 2014

    Rimon Hanna

    Stars Realty LLC

    Section Image
  • Carol Lukity

    Seller's Agent in 2013

    Carol Lukity

    Berkshire Hathaway HomeServices Kee Realty

    (586) 634-3933

    23 in this area

    261 Total Sales

    Carol Lukity
    Section Image
  • Jake Herish

    Seller's Agent in 2013

    Jake Herish

    Brookstone, Realtors LLC

    (586) 453-5641

    1 in this area

    74 Total Sales

    Jake Herish
    Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 31174904

Michigan Multiple Listing Service

APN: 12-13-14-176-022

Michigan Macomb County Warren 48093 Northeast Warren

28457 Queens Ct, Warren, MI

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.

Michigan Multiple Listing Service 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 2026 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
Your Personal Tour Guide

Ask me questions while you tour the home.