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
$840,000
861 Quarry, Rochester Hills, MI 48306
6beds
4,914sqft
Single Family Residence
Built in 2005
0.34 Acres Lot
$855,000 Zestimate®
$171/sqft
$5,595 Estimated rent
Home value
$855,000
$812,000 - $898,000
$5,595/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$5,595/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$5,595/mo
Rent Zestimate®
Refinance and save
$5,770/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$5,770/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 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 Report a problem | ||
| 10/17/2025 | Pending sale | $915,000$186/sqft |
Source: Realcomp II #20251042899 Report a problem | ||
| 10/7/2025 | Contingent | $915,000$186/sqft |
Source: Berkshire Hathaway HomeServices Michigan and Northern Indiana Real Estate #20251042899 Report a problem | ||
| 8/7/2025 | Price change | $915,000-3.6%$186/sqft |
Source: Realcomp II #20250037199 Report a problem | ||
| 7/23/2025 | Price change | $949,500-9.6%$193/sqft |
Source: Realcomp II #20250037199 Report a problem | ||
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
$855,000
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
$855,000