Save
Ask
Tour
Hide
Share
$1,050,000
57 Days On Site

861 QUARRY
Rochester Hills City, MI 48306

For Sale|Single Family Residence|Active
6
Beds
6
Total Baths
4
Full Baths
2
Partial Baths
4,914
SqFt
$214
/SqFt
2005
Built
Subdivision:
CLEAR CREEK SUB NO 3
County:
Oakland
861 QUARRY861 QUARRY861 QUARRY861 QUARRY
Save
Ask
Tour
Hide
Share

Discover luxury, space, and entertainment at its finest in this stunning custom-built home located in the highly coveted Clear Creek Subdivision of Rochester Hills. Boasting over 7,000 square feet of beautifully finished living space, this home offers a remarkable floor plan designed for both everyday comfort and elegant entertaining. Step into a grand foyer with a sweeping staircase that sets the tone for the craftsmanship and upgrades throughout. Rich hardwood floors and ceramic tile flow through the expansive main level, featuring a large great room with a dramatic balcony overlook and a two-sided fireplace connecting to a cozy hearth room. The gourmet kitchen is a chef’s dream—complete with a massive center island, premium finishes, and ample space for gathering. Enjoy your favorite drink in the custom pub area, perfect for hosting guests in style. Upstairs, find generously sized bedrooms including a bonus room housing the sixth bedroom. The finished walkout lower level is a true retreat, offering a spacious family room, rec area, exercise room, home theater, and a luxurious in-law or nanny suite with a full private bath. Extensive built-in cabinetry and storage make organization effortless. Outside, relax or entertain on the maintenance-free concrete and brick elevated patio, complete with a built-in fire pit and serene views of the ravine—your private outdoor oasis. Additional highlights include a three-car side-turn garage, award-winning Rochester Community Schools, and an unbeatable location near parks, trails, shopping, and dining. Schedule your private tour today!

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,050,000
Days On Site 
57 Days
Bedrooms 
6
Inside Area (SqFt) 
4,914 sqft
Total Baths 
6
Full Baths 
4
Partial Baths 
2
Lot Size 
0.34 Acres
Year Built 
2005
MLS® Number 
20250037199
Status 
Active
Property Tax 
$18,972
HOA/Condo/Coop Fees 
$43.75 monthly
Sq Ft Source 
Public Records
Friends & Family
Recent Activity
2 months agoListing first seen on site
2 months agoListing updated with changes from the MLS®
General Features
Acres 
0.34
Attached Garage 
Yes
Cross Street 
N of Tienken E of Sheldon
Disclosures 
Taxes Not Homestead Exempt
Garage 
Yes
Garage Spaces 
3
Parking 
AttachedGarage Faces Side
Pets 
Yes
Property Sub Type 
Single Family Residence
Security 
Smoke Detector(s)
Sewer 
Public Sewer
Special Circumstances 
Standard
SqFt Above 
4683
SqFt Below 
231
Stories 
Two
Style 
Colonial
Water Source 
Public
Interior Features
Appliances 
Gas Water HeaterDishwasherDisposalDryerExhaust FanFree-Standing RefrigeratorMicrowave
Basement 
FinishedFullWalk-Out Access
Cooling 
Ceiling Fan(s)Central Air
Fireplace 
Yes
Fireplace Features 
GasGreat RoomKitchen
Furnished 
Negotiable
Heating 
Exhaust FanForced AirNatural Gas
Laundry Features 
Laundry Room
BathFull 
Dimensions - 8.00 x 7.00Level - Second
BathLav 
Dimensions - 5.00 x 5.00Level - Entry
Bedroom 
Dimensions - 16.00 x 13.00Level - Second
Bonus Room 
Dimensions - 18.00 x 14.00Level - Second
Dining Room 
Dimensions - 15.00 x 11.00Level - Entry
Kitchen 
Dimensions - 30.00 x 23.00Level - Entry
Laundry 
Dimensions - 10.00 x 6.00Level - Entry
Library 
Dimensions - 15.00 x 13.00Level - Entry
Master Bathroom 
Dimensions - 27.00 x 17.00Level - Second
Master Bedroom 
Dimensions - 16.00 x 12.00Level - Second
Media Room 
Dimensions - 22.00 x 12.00Level - Basement
SittingRoom 
Dimensions - 17.00 x 13.00Level - Entry
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Brick
Patio And Porch 
DeckPorchTerrace
Pool Features 
None
Roof 
Asphalt
Community Features
Association Dues 
525
Building Access 
GroundLevelwSteps
Financing Terms Available 
CashConventional
HOA Fee Frequency 
Annually
MLS Area 
Area02151RochesterHills
Roads 
Paved
School District 
Rochester
Schools
School District
Rochester
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of BHHS Michigan RE Great Lakes RH: 2482930000



IDX provided courtesy of Realcomp II Ltd. via RealcompIILtd. Copyright © 2025 Realcomp II Ltd. Shareholders.

IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing and that the data is deemed reliable but not guaranteed accurate by the MLS.

Neighborhood & Commute
Source: Walkscore
Community information and market data Powered by ATTOM Data Solutions. Copyright ©2019 ATTOM Data Solutions. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share