This beautifully maintained 5-bedroom, 3-bathroom brick bi-level with outstanding curb appeal sits on a private, treed, nearly half-acre lot in the coveted Coachlamp Hills neighborhood within the award-winning Rochester School District. The main level impresses with a sun-drenched living room and dining room showcasing gorgeous hardwood floors, plus a modern kitchen featuring maple cabinetry, a center island, pantry with pullouts, high-end built-in appliances, sleek black granite countertops, and recessed and under-cabinet lighting - all opening through a newer Andersen door wall to a two-level deck that steps down to your private backyard oasis. The spacious primary suite offers a cozy fireplace, two closets including a walk-in, and a beautifully updated ensuite with a custom ceramic shower, while two additional bedrooms and a second updated full bath complete the main level. The expansive lower level delivers a second family room with fireplace, two more bedrooms, a third full bath, a laundry room, and a four-season heated sunroom currently used as a home office. Three new windows in the sunroom (2026), generator inlet, AC and Furnace (2013). Outside, a 24x40 heated gunite pool with attached spa and covered gazebo creates the ultimate entertaining backdrop, perfectly complementing this home's refined indoor living - all just minutes from downtown Rochester's restaurants and shopping.
Est. $3,191 per month, based on comparable rentals
Sale and tax history for 117 Coachlamp Rd
Sale History
Tax History
Date
Event
Price
REALCOMP #20261030886
Jun 16, 2026
Sold
$545,000
$191/sq ft
May 14, 2026
Pending
—
May 6, 2026
Listed
$545,000
$191/sq ft
This beautifully maintained 5-bedroom, 3-bathroom brick bi-level with outstanding curb appeal sits on a private, treed, nearly half-acre lot in the coveted Coachlamp Hills neighborhood within the award-winning Rochester School District. The main level impresses with a sun-drenched living room and dining room showcasing gorgeous hardwood floors, plus a modern kitchen featuring maple cabinetry, a center island, pantry with pullouts, high-end built-in appliances, sleek black granite countertops, and recessed and under-cabinet lighting — all opening through a newer Andersen door wall to a two-level deck that steps down to your private backyard oasis. The spacious primary suite offers a cozy fireplace, two closets including a walk-in, and a beautifully updated ensuite with a custom ceramic shower, while two additional bedrooms and a second updated full bath complete the main level. The expansive lower level delivers a second family room with fireplace, two more bedrooms, a third full bath, a laundry room, and a four-season heated sunroom currently used as a home office. Three new windows in the sunroom (2026), generator inlet, AC and Furnace (2013). Outside, a 24x40 heated gunite pool with attached spa and covered gazebo creates the ultimate entertaining backdrop, perfectly complementing this home's refined indoor living — all just minutes from downtown Rochester's restaurants and shopping.
MiRealSource-MiMLS #60990423
Jun 16, 2026
Sold
$545,000
$191/sq ft
May 14, 2026
Pending
—
May 6, 2026
Listed
$545,000
$191/sq ft
This beautifully maintained 5-bedroom, 3-bathroom brick bi-level with outstanding curb appeal sits on a private, treed, nearly half-acre lot in the coveted Coachlamp Hills neighborhood within the award-winning Rochester School District. The main level impresses with a sun-drenched living room and dining room showcasing gorgeous hardwood floors, plus a modern kitchen featuring maple cabinetry, a center island, pantry with pullouts, high-end built-in appliances, sleek black granite countertops, and recessed and under-cabinet lighting - all opening through a newer Andersen door wall to a two-level deck that steps down to your private backyard oasis. The spacious primary suite offers a cozy fireplace, two closets including a walk-in, and a beautifully updated ensuite with a custom ceramic shower, while two additional bedrooms and a second updated full bath complete the main level. The expansive lower level delivers a second family room with fireplace, two more bedrooms, a third full bath, a laundry room, and a four-season heated sunroom currently used as a home office. Three new windows in the sunroom (2026), generator inlet, AC and Furnace (2013). Outside, a 24x40 heated gunite pool with attached spa and covered gazebo creates the ultimate entertaining backdrop, perfectly complementing this home's refined indoor living - all just minutes from downtown Rochester's restaurants and shopping.
REALCOMP #2220037291
Jul 22, 2022
Sold
$425,000
$149/sq ft
Jun 15, 2022
Pending
—
Jun 8, 2022
Price Changed
$425,000
$149/sq ft
Jun 8, 2022
Relisted
—
Jun 3, 2022
Contingent
—
May 19, 2022
Listed
$450,000
$158/sq ft
May 18, 2022
Coming Soon
$450,000
$158/sq ft
MiRealSource-MiMLS #60097161
Jul 22, 2022
Sold
$425,000
$149/sq ft
Jun 15, 2022
Pending
—
Jun 8, 2022
Price Changed
$425,000
$149/sq ft
Jun 8, 2022
Relisted
—
Jun 3, 2022
Contingent
—
May 19, 2022
Listed
$450,000
$158/sq ft
May 18, 2022
Coming Soon
$450,000
$158/sq ft
May 17, 2022
Listed
$425,000
$149/sq ft
Public Records
Mar 23, 2020
Sold
$379,000
$133/sq ft
MiRealSource-MiMLS #40015551
Mar 6, 2020
Sold
$379,900
$133/sq ft
Feb 7, 2020
Pending
—
Jan 13, 2020
Listed
$379,900
$133/sq ft
REALCOMP #2200003366
Mar 6, 2020
Sold
$379,900
$133/sq ft
Feb 7, 2020
Pending
—
Jan 13, 2020
Listed
$379,900
$133/sq ft
MiRealSource-MiMLS #21656075
Jan 5, 2020
Listing Removed
—
Nov 19, 2019
Price Changed
$399,999
$140/sq ft
Oct 22, 2019
Price Changed
$410,500
$144/sq ft
Sep 12, 2019
Listed
$425,500
$149/sq ft
REALCOMP #219092790
Jan 5, 2020
Listing Removed
—
Nov 18, 2019
Price Changed
$399,999
$140/sq ft
Oct 22, 2019
Price Changed
$410,500
$144/sq ft
Sep 12, 2019
Listed
$425,500
$149/sq ft
Public Records
May 26, 1993
Sold
$165,000
$58/sq ft
Public Records
Jan 16, 1990
Sold
$200,000
$70/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$5,015 (+3.2%)
2024
$4,860 (+5.0%)
2023
$4,627 (+3.2%)
2022
$4,483 (+7.3%)
2021
$4,180 (+17.0%)
2020
$3,572 (+1.1%)
2019
$3,534 (−0.4%)
2018
$3,547 (+1.6%)
2017
$3,493 (+0.5%)
2016
$3,474 (−1.3%)
2015
$3,521 (−0.1%)
2014
$3,525
2013
$3,527
Public record
Public record
Permits
Beds
5
Baths
3
Stories
—
Lot width
—
Lot depth
—
Lot size
0.46 Acres
Year renovated
1982
Sq. Ft.
2,847
Year built
1973
Style
Single Family Residential
County
Oakland County
APN
N -10-35-152-002
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 25, 2026.
Jun 9, 2001 • Final
Plumbing
Replace the water heater.
Plumbing
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking/Garage Information
Has Garage
Garage Dimensions: 21x29
# of Parking Spaces in Garage: 2.5
Garage Type: Attached Garage, Electric In Garage, Gar Door Opener, Side Loading Garage, Workshop, Direct Access