5165 Aintree Road

Accepting Backup Offers
Accepting Backup Offers
Traditional colonial with great curb appeal
4 bedroom, 3 1/2 bath
Side entry 2+ car garage
Large backyard
Welcoming entrance
0918A81C-FC9E-4C6C-9F99-3A186E1E0319.jpeg
Large foyer
Hardwood staircase & foyer
Living room - virtually staged
Living room
Dining room - virtually staged
Dining room
Large kitchen
Counter-seating
Stainless appliances
78DC09E8-7ED1-4324-9D3D-4AA93BBE2E35.jpeg
Hardwood flooring
2B39ACCC-FC18-4B1E-9EB0-C8D9441A69FC.jpeg
Pantry nook
Breakfast nook - virtually staged
Breakfast nook
Family room - virtually staged
Family room with gas fireplace
Family room - virtually staged
Family room, doorwall to deck
Main floor office
Main floor office
Full bath in main floor office
Hardwood flooring in upstairs hallway and bonus space
Bonus space at top of stairs
Primary suite - virtually staged
Primary suite
Primary suite has walk-in closet plus 2nd closet
Primary suite vanity & full bath
Primary full bath
Full bath upstairs with dual sinks
Bedroom #2
Bedroom #2
Bedroom #3
Bedroom #3
Bedroom #4
Bedroom #4 -walk in closet
Main floor laundry room, door to garage
Main floor 1/2 bath
Large deck off of family room
IMG_8047.jpeg
IMG_8043.jpeg
Large backyard
Wooded view from deck
Surrounded by mature trees
Quiet corner lot
Situated deep within CoachLamp Hills sub
Easy access to Stony Creek Metropark & Hugger Elementary
Whole house generator 2025
Full unfinished basement
IMG_7263.jpeg
Main floor
2nd floor
Basement
Accepting Backup Offers
$475,000
Est: $2,843/moGet pre-approved
4 beds2,641 sqft

5165 Aintree Road, Rochester, MI 48306

Description

First time on the market in 45 years! Nestled deep within popular CoachLamp Hills sub, this 4 bed / 3 1/2 bath colonial sits on a beautiful .45 acre tree-lined lot offering exceptional privacy! Lovingly cared for by its long time owners, the home offers a timeless, traditional layout with generously sized living & dining room plus large vaulted family room with cozy gas fireplace. The spacious kitchen features hardwood flooring, stainless appliances, butcher block countertops, counter seating, plenty...First time on the market in 45 years! Nestled deep within popular CoachLamp Hills sub, this 4 bed / 3 1/2 bath colonial sits on a beautiful .45 acre tree-lined lot offering exceptional privacy! Lovingly cared for by its long time owners, the home offers a timeless, traditional layout with generously sized living & dining room plus large vaulted family room with cozy gas fireplace. The spacious kitchen features hardwood flooring, stainless appliances, butcher block countertops, counter seating, plenty of cabinet & counter space, pantry, plus bright dining area. Main floor office is complimented by an attached full bath, providing excellent flexibility for use as a 1st floor bedroom, guest room, or work from home space. Upstairs, the spacious primary suite offers ensuite bath w/separate vanity area, walk-in closet plus extra 2nd closet. Three additional bedrooms are all very generously sized, & the upstairs bonus space is perfect for hobbies or 2nd office. Outdoors, the large deck overlooks the beautiful tree-lined backyard with garden area plus lots of room for games & entertaining. Additional highlights include a full unfinished basement ready for your vision, main floor laundry, hardwood staircase, & replacement windows. For added peace of mind, a brand new septic field has just been installed Nov. 2026. Whole house generator 2025. Hwt 2022. Unbeatable location with award-winning Rochester Community Schools (Hugger, Hart, Stoney Creek) & just minutes from Downtown Rochester & Stony Creek Metro Park. Don’t miss this rare opportunity to make a cherished home your very own with keys at closing!
Single FamilyProperty Type
0.45 acresLot Size
1975Year Built
$180/sq ftPrice per sq ft
$150/yrHOA Fees
2 carsParking Spaces
  • Listed by: Barbara Zarantonello 248.891.7724 barbzhomes@gmail.com Brokerage DRE #650536295003 • Berkshire Hathaway HomeServices Kee Realty
Last updated: 11/14/2026 07:33 PM
Source: Realcomp, MLS#: 20261065139
9 days on Market
See It First™ on Compass

Find homes before they're listed on other real estate sites.

Start your search

Location

Add your commute
Property Calculator

Get preapproved with Rocket Mortgage1

$2,843 per month

Principal and Interest

$2,536

Property Taxes

$294

HOA Dues

$13

The Payment Calculator is for illustrative purposes only.
Get prequalified

Property information

5165 Aintree Road

Property Details

  • Taxes: $3,532 / year
  • MLS Type: Residential / Single Family Residence
  • County: Oakland County
  • Subdivision Name: Coach Lamp Hills 3
  • Architectural Style: Colonial
  • Waterfront: No
  • Senior Community: No

Building Information

  • Year Built: 1975
  • Lot Size: 0.45 AC / 19,602 SF

Summary

Location and General Information

  • Carrier Route: R061
  • Directions: From Rochester Rd, go E on Aintree
  • Latitude: 42.72353
  • Longitude: -83.130793
  • Township: Oakland Oakland Twp
  • Cross Street: E of Rochester Rd, S of Snell
  • MLS Area Major: Oakland Twp (63101)

Taxes and HOA

  • Association Fee: $150.00
  • Association Phone: lemke5049@comcast.net
  • Parcel Number: 1035156001
  • Tax Amount Summer: $2,310.00
  • Tax Amount Winter: $1,222.00
  • Tax Annual Amount: $3,532.00
  • Tax Assessed Value: $144,850.00
  • Tax Legal Description: T4N, R11E, SEC 35 COACH LAMP HILLS NO 3 LOT 83
  • Association Fee Frequency: Annually
  • Association Contact: Beth Lemke
  • Association: Yes

School Information

  • High School District: Rochester

Parking

  • Garage Spaces: 2.5
  • Attached Garage: Yes
  • Garage: Yes
  • Parking Features: Twoand Half Car Garage, Attached, Garage Door Opener, Side Entrance

Property

Lot Information

  • Frontage Length: 110.0
  • Lot Size Acres: 0.45
  • Lot Size Dimensions: 110x163x128x155
  • Lot Size Units: Acres
  • Road Frontage Feet: 110
  • Road Frontage Type: Paved

Property and Assessments

  • State Equalized Value: 233730.0
  • Living Area: 2641.0
  • Building Area Total: 3807.0
  • Above Grade Finished Area: 2641.0
  • Above Grade Finished Area Units: Square Feet
  • Below Grade Total Area: 1166.0
  • Class Name: Residential
  • Living Area Source: Public Records
  • New Construction: No
  • Year Built: 1975

Building Features

  • Accessibility Features: Standby Generator
  • Construction Materials: Brick, Vinyl Siding
  • Entry Location: Ground Levelw Steps
  • Foundation Details: Basement, Poured, Sump Pump
  • Levels: Two
  • Roof: Asphalt
  • Stories Total: 2

Utilities

  • Sewer: Septic Tank
  • Water Source: Community

Interior and Exterior Features

Interior Features

  • Bathrooms Total Notational: 3.1
  • Appliances: Dishwasher, Dryer, Free Standing Electric Range, Free Standing Refrigerator, Stainless Steel Appliances, Washer
  • Basement: Full, Unfinished
  • Has Basement: Yes
  • Bathrooms Full: 3
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 4
  • Bedrooms Total: 4
  • Cooling: Central Air
  • Has Cooling: Yes
  • Fireplace Features: Family Room, Gas
  • Fireplace: Yes
  • Heating: Forced Air, Natural Gas
  • Has Heating: Yes
  • Laundry Features: Laundry Room
  • Rooms Total: 10
  • Water Heater Fuel: Natural Gas

Exterior Features

  • Exterior Features: Chimney Caps, Gutter Guard System
  • Fencing: Fencingnot Allowed
  • Patio And Porch Features: Deck, Porch
  • Pool Private: No

Room Information

Room 1

  • Room Description: Carpet
  • Room Dimensions: 20 X 13
  • Room Length: 20.0
  • Room Width: 13.0
  • Room Flooring: Carpet
  • Room Level: Entry
  • Room Type: Dining Room

Room 2

  • Room Description: Carpet
  • Room Dimensions: 22 X 11
  • Room Length: 22.0
  • Room Width: 11.0
  • Room Flooring: Wood
  • Room Level: Second
  • Room Type: Bedroom 2

Room 3

  • Room Description: Carpet
  • Room Dimensions: 12 X 12
  • Room Length: 12.0
  • Room Width: 12.0
  • Room Flooring: Carpet
  • Room Level: Second
  • Room Type: Bedroom 3

Room 4

  • Room Dimensions: 18 X 12
  • Room Length: 18.0
  • Room Width: 12.0
  • Room Flooring: Carpet
  • Room Level: Entry
  • Room Type: Lavatory1

Room 5

  • Room Description: Carpet
  • Room Dimensions: 12 X 10
  • Room Length: 12.0
  • Room Width: 10.0
  • Room Flooring: Carpet
  • Room Level: Entry
  • Room Type: Family Room

Room 6

  • Room Description: Ceramic
  • Room Dimensions: 10x5
  • Room Length: 10.0
  • Room Width: 5.0
  • Room Flooring: Wood
  • Room Level: Entry
  • Room Type: Laundry

Room 7

  • Room Dimensions: 10 X 5
  • Room Length: 10.0
  • Room Width: 5.0
  • Room Flooring: Ceramic Tile
  • Room Level: Entry
  • Room Type: Library

Room 8

  • Room Description: Carpet
  • Room Dimensions: 18 X 12
  • Room Length: 18.0
  • Room Width: 12.0
  • Room Flooring: Carpet
  • Room Level: Second
  • Room Type: Bedroom 1

Room 9

  • Room Description: Carpet
  • Room Dimensions: 12 X 11
  • Room Length: 12.0
  • Room Width: 11.0
  • Room Flooring: Carpet
  • Room Level: Second
  • Room Type: Bedroom 4

Room 10

  • Room Description: Carpet
  • Room Dimensions: 11 X 10
  • Room Length: 11.0
  • Room Width: 10.0
  • Room Flooring: Carpet
  • Room Level: Entry
  • Room Type: Living Room

Room 11

  • Room Description: Wood
  • Room Dimensions: 14 X 10
  • Room Length: 14.0
  • Room Width: 10.0
  • Room Flooring: Carpet
  • Room Level: Entry
  • Room Type: Bathroom 1

Room 12

  • Room Description: Ceramic
  • Room Flooring: Ceramic Tile
  • Room Level: Second
  • Room Type: Bathroom 2

Agent

Sale and Listings

  • Public GLR Website: Yes

Rental

Rent Information

  • Existing Lease: No

Property History

5165 Aintree Road

DateEventPrice
Nov 15, 2026

Contract Out

MiRealSource #61044755

—
Nov 14, 2026

Contract Out

Realcomp #20261065139

—
Nov 7, 2026

Listed (Active)

Realcomp #20261065139

$475,000
DateEventPrice
11/15/2026

Contract Out

MiRealSource #61044755

—
11/14/2026

Contract Out

Realcomp #20261065139

—
11/07/2026

Listed (Active)

Realcomp #20261065139

$475,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public records

5165 Aintree Road

Beds

4

Baths

2.5

Total Finished SqFt

2,641 SqFt

Above Grade Finished SqFt

2,641 SqFt

Unfinished Basement SqFt

1,166 SqFt

Stories

2

Schools

Near 5165 Aintree Road

This home is within Rochester Community School District.

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Know your buying power with a preapproval and custom rate in minutes
Rocket Mortgage1

Similar Homes

New listings in 48306

$485,000 | 1719 North Fairview Lane, Rochester, MI 48306
1/41
Open: 11/15 01:00PM - 03:00PM

$485,000

3
Bedrooms
1,776
Square Feet
0.28
Acres

1719 North Fairview Lane, Rochester, MI 48306

$425,000 | 144 Ann Maria Drive, Rochester Hills, MI 48306
1/44

$425,000

3
Bedrooms
1,800
Square Feet
0.55
Acres

144 Ann Maria Drive, Rochester Hills, MI 48306

$299,900 | 3436 Tremonte Circle, Rochester, MI 48306
1/19
Open: 11/15 01:00PM - 03:00PM

$299,900

2
Bedrooms
1,533
Square Feet

3436 Tremonte Circle, Rochester, MI 48306

$1,275,000 | 899 Majestic Drive, Rochester Hills, MI 48306
1/44
Open: 11/15 01:00PM - 03:00PM

$1,275,000

4
Bedrooms
6,936
Square Feet
0.36
Acres

899 Majestic Drive, Rochester Hills, MI 48306

$649,900 | 4060 Norwich Court, Rochester, MI 48306
1/32
Open: 11/15 01:00PM - 03:00PM

$649,900

4
Bedrooms
3,180
Square Feet
0.47
Acres

4060 Norwich Court, Rochester, MI 48306

$1,425,000 | 1619 Glacial Court, Rochester Hills, MI 48306
1/46

$1,425,000

4
Bedrooms
4,672
Square Feet
0.42
Acres

1619 Glacial Court, Rochester Hills, MI 48306

$2,190,000 | 255 Camelot Way, Rochester, MI 48306
1/64

$2,190,000

5
Bedrooms
8,518
Square Feet
2.59
Acres

255 Camelot Way, Rochester, MI 48306

$650,000 | 3526 Inverness Drive, Rochester, MI 48306
1/52

$650,000

4
Bedrooms
3,108
Square Feet
0.44
Acres

3526 Inverness Drive, Rochester, MI 48306

$4,150,000 | 2520 Creekside Court, Rochester, MI 48306
1/35
Open: 11/15 12:00PM - 04:00PMNew Construction

$4,150,000

5
Bedrooms
6,990
Square Feet
0.56
Acres

2520 Creekside Court, Rochester, MI 48306

Explore Nearby Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Berkshire Hathaway HomeServices Kee Realty

IDX provided courtesy of Realcomp II Ltd. via Compass and its related brokerages. Copyright 2026 Realcomp II Ltd. Shareholders. IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. The data relating to real estate properties on this website was last updated on 11/14/2026 07:33 PM PST