3000.00 PRICE REDUCTION. Rare 1ST FLOOR Deluxe Condo which offers views of Your Own CARPORT and the Beautiful Park like setting looking out your Door Wall at Enticing Courtyard, also providing a cross breeze through the unit if desired. Your Bright Living area, has ample room and leads you out to your private Patio for relaxation and enjoyment. The kitchen area is large with ample dining area, (All appliances Included). The Large Bedroom includes a walk-in closet and allows for large furnishings. The Full bath is oversized and comfortable. Additional storage in the well lighted lower level with common laundry facility. Association Fee includes gas and water, hot water tank is repaired and replaced by association. HVAC was replaced in 2015. Complex offers a pool and clubhouse. Room sizes estimated, Pets welcome with restrictions
Est. $1,466 per month, based on comparable rentals
Sale and tax history for 29217 Hayes #2 Rd
Sale History
Tax History
Date
Event
Price
MiRealSource-MiMLS #50213051
Jul 10, 2026
Sold
$60,000
$82/sq ft
Jul 1, 2026
Pending
—
Jun 27, 2026
Listed
$69,900
$96/sq ft
3000.00 PRICE REDUCTION. Rare 1ST FLOOR Deluxe Condo which offers views of Your Own CARPORT and the Beautiful Park like setting looking out your Door Wall at Enticing Courtyard, also providing a cross breeze through the unit if desired. Your Bright Living area, has ample room and leads you out to your private Patio for relaxation and enjoyment. The kitchen area is large with ample dining area, (All appliances Included). The Large Bedroom includes a walk-in closet and allows for large furnishings. The Full bath is oversized and comfortable. Additional storage in the well lighted lower level with common laundry facility. Association Fee includes gas and water, hot water tank is repaired and replaced by association. HVAC was replaced in 2015. Complex offers a pool and clubhouse. Room sizes estimated, Pets welcome with restrictions
REALCOMP #58050213051
Jul 10, 2026
Sold
$60,000
$82/sq ft
Jul 1, 2026
Pending
—
Jun 27, 2026
Listed
$69,900
$96/sq ft
MiRealSource-MiMLS #50209775
Jun 28, 2026
Listing Removed
—
Jun 28, 2026
Listing Removed
—
Jun 27, 2026
Price Changed
$69,900
$96/sq ft
Jun 2, 2026
Listed
$72,900
$100/sq ft
REALCOMP #58050209775
Jun 28, 2026
Listing Removed
—
Jun 27, 2026
Price Changed
$69,900
$96/sq ft
Jun 2, 2026
Listed
$72,900
$100/sq ft
MiRealSource-MiMLS #50207668
Jun 3, 2026
Listing Removed
—
Jun 3, 2026
Listing Removed
—
Jun 2, 2026
Price Changed
$72,900
$100/sq ft
May 15, 2026
Listed
$74,900
$103/sq ft
REALCOMP #58050207668
Jun 3, 2026
Listing Removed
—
Jun 2, 2026
Price Changed
$72,900
$100/sq ft
May 15, 2026
Listed
$74,900
$103/sq ft
MiRealSource-MiMLS #50161504
Dec 27, 2024
Listing Removed
—
Dec 27, 2024
Listing Removed
—
Nov 20, 2024
Listed
$89,900
$123/sq ft
REALCOMP #58050161504
Dec 27, 2024
Listing Removed
—
Nov 20, 2024
Listed
$89,900
$123/sq ft
MiRealSource-MiMLS #50160569
Nov 21, 2024
Listing Removed
—
Nov 21, 2024
Listing Removed
—
Nov 20, 2024
Price Changed
$89,900
$123/sq ft
Nov 8, 2024
Listed
$91,900
$126/sq ft
REALCOMP #58050160569
Nov 21, 2024
Listing Removed
—
Nov 8, 2024
Listed
$89,900
$123/sq ft
Greater Lansing AoR #50159939
Nov 9, 2024
Listing Removed
—
Nov 9, 2024
Listing Removed
—
Nov 7, 2024
Price Changed
$91,900
$126/sq ft
Nov 1, 2024
Listed
$93,000
$128/sq ft
REALCOMP #58050159939
Nov 9, 2024
Listing Removed
—
Nov 1, 2024
Listed
$91,900
$126/sq ft
MiRealSource-MiMLS #50159418
Nov 2, 2024
Listing Removed
—
Nov 2, 2024
Listing Removed
—
Oct 30, 2024
Price Changed
$93,000
$128/sq ft
Oct 26, 2024
Listed
$94,900
$130/sq ft
REALCOMP #58050159418
Nov 2, 2024
Listing Removed
—
Oct 26, 2024
Listed
$93,000
$128/sq ft
Greater Lansing AoR #40157741
Apr 21, 2021
Sold
$57,550
$79/sq ft
Apr 21, 2021
Sold
$57,550
$79/sq ft
Apr 1, 2021
Pending
—
Mar 29, 2021
Listed
$55,900
$77/sq ft
Mar 29, 2021
Listed
$55,900
$77/sq ft
REALCOMP #2210020735
Apr 21, 2021
Sold
$57,550
$79/sq ft
Apr 1, 2021
Pending
—
Mar 29, 2021
Listed
$55,900
$77/sq ft
MiRealSource-MiMLS #31174497
Apr 25, 2014
Sold
$18,000
$25/sq ft
Mar 25, 2014
Listing Removed
—
Nov 21, 2013
Listed
$22,300
$31/sq ft
REALCOMP #213119531
Apr 25, 2014
Sold
$18,000
$25/sq ft
Nov 21, 2013
Listed
$22,300
$31/sq ft
MiRealSource-MiMLS #172343
Apr 2, 2009
Sold
$1,535
$2/sq ft
Dec 18, 2008
Listing Removed
—
Dec 5, 2008
Listed
$15,000
$21/sq ft
MiRealSource-MiMLS #196729
Aug 25, 2006
Listing Removed
—
Feb 25, 2006
Listed
$49,900
$68/sq ft
MiRealSource-MiMLS #237296
Apr 15, 2005
Sold
$56,000
$77/sq ft
Mar 18, 2005
Listing Removed
—
Mar 12, 2005
Listed
$58,000
$80/sq ft
MiRealSource-MiMLS #212850
Dec 31, 2004
Listing Removed
—
Jul 14, 2004
Listed
$59,900
$82/sq ft
MiRealSource-MiMLS #236914
Jun 13, 2003
Sold
$61,000
$84/sq ft
Jun 12, 2003
Listing Removed
—
May 15, 2003
Listed
$64,900
$89/sq ft
MiRealSource-MiMLS #194206
Jun 6, 1997
Sold
$43,000
$59/sq ft
Apr 5, 1997
Listing Removed
—
Mar 29, 1997
Listed
$42,999
$59/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
—
Sq. Ft.
—
Year built
—
Style
Condo/Co-op
County
Macomb County
APN
1312477054
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jun 14, 2025.
Property details
Parking
Parking/Garage Information
Parking Features: Carport
Interior
Bathroom Information
# of Full Bathrooms: 1
Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air, Natural Gas
Interior Features
Interior Features: Eat-in Kitchen
Appliances: Gas Water Heater, Oven, Refrigerator, Range
Room Information
# of Rooms Total: 4
Laundry Features: Common Area
Has Basement
Basement Details: Block
Exterior
Exterior Features
Patio And Porch Features: Patio, Porch
Pool Information
Pool Features: Community, Outdoor Pool
Building Information
Above Grade Finished Area: 729
Above Grade Finished Area Units: Square Feet
Levels: One
Construction Materials: Brick
Foundation Details: Block
Property Features
Pets Allowed: Call, Yes
Property Information
Property Type: Residential
Property Sub Type: Condominium
Raw Mls Property Sub Type: Condominium
Lot Information
Road Responsibility: Public Maintained Road
Zoning Description: Residential
Financial
Tax Information
Tax Annual Amount: $1,483.52
Utilities
Utility Information
Water Source: Public
Sewer: Public Sewer
Location
HOA Information
Has Homeowners Association
Association Amenities: Clubhouse, Laundry, Pool
Association Fee: $348.75
Association Fee Frequency: Monthly
Derived Association Fee (Monthly): $348.75
Association Fee Includes: Gas, Maintenance Grounds, Snow Removal, Trash, Water
Schools Information
High School District: WarrenWoods
Location Information
Subdivision Name: LANCASTER WOODS
Cross Street: N 12 Mile / W Hayes
Community Information
Community Features: Pool, Clubhouse
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Condo/Co-op
Year Built: —
Year Renovated: —
County: Macomb County
APN: 1312477054
Home facts updated by county records on Jun 14, 2025
Other
Listing Information
List AOR: MiRealSource
Around this home
Schools
Pinewood Elementary School
Public K-5 • Assigned • 0.4mi
8/10
Warren Woods Middle School
Public 6-8 • Assigned • 1.1mi
6/10
Warren Woods Tower High School
Public 9-12 • Assigned • 0.9mi
6/10
Provided by GreatSchools
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
Average low and high temperatures (°F)
29
17
34
20
52
32
60
42
67
49
81
61
84
68
80
63
76
58
66
47
50
39
37
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
74/ 100
Good sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
9.1 hrs
3.8 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$64,000 – $77,000
Sell confidently with a local market expert in Warren.