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.
For sale
$1,175,000
877 Quarry, Rochester Hills, MI 48306
4beds
5,365sqft
Est.:
Single Family Residence
Built in 2004
0.34 Acres Lot
$1,138,700 Zestimate®
$219/sqft
$45/mo HOA
What's special
High end finishesWooded common areaWalkout basementBeautiful hardwood floorsLower brick paver patioHuge deckLuxury bathroom
- 84 days
- on Zillow |
- 1,468 |
- 38 |
Zillow last checked: 7 hours ago
Listing updated: May 29, 2025 at 06:09am
Listed by:
Thomas Zibkowski 586-709-1727,
Real Estate One Inc-Shelby 586-532-5500
Source: MiRealSource,MLS#: 50174664
Originating MLS: MiRealSource
Originating MLS: MiRealSourceTravel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & 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
Video & virtual tour
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: $219/sqft
- Tax assessed value: $1,043,860
- Annual tax amount: $8,828
- Date on market: 5/14/2025
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
- Road surface type: Paved
- Loading
- Loading
