• 4 Bedrooms
  • 4 Full Bath
  • 1 Half Bath
  • 5,263 SqFt
  • MLS# 31316039
  • Photos
  • Map
  • Satellite
Portrait of Tom Zibkowski
Listed by Tom Zibkowski

586-532-6700

Shelby Twp. - Real Estate One

Contact Customer Care

Mon-Fri 9am-9pm Sat/Sun 9am-7pm

248-208-3883

Stunning Model show condition 5,200 sq. ft. colonial w/walkout basement to wooded ravine (no neighbors in sight, one of best lots in subdivsion) 4.5-car garage, extensive landscaping w/outdoor fireplace on private lower brick paver patio, hardwood floors entire 1st & 2nd floors, built with the finest materials & craftsmanship, granite counters throughout, custom trim & moldings, 2-way fireplace between library and family room, basement has been studded and ready to finish, fantastic views, dual staircases, pub room with wet bar between great room and dining room, large owners suite with huge walk-in closet and luxurious bath, large cedar deck backing to a wooded ravine on a great cul-de-sac location.

Property Information

Status
Active 
Address
877 Quarry 
City
Rochester Hills 
Zip
48306 
County
Oakland 
Possession
30 
Zoning
Residential
Listing Date
03/31/2017 
Subdivision
Clear Creek Subdivision #3 
Total Finished SqFt
5,263 
Above Grade SqFt
5,263 
Garage
4.5 
Garage Desc.
Attached Garage, Direct Access, Electric in Garage, Gar Door Opener, Side Loading Garage 
Water
Public Water
Sewer
Public Sanitary
Year Built
2005 
Home Style
Colonial 
Parking Desc.
3 or More Spaces, Garage 

School Information

School District
Rochester 
Elementary School
Hugger 
Middle School
Hart 
High School
Stoney Creek HS 

Taxes

Association Fee
$425 

Rooms and Land

MasterBedroom
17X16 2nd Floor
Bedroom2
17X14 2nd Floor
Bedroom3
18X13 2nd Floor
Bedroom4
14X14 2nd Floor
Dining
18X13 1st Floor
Family
22X21 1st Floor
Kitchen
16X13 1st Floor
Living
21X13 1st Floor
Den
20X13 1st Floor
Breakfast
17X14 1st Floor
Basement
Partially Finished, Poured, Walk Out 
Cooling
Ceiling Fan(s), Central A/C 
Heating
Forced Air 
Acreage
0.34 
Lot Dimensions
100' x 151' 
Appliances
Bar-Refrigerator, Central Vacuum, Dishwasher, Disposal, Humidifier, Intercom, Microwave, Range/Oven, Refrigerator 

Features

Fireplace Desc.
FamRoom Fireplace, Gas Fireplace 
Interior Features
Cable/Internet Avail., Security System, Wet Bar/Bar 
Exterior Materials
Brick 
Exterior Features
Deck, Lawn Sprinkler, Patio, Porch, Sidewalks, Street Lights 

Listing Video for 877 Quarry, Rochester Hills MI 48306

Mortgage Calculator

years
annual
annual

Get Pre-Approved

  • Market Statistics
  • Schools Information
  • Local Business
Market Statistics
School Information
Local Business

Learn More About This Listing

Portrait of Tom Zibkowski
Listed by Tom Zibkowski

586-532-6700

Shelby Twp. - Real Estate One

Contact Customer Care

Mon-Fri 9am-9pm Sat/Sun 9am-7pm

248-208-3883

Listing Broker

Real Estate One logo

Listing Courtesy of Real Estate One
Office Address 50190 Schoenherr
Originating MLS: MiRealSource
Source MLS: MiRealSource

Real Estate One Family of Companies

877 Quarry Rochester Hills
Contact us
$899,900
For Sale • Bed: 4 • Bath: 4/1