Back on market due to no fault of the seller. Previous buyer was unable to secure financing after the home was placed under contract. Their loss is your opportunity. If you missed it the first time, now is your chance to make this home yours. 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
* Some interior photos have been virtually staged
Property Details
Price:
$999,999
MLS #:
20261021339
Status:
Active
Beds:
4
Baths:
4
Type:
Single Family
Subtype:
SingleFamilyResidence
Subdivision:
CLEAR CREEK SUB NO 3
Neighborhood:
area02151rochesterhills
Listed Date:
Apr 2, 2026
Finished Sq Ft:
3,828
Year Built:
2011
See this Listing
Schools
School District:
Rochester
Interior
Above Grade Finished Area
3828
Appliances
BarFridge, Dishwasher, Disposal, Dryer, FreeStandingGasOven, FreeStandingRefrigerator, Microwave, Washer
Bathrooms
3 Full Bathrooms, 1 Half Bathroom
Cooling
Ceiling Fans, Central Air
Heating
Forced Air, Natural Gas
Levels
Two
Exterior
Architectural Style
Colonial
Community Features
Sidewalks
Construction Materials
Brick, Stone, Wood Siding
Exterior Features
Barbecue, Lighting
Garage Spaces
3
Lot Features
Wooded
Parking Features
ThreeCarGarage, Attached, SideEntrance
Patio And Porch Features
Deck, Patio
Financial
HOA Fee
$485
HOA Fee Frequency
Annually
HOA Phone
2488919617
Taxes
$7,665
Map
Community
- Address787 Quarry Rochester Hills MI
- SubdivisionCLEAR CREEK SUB NO 3
- CityRochester Hills
- CountyOakland
- Zip Code48306
Subdivisions in Rochester Hills
- ADAMS OAKS-A SINGH
- AVON HILLS
- AVON HILLS VILLAGE NO 2
- AVON HOLLOW
- AVON LAKES VILLAGENO 4
- AVON MANOR ESTATESNO 1
- AVON ON THE LAKE
- AVON RAVINESNO 1
- AVON RAVINESNO 2
- AVONCROFTS
- AVONDALE FARMS
- BARCLAY OCCPN 461
- BARRINGTON PK/ROCHESTER HILLS
- BELLBROOK OF ROCH RESIDENCE CONDO
- BELLE CONE GARDENS
- BELLE CONE GARDENS 1
- BELLE CONE GARDENS 2
- BREWSETER VILLAGE
- BROOKEDALE WEST
- BROOKEDALE WOODS 2
- BROOKLANDS
- BUTLER RIDGE 2
- CHICHESTER EAST
- CHRISTIAN HILLS 1
- CLEAR CREEK SUB NO 3
- CLEAR CREEKNO 1
- CLEAR CREEKNO 5
- COOLIDGE HIGHWAY SUB -AVON TWP
- COOLIDGE HIGHWAY-AVON TOWNSHIP
- CRESTWOOD VILLAGE OF ROCHESTER HILLS OCCPN 1237
- CROOKS ROAD CONDO
- CUMBERLAND HILLSNO 1
- CUMBERLAND HILLSNO 3
- CUMBERLAND WOODSNO 2
- DENISON ACRES
- EDDINGTON FARMSNO 3
- ELMDALE
- EYSTERS AVON GARDENS
- EYSTERS BLOOMER PARK
- FAIRVIEW FARMS 2
- FALCON ESTATESNO 3
- FERRYVIEW HOMELANDS
- GOLDEN HILLS
- GREAT OAKS WESTNO 2
- GROVES
- HAMPTON ON THE GREEN CONDO
- HAMPTON PINES TOWN HOMES CONDO
- HARRINGTON PARR/ROCHESTER HILL
- HAWTHORN HILLS NO 5
- HAWTHORN SUB NO 1
- HAWTHORN SUB NO 2
- HEATHERWOOD VILLAGE 1
- HEATHERWOOD VILLAGE 2
- HEATHERWOOD VILLAGE NO 3
- HIDDEN HILLS CONDO – ROCHESTER HILLS
- HITCHMANS HAVEN ESTATES 1
- HUNTERS CREEK
- HUNTINGTON PARK CONDO
- JUDSON PARK SUB
- JUENGELS ORCHARDS
- KENSINGTON FORESTNO 1
- KINGS COVE CONDO
- KLEM GARDENS
- MAC KARY SUB
- MEADOW CREEK OCCPN 1435
- MEADOWBROOK HILLS OCCPN 196
- MEADOWFIELD CONDO OCCPN 607
- MEADOWFIELD CONDOMINIUMS
- MILL STREAM VILLAGE OCCPN 1458
- NORTH FAIRVIEW FARMS 4
- NORTH HILL
- NORTH HILL- ROCHESTER HILLS
- NORTH OAKS – A SINGH DEV
- NORTHBROOKE-A SINGH DEV
- OAKBROOK OCCPN 206
- OAKLAND COUNTY CONDO PLAN NO 2283 PINE WOODS
- OAKLAND COUNTY CONDO PLAN NO 2323 THE GROVES
- OAKLAND VIEW
- OAKWOOD PARK OCCPN 147
- OCCPN 2303 VILLAS AT SHADOW PINES
- PINE WOODS CONDOMINIUM
- QUAIL RIDGENO 1
- REGAL OFFICE PLAZA OCCPN 819
- REGENCY PARK CONDO OF HAMPTON OCCPN 527
- ROCHDALE
- ROCHELLE PARK CONDO OCCPN 520
- ROCHESTER ESTATES
- ROCHESTER GLENS
- ROCHESTER HEIGHTS- ROCHESTER
- ROCHESTER KNOLL
- ROCHESTER MEDICAL PLAZA CONDO OCCPN 1982
- ROOKERY WOODSNO 1
- SARGENTS CROSSING OCCPN 501
- SHADOW WOODSNO 1
- SPRING HILLNO 4
- SPRVSR’S PLAT OF BROOKLANDS PARK
- STRATFORD KNOLLS 10
- STRATFORD MANOR TWNHS OCCPN 1040
- STRATFORD VILLAGE MANOR CONDO OCCPN 1857
- STREAMWOOD ESTATES
- STREAMWOOD ESTATES OCCPN 178
- SUNNYDALE GARDENS 3
- SUPRVR’S PLAT NO 7 – AVON TWP
- SUPRVR’S PLAT NO 9 – ROCHESTER HILLS
- SUPRVR’S PLAT OF BROOKLANDS PARK NO 3
- SUPRVR’S PLAT OF DODGE AUBURN PARK
- SUPRVRS 9 – ROCHESTER HILLS
- SUPRVRS OF BROOKLANDS PARK 1
- SUPRVRS OF BROOKLANDS PARK 11
- SUPRVRS OF BROOKLANDS PARK 3
- SUPRVRS OF BROOKLANDS PARK 4
- SUPRVRS OF DODGE AUBURN PARK
- SUPRVRS REP OF GLIDEWELL
- THE SANCTUARY IN THE HILLS CONDO
- THORNRIDGE SUB NO 4
- TIENKEN MANOR ESTATES 8
- VILLAGE SQUARE CONDO OF ROCHESTER
- WALNUT BROOK ESTATES OCCPN 515
- WHISPERING WINDS CONDOMINIUM
- WILLOWOOD
- WILLOWOOD SUB
- WINCHESTER VILLAGE
- WINCHESTER VILLAGENO 1
Market Summary
Current real estate data for Single Family in Rochester Hills as of Apr 22, 2026
108
Single Family Listed
81
Avg DOM
213
Avg $ / SqFt
$595,241
Avg List Price
Property Summary
- Located in the CLEAR CREEK SUB NO 3 subdivision, 787 Quarry Rochester Hills MI is a Single Family for sale in Rochester Hills, MI, 48306. It is listed for $999,999 and features 4 beds, 4 baths, and has approximately 3,828 square feet of living space, and was originally constructed in 2011. The current price per square foot is $261. The average price per square foot for Single Family listings in Rochester Hills is $213. The average listing price for Single Family in Rochester Hills is $595,241. To schedule a showing of MLS#20261021339 at 787 Quarry in Rochester Hills, MI, contact your LoChirco Realty, LLC agent at 586-321-9997.
Similar Listings Nearby

787 Quarry
Rochester Hills, MI