Save
Ask
Tour
Hide
$1,175,000
217 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
Call Now: 810-360-3488
Is this the listing for you? We can help make it yours.
810-360-3488
Save
Ask
Tour
Hide
Mortgage Calculator
Monthly Payment (Est.)
$5,361Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2025 Information is deemed reliable but not guaranteed.
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
217 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
$12,334.91
HOA/Condo/Coop Fees
$45 monthly
Sq Ft Source
Assessor
Friends & Family
Recent Activity
| 7 months ago | Listing first seen on site | |
| 7 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
Levels
Two
Parking
AttachedGarageGarage Door OpenerPavedAssignedGarage Faces Side
Pets
Yes
Property Sub Type
Single Family Residence
Sewer
Public Sewer
Special Circumstances
Standard
SqFt Above
5365
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 - 5.0 x 8.0Level - Upper
BathLav
Dimensions - 8.0 x 5.0
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.0
Family Room
Dimensions - 21.0 x 20.0
Great Room
Kitchen
Dimensions - 12.0 x 17.0
Laundry
Dimensions - 9.0 x 8.0
Library
Dimensions - 13.0 x 19.0
Living Room
Dimensions - 13.0 x 19.0
Master Bathroom
Dimensions - 16.0 x 20.0Level - Upper
Master Bedroom
Dimensions - 19.0 x 8.0Level - Upper
Office
Dimensions - 16.0 x 17.0
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
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.