$899,900 877 Quarry Rochester Hills, MI

MLS: 31316039   Type: Single Family   County: Oakland   City: Rochester Hills   Neighborhood: Clear Creek Subdivision #3   Zip: 48306   Style: Colonial     Stories: 2   Taxes: $10,120

Mortgage $4,225 /mo



Half Baths

Sqr Footage









All sizes apprx. 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 (one of the best lots in the subdivision).

Elementary School

Middle School

High School

Click Here
Distance: N/A Miles
Click Here
Distance: N/A Miles
Click Here
Distance: N/A Miles

Price History

3/31/2017 Listed $899,900

Associated Document Count 2
Association Fee Y/n Yes
Fee Amount 425
Fee Schedule Yearly
Financial Terms Cash, Conventional
Flood Insurance Unknown
Listing Status Active
Manufactured Y/n No
Municipality Rochester Hills
Originating Mls MiRealSource
School District Rochester Community School Distr
Source Mls MI Real Source
Status Active
Style Colonial
Subdivision Y/N Clear Creek Subdivision #3
Subj To Short Sale Apprvl No
Year Built 2005
Zoning Residential

Interior Features

# of Fireplaces FamRoom Fireplace, Gas Fireplace
Appliances Bar-Refrigerator, Central Vacuum, Dishwasher, Disposal, Humidifier, Intercom, Microwave, Range/Oven, Refrigerator
Basement Partially Finished, Walk Out, Poured
Basement Y/n Yes
Bath Descriptions First Flr Lavatory, MstrBdrm Full Bathroom, Second Flr Lavatory
Bedroom 1 Length 17
Bedroom 1 Level Second
Bedroom 1 Width 16
Bedroom 2 Length 17
Bedroom 2 Level Second
Bedroom 2 Width 14
Bedroom 3 Length 18
Bedroom 3 Level Second
Bedroom 3 Width 13
Bedroom 4 Length 14
Bedroom 4 Level Second
Bedroom 4 Width 14
Breakfast Nook Length 17
Breakfast Nook Level First
Breakfast Nook Width 14
Cooling Ceiling Fan(s), Central A/C
Dining Room Length 18
Dining Room Level First
Dining Room Width 13
Dining/Kitchen Pantry, Eat-In Kitchen, Formal Dining Room
Family Room Length 22
Family Room Level First
Family Room Width 21
Full Baths 4
Half Baths 1
Heating Forced Air
Interior Features Cable/Internet Avail., Security System, Wet Bar/Bar
Kitchen Length 16
Kitchen Level First
Kitchen Width 13
Library/den Length 20
Library/den Level First
Library/den Width 13
Living Room Length 21
Living Room Level First
Living Room Width 13
Water Heater Gas

Exterior Features

Exterior Brick
Exterior Features Deck, Lawn Sprinkler, Patio, Porch, Sidewalks, Street Lights
Flood Plain Unknown
Foundation Basement
Frontage 100
Garage Attached Garage, Side Loading Garage
Garage # Of Car 4.5
Lot Dimensions 100x151
Lot Size Area 0.34
Parking 3 or More Spaces, Garage
Roads Paved Street
Structure Style 2 Story
Water Public Water
Well/Septic Inspection Done No

Property Schools

Direct Link:


Gallery (25 photos)

Ask Your Agent a Question

Property vs Zip Code Avg (48306)

Price 899K Avg 792K

Sqr Feet 5,263 Avg 3,858

Cost / Sqr Ft $171 Avg $205

Taxes $10,120 Avg $6,085

Acres 0.34 Avg 1.16

Visits 13 Avg 14

Days on Site 391 Avg 100

Ask How to Finance this Property

Download Our Mobile App

Download Millions Mapped

Listing Provided Courtesy Of: Realty Executives Midwest

Back to Search

Chat is Now Online! Ask Away!

Find Your Home's Value Instantly

Saved Properties

This is a list of your favorite properties. We will email you if a property is reduced or leaves the market.

Click 'Save' to add a property to this list.

Register / Login

New & returning visitors please enter your information to login.

By clicking 'register' you are agreeing to our terms of use & giving us expressed written consent to contact you.

Questions? Comments? Complaints?

This message will go directly to the head of our team.

Location & Address

Searching Michigan Homes by Janet Hull & Thomas Bush
50190 Schoenherr
Shelby Township, MI