Skip To Content

877 Quarry

Rochester Hills, MI 48306
  • $1,175,000
  • STATUS: Active
  • ON SITE: 29 Days
  • MLS #: 50174664
$1,175,000
  • 4
    BEDS
  • 0.34
    ACRES
  • 4
    BATHS
  • 1
    1/2 BATHS
  • 5,365
    SQFT
  • $219
    $/SQFT
Neighborhood:
Clear Creek Subdivision #3
Type:
Single-Family Home
Built:
2004
County:
Oakland
Area:
Rochester Hills (63151)

School Information

Elementary School:
Hugger
Middle School:
Hart
High School:
Stoney Creek
School District:
Rochester Community School Distr
School Ratings & Info

Description

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.

Monthly Payment Calculator



[MiRealSource] logo ©2025 MiRealSource (Michigan Multiple Listing Service). All rights reserved. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or The Kelder Group LLC. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc. Data last updated: 2025-06-12T23:50:46.287.
www.kelder.com/homes/163800707
Print Image

877 Quarry Rochester Hills, MI 48306

  • Price: $1,175,000
  • Status: Active
  • On Site: 29 Days
  • MLS #: 50174664
4
Beds
4
Baths
1
½ Baths
0.34
Acres
5,365
SQFT
$219
$/SQFT
2004
Built
Neighborhood:
Clear Creek Subdivision #3
County:
Oakland
Area:
Rochester Hills (63151)
Elementary School:
Hugger
Middle School:
Hart
High School:
Stoney Creek
School District:
Rochester Community School Distr
Property Description
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.
Exterior Features

Exterior Construction Brick Exterior Features Exterior BalconyDeckBBQ/Grill Built-inLawn SprinklerPatioPorchSidewalksStreet Lights Foundation Type Basement Frontage 100 Garage Type Attached GarageElectric in GarageGar Door OpenerSide Loading Garage Lot Description Deep Lot - 150+ Ft.Large Lot - 65+ Ft. Lot Size 100 x 151 x 100 x 150 Parking 3 or More SpacesGaragePaved Driveway Roads Paved Street Structure Style 2 Story Styles Colonial Waterfront YN No

Interior Features

Appliances Bar-RefrigeratorCentral VacuumDishwasherDisposalDryerHumidifierIntercomMicrowaveRange/OvenRefrigeratorWasher Basement Type FullPartially FinishedWalk OutSump Pump Basement YN Yes Below Grade Sq Ft 2833 Below Grade Sq Ft Finished 0 Cooling System Ceiling Fan(s)Central A/C Fireplace Features Gas FireplaceGrt Rm FireplaceLivRoom Fireplace Fireplace YN Yes Fuel Type Natural Gas Heating System Forced AirHumidifier Interior Features 9 ft + CeilingsInterior BalconyBay WindowCable/Internet Avail.Cathedral/Vaulted CeilingHardwood FloorsSpa/Jetted TubSump PumpWalk-In ClosetWet Bar/Bar Sub Room Description Den/Study/LibEntryFirst Floor LaundryGreat RoomLiving RoomUtility/Laundry RoomPrimary BedroomPrimary BathroomFirst Flr LavatoryPrimary Bdrm SuiteSecond Flr Full BathroomShared BathroomBreakfast Nook/RoomPantryEat-In KitchenFormal Dining Room Water Heater Gas

Property Features

Additional Documents YN Yes Assessments YN No Association Fee Includes HOA Association Fee YN Yes Community Amenities SidewalksStreet Lights Encroachment YN No Fee Amount 540 Fee Schedule Yearly Financial Terms CashConventional Flood Insurance Unknown Flood Plain Unknown For Sale Or Rent For Sale Lease YN No Manufactured YN No Municipality Rochester Hills Municipality Type City Ownership Private Pet Restrictions YN No Pets Allowed YN Yes Principal Res Exempt YN Yes SEV 538220 Sev Year 2025 Sewer Septic Public Sanitary Site And Lot Features Cul-De-SacSubdivisionWalk to SchoolPlattedSidewalksSloping Site Condo YN No Sq Ft Source Assessors Data Subject To Short Sale Approval No Summer Tax Amount 6234.88 Summer Tax Year 2024 Total Tax Amount 8828.35 Total Tax Year 2024 Water Public Water Winter Tax Amount 5593.47 Winter Tax Year 2024 Zoning Residential

Listing courtesy of Real Estate One Inc-Shelby : 586-532-5500.

Source MLS: MiRealSource
Originating MLS: MiRealSource

[MiRealSource] logoProvided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource. The information published and disseminated by the Originating MLS is communicated verbatim, without change by the Originating MLS, as filed with it by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.


[MiRealSource] logo ©2025 MiRealSource (Michigan Multiple Listing Service). All rights reserved. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or The Kelder Group LLC. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc. Data last updated: 2025-06-12T23:50:46.287.
 
https://bt-photos.global.ssl.fastly.net/realsource/orig_boomver_1_50174664-2.jpg https://bt-photos.global.ssl.fastly.net/realsource/orig_boomver_1_50174664-2.jpg https://bt-photos.global.ssl.fastly.net/realsource/orig_boomver_1_50174664-2.jpg
Logo
The Kelder Group LLC
9284 Lapeer Rd.
Davison MI, 48423