Seller's Agent in 2025
Thomas Zibkowski
Real Estate One Inc-Shelby
(586) 532-5321
1 in this area
277 Total Sales
1540 Clear Creek Dr Rochester Hills, MI 48306
Clear Creek NeighborhoodEstimated Value: $1,238,526 - $1,262,000
6
Beds
7
Baths
7,200
Sq Ft
$173/Sq Ft
Est. Value
Highlights
- Colonial Architecture
- Fireplace in Primary Bedroom
- Cathedral Ceiling
- Hugger Elementary School Rated A
- Recreation Room
- Wood Flooring
About This Home
As of February 2025Immediate Possession! Designer showcase Colonial with finished walkout basement on a very private lot with wooded common area in backyard & side yard in the highly sought after Clear Creek Community. Featuring almost 8,000 sq. ft. of finely appointed living space that was finished with only the finest materials and craftmanship; Chef's gourmet island kitchen with quartz countertops with Wolf & Jenn-Air built-in appliances, ice maker & office study area with 3 built-in desks; Large hearth area in kitchen nook with 2-way fireplace to great room; Beautiful 32" x 32" marble tile throughout most of 1st floor; Walls of windows in 2-story great room; Spacious primary suite with fireplace, hardwood floors, luxury bath & large walk-in closet; Bedrooms 2, 3 & 4 all have private baths, bedroom 5 upstairs is finished bonus room with walk-in closet and large 2nd floor laundry. Finished walkout features a large wet bar/kitchen area, 6th bedroom, 5th full bathroom, 4th fireplace, exercise room and open entertaining area. Exterior of home boasts a premium private lot bounded by Rochester Parkland (wetlands) on rear & west side of home, brick paver walk-ways & front/rear patios, custom landscaping, KitchenAid Built-In Outdoor Grill (Natural Gas) along with a Generac Whole-House Generator installed in 2022. See attached list of features for more details. EXCLUDES RING Security Camera System.
Last Agent to Sell the Property
Real Estate One Inc-Shelby License #MISPE-6501186298 Listed on: 10/29/2024
Home Details
Home Type
- Single Family
Est. Annual Taxes
Year Built
- Built in 2005
Lot Details
- 0.39 Acre Lot
- Lot Dimensions are 100 x 170
- Sprinkler System
HOA Fees
- $44 Monthly HOA Fees
Home Design
- Colonial Architecture
- Brick Exterior Construction
- Poured Concrete
Interior Spaces
- 2-Story Property
- Wet Bar
- Central Vacuum
- Bar Fridge
- Cathedral Ceiling
- Ceiling Fan
- Gas Fireplace
- Entryway
- Great Room with Fireplace
- Living Room
- Formal Dining Room
- Den
- Recreation Room
- Bonus Room
- Home Gym
- Home Security System
Kitchen
- Breakfast Area or Nook
- Eat-In Kitchen
- Oven or Range
- Microwave
- Dishwasher
- Disposal
Flooring
- Wood
- Ceramic Tile
Bedrooms and Bathrooms
- 6 Bedrooms
- Fireplace in Primary Bedroom
- Walk-In Closet
- 7 Bathrooms
- Hydromassage or Jetted Bathtub
Laundry
- Laundry on upper level
- Dryer
- Washer
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Sump Pump
- Fireplace in Basement
- Basement Window Egress
Parking
- 3.5 Car Direct Access Garage
- Side Facing Garage
- Garage Door Opener
Outdoor Features
- 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 HOA
- Clear Creek Subdivision #2
Listing and Financial Details
- Assessor Parcel Number 15-02-253-002
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Oct 29, 2024
Closed on
Feb 11, 2025
Sold by
Turner Rebecca M
Bought by
Ananthamurthy Ganesh Bharadwaj and Vaidyanath Pavana
Seller's Agent
Thomas Zibkowski
Real Estate One Inc-Shelby
Buyer's Agent
Raphael Roufail
Brookstone, Realtors LLC
List Price
$1,390,000
Sold Price
$1,250,000
Premium/Discount to List
-$140,000
-10.07%
Total Days on Market
78
Views
117
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$1,118
Avg. Annual Appreciation
-0.31%
Original Mortgage
$999,999
Outstanding Balance
$999,999
Interest Rate
6.38%
Mortgage Type
New Conventional
Estimated Equity
$248,883
Purchase Details
Closed on
Apr 12, 2019
Sold by
Newson Jeffrey R and Newson Dawn
Bought by
Turner Jason and Turner Rebecca M
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$744,000
Interest Rate
4.4%
Mortgage Type
New Conventional
Purchase Details
Closed on
Dec 19, 2016
Sold by
Stevens Dawn and Newson Dawn
Bought by
Newson Jeffrey R and Newson Dawn
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$363,000
Interest Rate
4.2%
Purchase Details
Listed on
Oct 11, 2013
Closed on
Jan 16, 2014
Sold by
Caporuscio Tommaso and Caporuscio Josephine
Bought by
Stevens Dawn
Seller's Agent
John DiPiazza
EXP Realty LLC
Buyer's Agent
John DiPiazza
EXP Realty LLC
List Price
$798,350
Sold Price
$750,000
Premium/Discount to List
-$48,350
-6.06%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.59%
Original Mortgage
$417,000
Interest Rate
4.5%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jul 1, 2004
Sold by
Elro Corp
Bought by
Caporuscio Tonunaso and Caporuscio Josephine
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Ananthamurthy Ganesh Bharadwaj | $1,250,000 | Shores Title | |
| Ananthamurthy Ganesh Bharadwaj | $1,250,000 | Shores Title | |
| Turner Jason | $930,000 | First American Title | |
| Newson Jeffrey R | -- | Sterling Title Agency | |
| Stevens Dawn | $750,000 | First American Title Ins Co | |
| Caporuscio Tonunaso | $174,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Ananthamurthy Ganesh Bharadwaj | $999,999 | |
| Previous Owner | Turner Jason | $744,000 | |
| Previous Owner | Newson Jeffrey | $363,000 | |
| Previous Owner | Newson Dawn | -- | |
| Previous Owner | Newson Jeffrey R | $363,000 | |
| Previous Owner | Stevens Dawn | $417,000 | |
| Previous Owner | Caporuscio Tommaso | $165,000 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 02/12/2025 02/12/25 | Sold | $1,250,000 | -5.7% | $174 / Sq Ft |
| 01/15/2025 01/15/25 | Pending | -- | -- | -- |
| 01/01/2025 01/01/25 | Price Changed | $1,324,900 | -4.7% | $184 / Sq Ft |
| 10/29/2024 10/29/24 | For Sale | $1,390,000 | +85.3% | $193 / Sq Ft |
| 01/19/2014 01/19/14 | Sold | $750,000 | -6.1% | $144 / Sq Ft |
| 11/07/2013 11/07/13 | Pending | -- | -- | -- |
| 10/11/2013 10/11/13 | For Sale | $798,350 | -- | $154 / Sq Ft |
Source: Michigan Multiple Listing Service
Tax History Compared to Growth
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,776 | $436,250 | $0 | $0 |
| 2018 | $12,467 | $396,730 | $0 | $0 |
| 2017 | $12,224 | $402,770 | $0 | $0 |
| 2015 | -- | $376,190 | $0 | $0 |
| 2014 | -- | $325,520 | $0 | $0 |
| 2011 | -- | $284,190 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Thomas Zibkowski
-
Troy Zibkowski
T
Seller Co-Listing Agent in 2025
Troy Zibkowski
Real Estate One Inc-Shelby
(586) 453-8515
1 in this area
39 Total Sales
-
Raphael Roufail
Buyer's Agent in 2025
Raphael Roufail
Brookstone, Realtors LLC
(586) 689-2211
1 in this area
78 Total Sales
-
Seller's Agent in 2014
John DiPiazza
EXP Realty LLC
(586) 634-2246
173 Total Sales
Map
Source: Michigan Multiple Listing Service
MLS Number: 50159656
APN: 15-02-253-002
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.
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
- 1686 Traceky
- 841 Quarry
- 861 Quarry
- 877 Quarry
- 1091 Clear Creek Dr
- 846 Majestic
- 755 Majestic
- 731 E Bluff Ct Unit 1
- 1538 Linden Ct
- 298 E Tienken Rd
- 1043 Moran Dr
- 1471 Courtland Blvd
- 390 Red Oak Ln
- 6589 Orion Rd
- 1065 Stony Pointe Blvd
- 5675 Thorny Ash Rd
- 1660 Maple Creek Ct
- 1227 Sycamore Dr
- 1127 Tienken Ct Unit 13
- 6230 Winkler Mill Rd
- 1540 Clear
- 1526 Clear Creek Dr
- 1526 Clear
- 1508 Docile Dr
- 1512 Clear Creek Dr
- 1580 Docile
- 1498 Clear Creek Dr
- 1525 Clear Creek Dr Unit Bldg-Unit
- 1525 Clear Creek Dr
- 1364 Tranquility Ct
- 1592 Docile
- 1511 Clear Creek Dr
- 1350 Tranquility Ct
- 1484 Clear Creek Dr
- 1497 Clear Creek Dr
- 1336 Tranquility Ct
- 1606 Docile
- 1576 Galena
- 1562 Galena
- 1483 Clear Creek Dr