Seller's Agent in 2025
Barbara Zarantonello
Berkshire Hathaway HomeServices Kee Realty
(248) 891-7724
29 in this area
141 Total Sales
174 Aintree Rd Rochester, MI 48306
4
Beds
2.5
Baths
2,292
Sq Ft
20,038
Sq Ft Lot
Highlights
- Deck
- Stainless Steel Appliances
- 2 Car Attached Garage
- Hugger Elementary School Rated A
- Porch
- Attic Fan
About This Home
As of May 2025***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!
Last Agent to Sell the Property
Berkshire Hathaway HomeServices Kee Realty License #6501400436 Listed on: 05/02/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
Year Built
- Built in 1971 | Remodeled in 2016
Lot Details
- 0.46 Acre Lot
- Lot Dimensions are 136x147
- Sprinkler System
HOA Fees
- $10 Monthly HOA Fees
Home Design
- Split Level Home
- Tri-Level Property
- Brick Exterior Construction
- Block Foundation
- Slab Foundation
- Asphalt Roof
- Chimney Cap
Interior Spaces
- 2,292 Sq Ft Home
- Gas Fireplace
- Family Room with Fireplace
- Living Room with Fireplace
- Attic Fan
- Unfinished Basement
Kitchen
- Free-Standing Gas Range
- Microwave
- Dishwasher
- Stainless Steel Appliances
- Disposal
Bedrooms and Bathrooms
- 4 Bedrooms
Parking
- 2 Car Attached Garage
- Garage Door Opener
Outdoor Features
- Deck
- Rain Gutter Guard System
- Porch
Location
- Ground Level
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Natural Gas Water Heater
- Water Softener is Owned
Community Details
- Beth Lemke Association
- Coach Lamp Hills No 1 Subdivision
- The community has rules related to fencing
Listing and Financial Details
- Assessor Parcel Number 1035154004
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
May 2, 2025
Closed on
May 21, 2025
Sold by
Frye Stephen W and Frye Deborah E
Bought by
Butcher Ryan and Butcher Annmarie
Seller's Agent
Barbara Zarantonello
Berkshire Hathaway HomeServices Kee Realty
Buyer's Agent
Frank Van Maele
Top Agent Realty
List Price
$465,000
Sold Price
$530,000
Premium/Discount to List
$65,000
13.98%
Views
189
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$12,241
Avg. Annual Appreciation
-2.74%
Purchase Details
Closed on
Jun 24, 2019
Sold by
Frye Stephen W and Frye Deborah E
Bought by
Frye Stephen W and Frye Deborah E
Purchase Details
Closed on
Apr 22, 2019
Sold by
Frye Stephen W and Frye Deborah E
Bought by
Frye Stephen W and Frye Deborah E
Purchase Details
Closed on
Dec 16, 2014
Sold by
Frye Stephen W and Frye Deborah E
Bought by
Frye Stephen W and Revocabl Deborah E Frye
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $530,000 | Premier Title | |
| Warranty Deed | $530,000 | Premier Title | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 05/21/2025 05/21/25 | Sold | $530,000 | +14.0% | $231 / Sq Ft |
| 05/04/2025 05/04/25 | Pending | -- | -- | -- |
| 05/02/2025 05/02/25 | For Sale | $465,000 | -- | $203 / Sq Ft |
Source: Realcomp
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $3,108 | $189,090 | $0 | $0 |
| 2024 | $2,027 | $184,270 | $0 | $0 |
| 2023 | $1,949 | $162,280 | $0 | $0 |
| 2022 | $2,886 | $156,360 | $0 | $0 |
| 2021 | $2,690 | $148,690 | $0 | $0 |
| 2020 | $1,883 | $143,090 | $0 | $0 |
| 2019 | $2,841 | $137,050 | $0 | $0 |
| 2018 | $2,851 | $130,110 | $0 | $0 |
| 2017 | $2,808 | $129,700 | $0 | $0 |
| 2016 | $2,793 | $128,880 | $0 | $0 |
| 2015 | -- | $118,610 | $0 | $0 |
| 2014 | -- | $112,640 | $0 | $0 |
| 2011 | -- | $94,930 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Barbara Zarantonello
-
Frank Van Maele
Buyer's Agent in 2025
Frank Van Maele
Top Agent Realty
(248) 302-6745
1 in this area
73 Total Sales
Map
Source: Realcomp
MLS Number: 20250017293
APN: 10-35-154-004
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
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.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393
Nearby Homes
- 133 Flumerfelt Ln
- 5718 Sheldon Rd
- 6601 Rochester Rd
- 451 Oak Arbor Cir E
- 4647 Applewood Ct
- 0000 Jendean Ln
- 2792 Enclave Dr
- 2774 Enclave Dr
- 4165 Oak Arbor Ct Unit 19
- 6022 Orion Rd
- 534 Parkland Hills Dr Unit 12
- 1364 Tranquility Ct
- 6589 Orion Rd
- 303 E Snell Rd
- 966 Majestic
- 877 Quarry
- 1600 Mill Race
- 1395 Crescent Ln
- 1133 Tienken Ct
- 3960 Harvest Creek Ct
Your Personal Tour Guide
Ask me questions while you tour the home.