BACK ON MARKET! Buyer didn't qualify. You won't believe how big and beautiful this 2005 ranch home is! Gorgeous exterior. Huge, wide, cement driveway. 2.5 car ATTACHED garage. 800 square-foot enclosed vaulted, covered, wood deck. Vaulted ceilings in living room, master bed and kitchen. Master bed with accessible bathroom and walk-in closet. 2nd and 3rd bedrooms have a 12x6 dual entry full bathroom. Updated "open concept" kitchen with new granite counters and extra cupboards. Custom wood inlaid hardwoods. 1/2-acre lot with 6-foot wooden fence. Fence panels replaced and UV sealed in 2021. Utica schools. Dry basement with radon mitigation system. Nice office in basement for "work at home". Security system. City water, septic. No steps on main floor. Wonderful house to stay your whole life. Convection, double oven. Energy star fridge, new washer, and dryer. 1st floor laundry. Hook up for full house generator ($1500) Basement plumbed for bathroom. Large shed. Sprinkler system.
Single-familyProperty Type
2005Year Built
0.48 acresLot Size
$248Est. Price/Sq.Ft.
2 car garageParking
Listed by Ann Howard• Sullivan Howard Real Estate LLC
Bought with Regan Monzo• Keller Williams Realty-Great Lakes
Hardwood floors throughout, beautiful three season enclosed deck great for entertaining, large backyard, kitchen with granite island, first floor laundry, Jack and Jill arrangement. Electric fireplace.
5 years ago• May not reflect the current state of the home
John Bremner
Redfin Associate agent
Sale history for 2457 Durham Rd
Date
Event
Price
RENT. #1
Jun 17, 2022
Price Changed
$2,490
$2/sq ft
Greater Lansing AoR #60092468
Jun 28, 2022
Sold
$376,900
$227/sq ft
Jun 13, 2022
Pending
—
May 30, 2022
Relisted
—
May 22, 2022
Contingent
—
May 10, 2022
Pending
—
May 5, 2022
Listed
$364,900
$220/sq ft
BACK ON MARKET! Buyer didn't qualify. You won't believe how big and beautiful this 2005 ranch home is! Gorgeous exterior. Huge, wide, cement driveway. 2.5 car ATTACHED garage. 800 square-foot enclosed vaulted, covered, wood deck. Vaulted ceilings in living room, master bed and kitchen. Master bed with accessible bathroom and walk-in closet. 2nd and 3rd bedrooms have a 12x6 dual entry full bathroom. Updated "open concept" kitchen with new granite counters and extra cupboards. Custom wood inlaid hardwoods. 1/2-acre lot with 6-foot wooden fence. Fence panels replaced and UV sealed in 2021. Utica schools. Dry basement with radon mitigation system. Nice office in basement for "work at home". Security system. City water, septic. No steps on main floor. Wonderful house to stay your whole life. Convection, double oven. Energy star fridge, new washer, and dryer. 1st floor laundry. Hook up for full house generator ($1500) Basement plumbed for bathroom. Large shed. Sprinkler system.
REALCOMP #2220033221
Jun 28, 2022
Sold
$376,900
$227/sq ft
Jun 13, 2022
Pending
—
May 30, 2022
Relisted
—
May 22, 2022
Contingent
—
May 10, 2022
Pending
—
May 5, 2022
Listed
$364,900
$220/sq ft
BACK ON MARKET! Buyer didn't qualify. You won't believe how big and beautiful this 2005 ranch home is! Gorgeous exterior. Huge, wide, cement driveway. 2.5 car ATTACHED garage. 800 square-foot enclosed vaulted, covered, wood deck. Vaulted ceilings in living room, master bed and kitchen. Master bed with accessible bathroom and walk-in closet. 2nd and 3rd bedrooms have a 12x6 dual entry full bathroom. Updated "open concept" kitchen with new granite counters and extra cupboards. Custom wood inlaid hardwoods. 1/2-acre lot with 6-foot wooden fence. Fence panels replaced and UV sealed in 2021. Utica schools. Dry basement with radon mitigation system. Nice office in basement for "work at home". Security system. City water, septic. No steps on main floor. Wonderful house to stay your whole life. Convection, double oven. Energy star fridge, new washer, and dryer. 1st floor laundry. Hook up for full house generator ($1500) Basement plumbed for bathroom. Large shed. Sprinkler system.
Public Records
Aug 14, 2019
Sold
$287,000
$173/sq ft
Greater Lansing AoR #31379125
Jul 11, 2019
Sold
$287,000
$173/sq ft
Jun 11, 2019
Pending
—
May 25, 2019
Price Changed
$299,000
$180/sq ft
May 16, 2019
Price Changed
$308,900
$186/sq ft
May 7, 2019
Listed
$299,000
$180/sq ft
May 7, 2019
Listed
$314,000
$189/sq ft
REALCOMP #58031379125
Jul 11, 2019
Sold
$287,000
$173/sq ft
May 7, 2019
Listed
$299,000
$180/sq ft
Greater Lansing AoR #31376072
May 7, 2019
Listing Removed
—
May 1, 2019
Price Changed
$323,000
$195/sq ft
Apr 11, 2019
Listed
$329,000
$198/sq ft
REALCOMP #58031376072
May 7, 2019
Listing Removed
—
Apr 11, 2019
Listed
$323,000
$195/sq ft
REALCOMP #26039004
May 15, 2006
Sold
$224,900
$136/sq ft
Mar 10, 2006
Listed
$224,900
$136/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$5,951 (+2.9%)
2024
$5,785 (+5.0%)
2023
$5,508 (+21.0%)
2022
$4,553 (+2.8%)
2021
$4,428 (−8.3%)
2020
$4,832 (+115.0%)
2019
$2,247 (+1.2%)
2018
$2,220 (+1.8%)
2017
$2,180 (+0.7%)
2016
$2,164 (−0.1%)
2015
$2,167 (+1.6%)
2014
$2,133
Tax history for 2457 Durham Rd
Year
Property tax
Land + Additions
Assessment*
2025
$5,951 (+2.9%)
2024
$5,785 (+5.0%)
2023
$5,508 (+21.0%)
2022
$4,553 (+2.8%)
2021
$4,428 (−8.3%)
2020
$4,832 (+115.0%)
2019
$2,247 (+1.2%)
2018
$2,220 (+1.8%)
2017
$2,180 (+0.7%)
2016
$2,164 (−0.1%)
2015
$2,167 (+1.6%)
2014
$2,133
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
4
Baths
2.5
Stories
1
Lot width
—
Lot depth
2 ft.
Lot size
20,908
Year renovated
2025
Sq. Ft.
1,659
Year built
2005
Style
Single Family Residential
County
Macomb County
APN
23-07-30-176-014
Parking Spaces
2
Basement
Yes
Accessible
Yes
HOA Dues
—
Garage
Yes
Features
Green
Last updated by owner on Feb 12, 2025.
R-1-C
One-Family Residential District
The One-Family districts are established to provide principally for one-family dwellings at varying densities. The specific interest of these districts is to encourage the construction and continued use of one-family dwellings and to prohibit the use of the land which would substantially interfere with the development of one -family dwellings and to discourage any land use which, because of its character and size, would create requirements and costs for public services substantially in excess of those at the specified densities and to discourage any land use which would generate excessive traffic on local streets.
Permitted uses
Include but are not limited to:
Agriculture
Housing-Single unit
Cemetery
Property details
Parking
Parking/Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 2.5
Parking Features: Attached, Paved, Garage Door Opener, Direct Access, Garage Faces Side
Interior
Bathroom Information
# of Full Bathrooms: 2
# of Half Bathrooms: 1
Heating & Cooling
Has Cooling
Cooling: Ceiling Fan(s), Central Air
Has Heating
Heating: Forced Air, Natural Gas
Interior Features
Appliances: Disposal, Range, Oven, Gas Water Heater
Has Fireplace
Fireplace Features: Living Room
Room Information
# of Rooms Total: 11
Has Basement
Basement Details: Partially Finished
Exterior
Exterior Features
Patio And Porch Features: Deck
Fencing: Fenced
Building Information
Direction Faces: North
Above Grade Finished Area: 1,659
Below Grade Finished Area: 144
# of Stories Total: 1
Construction Materials: Brick, Vinyl Siding
Property Features
Accessibility Features: Accessible Full Bath
Pets Allowed: Yes
Other Structures: Shed(s)
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: Single Family
Lot Information
Frontage Length: 133
Lot Size : 133 x 123
Lot Size Acres: 0.48
Financial
Tax Information
Tax Annual Amount: $4,428
Utilities
Utility Information
Water Source: Public
Utilities: Cable Available
Sewer: Septic Tank
Location
Schools Information
School District: Utica Community Schools
Location Information
Directions: Dequindre to Durham, turn East on Durham
Cross Street: N of Auburn/E of Dequindr
Public facts
Beds: 4
Baths: 2.5
Sq. Ft.: 1,659
Stories: —
Parking Spaces: 2
Basement: Yes
Accessible: Yes
Lot Size: 0.48 acres
Style: Single Family Residential
Year Built: 2005
Year Renovated: 2025
County: Macomb County
APN: 23-07-30-176-014
HOA Dues: —
Garage: Yes
Features: Green
Home facts updated by owner on Feb 12, 2025
Other
Listing Information
List AOR: RealComp
Around this home
Schools
K - 12
Preschool & daycare
Roberts Elementary School
Public PreK-6 • Assigned • 2.2mi
7/10
Eppler Junior High School
Public 7-9 • Assigned • 2.8mi
6/10
Utica High School
Public 9-12 • Assigned • 2.3mi
9/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
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 97° 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
Shelby Township, MI • 48317
Average low and high temperatures (°F)
29°
16°
35°
19°
52°
31°
61°
41°
68°
48°
82°
60°
87°
66°
80°
61°
77°
55°
65°
46°
50°
37°
36°
24°
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.3 hours in
June and 2.5 hours in December, placing it below the
U.S. average for solar exposure.
9.3 hrs
2.5 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$391,000 – $473,000
Reach more buyers when you sell with Redfin. Save up to $4,110 in fees.3 minutes to get started.