• 248-247-1040
  • Support@MiRealSource.com

$1,175,000 for Sale

877 quarry drive, rochester hills, MI 48306

Go Back
Beds 4 Baths 5 5,365 Sqft 0.34 Acres 1 of 76
View Map
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.
General Information
Sale Price: $1,175,000
Price/SqFt: $219
Est. Payments: $7,543
Calculate Payments Mortgage Rates
Status: Active
MLS#: 50174664
City: rochester hills
Post Office: rochester hills
Schools: rochester community school district
County: Oakland
Subdivision: clear creek subdivision #3
Acres: 0.34
Lot Dim: 100 x 151 x 100 x 150
Bedrooms:4
Bathrooms:5   (4 full, 1 half)
House Size: 5,365 sq.ft.
Acreage: 0.34 est.
Year Built: 2004
Property Type: Single Family
Style: Colonial
Features & Room Sizes
Bedroom 1:  16x20
Bedroom 2 :  13x28
Bedroom 3:  14x18
Bedroom 4:  14x20
Family Room:  21x20
Greatroom: 
Dining Room:  14x22
Kitchen:  12x17
Livingroom:  13x19
Pole Buildings: 
Paved Road:  Paved Street
Garage:  4.5
Garage Description:  Attached Garage,Electric in Garage,Gar Door Opener,Side Loading Garage
Exterior:  Brick
Exterior Misc:  Exterior Balcony,Deck,BBQ/Grill Built-in,Lawn Sprinkler,Patio,Porch,Sidewalks,Street Lights
Fireplaces:  Yes
Fireplace Description:  Gas Fireplace,Grt Rm Fireplace,LivRoom Fireplace
Basement:  Yes
Basement Description:  Full,Partially Finished,Walk Out,Sump Pump
Foundation :  Basement
Appliances:  Bar-Refrigerator,Central Vacuum,Dishwasher,Disposal,Dryer,Humidifier,Intercom,Microwave,Range/Oven,Refrigerator,Washer
Cooling:  Ceiling Fan(s),Central A/C
Heating:  Forced Air,Humidifier
Fuel:  Natural Gas
Waste:  Public Sanitary
Watersource:  Public Water
Tax, Fees & Legal
Est. Summer Taxes:  $6,235
Est. Winter Taxes:  $5,593
HOA fees:  540
HOA fees Period:  Yearly


Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource. The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Copyright 2025 MiRealSource. All rights reserved. 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. ©2025
All information provided is deemed reliable but is not guaranteed and should be independently verified. Participants are required to indicate on their websites that the information being provided is 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. Listing By: Thomas Zibkowski of Real Estate One Inc-Shelby

This listing last updated: Thu, May 29, 2025 at 9:09:00 AM EDT

MIRealSource Listing Data Last Updated On Monday, June 2 2025 at 10:15am
Share this property
Listings presented by:
Thomas Zibkowski
Real Estate One Inc-Shelby
Call: (586) 709-1727

Ask about this property