787 Quarry Drive

3,828 Sq. Ft.
$261 / Sq. Ft.
3,828
Sq. Ft.
$261
per Sq. Ft.

Description

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...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
  1. Listed by Chris Anderson • Bottom Line Real Estate
    P: (248)-515-5782 C: (248)-515-5782 chris@bottomlinerealestate.net

Property Details for 787 Quarry Drive

Architectural Style
Colonial
Furnished
Furnished
Subdivision Name
CLEAR CREEK SUB NO 3
Has Waterfront
No
LISTING CLOSED: 05/22/2026 12:00 AM

Property Details for 787 Quarry Drive

StatusClosed
MLS #60980551
Days on Market22
Taxes$7,665 / year
HOA Fees$485 / year
Condo/Co-op Fees-
Property TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built2011
Lot Size0.35 AC / 15,245 SF
CountyOakland County

Location

Listing Courtesy of Bottom Line Real Estate

Sold By LoChirco Realty, LLC

Add your commute

Building Information for 787 Quarry Drive

Stories2Year Built2011Building Size-Lot Size0.35 AC / 15,245 SF

Payment Calculator

$5,662 per month

30 year fixed, 6.36% Interest

Principal and Interest

$4,983

Property Taxes

$639

HOA Dues

$40

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 787 Quarry Drive

Summary
Location and General Information
  • Cross Street: north of Tienken, east of
  • Directions: north of Tienken, east of Sheldon
  • Latitude: 42.703631
  • Longitude: -83.116178
  • MLS Area Major: Rochester Hills (63151)
  • Senior Community: No
Taxes and HOA
  • Association Fee: $485.00
  • Association Fee Frequency: Annually
  • Association Phone: 2488919617
  • Association: Yes
  • Association Fee Monthly: $40.42
  • Parcel Number: 1502429008
  • Tax Annual Amount: $7,665.00
  • Tax Assessed Value: 306360
School Information
  • High School District: Rochester
Parking
  • Attached Garage: Yes
  • Garage Spaces: 3.0
  • Garage: Yes
  • Parking Features: Attached, Paved, Garage Faces Side
Property
Lot Information
  • Frontage Length: 90.0
  • Lot Features: Wooded
  • Lot Size Acres: 0.35
  • Lot Size Units: Acres
  • Lot Size Dimensions: 90X167
  • Road Frontage Type: Paved
Property and Assessments
  • Above Grade Finished Area: 3828.0
  • Above Grade Finished Area Units: Square Feet
  • Building Area Total: 5662.0
  • Living Area: 3828.0
  • Living Area Source: Public Records
  • New Construction: No
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Year Built: 2011
Building Features
  • Construction Materials: Brick, Stone, Wood Siding
  • Entry Location: Ground Level
  • Foundation Details: Basement, Poured
  • Levels: Two
  • Total Stories: 2
Utilities
  • Sewer: Public Sewer
  • Water Source: Other
Interior and Exterior Features
Exterior Features
  • Community Features: Sidewalks
  • Exterior Features: Outdoor Grill
  • Patio And Porch Features: Patio, Deck
  • Private Pool: No
Interior Features
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Washer, Range, Oven
  • Basement: Unfinished
  • Has Basement: Yes
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bathrooms: 4
  • Total Bedrooms: 4
  • Cooling: Ceiling Fan(s), Central Air
  • Has Cooling: Yes
  • Fireplace Features: Family Room, Gas
  • Has Fireplace: Yes
  • Heating: Forced Air, Natural Gas
  • Has Heating: Yes
  • Total Rooms: 13
Room Information
Room 1
  • Dimensions: 14x15
  • Length: 14.0
  • Level: Second
  • Type: Kitchen
  • Width: 15.0
Room 2
  • Dimensions: 6x6
  • Length: 6.0
  • Level: Entry
  • Type: Bath Lav
  • Width: 6.0
Room 3
  • Dimensions: 12x17
  • Length: 12.0
  • Level: Second
  • Type: Dining Room
  • Width: 17.0
Room 4
  • Dimensions: 6x6
  • Length: 6.0
  • Level: Second
  • Type: Bathroom 1
  • Width: 6.0
Room 5
  • Dimensions: 12x14
  • Length: 12.0
  • Level: Second
  • Type: Bedroom 2
  • Width: 14.0
Room 6
  • Dimensions: 15x12
  • Length: 15.0
  • Level: Second
  • Type: Bedroom 4
  • Width: 12.0
Room 7
  • Dimensions: 15x21
  • Length: 15.0
  • Level: Second
  • Type: Bedroom 1
  • Width: 21.0
Room 8
  • Dimensions: 18x19
  • Length: 18.0
  • Level: Second
  • Type: Family Room
  • Width: 19.0
Room 9
  • Dimensions: 12x15
  • Length: 12.0
  • Level: Second
  • Type: Bedroom 5
  • Width: 15.0
Room 10
  • Dimensions: 12x14
  • Length: 12.0
  • Level: Second
  • Type: Bedroom
  • Width: 14.0
Room 11
  • Dimensions: 16x14
  • Length: 16.0
  • Level: Second
  • Type: Bedroom 3
  • Width: 14.0
Room 12
  • Dimensions: 12 X 17
  • Length: 12.0
  • Level: Entry
  • Type: Dining Room
  • Width: 17.0

Property History for 787 Quarry Drive

DateEvent & SourcePriceAppreciation
May 22, 2026

Sold (Public Record)

Public Record #1941667321

$1,000,000

+16.4% / yr

May 22, 2026

Sold

MiRealSource #60980551

$1,000,000—
May 22, 2026

Sold

Realcomp #20261021339

$1,000,000—
DateEvent & SourcePrice
05/22/2026

Sold (Public Record)

Public Record #1941667321

$1,000,000

+16.4% / yr

05/22/2026

Sold

MiRealSource #60980551

$1,000,000
05/22/2026

Sold

Realcomp #20261021339

$1,000,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 787 Quarry Drive

Taxable ValueLand-Additions-Total-
Tax Record2022$12,988 ($1,082 / month)
Home Facts
Beds4Baths3.5Total Finished SqFt3,828 SqFtAbove Grade Finished SqFt3,828 SqFtStories2Lot Size14,810 SqFtStyleSingle Family ResidenceYear Built2011ZoningRVCountyOAKLANDAPN70-15-02-429-008Fireplace TypeHas Fireplace

Schools near 787 Quarry Drive

This home is within Rochester Community School District.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 12
Public - 6 to 12
Public - 9 to 12
Rating
School
Distance
Hugger Elementary School
PublicPK to 5

Hart Middle School
Public6 to 12

Stoney Creek High School
Public6 to 12

John M Schultz Educational Campus
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Bottom Line Real Estate

Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. 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 2026 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.