Fully renovated in 2023 with modern finishes throughout, this 2-bedroom, 1-bath condo in Warren's Yorkshire Woods community is truly move-in ready! High-end appliances, new cabinets, quartz counter tops, new flooring, new paint, a high-end spa-like bathroom, and a brand-new AC and furnace (2025) make this one stand out from the rest. The $317/month HOA covers gas and water, making this one of the most maintenance-free and cost-efficient options on the market. A carport and a basement storage space complete this well-appointed condo. Low-maintenance living, fully updated, and priced to sell. .. this one won't last!
Fully renovated in 2023 with modern finishes throughout, this 2-bedroom, 1-bath condo in Warren's Yorkshire Woods community is truly move-in ready! High-end appliances, new cabinets, quartz counter tops, new flooring, new paint, a high-end spa-like bathroom, and a brand-new AC and furnace (2025) make this one stand out from the rest. The $317/month HOA covers gas and water, making this one of the most maintenance-free and cost-efficient options on the market. A carport and a basement storage space complete this well-appointed condo. Low-maintenance living, fully updated, and priced to sell. .. this one won't last!
MiRealSource-MiMLS #61020778
Aug 14, 2026
Listed
$135,000
$71/sq ft
Aug 13, 2026
Coming Soon
$135,000
$71/sq ft
REALCOMP #20251044828
Feb 18, 2026
Listing Removed
—
Oct 30, 2025
Price Changed
$120,000
$63/sq ft
Oct 19, 2025
Price Changed
$125,000
$66/sq ft
Oct 12, 2025
Listed
$150,000
$79/sq ft
MiRealSource-MiMLS #60944624
Feb 18, 2026
Listing Removed
—
Oct 30, 2025
Price Changed
$120,000
$63/sq ft
Oct 20, 2025
Price Changed
$125,000
$66/sq ft
Oct 12, 2025
Listed
$150,000
$79/sq ft
REALCOMP #58050126079
Nov 17, 2023
Sold
$77,600
$41/sq ft
Oct 25, 2023
Listed
$77,000
$41/sq ft
REALCOMP #58050084164
Sep 27, 2022
Sold
$68,000
$36/sq ft
Jul 26, 2022
Listed
$67,900
$36/sq ft
MiRealSource-MiMLS #176575
Feb 3, 2010
Sold
$18,000
$9/sq ft
Jan 8, 2010
Listing Removed
—
May 22, 2009
Listed
$18,000
$9/sq ft
MiRealSource-MiMLS #136423
Feb 22, 2008
Sold
$28,000
$15/sq ft
Jan 23, 2008
Listing Removed
—
Dec 14, 2007
Listed
$28,000
$15/sq ft
REALCOMP #27220169
Feb 20, 2008
Sold
$28,000
$15/sq ft
Dec 11, 2007
Listed
$28,000
$15/sq ft
MiRealSource-MiMLS #277026
Mar 25, 2005
Sold
$70,500
$37/sq ft
Mar 7, 2005
Listing Removed
—
Jan 10, 2005
Listed
$68,900
$36/sq ft
MiRealSource-MiMLS #237002
Sep 17, 2004
Sold
$7,400
$4/sq ft
Aug 1, 2004
Listing Removed
—
Jul 21, 2004
Listed
$74,000
$39/sq ft
MiRealSource-MiMLS #248592
Feb 14, 2003
Sold
$68,000
$36/sq ft
Nov 29, 2002
Listing Removed
—
Nov 13, 2002
Listed
$69,900
$37/sq ft
MiRealSource-MiMLS #224241
Aug 20, 2002
Sold
$63,000
$33/sq ft
Jul 1, 2002
Listing Removed
—
Jun 12, 2002
Listed
$69,900
$37/sq ft
MiRealSource-MiMLS #242803
Jun 8, 2001
Sold
$69,900
$37/sq ft
May 9, 2001
Listing Removed
—
Apr 24, 2001
Listed
$69,900
$37/sq ft
MiRealSource-MiMLS #190677
May 27, 1998
Sold
$49,000
$26/sq ft
Apr 27, 1998
Listing Removed
—
Apr 14, 1998
Listed
$49,900
$26/sq ft
MiRealSource-MiMLS #193486
Sep 17, 1996
Sold
$43,500
$23/sq ft
Aug 22, 1996
Listing Removed
—
Aug 9, 1996
Listed
$44,900
$24/sq ft
MiRealSource-MiMLS #191041
Mar 28, 1995
Sold
$41,000
$22/sq ft
Jan 11, 1995
Listed
$42,900
$23/sq ft
As the MLS and public records start to fill up, we'll list the details here.
Public record
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Finished Sq. Ft.
—
Unfinished Sq. Ft.
—
Total Sq. Ft.
—
Year built
—
Style
Condo/Co-op
County
Macomb County
APN
1312476048
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 9, 2023.
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
3/10 Heat Factor
7 days above 96° expected this year, 15 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
3/10 Air Factor
3 unhealthy days expected this year, 4 days in 30 years
Provided by First Street
Historical weather
Warren, MI • 48088 4028
Average low and high temperatures (°F)
29
17
34
20
52
32
60
42
67
49
81
61
85
68
79
62
76
56
66
47
50
39
37
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
86/ 100
Very good sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.3 hrs
6.1 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 29101 Hayes Rd
$130,922
$4,078 under list price of $135K
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $101K to $167K.