This home's estimate is 7.5% lower than the average sale price ($105K) of 5 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
29149 Hayes Unit 37 2nd flr, Warren, MI 48088
About this home
This condo was totally renovated in 2013 & is immaculate! Porcelain wood grain tile in Kitchen & hallway, BRAND NEW custom kitchen & dining area w/ GE Profile appliances (stove w/ dbl oven, fridge, dishwasher, trash compactor, microwvave) custom Cherry cabinets, granite counters, large SS sink, totally updated bath, new carpet in living room & bedrms, new door w/ blt-in blinds to balcony w/ composite decking. Laundry facility in common bsmt, private enclosed storage area. Clean & updated hallways. Close to Macomb Community College, freeways, eating & shopping.

Redfin Estimate
Earn from this home
Get cash now or lower your monthly rate
List your home for rent
Market trends in 48088, MI
Last updated August 2026
Buyer's Market
Seller's Market
Seller's market
- NEW 7 HRS AGO
- OPEN SAT, 1PM TO 3PM
- OPEN SAT, 1PM TO 3PM
See all
Provided by Redfin
Sale history for 29149 Hayes Unit 37 2nd flr
$68/sq ft
$72/sq ft
Tax history for 29149 Hayes Unit 37 2nd flr
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Property details
Interior
- Interior Features
- # of Rooms (Total): 4
- Appliances: Dishwasher, Disposal, Microwave, Range/Oven, Refrigerator, Trash Compactor
- Bedroom Information
- Bedroom 1 Level: Entry
- Bedroom 1 Dimensions: 18 x 11
- Bedroom 1 Floor Covering: Carpet
- Bedroom 1 Floor Covering: Carpet
- Bedroom 2 Level: Entry
- Bedroom 2 Dimensions: 11 x 10
- Bedroom 2 Floor Covering: Carpet
- Bathroom Information
- # of Bathrooms (Full): 1
- # of Baths/Lavatories (Total): 1
- Dining/Kitchen Information
- Kitchen Floor Covering: Ceramic
- Kitchen Level: Entry
- Kitchen Dimension: 17 x 8
- Library/Den/Living Room Information
- Living Room Floor Covering: Carpet
- Living Room Level: Entry
- Living Room Dimensions: 16 x 12
- Laundry/Basement Information
- Basement : Has Basement
- Basement Type: Common
Exterior
- Exterior Features
- Exterior Construction: Brick
- Exterior Features: Exterior Balcony
- Foundation Type: Basement
- Property Information
- Unit/Building Number: # 37 2nd flr
- Property Type: Condominium
- Structure Style: Condo/Ranch 2nd Flr or Above
- Year Built: 1970
- Below Grade Sq. Ft.: 0
- Below Grade Sq. Ft. (Finished): 0
- Land Information
- Land Contract: No
Financial
- Tax/Assessments Information
- Total Tax Year: 2017
- Total Tax Amount: $853
- Summer Tax Year: 2017
- Summer Tax Amount: $633
- Winter Tax Year: 2017
- Winter Tax Amount: $20
Utilities
- Utility Information
- Heat/Fuel Type: Natural Gas
- Water: Public Water
- Cooling System: Central A/C
- Heating System: Forced Air
- Sewer Septic: Public Sanitary
Location
- Homeowners Association Information
- Association/Community Amenities: Laundry Facility, Cats Allowed
- Has Association Fee
- Fee Amount: $218
- Fee Schedule: Monthly
- School Information
- School District: Warren Woods Public Schools
- School District: Warren Woods Public Schools
- Location Details
- Municipality: Warren
- Mail City: Warren
- Subdivision: Yorkshire Woods Condo
- Municipality: Warren
- Area (Municipality): Warren (50023)
Public facts
- Beds: —
- Baths: 1.0
- Sq. Ft.: 900
- Stories: 1.0
- Lot Size: —
- Style: Condo/Co-op
- Year Built: 1970
- Year Renovated: —
- County: Macomb County
- APN: 12-13-12-476-094
Other
- Listing Information
- Originating MLS: MiRealSource
- Originating MLS: MI Real Source
Around this home
Schools
Public K-5 • Assigned • 0.4mi
Public 6-8 • Assigned • 1.1mi
Public 9-12 • Assigned • 0.8mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
Unlikely to be in a wildfire in next 30 years
7 days above 96° expected this year, 15 days in 30 years
Minimal risk of severe winds over next 30 years
3 unhealthy days expected this year, 4 days in 30 years
Sun exposure
In this area, properties receive around 9.1 hours in June and 2.4 hours in December, placing it below the U.S. average for solar exposure.
Sell confidently with a local market expert in Warren. 3 minutes to get started.
Nearby similar homes
New listings for sale in 48088 7031
Home values near 29149 Hayes Unit 37 2nd flr
| Address | Redfin Estimate |
|---|---|
2 Beds | 1 Baths | 900 Sq. Ft. | $90,822 |
- Beds | 1 Baths | 900 Sq. Ft. | $84,405 |
| Address | Redfin Estimate |
|---|---|
- Beds | 1 Baths | 900 Sq. Ft. | $88,743 |
- Beds | 1 Baths | 900 Sq. Ft. | $84,413 |
| Address | Redfin Estimate |
|---|---|
- Beds | 1 Baths | 900 Sq. Ft. | $89,736 |
- Beds | 1 Baths | 900 Sq. Ft. | $80,103 |
More real estate resources
- Cities
- Zip Codes
- Minor Civil Divisions
- Neighborhoods
- Popular Searches
| Detroit homes for sale | |||
| Royal Oak homes for sale | |||
| Troy homes for sale |
| 48066 homes for sale | |||
| 48234 homes for sale | |||
| 48088 homes for sale | |||
| 48312 homes for sale | |||
| 48091 homes for sale |
| Shelby Township homes for sale |
| East Detroit homes for sale | |||
| Northwest Warren homes for sale | |||
| Southwest Warren homes for sale | |||
| Fitzgerald homes for sale | |||
| Northeast Warren homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.






































United States
Canada