Stately colonial located in popular Coach Lamp Hills sub situated on large lot with mature trees. Beautiful spacious kitchen with cherry cabinets, hardwood flooring, vaulted ceiling, center island & corian counters. Huge family rm off kitchen w/ gas fireplace, large windows, & doorwall to deck & scenic backyard. French doors to main floor office, plus L-shaped living room/dining room for more entertaining space. Crown molding in most rooms. Upstairs you’ll absolutely love the x-large master suite, complete w/ walk-in closet & gorgeous new master bath! Additional 3 bedrooms are all spacious, plus 2nd full bath is good-sized with double sinks. Convenient main floor laundry. Finished basement provides additional living space plus large area for storage. Beautiful lot located deep in the sub, stamped concrete driveway & walkway, new roof/siding/HWT 2014, plus 3-car garage. Award-winning Rochester Schools, close to Stony Creek Metropark & Downtown Rochester. 1 yr home warranty included!
Single-familyProperty Type
1976Year Built
0.4 acresLot Size
$182Est. Price/Sq.Ft.
3 car garageParking
Listed by Barbara Zarantonello• Real Living Kee Realty-Rochester
COUNTRY LIVING JUST 2 MILES FROM DOWNTOWN ROCHESTER! MATURE TREES SURROUND THIS STATELY HOME FEATURING MANY QUALITY UPDATES--NEWER STAMPED CONCRETE DRIVE, WALK, PORCH, LEADED GLASS FRONT DOORS & NEWER NO-MAINTENANCE DECK W/ PERGOLA & PLUMBED GAS GRILL--CORIAN COUNTERS, CROWN MOLDINGS, ORNAMENTAL WOODWORK THROUGHOUT--SELLERS WILL OFFER HOME WARRANTY & $2000 TOWARD BUYER CONCESSIONS.
Public Records
Feb 15, 2001
Sold
$336,000
$96/sq ft
Public Records
Oct 2, 1998
Sold
$315,000
$90/sq ft
REALCOMP #00840613
Aug 22, 1998
Listing Removed
—
Jun 20, 1998
Listed
$324,500
$93/sq ft
REALCOMP #00810116
Jun 12, 1998
Listing Removed
—
Feb 13, 1998
Listed
$330,000
$95/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$5,592 (+3.2%)
2024
$5,419 (+5.0%)
2023
$5,159 (+2.5%)
2022
$5,031 (+7.3%)
2021
$4,691 (+23.6%)
2020
$3,795 (+1.1%)
2019
$3,755 (−3.6%)
2018
$3,896 (+5.0%)
2017
$3,711 (+0.5%)
2016
$3,692 (−1.3%)
2015
$3,741 (−0.1%)
2014
$3,745
Tax history for 5164 Aintree Rd
Year
Property tax
Land + Additions
Assessment*
2025
$5,592 (+3.2%)
2024
$5,419 (+5.0%)
2023
$5,159 (+2.5%)
2022
$5,031 (+7.3%)
2021
$4,691 (+23.6%)
2020
$3,795 (+1.1%)
2019
$3,755 (−3.6%)
2018
$3,896 (+5.0%)
2017
$3,711 (+0.5%)
2016
$3,692 (−1.3%)
2015
$3,741 (−0.1%)
2014
$3,745
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
4
Baths
2.5
Stories
2
Lot width
—
Lot depth
—
Lot size
0.4 Acres
Year renovated
1983
Sq. Ft.
3,417
Year built
1976
Style
Single Family Residential
County
Oakland County
APN
N -10-35-152-030
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 13, 2026.
Property details
Parking
Parking/Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 3
Parking Features: Attached, Garage Door Opener, Garage Faces Side
Interior
Virtual Tour
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
Interior Features: High Speed Internet, Smart Thermostat
Appliances: Refrigerator, Gas Water Heater, Built-In Refrigerator, Dishwasher, Disposal, Dryer, Free-Standing Gas Range, Humidifier, Microwave, Washer
Flooring: Carpet, Ceramic Tile, Wood
Has Fireplace
Fireplace Features: Family Room, Gas
Room Information
# of Rooms Total: 11
Has Basement
Basement Details: Finished, Sump Pump
Exterior
Exterior Features
Exterior Features: Barbecue
Patio And Porch Features: Deck, Porch
Roof: Asphalt
Pool Information
Pool Features: None
Building Information
Entry Location: GroundLevelwSteps
Above Grade Finished Area: 2,971
Above Grade Finished Area Units: Square Feet
Below Grade Finished Area: 520
Below Grade Finished Area Units: Square Feet
Levels: Two
Construction Materials: Brick, Vinyl Siding
Has Home Warranty
Foundation Details: Block
Property Features
Green Indoor Air Quality: Contaminant Control
Pets Allowed: Yes
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: SingleFamilyResidence
Lot Information
Road Surface Type: Paved
Lot Size Dimensions: 155 x 174 x 50 x 170
Lot Size Area: 0.4
Lot Size Units: Acres
Lot Size Acres: 0.4
Financial
Tax Information
Tax Annual Amount: $3,754
Utilities
Utility Information
Sewer: Septic Tank
Location
HOA Information
Has Homeowners Association
Association Fee: $100
Association Fee Frequency: Annually
Derived Association Fee (Monthly): $8.33
Schools Information
High School District: Rochester
Location Information
Directions: From Rochester Rd turn east on Aintree
Subdivision Name: COACH LAMP HILLS NO 3
Cross Street: N of Mead/E of Rochester Rd
Public facts
Beds: 4
Baths: 2.5
Sq. Ft.: 3,417
Stories: 2.0
Lot Size: 0.4 acres
Style: Single Family Residential
Year Built: 1976
Year Renovated: 1983
County: Oakland County
APN: N -10-35-152-030
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.7mi
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
$604,000 – $731,000
Reach more buyers when you sell with Redfin. Save up to $6,356 in fees.3 minutes to get started.