Sharp remodeled colonial in a great area north of Rochester. Amazing granite kitchen with all new stainless steel appliances, lots of cabinet space, breakfast bar, and a separate pantry closet. Large cathedral ceiling family room with a fireplace, a granite wet bar, and a doorwall out to the back deck. There are 4 generous bedrooms including a huge master suite. The large master bath has both a shower and whirlpool tub. There is a full finished basement, and a huge oversized 2 car attached garage that will fit at least 3 cars. There is a double wide driveway with a basketball post at the back. The home has a Generac backup generator system to protect against power outages. First floor laundry room, home office or den off the foyer, formal dining room, fresh paint throughout, excellent flooring, and much more. Owners will consider Land Contract terms. Call us today to see this beautiful home for yourself.
Single-familyProperty Type
1976Year Built
0.45 acresLot Size
$166Est. Price/Sq.Ft.
2 car garageParking
Listed by William Caton• American Real Estate Services
Bought with Robert Griffith• Indianwood Real Estate, LLC
Source:REALCOMP #215031652
Redfin Estimate
$667,645
$293K since sold in November 2015$18K since July
Recently sold homes
Estimate history
Homes for sale
This home's estimate is 26.4% higher than the average sale price ($528K) of 6 comparable homes.
Sharp remodeled colonial in a great area north of Rochester. Amazing granite kitchen with all new stainless steel appliances, lots of cabinet space, breakfast bar, and a separate pantry closet. Large cathedral ceiling family room with a fireplace, a granite wet bar, and a doorwall out to the back deck. There are 4 generous bedrooms including a huge master suite. The large master bath has both a shower and whirlpool tub. There is a full finished basement, and a huge oversized 2 car attached garage that will fit at least 3 cars. There is a double wide driveway with a basketball post at the back. The home has a Generac backup generator system to protect against power outages. First floor laundry room, home office or den off the foyer, formal dining room, fresh paint throughout, excellent flooring, and much more. Owners will consider Land Contract terms. Call us today to see this beautiful home for yourself.
Greater Lansing AoR #21154733
May 15, 2015
Sold
$375,000
$93/sq ft
May 5, 2015
Listing Removed
—
Apr 8, 2015
Listed
$399,900
$99/sq ft
Apr 8, 2015
Listed
$399,900
$99/sq ft
REALCOMP #215024825
Apr 2, 2015
Listing Removed
—
Mar 23, 2015
Listed
$398,777
$99/sq ft
MiRealSource-MiMLS #21094686
Apr 2, 2015
Listing Removed
—
Apr 2, 2015
Listing Removed
—
Mar 23, 2015
Listed
$398,777
$99/sq ft
REALCOMP #215003236
Mar 13, 2015
Listing Removed
—
Jan 12, 2015
Listed
$394,900
$98/sq ft
MiRealSource-MiMLS #31226044
Mar 13, 2015
Listing Removed
—
Jan 12, 2015
Listed
$394,900
$98/sq ft
MiRealSource-MiMLS #21098081
Jan 9, 2015
Listing Removed
—
Oct 17, 2014
Listed
$397,777
$99/sq ft
REALCOMP #214108619
Jan 9, 2015
Listing Removed
—
Oct 17, 2014
Listed
$397,777
$99/sq ft
MiRealSource-MiMLS #21104375
Apr 11, 2014
Listing Removed
—
Mar 17, 2014
Listed
$410,000
$102/sq ft
REALCOMP #214021708
Apr 11, 2014
Listing Removed
—
Mar 17, 2014
Listed
$410,000
$102/sq ft
Public Records
Mar 14, 2014
Sold
$255,000
$63/sq ft
MiRealSource-MiMLS #717193
Jun 30, 2009
Sold
$235,000
$58/sq ft
Jun 10, 2009
Listing Removed
—
May 5, 2009
Listed
$242,900
$60/sq ft
REALCOMP #29061752
Jun 30, 2009
Sold
$235,000
$58/sq ft
May 5, 2009
Listed
$242,900
$60/sq ft
Public Records
Jul 27, 1994
Sold
$206,000
$51/sq ft
MiRealSource-MiMLS #687982
Jul 11, 1994
Listing Removed
—
Jul 7, 1994
Sold
$206,000
$51/sq ft
Apr 18, 1994
Listed
$219,757
$54/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$6,467 (+3.2%)
2024
$6,267 (+5.0%)
2023
$5,966 (+2.5%)
2022
$5,818 (+7.3%)
2021
$5,425 (−6.3%)
2020
$5,788 (+1.1%)
2019
$5,727 (−0.4%)
2018
$5,748
2017
$5,749 (+0.5%)
2016
$5,721 (+28.0%)
2015
$4,471 (−27.3%)
2014
$6,146
Tax history for 5172 Aintree Rd
Year
Property tax
Land + Additions
Assessment*
2025
$6,467 (+3.2%)
2024
$6,267 (+5.0%)
2023
$5,966 (+2.5%)
2022
$5,818 (+7.3%)
2021
$5,425 (−6.3%)
2020
$5,788 (+1.1%)
2019
$5,727 (−0.4%)
2018
$5,748
2017
$5,749 (+0.5%)
2016
$5,721 (+28.0%)
2015
$4,471 (−27.3%)
2014
$6,146
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Property details
Interior
Basement Information
Basement Sq. Ft: 1,251
Basement Finish: Partially Finished
Bathroom Information
# of Full Baths: 3
Heating & Cooling
Air Conditioning Type: Central
Heating Fuel Type: Gas
Heating Type: Forced Air
Fireplace Information
# of Fireplaces: 1
Has Fireplace
Room Information
# of Rooms: 11
Exterior
Exterior Information
Building Style Type: Colonial
Exterior Wall: Brick Siding
Roof Covering Type: Asphalt
Roof Shape Type: Asphalt
Property Information
Subdivision Name: COACH LAMP HILLS 3
Living Sq. Ft: 4,034
Ground Floor Sq. Ft: 1,762
# of Units: 1
# of Stories: 2
Stories Type: 2
Legal Description: T4N, R11E, SEC 35 COACH LAMP HILLS NO 3 LOT 66
Parking & Garage Information
# of Parking Spaces: 2
Parking Type: Attached Garage
Garage/Parking Sq. Ft: 779
Garage / Carport Type: Attached
Lot Information
# of Buildings: 1
Land Sq. Ft: 19,602
Legal Lot Number: 66
Municipality Name: OAKLAND TOWNSHIP
Acres: 0.45
Zoning Code: SI
County Use Description: RESIDENTIAL IMPROVED
State Use Description: RESIDENTIAL
Utility Information
Sewer Type: Septic
Financial
Assessor Information
Assessment Year: 2025
Public facts
Beds: 4
Baths: 3.0
Sq. Ft.: 4,034
Stories: 2.0
Lot Size: 0.45 acres
Style: Single Family Residential
Year Built: 1976
Year Renovated: 1990
County: Oakland County
APN: N -10-35-152-031
Home facts updated by county records on Aug 13, 2026
Around this home
Schools
Hugger Elementary School
Public PreK-5 • Assigned • 0.3mi
9/10
Hart Middle School
Public PreK-12 • Assigned • 1.6mi
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
2/10 Heat Factor
7 days above 96° expected this year, 15 days in 30 years
2/10 Wind Factor
Minor risk of severe winds over next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 4 days in 30 years
Provided by First Street
Historical weather
Rochester, MI • 48306
Average low and high temperatures (°F)
27
15
33
19
51
31
60
40
67
47
81
59
85
64
81
61
77
55
66
44
48
36
35
23
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.2 hours in
June and 2.4 hours in December, placing it below the
U.S. average for solar exposure.
9.2 hrs
2.4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$635,000 – $768,000
Reach more buyers when you sell with Redfin. Save up to $6,676 in fees.3 minutes to get started.