The pool is open & ready for summer fun! This stately 3261 sq ft colonial is situated deep within popular Coach Lamp Hills sub on a scenic 1/2 acre lot. Foyer features beautiful hardwood flooring & sweeping spiral staircase. Large living room & formal dining room for entertaining, plus spacious family room w/ wonderful view of backyard & creek! Kitchen has great cabinet & counter space w/ center island & large dining area overlooking yard. Main floor library/office. Newly remodeled main floor laundry room. Upstairs features spacious primary suite w/ full bath, dual sinks & vanities plus extra vanity, walk-in-closet plus bonus closet. Additional bedrooms all good sized, 2 with walk-in-closet. Finished daylight basement provides even more living space. New Timbertech deck off family rm & kitchen w/ steps down to inground pool. Great curb appeal w/ new circular driveway. New pool heater 2019, roof 2013. Close to Stony Creek Metropark & Downtown Rochester. Award-winning Rochester Schools!
Single-familyProperty Type
1977Year Built
0.49 acresLot Size
$197Est. Price/Sq.Ft.
2 car garageParking
Listed by Barbara Zarantonello• Berkshire Hathaway HomeServices Kee Realty
•248-651-1200 (broker)
•john@keerealty.com (broker)
Bought with Holly Hohnholt• Berkshire Hathaway HomeServices Kee Realty
The pool is open & ready for summer fun! This stately 3261 sq ft colonial is situated deep within popular Coach Lamp Hills sub on a scenic 1/2 acre lot. Foyer features beautiful hardwood flooring & sweeping spiral staircase. Large living room & formal dining room for entertaining, plus spacious family room w/ wonderful view of backyard & creek! Kitchen has great cabinet & counter space w/ center island & large dining area overlooking yard. Main floor library/office. Newly remodeled main floor laundry room. Upstairs features spacious primary suite w/ full bath, dual sinks & vanities plus extra vanity, walk-in-closet plus bonus closet. Additional bedrooms all good sized, 2 with walk-in-closet. Finished daylight basement provides even more living space. New Timbertech deck off family rm & kitchen w/ steps down to inground pool. Great curb appeal w/ new circular driveway. New pool heater 2019, roof 2013. Close to Stony Creek Metropark & Downtown Rochester. Award-winning Rochester Schools!
REALCOMP #2220029426
Jun 21, 2022
Sold
$555,000
$170/sq ft
May 15, 2022
Pending
—
May 13, 2022
Listed
$535,000
$164/sq ft
May 11, 2022
Coming Soon
$535,000
$164/sq ft
The pool is open & ready for summer fun! This stately 3261 sq ft colonial is situated deep within popular Coach Lamp Hills sub on a scenic 1/2 acre lot. Foyer features beautiful hardwood flooring & sweeping spiral staircase. Large living room & formal dining room for entertaining, plus spacious family room w/ wonderful view of backyard & creek! Kitchen has great cabinet & counter space w/ center island & large dining area overlooking yard. Main floor library/office. Newly remodeled main floor laundry room. Upstairs features spacious primary suite w/ full bath, dual sinks & vanities plus extra vanity, walk-in-closet plus bonus closet. Additional bedrooms all good sized, 2 with walk-in-closet. Finished daylight basement provides even more living space. New Timbertech deck off family rm & kitchen w/ steps down to inground pool. Great curb appeal w/ new circular driveway. New pool heater 2019, roof 2013. Close to Stony Creek Metropark & Downtown Rochester. Award-winning Rochester Schools!
Public Records
Aug 6, 2003
Sold
$389,000
$119/sq ft
MiRealSource-MiMLS #822819
Jun 16, 2003
Sold
$389,900
$120/sq ft
May 2, 2003
Listing Removed
—
Aug 10, 2002
Listed
$419,900
$129/sq ft
REALCOMP #22072815
Jun 16, 2003
Sold
$389,900
$120/sq ft
Aug 10, 2002
Listed
$419,900
$129/sq ft
Public Records
Jul 19, 1994
Sold
$237,000
$73/sq ft
MiRealSource-MiMLS #720856
Jun 17, 1994
Sold
$237,000
$73/sq ft
Feb 21, 1994
Listed
$244,900
$75/sq ft
Public Records
Jun 7, 1990
Sold
$225,000
$69/sq ft
Public Records
Feb 1, 1977
Sold
$96,690
$30/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$11,000 (+1.0%)
2024
$10,896 (+7.3%)
2023
$10,155 (+137.3%)
2022
$4,279 (+7.3%)
2021
$3,989 (−5.6%)
2020
$4,224 (+1.1%)
2019
$4,179 (−0.4%)
2018
$4,195 (+1.6%)
2017
$4,131 (+0.5%)
2016
$4,109 (−1.3%)
2015
$4,164
2014
$4,168
Tax history for 5246 AINTREE Rd
Year
Property tax
Land + Additions
Assessment*
2025
$11,000 (+1.0%)
2024
$10,896 (+7.3%)
2023
$10,155 (+137.3%)
2022
$4,279 (+7.3%)
2021
$3,989 (−5.6%)
2020
$4,224 (+1.1%)
2019
$4,179 (−0.4%)
2018
$4,195 (+1.6%)
2017
$4,131 (+0.5%)
2016
$4,109 (−1.3%)
2015
$4,164
2014
$4,168
*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
Permits
Beds
4
Baths
2.5
Stories
2
Lot width
—
Lot depth
—
Lot size
0.49 Acres
Year renovated
1984
Sq. Ft.
3,261
Year built
1977
Style
Single Family Residential
County
Oakland County
APN
N -10-35-152-039
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 13, 2026.
Jan 19, 2024 • Final
Building
Remodel
Aug 15, 2012 • Final
Mechanical
HVAC
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking/Garage Information
Has Garage
# of Parking Spaces in Garage: 2.5
Garage Type: Attached Garage, Electric In Garage, Gar Door Opener, Side Loading Garage