DON’T MISS THIS WONDERFULLY LOCATED 3237 SQ FT COLONIAL - THE BEST BUY IN OAKLAND TWP!! Recent updates include new carpet throughout, white kitchen, new flooring in foyer, plus fresh paint. Large entrance with spiral staircase. Extremely spacious throughout, the family room is especially large with lots of natural light, gas fireplace, & doorwalls to deck & patio. You'll love the expansive kitchen with plenty of cupboard & counter space, granite, huge island w/ seating, desk area, & lots of space for a good-sized kitchen table. Large master bdrm with en-suite & walk-in-closet, 3 additional bedrooms all very spacious. Formal dining room off of foyer & kitchen, plus formal living room for entertaining. Additional living space found in finished basement, complete with bar & 1/2 bath. Corner lot on 1/2 acre provides a large side-yard, with deck & patio in back for grilling and relaxing. Newer roof, windows have been replaced. Award-winning Rochester Schools & close to Downtown Rochester!
Single-familyProperty Type
1977Year Built
0.47 acresLot Size
$145Est. Price/Sq.Ft.
2 car garageParking
Listed by Barbara Zarantonello• Real Living Kee Realty-Rochester
Bought with Barbara Zarantonello• Real Living Kee Realty-Rochester
DON’T MISS THIS WONDERFULLY LOCATED 3237 SQ FT COLONIAL - THE BEST BUY IN OAKLAND TWP!! Recent updates include new carpet throughout, white kitchen, new flooring in foyer, plus fresh paint. Large entrance with spiral staircase. Extremely spacious throughout, the family room is especially large with lots of natural light, gas fireplace, & doorwalls to deck & patio. You'll love the expansive kitchen with plenty of cupboard & counter space, granite, huge island w/ seating, desk area, & lots of space for a good-sized kitchen table. Large master bdrm with en-suite & walk-in-closet, 3 additional bedrooms all very spacious. Formal dining room off of foyer & kitchen, plus formal living room for entertaining. Additional living space found in finished basement, complete with bar & 1/2 bath. Corner lot on 1/2 acre provides a large side-yard, with deck & patio in back for grilling and relaxing. Newer roof, windows have been replaced. Award-winning Rochester Schools & close to Downtown Rochester!
REALCOMP #219105622
Feb 25, 2020
Sold
$339,000
$84/sq ft
Jan 25, 2020
Pending
—
Jan 14, 2020
Price Changed
$345,000
$85/sq ft
Dec 10, 2019
Relisted
—
Dec 9, 2019
Pending
—
Oct 25, 2019
Listed
$350,000
$87/sq ft
DON’T MISS THIS WONDERFULLY LOCATED 3237 SQ FT COLONIAL - THE BEST BUY IN OAKLAND TWP!! Recent updates include new carpet throughout, white kitchen, new flooring in foyer, plus fresh paint. Large entrance with spiral staircase. Extremely spacious throughout, the family room is especially large with lots of natural light, gas fireplace, & doorwalls to deck & patio. You'll love the expansive kitchen with plenty of cupboard & counter space, granite, huge island w/ seating, desk area, & lots of space for a good-sized kitchen table. Large master bdrm with en-suite & walk-in-closet, 3 additional bedrooms all very spacious. Formal dining room off of foyer & kitchen, plus formal living room for entertaining. Additional living space found in finished basement, complete with bar & 1/2 bath. Corner lot on 1/2 acre provides a large side-yard, with deck & patio in back for grilling and relaxing. Newer roof, windows have been replaced. Award-winning Rochester Schools & close to Downtown Rochester!
Greater Lansing AoR #21640186
Sep 22, 2019
Listing Removed
—
Aug 5, 2019
Listed
$345,900
$86/sq ft
REALCOMP #219079497
Sep 23, 2019
Listing Removed
—
Aug 5, 2019
Listed
$345,900
$86/sq ft
Greater Lansing AoR #21582156
Aug 5, 2019
Listing Removed
—
Jun 28, 2019
Price Changed
$345,900
$86/sq ft
Mar 19, 2019
Listed
$359,900
$89/sq ft
REALCOMP #219022718
Aug 5, 2019
Listing Removed
—
Jun 28, 2019
Price Changed
$345,900
$86/sq ft
Mar 19, 2019
Listed
$359,900
$89/sq ft
Greater Lansing AoR #21501120
Mar 19, 2019
Listing Removed
—
Jan 12, 2019
Price Changed
$379,900
$94/sq ft
Sep 29, 2018
Price Changed
$385,000
$95/sq ft
Sep 14, 2018
Price Changed
$399,900
$99/sq ft
Sep 5, 2018
Listed
$445,000
$110/sq ft
REALCOMP #218086543
Mar 19, 2019
Listing Removed
—
Jan 11, 2019
Price Changed
$379,900
$94/sq ft
Sep 29, 2018
Price Changed
$385,000
$95/sq ft
Sep 14, 2018
Price Changed
$399,900
$99/sq ft
Sep 5, 2018
Listed
$445,000
$110/sq ft
Public Records
Jul 1, 1986
Sold
$155,500
$39/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$5,506 (+3.2%)
2024
$5,336 (+5.0%)
2023
$5,080 (+2.5%)
2022
$4,954 (+7.3%)
2021
$4,619 (+15.3%)
2020
$4,005 (−41.0%)
2019
$6,789 (+70.7%)
2018
$3,977 (+1.6%)
2017
$3,916 (+0.5%)
2016
$3,895 (−1.3%)
2015
$3,948 (−0.1%)
2014
$3,952
Tax history for 5118 Aintree Rd
Year
Property tax
Land + Additions
Assessment*
2025
$5,506 (+3.2%)
2024
$5,336 (+5.0%)
2023
$5,080 (+2.5%)
2022
$4,954 (+7.3%)
2021
$4,619 (+15.3%)
2020
$4,005 (−41.0%)
2019
$6,789 (+70.7%)
2018
$3,977 (+1.6%)
2017
$3,916 (+0.5%)
2016
$3,895 (−1.3%)
2015
$3,948 (−0.1%)
2014
$3,952
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
1
Baths
2.5
Stories
2
Lot width
—
Lot depth
—
Lot size
0.47 Acres
Year renovated
1984
Sq. Ft.
3,838
Year built
1977
Style
Single Family Residential
County
Oakland County
APN
N -10-35-101-008
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Nov 4, 2026.
Property details
Parking
Parking/Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 2.5
Parking Features: Attached, Paved, Garage Door Opener, Garage Faces Side
Interior
Bathroom Information
# of Full Bathrooms: 2
# of Half Bathrooms: 2
Heating & Cooling
Has Cooling
Cooling: Ceiling Fan(s), Central Air
Has Heating
Heating: Forced Air, Natural Gas
Interior Features
Interior Features: Bar
Appliances: Dishwasher, Disposal, Refrigerator, Range, Oven, Gas Water Heater
Has Fireplace
Fireplace Features: Family Room, Gas
Room Information
# of Rooms Total: 15
Has Basement
Basement Details: Finished
Exterior
Exterior Features
Patio And Porch Features: Patio, Deck, Porch
Building Information
Above Grade Finished Area: 3,237
Below Grade Finished Area: 800
# of Stories Total: 2
Construction Materials: Brick, Wood Siding
Property Features
Pets Allowed: Yes
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: Single Family
Lot Information
Lot Features: Corner Lot
Frontage Length: 207
Lot Size : 207x81x182x108
Lot Size Acres: 0.47
Financial
Tax Information
Tax Annual Amount: $5,326
Utilities
Utility Information
Utilities: Cable Available
Sewer: Septic Tank
Location
HOA Information
Has Homeowners Association
Association Fee: $80
Association Fee Frequency: Annually
Derived Association Fee (Monthly): $6.67
Schools Information
School District: Rochester Community School District
Location Information
Directions: Take Aintree E from Rochester Rd, home on corner of Aintree and Glengate
Subdivision Name: COACH LAMP HILLS NO 3
Cross Street: Mead
Public facts
Beds: 1
Baths: 2.5
Sq. Ft.: 3,838
Stories: 2.0
Lot Size: 0.47 acres
Style: Single Family Residential
Year Built: 1977
Year Renovated: 1984
County: Oakland County
APN: N -10-35-101-008
Home facts updated by county records on Nov 4, 2026
Other
Listing Information
List AOR: RealComp
Around this home
Schools
K - 12
Preschool & daycare
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°
65°
80°
59°
77°
53°
65°
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
$556,000 – $673,000
Reach more buyers when you sell with Redfin. Save up to $5,850 in fees.3 minutes to get started.