174 Aintree Road

2,292 Sq. Ft.
$231 / Sq. Ft.
2,292
Sq. Ft.
$231
per Sq. Ft.

Description

Offer deadline sat. May 3 @ 7pm Welcome to this beautiful, fully updated tri-level located in Oakland Twp's popular Coach Lamp Hills sub! Situated on a .46 acre lot, this spacious 4 bedroom home is completely move-in ready! You'll love the modern kitchen with white cabinetry, quartz countertops, SS appliances, large island, & bright breakfast nook. Large living room with gas fireplace is full of natural light & opens to formal dining room. Relax around the cozy wood-burning fireplace in the comfortable...Offer deadline sat. May 3 @ 7pm Welcome to this beautiful, fully updated tri-level located in Oakland Twp's popular Coach Lamp Hills sub! Situated on a .46 acre lot, this spacious 4 bedroom home is completely move-in ready! You'll love the modern kitchen with white cabinetry, quartz countertops, SS appliances, large island, & bright breakfast nook. Large living room with gas fireplace is full of natural light & opens to formal dining room. Relax around the cozy wood-burning fireplace in the comfortable family room, with door leading to brick-paver patio in backyard. Very spacious primary suite offers full ensuite bath plus walk-in closet, with brand new carpet throughout the whole upper level. Beautiful hardwood flooring flows from foyer through kitchen & family room, and laundry is conveniently located just a few steps down from main level. This home has wonderful outdoor space, with an incredible custom cedar deck built in 2021 providing the ideal place to enjoy the private tree-lined backyard. Unique basement access is from the garage, making it perfect for a separate office space, workshop/hobby room, or gym. New furnace 2024, HWT 2018, roof approx 12 yrs old, all windows replaced. Award-winning Rochester Schools (Hugger, Hart, Stoney Creek). Fantastic location on quiet street close to Downtown Rochester & Stony Creek Metropark!
  1. Listed by Barbara Zarantonello • Berkshire Hathaway HomeServices Kee Realty
    P: (248)-891-7724 C: (248)-891-7724 barbzhomes@gmail.com

Property Details for 174 Aintree Road

Architectural Style
Split Level
Subdivision Name
COACH LAMP HILLS NO 1
Has Waterfront
No
LISTING CLOSED: 05/21/2025 12:00 AM

Property Details for 174 Aintree Road

StatusClosed
MLS #60389698
Days on Market5
Taxes$3,036 / year
HOA Fees$125 / year
Condo/Co-op Fees-
Property TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built1971
Lot Size0.46 AC / 20,037 SF
CountyOakland County

Location

Listing Courtesy of Berkshire Hathaway HomeServices Kee Realty

Sold By Top Agent Realty

Add your commute

Building Information for 174 Aintree Road

Stories-Year Built1971Building Size-Lot Size0.46 AC / 20,037 SF

Payment Calculator

$2,904 per month

30 year fixed, 6.36% Interest

Principal and Interest

$2,641

Property Taxes

$253

HOA Dues

$10

The Payment Calculator is for illustrative purposes only.

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

Rocket Mortgage1

Property Information for 174 Aintree Road

Summary
Location and General Information
  • Cross Street: E of Rochester Rd, S of S
  • Directions: From Rochester Rd, go E on Coach Lamp Rd, Turn R on Aintree
  • Latitude: 42.718939
  • Longitude: -83.132449
  • MLS Area Major: Oakland Twp (63101)
  • Senior Community: No
  • Township: Oakland Oakland Twp
Taxes and HOA
  • Association Fee: $125.00
  • Association Fee Frequency: Annually
  • Association Phone: Lemke5049@comcast.net
  • Association: Yes
  • Association Fee Monthly: $10.42
  • Parcel Number: 1035154004
  • Tax Annual Amount: $3,036.00
  • Tax Assessed Value: 126040
School Information
  • High School District: Rochester
Parking
  • Attached Garage: Yes
  • Garage Spaces: 2.0
  • Garage: Yes
  • Parking Features: Attached, Paved, Garage Door Opener, Garage Faces Side
Property
Lot Information
  • Frontage Length: 136.0
  • Lot Features: Sprinklers
  • Lot Size Acres: 0.46
  • Lot Size Area: 0.46
  • Lot Size Units: Acres
  • Lot Size Dimensions: 136x147
  • Road Frontage Type: Paved
Property and Assessments
  • Above Grade Finished Area: 2292.0
  • Building Area Total: 3090.0
  • Living Area: 2292.0
  • Living Area Source: Public Records
  • New Construction: No
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Year Built: 1971
Building Features
  • Construction Materials: Brick
  • Entry Location: Ground Levelw Steps
  • Foundation Details: Slab
  • Levels: Three Or More
  • Roof: Asphalt
Utilities
  • Sewer: Septic Tank
  • Water Source: Community
Interior and Exterior Features
Exterior Features
  • Exterior Features: Chimney Caps, Gutter Guard System
  • Fencing: Fencingnot Allowed
  • Patio And Porch Features: Deck, Porch
  • Private Pool: No
Interior Features
  • Appliances: Dishwasher, Disposal, Microwave, Refrigerator, Range, Oven, Gas Water Heater
  • Basement: Unfinished
  • Has Basement: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bathrooms: 3
  • Total Bedrooms: 4
  • Cooling: Central Air, Attic Fan
  • Has Cooling: Yes
  • Fireplace Features: Family Room, Gas, Living Room
  • Has Fireplace: Yes
  • Heating: Forced Air, Natural Gas
  • Has Heating: Yes
  • Total Rooms: 11
  • Water Heater: Gas
Room Information
Room 1
  • Description: Carpet
  • Dimensions: 19x13
  • Length: 19.0
  • Level: Entry
  • Type: Living Room
  • Width: 13.0
Room 2
  • Description: Carpet
  • Dimensions: 19x13
  • Length: 19.0
  • Level: Upper
  • Type: Bedroom 1
  • Width: 13.0
Room 3
  • Dimensions: 16x11
  • Length: 16.0
  • Level: Entry
  • Type: Kitchen
  • Width: 11.0
Room 4
  • Description: Carpet
  • Dimensions: 13x11
  • Length: 13.0
  • Level: Upper
  • Type: Bedroom 2
  • Width: 11.0
Room 5
  • Description: Ceramic
  • Length: 19.0
  • Level: Lower
  • Type: Bathroom 1
  • Width: 13.0
Room 6
  • Description: Carpet
  • Dimensions: 13x10
  • Length: 13.0
  • Level: Upper
  • Type: Bedroom 3
  • Width: 10.0
Room 7
  • Length: 13.0
  • Level: Lower
  • Type: Bedroom
  • Width: 10.0
Room 8
  • Description: Carpet
  • Dimensions: 13x10
  • Length: 13.0
  • Level: Upper
  • Type: Dining Room
  • Width: 10.0
Room 9
  • Description: Carpet
  • Dimensions: 13x10
  • Length: 13.0
  • Level: Upper
  • Type: Bedroom 4
  • Width: 10.0
Room 10
  • Description: Wood
  • Dimensions: 18x13
  • Length: 18.0
  • Level: Lower
  • Type: Family Room
  • Width: 13.0
Room 11
  • Level: Lower
  • Type: Bath Lav

Property History for 174 Aintree Road

DateEvent & SourcePriceAppreciation
May 21, 2025

Sold (Public Record)

Public Record #1558536728

$530,000
May 21, 2025

Sold

Realcomp #20250017293

$530,000
May 21, 2025

Sold

MiRealSource #60389698

$530,000
DateEvent & SourcePrice
05/21/2025

Sold (Public Record)

Public Record #1558536728

$530,000
05/21/2025

Sold

Realcomp #20250017293

$530,000
05/21/2025

Sold

MiRealSource #60389698

$530,000

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

Public Records for 174 Aintree Road

Taxable ValueLand-Additions-Total-
Tax Record2024$3,108 ($259 / month)
Home Facts
Beds3Baths2Total Finished SqFt2,292 SqFtAbove Grade Finished SqFt2,292 SqFtStories1Lot Size20,038 SqFtStyleSingle Family ResidenceYear Built1971ZoningSICountyOAKLANDAPNN -10-35-154-004Fireplace TypeHas Fireplace

Schools near 174 Aintree Road

This home is within Rochester Community School District.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 12
Public - 6 to 12
Public - 9 to 12
Rating
School
Distance
Hugger Elementary School
PublicPK to 5

Stoney Creek High School
Public6 to 12

Hart Middle School
Public6 to 12

John M Schultz Educational Campus
Public9 to 12

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.

Similar Homes

Nearby off-market 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

Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc.