Your Michigan Home Search Starts HERE!

Save
Ask
Tour
Hide
Share
$1,299,900
6 Days On Site

787 Quarry
Rochester Hills City, MI 48306

For Sale|Single Family Residence|Active
4
Beds
4
Total Baths
3
Full Baths
1
Partial Bath
3,828
SqFt
$340
/SqFt
2011
Built
Subdivision:
CLEAR CREEK SUB NO 3
County:
Oakland
Call Now: 810-360-3488
Is this the listing for you? We can help make it yours.
810-360-3488
787 Quarry787 Quarry787 Quarry787 Quarry
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$5,931
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

Nestled on a premium, elevated lot in the highly sought-after Clear Creek community of Rochester Hills, this home offers an exceptional blend of privacy, location, and natural beauty. Backing to a serene wooded tree line, you'll enjoy peaceful views and abundant sunshine all day thanks to the desirable North/South exposure. Whether you're relaxing on the spacious terrace deck or entertaining on the covered walk-out patio with built-in bar area, outdoor living is a true highlight of this property. Inside, the main floor boasts a large open-concept layout, ideal for both everyday living and entertaining. A convenient half bath is located on the main level, while upstairs you’ll find three generously sized bedrooms and a grand master suite, each offering ample closet and storage space. The walkout basement is mostly unfinished, offering the opportunity to customize additional living space, yet already serves as an excellent indoor/outdoor entertainment zone. Enjoy unbeatable walkability and convenience: Just 1 mile to Downtown Rochester, walking distance to both Hart Middle School & Stoney Creek High School, close to parks, biking trails, rivers, restaurants, shopping, and entertainment. * Some interior photos have been virtually staged

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,299,900
Days On Site 
6 Days
Bedrooms 
4
Inside Area (SqFt) 
3,828 sqft
Total Baths 
4
Full Baths 
3
Partial Baths 
1
Lot Size 
0.35 Acres
Year Built 
2011
MLS® Number 
20261016289
Status 
Active
Property Tax 
$7,665
HOA/Condo/Coop Fees 
$40.42 monthly
Sq Ft Source 
Public Records
Friends & Family
Recent Activity
yesterdayStatus changed to Active
yesterdayListing updated with changes from the MLS®
7 days agoListing first seen on site
General Features
Acres 
0.35
Cross Street 
north of Tienken, east of Sheldon
Disclosures 
Exclusions Do Not Exist, No Restrictions, Taxes Not Homestead Exempt
Garage 
Yes
Garage Spaces 
3
Levels 
Two
Parking 
AttachedGarage Faces Side
Pets 
Dogs OK
Property Sub Type 
Single Family Residence
Sewer 
Public Sewer
Special Circumstances 
Standard
SqFt Above 
3828
Style 
Colonial
Water Source 
Other
Interior Features
Appliances 
Bar FridgeDishwasherDisposalDryerFree-Standing Gas OvenFree-Standing RefrigeratorMicrowaveWasher
Basement 
UnfinishedWalk-Out Access
Cooling 
Ceiling Fan(s)Central Air
Fireplace 
Yes
Fireplace Features 
Family RoomGas
Furnished 
Partially
Heating 
Forced AirNatural Gas
BathDualEntry 
Dimensions - 13 X 7Level - Second
BathFull 
Dimensions - 11 X 7Level - Second
BathLav 
Dimensions - 6 X 6
Bedroom 
Dimensions - 12 X 14Level - Second
BreakfastNookRoom 
Dimensions - 12 X 15
Dining Room 
Dimensions - 12 X 17
Family Room 
Dimensions - 18 X 19
Kitchen 
Dimensions - 14 X 15
Library 
Dimensions - 12 X 14
Master Bathroom 
Dimensions - 15 X 21Level - Second
Master Bedroom 
Dimensions - 16 X 10Level - Second
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
BrickStoneWood Siding
Exterior 
BarbecueLighting
Lot Features 
Wooded
Patio And Porch 
DeckPatio
Pool Features 
None
Community Features
Association Dues 
485
Building Access 
GroundLevel
Community Features 
Sidewalks
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 Bottom Line Real Estate: [email protected]



IDX provided courtesy of Realcomp II Ltd. via RealcompIILtd. Copyright © 2026 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
Share