Skip main navigation
Off market
  • $1,286,900

    787 Quarry, Rochester Hills, MI 48306

    4beds
    3,828sqft
    Single Family Residence
    Built in ----
    -- sqft lot
    $1,286,900 Zestimate®
    $336/sqft
    $5,148 Estimated rent

    Home value

    $1,286,900

    $1.22M - $1.35M

    $5,148/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $5,148/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $5,148/mo

    Rent Zestimate®

    Refinance and save

    $6,878/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $6,878/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Designed for executive living and corporate relocation, this exceptional Clear Creek residence offers over 3,800 sq ft of refined space, privacy, and convenience in one of Rochester Hills' most desirable communities. Built in 2011, the home features 4 spacious bedrooms, 3.5 bathrooms, and a layout that balances everyday comfort with upscale entertaining. Expansive living areas and abundant natural light create an elevated yet welcoming atmosphere throughout. The kitchen flows seamlessly into the main living space, while generously sized bedrooms, including a luxurious primary suite, provide the space and quiet professionals and families appreciate. Flexible use rooms offer ideal setups for a home office, fitness space, or guest accommodations. This home is ideal for relocating executives, corporate placements, or tenants seeking a high-quality residence without the commitment of ownership. Situated in the prestigious Clear Creek community just 1 mile from Downtown Rochester, this location offers exceptional walkability and access to lifestyle amenities. Walking distance to middle and high schools, and close to parks, biking trails, rivers, restaurants, shopping, and entertainment, the setting combines privacy with everyday convenience. Flexible lease terms considered. Inquire for details on included services and furnishing options. Tenants will be responsible for all utilities (gas & electric), water, weekly lawn cutting (w/Marino's), fall clean up, and trash billing. Tenants will be responsible for obtaining renter's insurance. Good credit, background check and verified income and employment is a must. ** Available for immediate occupany.

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Zillow last checked: 7 hours ago

    Listing updated: February 25, 2026 at 08:13pm

    Source: Zillow Rentals

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 4
    • Full bathrooms: 4
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Dryer, Washer
    • Laundry: In Unit
    Features
    • Flooring: Hardwood
    • Furnished: Yes
    Interior area
    • Total interior livable area: 3,828 sqft

    Property

    Parking
    • Parking features: Attached
    • Has attached garage: Yes
    • Details: Contact manager
    Features
    • Exterior features: Electricity not included in rent, Garbage not included in rent, Gas not included in rent, No Utilities included in rent, Water not included in rent
    Details
    • Parcel number: 1502429008

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence

    Community & neighborhood

    Location
    • Region: Rochester Hills

    HOA & financial

    Other fees
    • Deposit fee: $12,750

    Price history

    DateEventPrice
    3/23/2026Listing removed$1,299,900$340/sqft
    Source: Realcomp II #20261016289 Report a problem
    3/19/2026Listed for sale$1,299,900+37.6%$340/sqft
    Source: Realcomp II #20261016289 Report a problem
    3/12/2026Listing removed$7,995$2/sqft
    Source: Zillow Rentals Report a problem
    2/26/2026Price change$7,995-8.6%$2/sqft
    Source: Zillow Rentals Report a problem
    12/30/2025Price change$8,750-16.7%$2/sqft
    Source: Zillow Rentals Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024-- $414,930 +16.8%
    2023-- $355,170 +3.8%
    2022-- $342,290 +6.3%

    Find assessor info on the county website

    Neighborhood: 48306

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $1,286,900
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $1,286,900