Sign In

Close

x
Showing 1 of 0
X
Save
877 Quarry Rochester Hills MI 48306-3584US4 Bed, 5.00 Bath (4 Full Bath , 1 Half Bath), 50174664
877 Quarry Rochester HillsMI48306-3584
1175000.0000 1/1/1900 12:00:00 AM
Realty Executives Stoney Creek
330 East StreetRochesterMI48307
248-207-1115
1 /

Courtesy of: Thomas Zibkowski, Real Estate One Inc-Shelby, tom@TomZibkowski.com

877 Quarry
Rochester Hills MI 48306-3584 US

Save
1 /

Courtesy of: Thomas Zibkowski, Real Estate One Inc-Shelby, tom@TomZibkowski.com

Realty Executives Stoney Creek
330 East Street
Rochester, MI, US 48307
248-207-1115

Get more info about this property

877 Quarry
Rochester Hills MI 48306-3584 US

$1,175,000

Active Listing ID 50174664
bed icon
4 bed
bath icon
5.00 Bath (4 Full , 1 Half)
lot icon
Lot: 0.34 Acres
home icon
Single Family Residence

$1,175,000

Active Listing ID 50174664
Save
3d icon
Maps

877 Quarry 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.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.34 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 4
  • 1/2 Bathrooms: 1
  • Cooling System: Ceiling Fan(s), Central Air
  • Exterior Finish: Bbq/Grill Built-in, Deck, Exterior Balcony, Lawn Sprinkler, Patio, Porch, Sidewalks, Street Lights, Sidewalks, Street Lights
  • Heating Fuels: Fireplace(s), Forced Air, Humidity Control (Heating)
  • Additional Features
  • Fireplace
  • Patio

School Information

  • School
  • Hugger(Elementary)
  • Hart(MiddleSchool)
  • Stoney Creek(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 1175000
  • unparsedaddress: 877 Quarry
  • postalcity: Rochester Hills
  • stateorprovince: MI
  • country: US
  • postalcode: 48306-3584
  • bathroomsfull: 4
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.34
  • lotsizeunits: Acres
  • lotsizearea: 0.34
  • livingarea: 5365
  • livingareaunits: Square Feet
  • listagentfullname: Thomas Zibkowski
  • listagentemail: tom@TomZibkowski.com
  • listagentkey: 3yd-MIREAL-26472
  • listagentmlsid: 26472
  • listagentpreferredphone: 5862001972
  • listagentofficephone: 5862001972
  • listofficekey: 3yd-MIREAL-1630
  • listagentstatelicense: 6501186298
  • listofficemlsid: 1630
  • disclaimer: Copyright © 2025 Multiple Listing Service MiRealSource. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: MIREAL
  • yearbuilt: 2004
  • listingcontractdate: 2025-05-14
  • listagenturl: http://www.tomzibkowski.com
  • countyorparish: Oakland
  • parcelnumber: 15-01-301-014
  • elementaryschool: Hugger
  • highschool: Stoney Creek
  • elementaryschooldistrict: Rochester Community School District
  • middleorjuniorschooldistrict: Rochester Community School District
  • highschooldistrict: Rochester Community School District
  • appliances: Dishwasher, Dryer, Garbage Disposer, Microwave, Range, Refrigerator, Refrigerator - Bar, Vacuum System, Washer
  • cooling: Ceiling Fan(s), Central Air
  • constructionmaterials: Brick
  • heating: Fireplace(s), Forced Air, Humidity Control (Heating)
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 2
  • parkingtotal: 0
  • parkingfeatures: Driveway, Garage, Garage - Attached, Paved or Surfaced
  • waterfrontyn: False
  • franchiseaffiliation: Real Estate One
  • interiorfeatures: 9 ft + Ceilings, Interior Balcony, Bay Window, Cable/Internet Avail., Cathedral/Vaulted Ceiling, Hardwood Floors, Spa/Jetted Tub, Sump Pump, Walk-In Closet, Wet Bar/Bar
  • exteriorfeatures: Exterior Balcony, Deck, Bbq/Grill Built-in, Lawn Sprinkler, Patio, Porch, Sidewalks, Street Lights, Sidewalks, Street Lights
  • architecturalstyle: Colonial
  • rooms: Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Den, Dining Room, Family Room, Kitchen, Laundry, Library, Living Room
  • utilities: Cable Available
  • patioandporchfeatures: Patio, Porch, Deck
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Real Estate One of Michigan", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[{"ExpenseCategory":"Home Owner Assessments Fee", "ExpenseFrequency":"Annually", "ExpenseValue":540}], "GeocodeOptions":null, "LeadRoutingEmail":"homes@janetandtom.com", "ListBrokerageCity":"Shelby Township", "ListBrokerageCountry":"US", "ListBrokerageEmail":"tbush@realestateone.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/MIREAL/ff808081171733300117266a2bb94b8b/20140121193124048.png", "ListBrokerageName":"Real Estate One of Michigan", "ListBrokeragePhone":"586-200-1972", "ListBrokeragePostalCode":"48315", "ListBrokerageStateOrProvince":"MI", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"50190 Schoenherr", "ListBrokerageWebsiteUrl":"http://www.JanetandTom.com", "ListOfficeAddress1":"56288 Van Dyke", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":null, "ListOfficeCity":"Shelby Twp", "ListOfficeCountry":"US", "ListOfficeEmail":"dawn@dawnwaldrip.com", "ListOfficePostalCode":"48316", "ListOfficeStateOrProvince":"MI", "ListPriceCurrencyType":"USD", "ListingTitle":"Colonial, Single Family - Rochester Hills, MI", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/877-Quarry_Rochester-Hills_MI_48306_M48376-94204?f=listhub&s=MIREAL&m=50174664&c=rexren", "MLSModificationTimestamp":"2025-10-04T14:02:27Z", "Neighborhoods":[{"Description":null, "Name":"Rochester Hills (63151)"}], "PostalCode":null, "RawPropertySubType":"Single Family", "RawPropertyType":"Single Family", "RoomCount":null, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 10/4/2025 4:31:30 PM GMT
Source Updated Date: 12/5/2025 6:42:08 PM GMT

Courtesy of: Thomas Zibkowski, Real Estate One Inc-Shelby, tom@TomZibkowski.com

Copyright © 2025 Multiple Listing Service MiRealSource. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Contact