NOT LISTED FOR SALE

28438 Queens Ct Warren, MI 48093

Northeast Warren Neighborhood

Estimated Value: $145,337 - $173,000

3 Beds
1.5 Baths
1,240 Sq Ft
$128/Sq Ft Est. Value

Last Sold July 23, 2021

Last sale price $120,000 $97 Per Sq Ft

Est. 32% increase in value since last sale

Current estimated payment $1,164/month

Highlights

  • Ground Level Unit
  • 1 Car Detached Garage
  • Forced Air Heating and Cooling System

About This Home

As of February 2024

3 bedrooms 1.1 bathrooms ready to move in condition. large living room with kitchen and dinning space. Upstairs has decent size 3 bedrooms with full updated bathroom. prime location in city of warren. Association fee includes the rent.

Last Agent to Rent the Property

Mahfujur Rahman

Home Pride Realty License #6501431352 Listed on: 02/15/2024

Last Renter's Agent

Iskandar Shamaoun

3DX Real Estate LLC Troy License #6501445063

3DX Real Estate LLC Troy

Townhouse Details

Home Type

  • Townhome

Year Built

  • Built in 1973

Home Design

  • Half Duplex
  • Brick Exterior Construction
  • Brick Foundation
  • Asphalt Roof

Interior Spaces

  • 1,240 Sq Ft Home
  • 1.5-Story Property
  • Unfinished Basement

Bedrooms and Bathrooms

  • 3 Bedrooms

Parking

  • 1 Car Detached Garage
  • Carport

Location

  • Ground Level Unit

Utilities

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

Community Details

  • Property has a Home Owners Association
  • Association Phone (586) 254-3000
  • Londonderry Downs Subdivision

Listing and Financial Details

  • Security Deposit $2,250
  • 12 Month Lease Term
  • Application Fee: 50.00
  • Assessor Parcel Number 1314176031

Townhouse Details

Home Type

Townhome

Year Built

Built in 1973

Lot Details

0

Rental Info

  • Application Fee: 50.00
  • Lease Type: Condominium
  • Security Deposit: 2250.00

Listing Details

  • Property Type: Condominium
  • Architecture Style: 1/2 Duplex
  • Architecture Level: 1 1/2 Story
  • Year Built: 1973
  • Entry Location: Ground Level
  • Pets Allowed: No
  • Special Features: None
  • Property Sub Type: Townhouses
  • Stories: 1

Interior Features

  • Total Bedrooms: 3
  • Total Bathrooms: 1.10
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Unfinished
  • Total Sq Ft: 1240

Exterior Features

  • Roof Material: Asphalt
  • Foundation Details: Basement
  • Construction Materials: Brick
  • Foundation Materials: Brick/Mortar
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 1 Car
  • Garage Features: Carport, Detached
  • Garage: Yes
  • MF Parking: Carports

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Source: Community

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Phone: 5862543000
  • Association Fee: Yes

Lot Info

  • Parcel Number: 1314176031

Multi Family

  • Length of Lease: 12 Months

MLS Schools

  • School District: Warren Woods

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 18, 2021
Closed on
Jul 23, 2021
Sold by
Ali Pirzada Syed S and Shaheen Farida
Bought by
Rahman Syed and Chowdhury Nadira Khatun
Seller's Agent
Nicholas Zeoli
Real Broker LLC
Buyer's Agent
Mahfujur Rahman
Home Pride Realty
List Price
$125,000
Sold Price
$120,000
Premium/Discount to List
-$5,000
-4%
Current Estimated Value
$158,334

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$38,334
Avg. Annual Appreciation
6.37%

Purchase Details

Listed on
Sep 8, 2016
Closed on
Oct 17, 2016
Sold by
Vsetula Mary J
Bought by
Shaheen Farida and Alipirzada Syed S
Seller's Agent
Chris Cotzias
Real Estate One Grosse Pointe
Buyer's Agent
Adrienne Bryant
Real Living Kee Realty-Troy
List Price
$64,500
Sold Price
$63,000
Premium/Discount to List
-$1,500
-2.33%

Home Financials for this Owner

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

Purchase Details

Closed on
Feb 15, 2012
Sold by
Vsetula Mary and Vsetula Antony S
Bought by
Vsetula Mary and Vsetula Jane E
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

Date Buyer Sale Price Title Company
Rahman Syed $120,000 None Available
Shaheen Farida $63,000 --
Vsetula Mary -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Shaheen Farida --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
02/29/2024 02/29/24 Rented $1,500 0.0% --
02/15/2024 02/15/24 For Rent $1,500 0.0% --
11/19/2022 11/19/22 Rented $1,500 0.0% --
11/17/2022 11/17/22 Under Contract -- -- --
10/13/2022 10/13/22 For Rent $1,500 +7.1% --
10/28/2021 10/28/21 Rented $1,400 0.0% --
10/27/2021 10/27/21 Under Contract -- -- --
09/28/2021 09/28/21 Price Changed $1,400 -3.4% $1 / Sq Ft
09/25/2021 09/25/21 Price Changed $1,450 +3.6% $1 / Sq Ft
09/23/2021 09/23/21 For Rent $1,400 0.0% --
07/23/2021 07/23/21 Sold $120,000 -4.0% $97 / Sq Ft View Prior Sale
06/25/2021 06/25/21 Pending -- -- --
06/18/2021 06/18/21 For Sale $125,000 +98.4% $101 / Sq Ft
10/12/2016 10/12/16 Sold $63,000 -2.3% $51 / Sq Ft View Prior Sale
10/02/2016 10/02/16 Pending -- -- --
09/08/2016 09/08/16 For Sale $64,500 -- $52 / 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,027 $65,200 $0 $0
2024 $39 $62,300 $0 $0
2023 $3,715 $55,650 $0 $0
2022 $3,523 $50,560 $0 $0
2021 $1,727 $49,420 $0 $0
2020 $1,655 $41,630 $0 $0
2019 $1,581 $33,640 $0 $0
2018 $0 $29,590 $0 $0
2017 $1,511 $29,370 $3,150 $26,220
2016 $1,267 $29,370 $0 $0
2015 -- $27,110 $0 $0
2012 -- $28,210 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Mahfujur Rahman

    Landlord's Agent in 2024

    Mahfujur Rahman

    Home Pride Realty

    (586) 229-0460

    13 in this area

    96 Total Sales

    Mahfujur Rahman
    Section Image
  • Iskandar Shamaoun

    Tenant's Agent in 2024

    Iskandar Shamaoun

    3DX Real Estate LLC Troy

    (248) 762-9377

    11 Total Sales

    Iskandar Shamaoun
    Section Image
  • Maria Garcia

    Buyer's Agent in 2022

    Maria Garcia

    Mid-Mitten Realty

    (989) 493-7938

    46 Total Sales

    Maria Garcia
    Section Image
  • Nicholas Zeoli

    Seller's Agent in 2021

    Nicholas Zeoli

    Real Broker LLC

    (248) 860-3268

    10 in this area

    423 Total Sales

    Nicholas Zeoli
    Section Image
  • Talaal Chaudhry

    Seller Co-Listing Agent in 2021

    Talaal Chaudhry

    Real Broker LLC

    (888) 501-7085

    3 in this area

    77 Total Sales

    Talaal Chaudhry
    Section Image
  • Chris Cotzias

    Seller's Agent in 2016

    Chris Cotzias

    Real Estate One Grosse Pointe

    (313) 550-3477

    55 Total Sales

    Chris Cotzias
    Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 20240009367

Realcomp

APN: 12-13-14-176-031

Michigan Macomb County Warren 48093 Northeast Warren

28438 Queens Ct, Warren, MI

Not Listed for Sale

Townhouses

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.

Realcomp IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
Copyright 2025 Realcomp II Ltd. Shareholders
IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393

Nearby Homes