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. Immediate possession
Sold for $1,030,000
$1,030,000
877 Quarry, Rochester Hills, MI 48306
4beds
5,365sqft
Single Family Residence
Built in 2004
0.34 Acres Lot
$1,032,500 Zestimate®
$192/sqft
$5,294 Estimated rent
Home value
$1,032,500
$981,000 - $1.08M
$5,294/mo
Loading...
Owner options
List your home for rent
$5,294/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,294/mo
Rent Zestimate®
Refinance and save
$7,060/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$7,060/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: April 07, 2026 at 06:16am
Listed by:
Thomas Zibkowski 586-709-1727,
Real Estate One Inc-Shelby
Bought with:
Antonio Gjonai, 6501390369
Mark V Homes LLC
Source: MiRealSource,MLS#: 50174664
Originating MLS: MiRealSource
Originating MLS: MiRealSourceFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Bedroom 1
- Level: Upper
- Area: 320
- Dimensions: 16 x 20
Bedroom 2
- Level: Upper
- Area: 364
- Dimensions: 13 x 28
Bedroom 3
- Level: Upper
- Area: 252
- Dimensions: 14 x 18
Bedroom 4
- Level: Upper
- Area: 280
- Dimensions: 14 x 20
Bathroom 1
- Level: Upper
- Area: 152
- Dimensions: 19 x 8
Bathroom 2
- Level: Upper
- Area: 40
- Dimensions: 5 x 8
Bathroom 3
- Level: Upper
- Area: 60
- Dimensions: 5 x 12
Bathroom 4
- Level: Entry
- Area: 72
- Dimensions: 9 x 8
Dining room
- Level: Entry
- Area: 308
- Dimensions: 14 x 22
Family room
- Level: Entry
- Area: 420
- Dimensions: 21 x 20
Kitchen
- Level: Entry
- Area: 204
- Dimensions: 12 x 17
Living room
- Level: Entry
- Area: 247
- Dimensions: 13 x 19
Office
- Level: Entry
- Area: 272
- Dimensions: 16 x 17
Heating
- Forced Air, Humidity Control, Natural Gas
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Bar Fridge, Dishwasher, Disposal, Dryer, Humidifier, Microwave, Range/Oven, Refrigerator, Washer, Gas Water Heater
- Laundry: First Floor Laundry, Laundry Room, Entry
Features
- High Ceilings, Interior Balcony, Cathedral/Vaulted Ceiling, Sump Pump, Walk-In Closet(s), Bar, Central Vacuum, Pantry, Eat-in Kitchen
- Flooring: Hardwood
- Windows: Bay Window(s)
- Basement: Full,Partially Finished,Walk-Out Access,Sump Pump
- Number of fireplaces: 2
- Fireplace features: Gas, Great Room, Living Room
Interior area
- Total structure area: 8,198
- Total interior livable area: 5,365 sqft
- Finished area above ground: 5,365
- Finished area below ground: 0
Property
Parking
- Total spaces: 4.5
- Parking features: 3 or More Spaces, Garage, Driveway, Attached, Electric in Garage, Garage Door Opener, Garage Faces Side
- Attached garage spaces: 4.5
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Patio, Porch
- Exterior features: Balcony, Built-in Barbecue, Lawn Sprinkler, Sidewalks, Street Lights
- Has spa: Yes
- Spa features: Spa/Jetted Tub
- Has view: Yes
- View description: Park/Greenbelt
- Frontage type: Road
- Frontage length: 100
Lot
- Size: 0.34 Acres
- Dimensions: 100 x 151 x 100 x 150
- Features: Deep Lot - 150+ Ft., Large Lot - 65+ Ft., Cul-De-Sac, Subdivision, Walk to School, Platted, Sidewalks, Sloped
Details
- Parcel number: 1501301014
- Zoning description: Residential
- Special conditions: Private
- Other equipment: Intercom
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Basement
Condition
- New construction: No
- Year built: 2004
Utilities & green energy
- Sewer: Public Sanitary
- Water: Public
- Utilities for property: Cable/Internet Avail.
Community & neighborhood
Location
- Region: Rochester Hills
- Subdivision: Clear Creek Subdivision #3
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $540 annually
- Amenities included: Sidewalks, Street Lights
- Services included: HOA
- Association name: See attached info
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 4/5/2026 | Sold | $1,030,000-6.4%$192/sqft |
Source:  MiRealSource #50174664 Report a problem | ||
| 2/20/2026 | Pending sale | $1,100,000$205/sqft |
Source: MiRealSource #50174664 Report a problem | ||
| 1/16/2026 | Price change | $1,100,000-6.4%$205/sqft |
Source: MiRealSource #50174664 Report a problem | ||
| 12/22/2025 | Pending sale | $1,175,000$219/sqft |
Source: MiRealSource #50174664 Report a problem | ||
| 5/14/2025 | Listed for sale | $1,175,000+30.6%$219/sqft |
Source: MiRealSource #50174664 Report a problem | ||
| 8/21/2019 | Listing removed | $899,900$168/sqft |
Source: Real Estate One #31316039 Report a problem | ||
| 3/31/2017 | Listed for sale | $899,900$168/sqft |
Source: Realty Executives Midwest #31316039 Report a problem | ||
| 1/14/2015 | Listing removed | $899,900$168/sqft |
Source: Realty Executives Midwest #214035080 Report a problem | ||
| 9/16/2014 | Price change | $899,900-3.2%$168/sqft |
Source: Realty Executives Midwest #214035080 Report a problem | ||
| 8/22/2014 | Price change | $929,900-2.1%$173/sqft |
Source: Realty Executives Midwest #214035080 Report a problem | ||
| 4/23/2014 | Listed for sale | $949,900+18.9%$177/sqft |
Source: Realty Executive Midwest #31189450 Report a problem | ||
| 11/5/2011 | Listing removed | $798,900$149/sqft |
Source: REALTY EXECUTIVES MIDWEST #211041711 Report a problem | ||
| 7/13/2011 | Price change | $798,900-6%$149/sqft |
Source: REALTY EXECUTIVES MIDWEST #211041711 Report a problem | ||
| 4/22/2011 | Listed for sale | $849,900+7.6%$158/sqft |
Source: Realty Executive Midwest #31052912 Report a problem | ||
| 9/13/2005 | Sold | $790,000+454.4%$147/sqft |
Source: Public Record Report a problem | ||
| 3/29/2005 | Sold | $142,500$27/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $521,930 +14.9% |
| 2023 | -- | $454,260 +3.5% |
| 2022 | -- | $438,930 +5.5% |
| 2021 | -- | $415,940 +15.6% |
| 2020 | -- | $359,730 -7.3% |
| 2019 | -- | $388,170 -0.2% |
| 2018 | $10,322 +2% | $388,990 +0% |
| 2017 | $10,120 | $388,900 +8% |
| 2015 | -- | $360,210 +7.8% |
| 2014 | -- | $334,260 +14.7% |
| 2011 | -- | $291,310 -16.2% |
| 2010 | -- | $347,500 |
| 2009 | -- | $347,500 +321.2% |
| 2003 | -- | $82,500 |
Find assessor info on the county website
Neighborhood: 48306
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.5 mi
Schools provided by the listing agent
- Elementary: Hugger
- Middle: Hart
- High: Stoney Creek
- District: Rochester Community School District
Source: MiRealSource. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
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
$1,032,500
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
$1,032,500