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,046,600 Zestimate®
$192/sqft
$5,351 Estimated rent
Home value
$1,046,600
$994,000 - $1.10M
$5,351/mo
Zestimate® history
Owner options
List your home for rent
$5,351/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$5,351/mo
Rent Zestimate®
Refinance and save
$7,268/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$7,268/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
High end finishesWooded common areaWalkout basementBeautiful hardwood floorsLower brick paver patioHuge deckLuxury bathroom
Zillow last checked:
Listing updated:
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
Rooms
- Room types: Den/Study/Lib, Entry, Laundry, Great Room, Living Room, Utility/Laundry Room, Master Bedroom, Master Bathroom, First Flr Lavatory, Second Flr Full Bathroom, Shared Bathroom, Breakfast Nook/Room, Dining Room
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 & HOA
Community
- Subdivision: Clear Creek Subdivision #3
HOA
- Has HOA: Yes
- Amenities included: Sidewalks, Street Lights
- Services included: HOA
- HOA fee: $540 annually
- HOA name: See attached info
Location
- Region: Rochester Hills
Financial & listing details
- Price per square foot: $192/sqft
- Tax assessed value: $1,076,440
- Annual tax amount: $12,334
- Date on market: 5/14/2025
- Cumulative days on market: 257 days
- 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 |
|---|---|---|
| 2025 | -- | $538,220 +3.1% |
| 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 homes
- $1,011,2004 bd6 ba4.2k sqft895 Quarry, Rochester Hills, MI 48306Off Market
- $375,0000.37 Acres841 Quarry, Rochester Hills, MI 48306Sold
- $840,0006 bd6 ba4.9k sqft861 Quarry, Rochester Hills, MI 48306Sold
- $1,221,0004 bd5 ba5.2k sqft870 Quarry, Rochester Hills, MI 48306Off Market
- $1,058,4004 bd3 ba4.2k sqft913 Quarry, Rochester Hills, MI 48306Off Market
- $1,061,9005 bd6 ba4.2k sqft886 Quarry, Rochester Hills, MI 48306Off Market
- $850,4004 bd6 ba3.7k sqft883 Majestic, Rochester Hills, MI 48306Off Market
- $---- bd-- ba-- sqft883 Majestic, Rochester, MI 48306Off Market
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
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,046,600
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,046,600
Nearby cities
Nearby zip codes
Other Rochester Hills Topics
