PerformAction
 logo  logo  logo
  • Contact Us
  • Sign In / Sign Up
  • FIND PROPERTIES
    • HOMES FOR SALE
    • OPEN HOUSES
    • LUXURY COLLECTION
    • COMMERCIAL
    • FOR LEASE
  • SELL YOUR HOME
    • HOME VALUATION
  • AGENTS
  • REGIONS
    • EASTERN MICHIGAN
    • GRAND RAPIDS AREA
    • GREAT LAKES BAY
    • LANSING AREA
    • NORTHERN MICHIGAN
    • SOUTHWEST AND GATEWAY MICHIGAN
    • NORTHERN INDIANA
    • NORTHWEST INDIANA
    • CHICAGOLAND
  • SERVICES
    • FRONTLINE HEROES
    • PROSPERITY HOME MORTGAGE
    • RELOCATION
    • TITLE RESOURCE AGENCY
    • INSURANCE RESOURCE
    • INDUSTRY PARTNERS
  • PROSPERITY HOME MORTGAGE
  • CAREERS
    • AGENT CAREERS
    • GET LICENSED
    • STAFF & SUPPORT CAREERS
  • ABOUT US
    • OFFICE LOCATIONS
    • OUR HISTORY
    • Article
    • FIND PROPERTIES
      • HOMES FOR SALE
      • OPEN HOUSES
      • LUXURY COLLECTION
      • COMMERCIAL
      • FOR LEASE
    • SELL YOUR HOME
      • HOME VALUATION
    • AGENTS
    • REGIONS
      • EASTERN MICHIGAN
      • GRAND RAPIDS AREA
      • GREAT LAKES BAY
      • LANSING AREA
      • NORTHERN MICHIGAN
      • SOUTHWEST AND GATEWAY MICHIGAN
      • NORTHERN INDIANA
      • NORTHWEST INDIANA
      • CHICAGOLAND
    • SERVICES
      • FRONTLINE HEROES
      • PROSPERITY HOME MORTGAGE
      • RELOCATION
      • TITLE RESOURCE AGENCY
      • INSURANCE RESOURCE
      • INDUSTRY PARTNERS
    • PROSPERITY HOME MORTGAGE
    • CAREERS
      • AGENT CAREERS
      • GET LICENSED
      • STAFF & SUPPORT CAREERS
    • ABOUT US
      • OFFICE LOCATIONS
      • OUR HISTORY
      • Article
Sign In / Sign Up
Clear Price
Cancel
Done Search

787 Quarry, Rochester Hills, MI 48306 (Sold on )

  • Open House
  • New Listing
  • Pending
  • Coming Soon
  • Price Reduced
  • Virtual Open House
  • Virtual Tour
  • PENDING UNDER CONTRACT
  • The seller has accepted an offer on this property.

 $999,999

  • Property Info
  • Photos
  • Print
  • Saved Save Listing
  • Share Listing
  • Virtual Tour
more_vert
  • Property Info
  • Photos
  • Print
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
gallery
  • 4 BedBeds
  • 4 BathBaths
  • 3,828 SqftSqft
  • TypeSingle Family
  • Pending
  • MLS# 20261021339

Virtual Tours

  • Virtual Tour

Additional Virtual Tour

  • Virtual Tour

Property 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 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 youll 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


Thank you for requesting a showing of this property. A representative will be in touch with you shortly to confirm the requested showing date and time.
Please note that your appointment is not confirmed until someone contacts you.

Request Info / Schedule Showing

Submit

Property Details 787 Quarry, Rochester Hills, MI 48306

General

  • MLS#: 20261021339
  • Property Type: Single Family
  • Property Sub Type: Single Family Residence
  • List Date: 04/02/2026
  • Year Built: 2011
  • Area: 02151 - Rochester Hills
  • Subdivision: CLEAR CREEK SUB NO 3
  • County: Oakland
  • Beds: 4
  • Full Bath: 3
  • Half Bath: 1
  • Total Baths: 4
  • Association Fee: $485
  • Association Fee Frequency: Annually
  • Annual Property Taxes: $7,665

Interior Features

  • Kitchen Appliances: Bar Fridge, Dishwasher, Disposal, Dryer, Free-Standing Gas Oven, Free-Standing Refrigerator, Microwave, Washer
  • Fireplace: Yes
  • Fireplace Locations: Family Room, Gas

Exterior Features

  • Exterior Features: Barbecue, Lighting
  • Pool Type: None

Schools

  • School District: Rochester

Structure

  • Style: Colonial
  • Siding: Barbecue, Lighting
  • Foundation: Basement, Poured
  • Style: Colonial
  • Basement Type: Unfinished, Walk-Out Access
  • Construction Materials: Brick, Stone, Wood Siding

Size & Lot

  • Sq.Ft.: 3,828
  • Acres: 0.3500
  • Lot Features: Wooded
  • Lot Dimensions: 90X167

Utilities

  • Cooling: Ceiling Fan(s), Central Air
  • Sewer: Public Sewer
  • Water: Other
  • Heating Fuel: Forced Air, Natural Gas

Estimated Monthly Mortgage Calculator

Get Your Custom Mortgage Quote

This calculator is provided for informational purposes. You should not make any decisions based simply on the information provided. Values indicated are estimates and may not be accurate and are only to be used as a guide. This calculator should not be relied upon in any way as the sole source of information. Please consult your financial, tax or legal advisers for an accurate assessment of your mortgage payments and any advice relating to your personal circumstances.

Output format
 

Similar Listings

    • Open House
    • Price Reduced
    • New Listing
    • Pending
    • Coming Soon
    • Virtual Open House
    • Virtual Tour
    • Sold
    • Leased
    • PENDING UNDER CONTRACT
    281 Mead Road, Rochester Hills
    $1,200,000
    MLS# 20261019004Single Family
    5,592 Sq. Ft.
    5 Beds4 Baths
    • Active
    • Pending
    • Active Under Contract
    Request Info
    Delete
    281 Mead Road, Rochester HillsDetails
      • Open House Sat. May 02; 12:30 PM - 02:30 PM
      • Price Reduced
      • New Listing
      • Pending
      • Coming Soon
      • Virtual Open House
      • Virtual Tour
      • Sold
      • Leased
      • PENDING UNDER CONTRACT
      1112 Canyon Creek Drive, Rochester Hills
      $1,199,900
      MLS# 58050205984Single Family
      6,606 Sq. Ft.
      4 Beds7 Baths
      • Active
      • Pending
      • Active Under Contract
      Request Info
      Delete
      1112 Canyon Creek Drive, Rochester HillsDetails
        • Open House Sat. May 02; 11:00 AM - 02:00 PM
        • Price Reduced
        • New Listing
        • Pending
        • Coming Soon
        • Virtual Open House
        • Virtual Tour
        • Sold
        • Leased
        • PENDING UNDER CONTRACT
        1920 Vinsetta Court, Rochester
        $1,199,000
        MLS# 20261027792Single Family
        6,325 Sq. Ft.
        5 Beds6 Baths
        • Active
        • Pending
        • Active Under Contract
        Request Info
        Delete
        1920 Vinsetta Court, RochesterDetails
          • Open House Fri. May 01; 03:00 PM - 05:00 PM
          • Price Reduced
          • New Listing
          • Pending
          • Coming Soon
          • Virtual Open House
          • Virtual Tour
          • Sold
          • Leased
          • PENDING UNDER CONTRACT
          1906 Independence Court, Rochester Hills
          $1,149,999
          MLS# 20261028124Single Family
          5,163 Sq. Ft.
          4 Beds4 Baths
          • Active
          • Pending
          • Active Under Contract
          Request Info
          Delete
          1906 Independence Court, Rochester HillsDetails
            • Open House
            • Price Reduced$105,000
            • New Listing
            • Pending
            • Coming Soon
            • Virtual Open House
            • Virtual Tour
            • Sold
            • Leased
            • PENDING UNDER CONTRACT
            303 E Snell Road, Rochester
            $1,095,000
            MLS# 20251050015Single Family
            5,508 Sq. Ft.
            5 Beds6 Baths
            • Active
            • Pending
            • Active Under Contract
            Request Info
            Delete
            303 E Snell Road, RochesterDetails
              • Open House Sat. May 02; 12:00 PM - 02:00 PM
              • Price Reduced$100,000
              • New Listing
              • Pending
              • Coming Soon
              • Virtual Open House
              • Virtual Tour
              • Sold
              • Leased
              • PENDING UNDER CONTRACT
              4806 Goodison Place Drive, Rochester
              $1,000,000
              MLS# 20261008038Single Family
              6,073 Sq. Ft.
              5 Beds5 Baths
              • Active
              • Pending
              • Active Under Contract
              Request Info
              Delete
              4806 Goodison Place Drive, RochesterDetails
                • Open House
                • Price Reduced
                • New Listing
                • Pending
                • Coming Soon
                • Virtual Open House
                • Virtual Tour
                • Sold
                • Leased
                • PENDING UNDER CONTRACT
                4647 APPLEWOOD, Rochester
                $999,900
                MLS# 20250014601Single Family
                2,505 Sq. Ft.
                3 Beds3 Baths
                • Active
                • Pending
                • Active Under Contract
                Request Info
                Delete
                4647 APPLEWOOD, RochesterDetails
                  • Open House
                  • Price Reduced
                  • New Listing
                  • Pending
                  • Coming Soon
                  • Virtual Open House
                  • Virtual Tour
                  • Sold
                  • Leased
                  • PENDING UNDER CONTRACT
                  4176 Oak Tree Circle, Rochester
                  $997,000
                  MLS# 20261030222Single Family
                  5,142 Sq. Ft.
                  6 Beds6 Baths
                  • Active
                  • Pending
                  • Active Under Contract
                  Request Info
                  Delete
                  4176 Oak Tree Circle, RochesterDetails
                    • Open House
                    • Price Reduced
                    • New Listing
                    • Pending
                    • Coming Soon
                    • Virtual Open House
                    • Virtual Tour
                    • Sold
                    • Leased
                    • PENDING UNDER CONTRACT
                    1150 Cripple Creek Lane, Rochester Hills
                    $995,000
                    MLS# 20261027232Single Family
                    5,422 Sq. Ft.
                    4 Beds5 Baths
                    • Active
                    • Pending
                    • Active Under Contract
                    Request Info
                    Delete
                    1150 Cripple Creek Lane, Rochester HillsDetails
                      • Open House
                      • Price Reduced
                      • New Listing
                      • Pending
                      • Coming Soon
                      • Virtual Open House
                      • Virtual Tour
                      • Sold
                      • Leased
                      • PENDING UNDER CONTRACT
                      930 Bear Creek Court, Rochester
                      $987,500
                      MLS# 20261029395Single Family
                      5,955 Sq. Ft.
                      4 Beds5 Baths
                      • Active
                      • Pending
                      • Active Under Contract
                      Request Info
                      Delete
                      930 Bear Creek Court, RochesterDetails
                        • Open House
                        • Price Reduced
                        • New Listing
                        • Pending
                        • Coming Soon
                        • Virtual Open House
                        • Virtual Tour
                        • Sold
                        • Leased
                        • PENDING UNDER CONTRACT
                        1721 Archers Pointe, Rochester Hills
                        $965,000
                        MLS# 20261013203Single Family
                        7,060 Sq. Ft.
                        4 Beds5 Baths
                        • Active
                        • Pending
                        • Active Under Contract
                        Request Info
                        Delete
                        1721 Archers Pointe, Rochester HillsDetails
                          • Open House
                          • Price Reduced
                          • New Listing
                          • Pending
                          • Coming Soon
                          • Virtual Open House
                          • Virtual Tour
                          • Sold
                          • Leased
                          • PENDING UNDER CONTRACT
                          120 Crestview Drive, Rochester
                          $949,900
                          MLS# 20261021883Single Family
                          5,124 Sq. Ft.
                          5 Beds4 Baths
                          • Active
                          • Pending
                          • Active Under Contract
                          Request Info
                          Delete
                          120 Crestview Drive, RochesterDetails
                          Goshen Logo

                          Get in Touch

                          1701 Elkhart Rd Goshen IN 46526

                          Contact Us

                          (877) 808-7007 customercare@bhhsni.com
                          Home values Agents
                          Careers Open houses
                          • Privacy policy
                          • Accessibility Statement
                          • Terms Of Use
                          • DMCA Notice
                          • Agent login
                          © 2026 BHH Affiliates, LLC. An independently owned and operated franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate.
                          Equal Housing Opportunity.
                          • Comparison List   0

                          Berkshire Hathaway HomeServices Northern Indiana Real Estate is powered by Burrow Services, Inc.