NOT LISTED FOR SALE

870 Quarry Rochester Hills, MI 48306

Clear Creek Neighborhood

Estimated Value: $1,228,000 - $1,629,000

4 Beds
5 Baths
5,272 Sq Ft
$257/Sq Ft Est. Value

Last Sold June 22, 2012

Last sale price $769,900 $146 Per Sq Ft

Est. 70% increase in value since last sale

Current estimated payment $8,463/month

38 Days on Market

Highlights

  • Tennis Courts
  • In Ground Pool
  • Colonial Architecture
  • Hugger Elementary School Rated A
  • Second Garage
  • Recreation Room

About This Home

As of June 2012

High demand Clear Creek! Absolutely stunning home with all of the upgrades. Large Island in Kit, custom Stone hood, 4 bdrm ea w/full bath & walk-in closet, bonus room could be 5th bdrm, 2nd office or theater room. 3/4 finished basement w/ full bath, steam shower & exercise rm. Gunite PebbleTec salt water pool, sport court. Extensive boulder walls, waterfall & landscaping. Double lots, lots of privacy. Perfect home for entertaining! Highly acclaimed Stoney, Hart & Hugger Schools. Move in soon to enjoy pool!

Last Agent to Sell the Property

Sheri Rivera

Keller Williams Troy License #MISPE-6501366855 Listed on: 04/02/2012

Last Buyer's Agent

. Non Mls Member

NON MLS MEMBER License #MISPE

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2006

Lot Details

  • 0.68 Acre Lot
  • Lot Dimensions are 207 x 98 x 236 x 210
  • Cul-De-Sac
  • Fenced Yard
  • Sprinkler System

HOA Fees

  • $32 Monthly HOA Fees

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Wood Siding

Interior Spaces

  • 5,272 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Sound System
  • Bar Fridge
  • Cathedral Ceiling
  • Screen For Fireplace
  • Window Treatments
  • Bay Window
  • Entryway
  • Great Room with Fireplace
  • Living Room
  • Den
  • Recreation Room
  • Home Gym
  • Home Security System
  • Laundry Room

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • 5 Full Bathrooms
  • Hydromassage or Jetted Bathtub

Partially Finished Basement

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

Parking

  • 3 Car Garage
  • Second Garage
  • Side Facing Garage
  • Garage Door Opener

Pool

  • In Ground Pool
  • Outdoor Pool

Outdoor Features

  • Property is near a pond
  • Tennis Courts
  • Patio
  • Porch

Location

  • Property is near schools

Utilities

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

Listing and Financial Details

  • Assessor Parcel Number 1501301021

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,579

Year Built

Built in 2006

Lot Details

0

HOA Fees

$32 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL CONDO
  • Type Of Property: Residential
  • Architecture Style: Colonial
  • Structure Style: 2 Story
  • Total Tax Amount: 9579
  • Total Tax Year: 2011
  • Year Built: 2006
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9 ft + Ceilings, Bay Window, Cable/Internet Avail., Cathedral/Vaulted Ceiling, Ceramic Floors, Hardwood Floors, Spa/Jetted Tub, Security System, Sound System, Sump Pump, Walk-In Closet, Wet Bar/Bar, Window Treatment(s)
  • Appliances: Bar-Refrigerator, Dishwasher, Disposal, Humidifier, Microwave, Range/Oven, Refrigerator
  • Fireplace: Yes
  • Fireplaces: Grt Rm Fireplace, MstrBedroom Fireplace, Fireplace Screen
  • Basement: Yes
  • Basement: Full, Partially Finished, Walk Out
  • Bedrooms: 4
  • Bedroom 1: On 2nd Floor, Dimensions: 21 x 19
  • Bedroom 2: On 2nd Floor, Dimensions: 15 x 13
  • Bedroom 3: On 2nd Floor, Dimensions: 13 x 12
  • Bedroom 4: On 2nd Floor, Dimensions: 13 x 12
  • Bathrooms Description: Basement Full Bath, First Flr Lavatory, MstrBdrm Full Bathroom
  • Full Bathrooms: 5
  • Total Bathrooms: 7
  • Room Types: Den/Study/Lib, Entry, Exercise Room, Great Room, Living Room, Recreation Room, Utility/Laundry Room
  • Breakfast Nook: On Entry Level, Dimensions: 19 x 15
  • Dining Room: On Entry Level, Dimensions: 15 x 13
  • Great Room: On Entry Level, Dimensions: 22 x 20
  • Kitchen: On Entry Level, Dimensions: 15 x 13
  • Kitchen Features: Breakfast Nook/Room, Pantry, Eat-In Kitchen, Formal Dining Room
  • Laundry: On Entry Level, Dimensions: 10 x 8
  • Library Den: On Entry Level, Dimensions: 15 x 12
  • Living Room: On Entry Level, Dimensions: 18 x 12
  • Other Room1: Dimensions: 20x10, On Level: Second
  • Half Bathrooms: 2
  • Above Grade Finished Sq Ft: 5272
  • Total Finished Sq Ft: 5272

Exterior Features

  • Pool: Yes
  • Exterior: Brick, Wood
  • Exterior Features: Fenced Yard, Inground Pool, Lawn Sprinkler, Patio, Porch, Sidewalks, Storms/Screens, Street Lights, Swimming Pool, Tennis Court(s)
  • Foundation: Basement
  • Frontage: 207
  • Road: City/County
  • Water Features: Pond

Garage/Parking

  • Garage: Additional Garage(s), Electric in Garage, Gar Door Opener, Side Loading Garage
  • Garage Spaces: 3
  • Parking: 3 or More Spaces, Garage
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water
  • Water Heater: Gas
  • Cooling: Central A/C

Condo/Co-op/Association

  • HOA Fees: 385
  • HOA Fee Frequency: Yearly
  • Community Features: Sidewalks, Street Lights, Pets-Allowed
  • Association Fee: Yes

Schools

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

Lot Info

  • Assessor Parcel Number: 1501301021
  • Zoning: Residential
  • Location: Cul-De-Sac, Subdivision, Walk to School
  • Lot Description: Large Lot - 65+ Ft., Platted, Sidewalks, Treed
  • Lot Dimensions: 207 x 98 x 236 x 210
  • Acreage: 0.68
  • Map Side Numeric: 13
  • Map Top Alpha: AE
  • Geo Subdivision: MI

Tax Info

  • Summer Tax: Year: 2011, Amount: $5,518.00
  • Winter Tax: Year: 2011, Amount: $4,061.00
  • Total Tax: Year: 2011, Amount: $9,579.00

MLS Schools

  • School District: Rochester Community School District

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 2, 2012
Closed on
Jun 22, 2012
Sold by
Riverra Anthony and Rivera Sheri L
Bought by
Setru Prabhushankar J and Setru Deepa P
Seller's Agent
Sheri Rivera
Keller Williams Troy
Buyer's Agent
. Non Mls Member
NON MLS MEMBER
List Price
$799,900
Sold Price
$769,900
Premium/Discount to List
-$30,000
-3.75%
Current Estimated Value
$1,307,308

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$537,408
Avg. Annual Appreciation
5.23%
Original Mortgage
$520,000
Outstanding Balance
$428,880
Interest Rate
3.62%
Mortgage Type
Adjustable Rate Mortgage/ARM
Estimated Equity
$1,078,070

Purchase Details

Closed on
Mar 3, 2006
Sold by
Stewart Building Company Inc
Bought by
Rivera Anthony and Rivera Sheri L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$600,000
Interest Rate
5.62%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Nov 15, 2002
Sold by
Elro Corporation
Bought by
Olympia Homes Inc
Source: Public Records

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

Purchase History

Date Buyer Sale Price Title Company
Setru Prabhushankar J $769,900 None Available
Rivera Anthony $170,000 Greco
Stewart Building Company Inc -- Greco
Olympia Homes Inc $142,500 Greco
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Setru Prabhushankar J $300,000
Open Setru Prabhushankar J $520,000
Previous Owner Rivera Anthony $417,000
Previous Owner Rivera Anthony $200,000
Previous Owner Rivera Anthony $600,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/22/2012 06/22/12 Sold $769,900 -3.8% $146 / Sq Ft
05/10/2012 05/10/12 Pending -- -- --
04/02/2012 04/02/12 For Sale $799,900 -- $152 / Sq Ft
Source: Michigan Multiple Listing Service

Tax History Compared to Growth

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,692 $453,220 $0 $0
2018 $11,079 $409,690 $0 $0
2017 $10,863 $411,500 $0 $0
2015 -- $384,510 $0 $0
2014 -- $356,910 $0 $0
2011 -- $298,370 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • S

    Seller's Agent in 2012

    Sheri Rivera

    Keller Williams Troy

  • .

    Buyer's Agent in 2012

    . Non Mls Member

    NON MLS MEMBER

See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 31096847

Michigan Multiple Listing Service

APN: 15-01-301-021

Michigan Oakland County Rochester Hills 48306 Clear Creek

870 Quarry, Rochester Hills, MI

This home is located at 870 Quarry, Rochester Hills, MI 48306 since 02 April 2012 and is currently estimated at $1,357,168, approximately $257 per square foot. This property was built in 2006. 870 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