Model show condition colonial with walkout basement to wooded common area in highly sought after Clear Creek Development. All high end finishes throughout; Chef’s gourmet island kitchen with built-in commercial grade appliances; Entertainers’ premium 1st floor wet bar; Bridge overlooking 2-story foyer & great room; 2-way fireplace between great room & library; Beautiful hardwood floors throughout 1st & 2nd floor; Spacious primary suite with large walk-in closet & luxury bathroom; 3-other bedrooms all have private bath access; Huge deck overlooking wooded common area & lower brick paver patio with built-in fireplace; 4.5-car garage; Walkout basement is fully studded out and ready for final finishes.
Property Details
Price:
$1,175,000
MLS #:
58050174664
Status:
Active
Beds:
4
Baths:
5
Type:
Single Family
Subtype:
Single Family Residence
Subdivision:
CLEAR CREEK SUBDIVISION #3
Neighborhood:
02151rochesterhills
Listed Date:
May 14, 2025
Finished Sq Ft:
5,365
Year Built:
2004
See this Listing
Schools
School District:
Rochester
Interior
Appliances
BarFridge, Dishwasher, Disposal, Dryer, Humidifier, Microwave, Oven, Refrigerator, Range, Washer
Bathrooms
4 Full Bathrooms, 1 Half Bathroom
Cooling
Ceiling Fans, Central Air
Flooring
Hardwood
Heating
Forced Air, Humidity Control, Natural Gas
Exterior
Architectural Style
Colonial
Community Features
Sidewalks, Street Lights
Construction Materials
Brick
Exterior Features
Balcony, Outdoor Grill
Parking Features
Assigned2Spaces, FourCarGarage, Attached, ElectricityinGarage, Garage, GarageDoorOpener, Paved, SideEntrance
Financial
HOA Fee
$540
HOA Frequency
Annually
Taxes
$8,828
Map
Community
- Address877 Quarry DR Rochester Hills MI
- SubdivisionCLEAR CREEK SUBDIVISION #3
- CityRochester Hills
- CountyOakland
- Zip Code48306
Market Summary
Current real estate data for Single Family in Rochester Hills as of Oct 15, 2025
133
Single Family Listed
76
Avg DOM
219
Avg $ / SqFt
$672,385
Avg List Price
Property Summary
- Located in the CLEAR CREEK SUBDIVISION #3 subdivision, 877 Quarry DR Rochester Hills MI is a Single Family for sale in Rochester Hills, MI, 48306. It is listed for $1,175,000 and features 4 beds, 5 baths, and has approximately 5,365 square feet of living space, and was originally constructed in 2004. The current price per square foot is $219. The average price per square foot for Single Family listings in Rochester Hills is $219. The average listing price for Single Family in Rochester Hills is $672,385. To schedule a showing of MLS#58050174664 at 877 Quarry DR in Rochester Hills, MI, contact your LoChirco Realty, LLC agent at 586-321-9997.
Similar Listings Nearby
877 Quarry DR
Rochester Hills, MI