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!
Sold for $840,000 on 12/08/25
$840,000
861 Quarry, Rochester Hills, MI 48306
6beds
4,914sqft
Single Family Residence
Built in 2005
0.34 Acres Lot
$840,400 Zestimate®
$171/sqft
$5,049 Estimated rent
Home value
$840,400
$798,000 - $882,000
$5,049/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: December 10, 2025 at 02:56am
Listed by:
Moe Siddique 248-293-0000,
BHHS Michigan RE Great Lakes RH
Bought with:
Randa Seman, 6501414252
ICON Realty Experts, LLC
Source: Realcomp II,MLS#: 20251042899
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 6
- Full bathrooms: 4
- 1/2 bathrooms: 2
Primary bedroom
- Level: Second
- Area: 459
- Dimensions: 27 X 17
Bedroom
- Level: Second
- Area: 208
- Dimensions: 16 X 13
Bedroom
- Level: Second
- Area: 169
- Dimensions: 13 X 13
Bedroom
- Level: Second
- Area: 198
- Dimensions: 18 X 11
Bedroom
- Level: Basement
- Area: 132
- Dimensions: 12 X 11
Bedroom
- Level: Basement
- Area: 204
- Dimensions: 17 X 12
Primary bathroom
- Level: Second
- Area: 192
- Dimensions: 16 X 12
Other
- Level: Second
- Area: 56
- Dimensions: 8 X 7
Other
- Level: Basement
- Area: 64
- Dimensions: 8 X 8
Other
- Level: Second
- Area: 110
- Dimensions: 11 X 10
Other
- Level: Entry
- Area: 42
- Dimensions: 7 X 6
Other
- Level: Entry
- Area: 25
- Dimensions: 5 X 5
Bonus room
- Level: Second
- Area: 252
- Dimensions: 18 X 14
Dining room
- Level: Entry
- Area: 165
- Dimensions: 15 X 11
Kitchen
- Level: Entry
- Area: 690
- Dimensions: 30 X 23
Laundry
- Level: Entry
- Area: 60
- Dimensions: 10 X 6
Library
- Level: Entry
- Area: 195
- Dimensions: 15 X 13
Media room
- Level: Basement
- Area: 264
- Dimensions: 22 X 12
Sitting room
- Level: Entry
- Area: 221
- Dimensions: 17 X 13
Heating
- Forced Air, Natural Gas
Cooling
- Ceiling Fans, Central Air
Appliances
- Included: Dishwasher, Disposal, Dryer, Exhaust Fan, Free Standing Refrigerator, Microwave
- Laundry: Laundry Room
Features
- Windows: Egress Windows
- Basement: Finished,Full,Walk Out Access
- Has fireplace: Yes
- Fireplace features: Gas, Great Room, Kitchen
Interior area
- Total interior livable area: 4,914 sqft
- Finished area above ground: 4,683
- Finished area below ground: 231
Property
Parking
- Total spaces: 3
- Parking features: Three Car Garage, Attached, Electricityin Garage, Garage Faces Side, Side Entrance
- Garage spaces: 3
Features
- Levels: Two
- Stories: 2
- Entry location: GroundLevelwSteps
- Patio & porch: Deck, Porch, Terrace
- Pool features: None
- Fencing: Fencingnot Allowed
Lot
- Size: 0.34 Acres
- Dimensions: 100.00 x 150.00
Details
- Parcel number: 1502429012
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Basement, Poured
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2005
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & neighborhood
Security
- Security features: Smoke Detectors
Location
- Region: Rochester Hills
- Subdivision: CLEAR CREEK SUB NO 3
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $525 annually
- Services included: Maintenance Grounds
- Association phone: 586-566-8100
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 12/8/2025 | Sold | $840,000-8.2%$171/sqft |
Source:  Realcomp II #20251042899 | ||
| 10/17/2025 | Pending sale | $915,000$186/sqft |
Source: Realcomp II #20251042899 | ||
| 10/7/2025 | Contingent | $915,000$186/sqft |
Source: Berkshire Hathaway HomeServices Michigan and Northern Indiana Real Estate #20251042899 | ||
| 8/7/2025 | Price change | $915,000-3.6%$186/sqft |
Source: Realcomp II #20250037199 | ||
| 7/23/2025 | Price change | $949,500-9.6%$193/sqft |
Source: Realcomp II #20250037199 | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $501,170 +15.2% |
| 2023 | -- | $435,000 +3.5% |
| 2022 | -- | $420,120 +3.5% |
Find assessor info on the county website
Neighborhood: 48306
Nearby schools
GreatSchools rating
- 8/10Hugger Elementary SchoolGrades: PK-5Distance: 1.8 mi
- 9/10Stoney Creek High SchoolGrades: 6-12Distance: 0.4 mi
- 8/10Hart Middle SchoolGrades: PK,6-12Distance: 0.6 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$840,400
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$840,400