$1,175,000

877 Quarry Rochester Hills, MI 48306

Estimated payment $6,992/month

Total Views 212,298
4 Beds
4.5 Baths
5,365 Sq Ft
$219 Price per Sq Ft

Highlights

  • Colonial Architecture
  • Deck
  • Wood Flooring
  • Hugger Elementary School Rated A
  • Cathedral Ceiling
  • Hydromassage or Jetted Bathtub

About This Home

Model show condition colonial with walkout basement to wooded common area in highly sought after Clear Creek Development. All high end finishes throughout; Chef's gourmet island kitchen with built-in commercial grade appliances; Entertainers' premium 1st floor wet bar; Bridge overlooking 2-story foyer & great room; 2-way fireplace between great room & library; Beautiful hardwood floors throughout 1st & 2nd floor; Spacious primary suite with large walk-in closet & luxury bathroom; 3-other bedrooms all have private bath access; Huge deck overlooking wooded common area & lower brick paver patio with built-in fireplace; 4.5-car garage; Walkout basement is fully studded out and ready for final finishes.

Listing Agent

Thomas Zibkowski

Real Estate One Inc-Shelby License #MISPE-6501186298 Listed on: 05/14/2025

Real Estate One Inc-Shelby

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2004

Lot Details

  • 0.34 Acre Lot
  • Lot Dimensions are 100 x 151 x 100 x 150
  • Cul-De-Sac
  • Sloped Lot
  • Sprinkler System

HOA Fees

  • $45 Monthly HOA Fees

Home Design

  • Colonial Architecture
  • Brick Exterior Construction

Interior Spaces

  • 5,365 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Central Vacuum
  • Bar Fridge
  • Cathedral Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Bay Window
  • Entryway
  • Great Room with Fireplace
  • Living Room with Fireplace
  • Formal Dining Room
  • Den
  • Wood Flooring
  • Intercom

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Hydromassage or Jetted Bathtub

Laundry

  • Laundry Room
  • Dryer
  • Washer

Partially Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Sump Pump

Parking

  • 4.5 Car Attached Garage
  • Side Facing Garage
  • Garage Door Opener

Outdoor Features

  • Balcony
  • Deck
  • Patio
  • Built-In Barbecue
  • Porch

Schools

  • Hugger Elementary School
  • Hart Middle School
  • Stoney Creek High School

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Heating System Uses Natural Gas
  • Gas Water Heater
  • Internet Available

Community Details

  • Association fees include hoa
  • See Attached Info HOA
  • Clear Creek Subdivision #3

Listing and Financial Details

  • Assessor Parcel Number 15-01-301-014

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,828

Year Built

Built in 2004

Lot Details

0

HOA Fees

$45 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL
  • Type Of Property: Single Family
  • Architecture Style: Colonial
  • Structure Style: 2 Story
  • Flood Insurance: Unknown
  • Flood Plain: Unknown
  • Total Tax Amount: 8828.35
  • Total Tax Year: 2024
  • Year Built: 2004
  • Mail City: Rochester Hills
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: 9 ft + Ceilings, Interior Balcony, Bay Window, Cable/Internet Avail., Cathedral/Vaulted Ceiling, Hardwood Floors, Spa/Jetted Tub, Sump Pump, Walk-In Closet, Wet Bar/Bar
  • Appliances: Bar-Refrigerator, Central Vacuum, Dishwasher, Disposal, Dryer, Humidifier, Intercom, Microwave, Range/Oven, Refrigerator, Washer
  • Fireplace: Yes
  • Fireplaces: Gas Fireplace, Grt Rm Fireplace, LivRoom Fireplace
  • Basement: Yes
  • Basement: Full, Partially Finished, Walk Out, Sump Pump
  • Bedrooms: 4
  • Bedroom 1: On Upper Floor, Dimensions: 16 x 20
  • Bedroom 2: On Upper Floor, Dimensions: 13 x 28
  • Bedroom 3: On Upper Floor, Dimensions: 14 x 18
  • Bedroom 4: On Upper Floor, Dimensions: 14 x 20
  • Full Bathrooms: 4
  • Total Bathrooms: 5
  • Bathroom 1: Dimensions: 19 x 8, On Level: Upper
  • Bathroom 2: Dimensions: 5 x 8, On Level: Upper
  • Bathroom 3: Dimensions: 5 x 12, On Level: Upper
  • Bathroom 4: Dimensions: 9 x 8, On Level: Entry
  • Room Types: Den/Study/Lib, Entry, First Floor Laundry, Great Room, Living Room, Utility/Laundry Room, Primary Bedroom, Primary Bathroom, First Flr Lavatory, Primary Bdrm Suite, Second Flr Full Bathroom, Shared Bathroom, Breakfast Nook/Room, Pantry, Eat-In Kitchen, Formal Dining Room
  • Dining Room: On Entry Level, Dimensions: 14 x 22
  • Family Room: On Entry Level, Dimensions: 21 x 20
  • Kitchen: On Entry Level, Dimensions: 12 x 17
  • Laundry: On Entry Level, Dimensions: 9 x 8
  • Library Den: On Entry Level, Dimensions: 13 x 19
  • Living Room: On Entry Level, Dimensions: 13 x 19
  • Sitting Room: On Lower Floor, Dimensions: 13 x 20
  • Other Room1: Dimensions: 16x17, On Level: Entry
  • Other Room 2: Dimensions: 21x18, On Level: Lower
  • Below Grade Sq Ft: 2833
  • Above Grade Finished Sq Ft: 5365
  • Total Finished Sq Ft: 5365
  • Half Bathrooms: 1

Exterior Features

  • Exterior: Brick
  • Exterior Features: Exterior Balcony, Deck, BBQ/Grill Built-in, Lawn Sprinkler, Patio, Porch, Sidewalks, Street Lights
  • Foundation: Basement
  • Frontage: 100
  • Road: Paved Street
  • Frontage Type: Road

Garage/Parking

  • Garage: Attached Garage, Electric in Garage, Gar Door Opener, Side Loading Garage
  • Garage Spaces: 4.5
  • Parking: 3 or More Spaces, Garage, Paved Driveway
  • Garage: Yes

Utilities

  • Heating: Forced Air, Humidifier
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water
  • Water Heater: Gas
  • Cooling: Ceiling Fan(s), Central A/C

Condo/Co-op/Association

  • HOA Fee Includes: Hoa
  • HOA Fees: 540
  • HOA Fee Frequency: Yearly
  • Community Features: Sidewalks, Street Lights
  • Association Contact: See attached info
  • Association Phone: See attached inf
  • Association Fee: Yes

Lot Info

  • Assessor Parcel Number: 15-01-301-014
  • Zoning: Residential
  • Lot Description: Deep Lot - 150+ Ft., Large Lot - 65+ Ft.
  • Lot Dimensions: 100 x 151 x 100 x 150
  • Acreage: 0.34
  • Geo Subdivision: MI
  • Site/Lot Features: Cul-De-Sac, Subdivision, Walk to School, Platted, Sidewalks, Sloping

Rental Info

  • Pets Allowed: Yes
  • Pet Restriction: No Restrictions

Tax Info

  • Summer Tax: Year: 2024, Amount: $6,234.88
  • Winter Tax: Year: 2024, Amount: $5,593.47
  • Total Tax: Year: 2024, Amount: $8,828.35

MLS Schools

  • Elementary School: Hugger
  • Middle School: Hart
  • School District: Rochester Community School District
  • HighSchool: Stoney Creek

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2022 $6,235 $438,930 $0 $0
2018 $10,322 $388,990 $0 $0
2017 $10,120 $388,900 $0 $0
2015 -- $360,210 $0 $0
2014 -- $334,260 $0 $0
2011 -- $291,310 $0 $0
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
05/14/2025 05/14/25 For Sale $1,175,000 -- $219 / Sq Ft
Source: Michigan Multiple Listing Service

Purchase History

Date Type Sale Price Title Company
Corporate Deed $790,000 Greco
Quit Claim Deed -- Greco
Warranty Deed $142,500 Greco
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $430,000 Fannie Mae Freddie Mac
Closed $150,000 No Value Available
Source: Public Records

About the Listing Agent

Thomas Zibkowski
Thomas Zibkowski

Real Estate One Inc-Shelby

(947) 729-2420

Section Image

Being in the Real Estate Business for the last 40 years has allowed me to represent Buyer’s and Seller’s in all different home sizes and price ranges. I have closed over 5,000 sales since 1982, average over $50 million dollars in closed sales annually and have been rated in the Top 100 Agents nationwide by Wall Street Journal.

I believe your home deserves the finest marketing campaign available so I provide the latest marketing technology to deliver a perfect presentation along with

View Thomas's Profile

Thomas' Other Listings

  • 54660 Whitby Way, Shelby Township, MI 48316

    $599,900

    • 4 Beds
    • 2.5 Baths
    • 3,945 Sq Ft
    • 54660 Whitby Way
    • Shelby Township, MI

    Mint condition colonial on hard to find, fenced, almost 1/2-acre private lot. Extensive landscaping provides great privacy in the back yard featuring hot tub, gazebo and large decks overlooking Koi Pond. This original owner home has been meticulously maintained and has granite countertops throughout. Two of the upstairs bedrooms have outdoor balconies overlooking private yard. Large island

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 3195 Nickelby Dr, Shelby Township, MI 48316

    $569,900 Pending

    • 3 Beds
    • 2.5 Baths
    • 2,557 Sq Ft
    • 3195 Nickelby Dr
    • Shelby Township, MI

    Immediate possession on this great room ranch on almost 1/2 acre treed yard. Large island kitchen with granite counter tops & spacious breakfast nook. Great split floor plan with primary bedroom on one side of house & 2 bedrooms on other side with Jack & Jill bath. Great room features cathedral ceilings, fireplace and wet bar. Large den for home office; 1st floor laundry; Partially finished

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 54438 Carrington Dr Unit Lot 110, Shelby Township, MI 48316

    $999,900 New Construction

    • 4 Beds
    • 3.5 Baths
    • 3,651 Sq Ft
    • 54438 Carrington Dr
    • Unit Lot 110
    • Shelby Township, MI

    Brand New Construction Colonial "The Hillcrest" scheduled for completion in February 2026. 4-bedrooms, 3 full bathrooms, 1 half bath, walk-out lower level and 3.5-car attached side entry garage with covered patio; all high-end finishes, 8’ doors throughout, wide plank hardwood flooring on entire 1st floor, wrought iron staircase overlooking 2-story great room & foyer, dual staircases to the extra

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 54464 Carrington Dr Unit Lot 111, Shelby Township, MI 48316

    $999,900 Pending

    • 4 Beds
    • 3.5 Baths
    • 3,665 Sq Ft
    • 54464 Carrington Dr
    • Unit Lot 111
    • Shelby Township, MI

    NEW CONSTRUCTION SPLIT LEVEL home that is currently under construction and scheduled for completion Summer 2025. This split level features 4 bedrooms with 3 full bathrooms, 1 half bath, 3-car side entrance garage, covered patio and daylight lower level. Home will include all high-end finishes throughout, 8' doors, wide plank hardwood flooring on entire 1st floor, Steel custom front doors,

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 54169 Carrington Dr Unit Lot 125, Shelby Township, MI 48316

    $1,024,900 New Construction

    • 4 Beds
    • 3.5 Baths
    • 3,665 Sq Ft
    • 54169 Carrington Dr
    • Unit Lot 125
    • Shelby Township, MI

    NEW CONSTRUCTION SPLIT LEVEL home that is currently under construction and scheduled for completion February 2026. This split level features 4 bedrooms with 3 full bathrooms, 1 half bath, 3.5-car side entrance garage, covered patio. Home will include all high-end finishes throughout, 8' doors, wide plank hardwood flooring on entire 1st floor, Steel custom front doors, wrought iron staircase

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 54125 Carrington Dr Unit Lot 126, Shelby Township, MI 48316

    $1,024,900 New Construction

    • 4 Beds
    • 3.5 Baths
    • 3,651 Sq Ft
    • 54125 Carrington Dr
    • Unit Lot 126
    • Shelby Township, MI

    COMPLETED Brand New Construction Colonial "The Hillcrest" ready for immediate occupancy. 4-bedrooms, 3 full bathrooms, 1 half bath, walk-out lower level and 3.5-car attached side entry garage with covered patio; all high-end finishes, 8’ doors throughout, wide-plank hardwood flooring on entire 1st floor, wrought iron staircase overlooking 2-story great room & foyer, dual staircases to the extra

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 51677 Forster Ln Unit Lot 6, Shelby Township, MI 48316

    $899,900 Pending

    • 4 Beds
    • 3.5 Baths
    • 3,651 Sq Ft
    • 51677 Forster Ln
    • Unit Lot 6
    • Shelby Township, MI

    Brand new Colonial being built & scheduled for completion in Fall 2025. Home features 4 bedrooms, 3 full baths, 1 half bath, stunning elevation with all high end finishes throughout, huge covered patio, designer island gourmet kitchen with granite countertops & LaFata custom cabinetry throughout, 2nd mini prep kitchen, wide plank hardwood flooring throughout entire 1st floor, bridge with wrought

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 51605 Forster Ln Unit Lot 3, Shelby Township, MI 48316

    $914,900 Pending

    • 4 Beds
    • 3.5 Baths
    • 3,578 Sq Ft
    • 51605 Forster Ln
    • Unit Lot 3
    • Shelby Township, MI

    NEW CONSTRUCTION Cambridge II Colonial being built and scheduled for completion in Spring 2026. Home will feature 4 bedrooms, 3 full bathrooms, 1 half bath, stunning elevation with all high-end finishes throughout, huge covered patio, designer island gourmet kitchen with quartz countertops and LaFata custom cabinetry throughout; 2nd mini prep kitchen, wide plank hardwood flooring throughout

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 51581 Forster Ln Unit Lot 2, Shelby Township, MI 48316

    $899,900 New Construction

    • 4 Beds
    • 3.5 Baths
    • 3,668 Sq Ft
    • 51581 Forster Ln
    • Unit Lot 2
    • Shelby Township, MI

    New Construction Split Level home being built and is scheduled for completion in the Spring of 2026. Home will feature 3,668 sq. ft., 4 bedrooms, 3 full bathrooms, 1 half bath and a 3.5-side entrance attached garage; all high end finishes throughout; 8' doors, wide plank hardwood flooring on most of the 1st floor, wrought iron staircase overlooking 2-story great room & foyer; designer island

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image

Source: Michigan Multiple Listing Service

MLS Number: 50174664

Michigan Multiple Listing Service

APN: 15-01-301-014

Michigan Oakland County Rochester Hills 48306

877 Quarry, Rochester Hills, MI

This home is located at 877 Quarry, Rochester Hills, MI 48306 and is currently priced at $1,175,000, approximately $219 per square foot. This property was built in 2004. 877 Quarry is a home located in Oakland County with nearby schools including Hart Middle School, Hugger Elementary School, and Stoney Creek High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Michigan Multiple Listing Service Source MLS: MiRealSource
Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource.

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 2025 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.

Nearby Homes
Thomas Zibkowski
Thomas Zibkowski
Listing Agent Section Image
Real Estate One Inc-Shelby
(947) 729-2420