Save
Ask
Tour
Hide
$1,175,000
64 Days On Site
877 Quarry DriveRochester Hills City, MI 48306
For Sale|Single Family Residence|Active
4
Beds
5
Total Baths
4
Full Baths
1
Partial Bath
5,365
SqFt
$219
/SqFt
2004
Built
Subdivision:
CLEAR CREEK SUBDIVISION #3
County:
Oakland
Save
Ask
Tour
Hide
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.
Save
Ask
Tour
Hide
Listing Snapshot
Price
$1,175,000
Days On Site
64 Days
Bedrooms
4
Inside Area (SqFt)
5,365 sqft
Total Baths
5
Full Baths
4
Partial Baths
1
Lot Size
0.34 Acres
Year Built
2004
MLS® Number
58050174664
Status
Active
Property Tax
$8,828.35
HOA/Condo/Coop Fees
$45 monthly
Sq Ft Source
Assessor
Friends & Family
Recent Activity
| 2 months ago | Listing first seen on site | |
| 2 months ago | Listing updated with changes from the MLS® |
General Features
Acres
0.34
Attached Garage
Yes
Cross Street
North off Tienken / East of Sheldon Road
Disclosures
Flood Unk, No Encroachment, Taxes Homestead Exempt
Garage
Yes
Garage Spaces
4
Parking
AttachedGarageGarage Door OpenerPavedAssignedGarage Faces Side
Pets
Yes
Property Sub Type
Single Family Residence
Sewer
Public Sewer
Special Circumstances
Standard
SqFt Above
5365
Stories
Two
Style
Colonial
Water Source
Public
Zoning
Residential
Interior Features
Appliances
Gas Water HeaterBar FridgeDishwasherDisposalDryerHumidifierMicrowaveOvenRefrigeratorRangeWasher
Basement
FullPartially FinishedSump PumpWalk-Out Access
Cooling
Ceiling Fan(s)Central Air
Fireplace
Yes
Fireplace Features
GasGreat RoomLiving Room
Flooring
Hardwood
Heating
Forced AirHumidity ControlNatural Gas
Interior
Cathedral Ceiling(s)Central VacuumEat-in KitchenEntrance FoyerHigh CeilingsHigh Speed InternetPantryWet BarWalk-In Closet(s)
Window Features
Bay Window(s)
BathFull
Dimensions - 9.0 x 8.0Level - Entry
BathLav
Dimensions - 8.0 x 5.0Level - Entry
Bedroom 2
Dimensions - 13.0 x 28.0Level - Upper
Bedroom 3
Dimensions - 14.0 x 18.0Level - Upper
Bedroom 4
Dimensions - 14.0 x 20.0Level - Upper
Bonus Room
Dimensions - 21.0 x 18.0Level - Lower
BreakfastNookRoom
Dining Room
Dimensions - 14.0 x 22.0Level - Entry
Family Room
Dimensions - 21.0 x 20.0Level - Entry
Great Room
Kitchen
Dimensions - 12.0 x 17.0Level - Entry
Laundry
Dimensions - 9.0 x 8.0Level - Entry
Library
Dimensions - 13.0 x 19.0Level - Entry
Living Room
Dimensions - 13.0 x 19.0Level - Entry
Master Bathroom
Dimensions - 16.0 x 20.0Level - Upper
Master Bedroom
Dimensions - 19.0 x 8.0Level - Upper
Office
Dimensions - 16.0 x 17.0Level - Entry
SittingRoom
Dimensions - 13.0 x 20.0Level - Lower
Save
Ask
Tour
Hide
Exterior Features
Construction Details
Brick
Exterior
BalconyOutdoor Grill
Lot Features
Cul-De-SacSloped
Patio And Porch
DeckPatioPorch
Pool Features
None
Windows/Doors
Bay Window(s)
Community Features
Accessibility Features
Therapeutic Whirlpool
Association Dues
540
Community Features
SidewalksStreet Lights
Financing Terms Available
CashConventional
HOA Fee Frequency
Annually
MLS Area
Area02151RochesterHills
Roads
Paved
School District
Rochester
Schools
School District
Rochester
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Real Estate One Inc-Shelby: 5867091727
IDX provided courtesy of Realcomp II Ltd. via MiRealSource. Copyright © 2025 Realcomp II Ltd. Shareholders.
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 and that the data is deemed reliable but not guaranteed accurate by the MLS.
IDX provided courtesy of Realcomp II Ltd. via MiRealSource. Copyright © 2025 Realcomp II Ltd. Shareholders.
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 and that the data is deemed reliable but not guaranteed accurate by the MLS.
Neighborhood & Commute
Source: Walkscore
Community information and market data Powered by ATTOM Data Solutions. Copyright ©2019 ATTOM Data Solutions. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.