877 Quarry Rochester Hills, MI
$ 899,900
Property Attributes
  • MLS#31316039
  • TypeSingle Family
  • CountyOAKLAND
  • CityRochester Hills
  • AreaRochester Hills
  • NeighborhoodClear Creek Subdivision #3
  • Zip48306
  • StyleColonial
  • Year Built2005
  • Taxes10120
  • Price$ 899,900
  • Bedrooms4
  • Full Bathrooms4
  • Half Bathrooms1
  • Sqr Footage5263
  • Lot Size0.34 Acres
Listing Provided Courtesy Of:
Realty Executives Midwest
Property Description

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
Unknown Elementary School Unknown Middle School Unknown High School
Price History
3/31/2017 Listed $899,900

General Features

Associated Document Count 2
Association Fee Y/n Yes
Bathrooms 5
Directions Enter Clear Creek North off Tienken, turn right on Quarry
Fee Amount 425
Fee Schedule Yearly
Financial Terms Cash, Conventional
Flood Insurance Unknown
Legal Description Lot #163, Clear Creek Subdivision #3
Listing Area Rochester Hills (63151)
Listing Status Active
Manufactured Y/n No
Municipality Rochester Hills
Originating Mls MiRealSource
Ownership Private
School District Rochester Community School Distr
Source Mls MI Real Source
Status Active
Style Colonial
Subdivision Clear Creek Subdivision #3
Subj To Short Sale Apprvl No
Type Residential
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
Fireplace? Yes
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
Total Beds 4
Water Heater Gas

Exterior Features

Exterior Brick
Exterior Features Deck, Lawn Sprinkler, Patio, Porch, Sidewalks, Street Lights
Flood Plain Unknown
Foundation Type 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
Waterfront Y/N No
Well/Septic Inspection Done No


  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Pets
  • Master On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Property vs Zip Code Average in 48306

AVG $750K
AVG $7,198
AVG 13
Year Built
AVG 1993

Looking for more comfortable experience?

Check out our mobile application and browse the properties as no other.

Areas We Cover