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
$862,300 Zestimate®
$171/sqft
$5,290 Estimated rent
Home value
$862,300
$811,000 - $914,000
$5,290/mo
Zestimate® history
Owner options
List your home for rent
$5,290/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$5,290/mo
Rent Zestimate®
Refinance and save
$6,012/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$6,012/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
Two-sided fireplaceMassive center islandPremium finishesHome theaterCraftsmanship and upgradesGrand foyerLarge great room
Zillow last checked:
Listing updated:
Listed by:
Moe Siddique 248-293-0000,
Berkshire Hathaway HomeServices MIRE
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 & HOA
Community
- Security: Smoke Detectors
- Subdivision: CLEAR CREEK SUB NO 3
HOA
- Has HOA: Yes
- Services included: Maintenance Grounds
- HOA fee: $525 annually
- HOA phone: 586-566-8100
Location
- Region: Rochester Hills
Financial & listing details
- Price per square foot: $171/sqft
- Tax assessed value: $404,950
- Annual tax amount: $18,972
- Date on market: 10/6/2025
- Cumulative days on market: 108 days
- 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 | ||
| 5/22/2025 | Listed for sale | $1,050,000+39.1%$214/sqft |
Source: Realcomp II #20250037199 Report a problem | ||
| 8/25/2015 | Sold | $755,000-1.8%$154/sqft |
Source:  MiRealSource #31243826 Report a problem | ||
| 7/18/2015 | Price change | $769,000-1.3%$156/sqft |
Source: Real Estate One-Rochester #215049025 Report a problem | ||
| 5/21/2015 | Listed for sale | $779,000$159/sqft |
Source: Real Estate One-Rochester #215049025 Report a problem | ||
| 3/3/2015 | Listing removed | $779,000$159/sqft |
Source: Real Estate One-Rochester #215004917 Report a problem | ||
| 1/13/2015 | Price change | $779,000-2.5%$159/sqft |
Source: Real Estate One-Troy #215004917 Report a problem | ||
| 11/7/2014 | Price change | $799,000-3.6%$163/sqft |
Source: Real Estate One-Troy #215004917 Report a problem | ||
| 10/20/2014 | Price change | $829,000-2.4%$169/sqft |
Source: Real Estate One-Troy #215004917 Report a problem | ||
| 9/15/2014 | Listed for sale | $849,000+414.5%$173/sqft |
Source: Owner Report a problem | ||
| 4/11/2005 | Sold | $165,000$34/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $516,660 +3.1% |
| 2024 | -- | $501,170 +15.2% |
| 2023 | -- | $435,000 +3.5% |
| 2022 | -- | $420,120 +3.5% |
| 2021 | -- | $405,920 +15.8% |
| 2020 | -- | $350,680 -7.2% |
| 2019 | -- | $377,900 -0.5% |
| 2018 | $19,009 0% | $379,610 +0% |
| 2017 | $19,018 | $379,530 +11.7% |
| 2015 | -- | $339,810 +7.7% |
| 2014 | -- | $315,540 +17.5% |
| 2011 | -- | $268,520 -15.7% |
| 2010 | -- | $318,490 |
| 2009 | -- | $318,490 +253.9% |
| 2003 | -- | $90,000 |
Find assessor info on the county website
Neighborhood: 48306
Nearby homes
- $1,061,9005 bd6 ba4.2k sqft886 Quarry, Rochester Hills, MI 48306Off Market
- $1,011,2004 bd6 ba4.2k sqft895 Quarry, Rochester Hills, MI 48306Off Market
- $1,058,4004 bd3 ba4.2k sqft913 Quarry, Rochester Hills, MI 48306Off Market
- $1,122,5004 bd3 ba4.7k sqft922 Quarry, Rochester Hills, MI 48306Off Market
- $1,309,1004 bd4 ba5.6k sqft904 Quarry, Rochester Hills, MI 48306Off Market
- $1,221,0004 bd5 ba5.2k sqft870 Quarry, Rochester Hills, MI 48306Off Market
- $1,030,0004 bd5 ba5.3k sqft877 Quarry, Rochester Hills, MI 48306Sold
- $375,0000.37 Acres841 Quarry, Rochester Hills, MI 48306Sold
Nearby schools
GreatSchools rating
- 9/10Hugger Elementary SchoolGrades: PK-5Distance: 1.8 mi
- 9/10Stoney Creek High SchoolGrades: 6-12Distance: 0.4 mi
- 9/10Hart Middle SchoolGrades: PK,6-12Distance: 0.7 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
$862,300
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
$862,300
Nearby cities
Nearby zip codes
Other Rochester Hills Topics
