24
$169,900
2 bd · 1 ba · 2,034 sqft
24028 Greenhill Road Unit: Unit 59, Warren, MI
Kristy Quenneville · Arterra Realty Michigan LLC

No listing photos
2
Beds
1
Baths
1,170
Sqft
2002
Year built
Range $139,782 – $214,176 · as of August 30, 2026
ATTOM automated valuation model · 54 published estimates over 6.7 years · shaded band is the model's own published low-to-high range
Highest reading $191,268 in August 2025; lowest $96,926 in February 2020. The vertical scale starts at the series' own low, not at zero — it is drawn to show movement, not absolute size.
$35,396
Estimated monthly payment
$1,251/mo
Loan amount $141,583. Estimate only — your actual rate and payment depend on credit, location, and lender.
2026 roll
Rings at ½ mile and 1 mile. Basemap © OpenMapTiles © OpenStreetMap contributors.
Open the Warren camera map5 license-plate readers mapped within 1 mile of this home, all identified as Flock Safety devices. None within ½ mile. Nearest: 0.5 mi south. Operators named in the data: Hazel Park Police Department and Madison Heights Police Department.
| Device type | Within ½ mi | Within 1 mi |
|---|---|---|
| License-plate readers | 0 | 5 |
| of which Flock Safety | 0 | 5 |
Community-reported via OpenStreetMap; may be incomplete. Data as of . © OpenStreetMap contributors (ODbL)
License-plate readers (ALPR) are fixed cameras that photograph passing vehicles and read their plates. Records are typically shared with the agency or association that operates the camera.
Flock Safety is a company whose plate-reader cameras are used by police departments, cities, HOAs and businesses. Its devices are usually solar-powered and pole-mounted.
School ratings (A+ to F) from HJN community data.
Siersma Elementary School
EE-5 · Regular · Warren Consolidated Schools
494 students · 14.8:1 student–teacher
Madison District Early Childhood Education Center
PK-KG · Regular · Madison Public Schools
64 students · 6.5:1 student–teacher
Michigan Mathematics and Science Academy Dequindre
KG-12 · Regular · Michigan Mathematics and Science Academy
573 students · 13.1:1 student–teacher
Madison Elementary School
KG-5 · Regular · Madison Public Schools
411 students · 15.6:1 student–teacher
Westview Elementary School
KG-5 · Regular · Fitzgerald Public Schools
446 students · 15.9:1 student–teacher
Madison Preparatory High School
PK-PK · Alternative/Other · Madison Public Schools
5 students · 6.3:1 student–teacher
Madison High School
9-12 · Regular · Madison Public Schools
255 students · 17.1:1 student–teacher
Beer Middle School
6-8 · Regular · Warren Consolidated Schools
665 students · 18.8:1 student–teacher
Within 2 miles of this home: 36+ restaurants and cafés, 3 grocery stores, 23 parks and green spaces, and 40+ transit stops.
Place data from OpenStreetMap.
McDonald's
East 10 Mile Road
Church's Chicken
Dequindre Road
Subway
Dequindre Avenue
Jimmy John's
Dequindre Road
Dunkin
East 11 Mile Road
Phulkari Punjabi Kitchen
Indian restaurant · Dequindre Road
Toarmina's Pizza Madison Hgts
Dequindre Road
Tim Hortons
Ryan Road
Kroger
Dequindre Road
Hazel Park Food Center
John R Road
Save-A-Lot
Steinhauser Park
Decorative Garden
Karam Park
Madison Woods
East Farnum Avenue
Rosie's Park
East Farnum Avenue
Wildwood Park
Delton Street
Fuller Park
Exchange Park
East Farnum Avenue
Dequindre / Tobsal NS (NB)
Dequindre / Heights (SB)
Dequindre / Red Roof Inn (NB)
Dequindre / Concept (NB)
Dequindre / Knights Inn (SB)
Dequindre / Concept (SB)
Dequindre / Riggs (NB)
Dequindre / Riggs (SB)
MiRealSource
Realcomp
Southwestern Michigan Association of REALTORSSome properties which appear for sale on this web site may subsequently have sold or may no longer be available.
24
$169,900
2 bd · 1 ba · 2,034 sqft
24028 Greenhill Road Unit: Unit 59, Warren, MI
Kristy Quenneville · Arterra Realty Michigan LLC
24$169,900
2 bd · 1 ba · 2,034 sqft
24028 Greenhill Road, Warren, MI
24$169,900
2 bd · 1 ba · 2,034 sqft
24028 Greenhill Road Unit 59, Warren, MI
Kristy Quenneville · Arterra Realty Michigan LLC
Price Reduced20$210,000
3 bd · 2 ba · 1,485 sqft
23937 Thomas Street, Warren, MI
on 2 MLSs
New14$165,000
3 bd · 2 ba · 1,240 sqft
2536 Chalk Farm Road, Warren, MI
on 2 MLSs
Price Reduced23$125,000
3 bd · 1 ba · 1,026 sqft
7552 Westminster Avenue, Warren, MI
on 2 MLSs




