$95,600
SOLD AUG 25, 2025

29173 Hayes Rd Unit B18 Warren, MI 48088

Northeast Warren Neighborhood
2 Beds
1 Bath
900 Sq Ft
$218/mo HOA Fee

Recently Sold

$106 Per Sq Ft

13% Above List Price

14 Days on Market

Highlights

  • Colonial Architecture
  • Forced Air Heating System
  • Cats Allowed
  • Patio

About This Home

As of August 2025

**HIGHEST & BEST DUE MONDAY JULY 14, 2025 @ 8AM **Estate Sale ** - Cute & Updated Warren Condo- Amenities include; furnished 2 bedrooms, updated Kitchen with Brand New stainless steel appliances, updated bath, all furniture can stay or go, 1st floor with patio, keyed entry, cats allowed NO dogs, 1 carport space. Assoc fee = $218. per month, includes gas, water, garbage, outside maint. Property is subject to probate court approval ( process typically takes 3-6 weeks) Sorry NO split closings. Property must be listed for a minimum of 10 days before any offer can be accepted. Please allow 24-72 business hours for attorney review.

Last Agent to Sell the Property

Cynthia Borowy-Megalizzi

Deed Realtors License #MISPE-6502320664 Listed on: 07/01/2025

Last Buyer's Agent

Vitaliy Perets

Home One Realty LLC License #6501428540

Property Details

Home Type

  • Condominium

Est. Annual Taxes

Year Built

  • Built in 1970

HOA Fees

  • $218 Monthly HOA Fees

Parking

  • Carport

Home Design

  • 900 Sq Ft Home
  • Colonial Architecture
  • Brick Exterior Construction

Kitchen

  • Oven or Range
  • Dishwasher

Bedrooms and Bathrooms

  • 2 Bedrooms
  • 1 Full Bathroom

Basement

  • Block Basement Construction
  • Basement Storage

Outdoor Features

  • Patio

Utilities

  • Forced Air Heating System
  • Heating System Uses Natural Gas

Listing and Financial Details

  • Assessor Parcel Number 12-13-12-476-075

Community Details

Overview

  • Association fees include gas included, ground maintenance, snow removal, trash removal
  • Reception HOA
  • Yorkshire Woods Subdivision

Pet Policy

  • Cats Allowed

Property Details

Home Type

Condominium

Est. Annual Taxes

$1,926

Year Built

Built in 1970

Lot Details

0

HOA Fees

$218 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL
  • Type Of Property: Condominium
  • Architecture Style: Colonial
  • Structure Style: Condo/Apt Lower
  • Total Tax Amount: 1926
  • Total Tax Year: 2024
  • Year Built: 1970
  • Mail City: Warren
  • Unit Number Building Number: B 18
  • Special Features: None
  • Property Sub Type: Condos

Interior Features

  • Appliances: Dishwasher, Range/Oven, Refrigerator
  • Basement: Yes
  • Basement: Block, Common, Common Storage Locker
  • Bedrooms: 2
  • Bedroom 1: On Main Floor, Dimensions: 18 x 10
  • Bedroom 2: On Main Floor, Dimensions: 11 x 10
  • Full Bathrooms: 1
  • Total Bathrooms: 1
  • Bathroom 1: On Level: Main
  • Dining Room: On Main Floor, Dimensions: 10 x 10
  • Kitchen: On Main Floor, Dimensions: 9 x 9
  • Living Room: On Main Floor, Dimensions: 15 x 12
  • Above Grade Finished Sq Ft: 900
  • Total Finished Sq Ft: 900

Exterior Features

  • Exterior: Brick
  • Exterior Features: Patio
  • Foundation: Basement

Garage/Parking

  • Garage: Carport
  • Garage: No

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water

Condo/Co-op/Association

  • HOA Fee Includes: Gas Included, Maintenance Grounds, Snow Removal, Trash Removal
  • HOA Fees: 218
  • HOA Fee Frequency: Monthly
  • Community Features: Sidewalks, Pets-Allowed
  • Association Contact: reception
  • Association Phone: 586-254-3000
  • Pets: Yes
  • Association Fee: Yes

Lot Info

  • Assessor Parcel Number: 12-13-12-476-075
  • Geo Subdivision: MI

Rental Info

  • Pets Allowed: Yes
  • Pet Restriction: Cats Allowed

Tax Info

  • Summer Tax: Year: 2024, Amount: $1,873.00
  • Winter Tax: Year: 2024, Amount: $53.00
  • Total Tax: Year: 2024, Amount: $1,926.00

MLS Schools

  • School District: Warren Woods Public Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 1, 2025
Closed on
Aug 25, 2025
Sold by
Ahmed Shamsun and Aull Heidi C
Bought by
Vp Eco Properties Llc
Seller's Agent
Cynthia Borowy-Megalizzi
Deed Realtors
Buyer's Agent
Vitaliy Perets
Home One Realty LLC
List Price
$84,900
Sold Price
$95,600
Premium/Discount to List
$10,700
12.6%
Views
46

Home Financials for this Owner

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

Purchase Details

Closed on
Aug 29, 2024
Sold by
First Positive Rehab Inc
Bought by
Ahmed Shamsun

Purchase Details

Closed on
May 28, 2024
Sold by
Macomb County
Bought by
Federal Home Loan Mtg Corp

Purchase Details

Closed on
Feb 23, 2024
Sold by
Sheriff Of Macomb County
Bought by
Federal Home Loan Mtg Corp

Purchase Details

Closed on
Feb 25, 2022
Sold by
Kiesgen Gregory L
Bought by
Ahmed Shamsun

Purchase Details

Closed on
Dec 10, 2004
Sold by
The Edward L Miller Living Trust
Bought by
Kiesgen Gregory L

Purchase Details

Closed on
Apr 4, 1998
Sold by
Rosik G L
Bought by
Miller E
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 Type Sale Price Title Company
Warranty Deed $95,600 None Listed On Document
Quit Claim Deed $73,378 None Listed On Document
Sheriffs Deed -- None Listed On Document
Quit Claim Deed $64,808 None Listed On Document
Sheriffs Deed $62,400 None Listed On Document
Sheriffs Deed $62,400 None Listed On Document
Warranty Deed $77,500 Chirco Title
Warranty Deed $60,000 Title One Inc
Deed $43,000 --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
08/25/2025 08/25/25 Sold $95,600 +12.6% $106 / Sq Ft
07/15/2025 07/15/25 Pending -- -- --
07/01/2025 07/01/25 For Sale $84,900 -- $94 / Sq Ft
Source: Michigan Multiple Listing Service

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 $2,530 $37,370 $0 $0
2024 $2,476 $35,180 $0 $0
2023 $1,873 $36,170 $0 $0
2022 $783 $28,440 $0 $0
2021 $1,013 $26,750 $0 $0
2020 $981 $24,300 $0 $0
2019 $947 $20,760 $0 $0
2018 $0 $16,180 $0 $0
2017 $910 $16,080 $2,100 $13,980
2016 $904 $16,080 $0 $0
2015 -- $15,230 $0 $0
2013 $973 $14,050 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • C

    Seller's Agent in 2025

    Cynthia Borowy-Megalizzi

    Deed Realtors

    (586) 739-5540

    2 in this area

    47 Total Sales

    Cynthia Borowy-Megalizzi
    Section Image
  • Vitaliy Perets

    Buyer's Agent in 2025

    Vitaliy Perets

    Home One Realty LLC

    (586) 202-8286

    4 in this area

    9 Total Sales

    Vitaliy Perets
    Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 50180320

Michigan Multiple Listing Service

APN: 12-13-12-476-075

Michigan Macomb County Warren 48088 Northeast Warren

29173 Hayes Rd Unit B18, Warren, MI

This home is located at 29173 Hayes Rd Unit B18, Warren, MI 48088 and is currently priced at $95,600, approximately $106 per square foot. This property was built in 1970. 29173 Hayes Rd Unit B18 is a home located in Macomb County with nearby schools including Warren Woods Tower High School, Michigan Collegiate Elementary, and Warren Woods Christian School.

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 2025 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