Julie Comella
Plum Tree Realty
(513) 866-7528
23 Total Sales
1 in Coldstream
$1,340,077 Price
7335 Five Mile Rd Cincinnati, OH 45230
Coldstream NeighborhoodEstimated Value: $1,796,528
5
Beds
7
Baths
8,154
Sq Ft
$220/Sq Ft
Est. Value
Highlights
- Eat-In Gourmet Kitchen
- Sitting Area In Primary Bedroom
- 4.69 Acre Lot
- Ayer Elementary School Rated A
- View of Trees or Woods
- Fireplace in Primary Bedroom
About This Home
As of May 2026Experience timeless elegance and exceptional privacy in this custom-built Ed Weber masterpiece, offering over 8,000 SF of refined living on 4.7 beautifully landscaped acres adjacent to Coldstream Country Club. A stately gated entrance welcomes you to a home featuring 5 bedrooms, 7 baths, and a dramatic two-story great room with coffered ceilings. The chef's kitchen with an expansive island and fireside sitting area is designed for both comfort and entertaining. The partially finished lower level offers endless potential for a golf simulator, theater, or fitness space. Outdoors, enjoy a resort-style gunite pool with waterfall, a redesigned paver patio, and lush, private surroundings. A rare offering in one of Cincinnati's most sought-after communities.
Last Agent to Sell the Property
Sparen Realty License #2018002831 Listed on: 04/16/2026
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 Details
Home Type
- Single Family
Est. Annual Taxes
- $37,010
Year Built
- Built in 1995
Lot Details
- 4.69 Acre Lot
Parking
- 3 Car Garage
- Driveway
- Off-Street Parking
Property Views
- Woods
- Valley
Home Design
- Transitional Architecture
- Traditional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
Interior Spaces
- 8,154 Sq Ft Home
- 2-Story Property
- Bookcases
- Chandelier
- Marble Fireplace
- Stone Fireplace
- Gas Fireplace
- Double Hung Windows
- Wood Frame Window
- Casement Windows
- Entrance Foyer
- Family Room with Fireplace
- 4 Fireplaces
Kitchen
- Eat-In Gourmet Kitchen
- Breakfast Bar
- Kitchen Island
Flooring
- Wood
- Tile
Bedrooms and Bathrooms
- 5 Bedrooms
- Sitting Area In Primary Bedroom
- Main Floor Bedroom
- Fireplace in Primary Bedroom
- Walk-In Closet
- Dual Vanity Sinks in Primary Bathroom
- Bathtub
- Built-In Shower Bench
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Fireplace in Basement
Utilities
- Forced Air Zoned Heating and Cooling System
- Heating System Uses Gas
- Gas Water Heater
Community Details
- No Home Owners Association
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 16, 2026
Closed on
May 29, 2026
Sold by
Siddiqi Norma S and Norma S Siddiqi Revocable Trust
Bought by
Seller's Agent
Joseph Stevie
Sparen Realty
Buyer's Agent
Bobbie Richerson
Fathom Realty Ohio
List Price
$1,799,999
Sold Price
$1,800,000
Premium/Discount to List
$1
0.0%
Views
52
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
-$3,472
Original Mortgage
$1,350,000
Outstanding Balance
$1,347,422
Interest Rate
6.23%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 2, 2005
Sold by
Siddiqi Norma S
Bought by
Siddiqi Khalid A and Siddiqi Norma S
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,332,500
Interest Rate
5.41%
Mortgage Type
New Conventional
Purchase Details
Closed on
May 9, 2000
Sold by
Norma Siddiqi
Bought by
Siddiqi Norma S
Purchase Details
Closed on
Mar 24, 1995
Sold by
Partridge Thomas P
Bought by
Siddiqi Khalid and Siddiqi Norma
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Coldstream, OH
-
Julie Comella
-
Nancy Pater
Nancy Pater
Keller Williams Seven Hills Re
(513) 547-2505
30 Total Sales
2 in Coldstream
$725K - $800K Price Range
-
Steven Booth
Steven Booth
Sibcy Cline, Inc.
(947) 210-5365
92 Total Sales
1 in Coldstream
$695,000 Price
-
Jennifer Allred
Jennifer Allred
Coldwell Banker Realty
(513) 440-3615
169 Total Sales
2 in Coldstream
$425K - $695K Price Range
-
Tammie Iverson
Tammie Iverson
Keller Williams Seven Hills Re
(513) 993-5332
100 Total Sales
1 in Coldstream
$700,000 Price
-
Jeff Rosa
Jeff Rosa
eXp Realty
(513) 866-8760
93 Total Sales
1 in Coldstream
$635,000 Price
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| -- | None Available | ||
| Siddiqi Norma | -- | -- | |
| Siddiqi Norma S | -- | -- | |
| Siddiqi Khalid | -- | -- |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | $1,332,500 | ||
| Previous Owner | Siddiqi Khalid | $308,546 | |
| Previous Owner | Siddiqi Khalid A | $1,100,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 05/29/2026 05/29/26 | Sold | $1,800,000 | 0.0% | $221 / Sq Ft |
| 04/23/2026 04/23/26 | Pending | -- | -- | -- |
| 04/16/2026 04/16/26 | For Sale | $1,799,999 | -- | $221 / Sq Ft |
Source: MLS of Greater Cincinnati (CincyMLS)
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 |
|---|---|---|---|---|
| 2025 | $37,975 | $606,501 | $80,248 | $526,253 |
| 2024 | $37,012 | $606,501 | $80,248 | $526,253 |
| 2023 | $35,139 | $606,501 | $80,248 | $526,253 |
| 2022 | $29,612 | $455,001 | $67,904 | $387,097 |
| 2021 | $28,986 | $455,001 | $67,904 | $387,097 |
| 2020 | $33,053 | $514,851 | $67,904 | $446,947 |
| 2019 | $24,813 | $350,176 | $61,730 | $288,446 |
| 2018 | $23,246 | $350,176 | $61,730 | $288,446 |
| 2017 | $21,972 | $350,176 | $61,730 | $288,446 |
| 2016 | $20,768 | $322,834 | $56,172 | $266,662 |
| 2015 | $20,138 | $322,834 | $56,172 | $266,662 |
| 2014 | $20,146 | $322,834 | $56,172 | $266,662 |
| 2013 | $20,944 | $354,760 | $61,726 | $293,034 |
Source: Public Records
Agents Affiliated with this Home
-
Joseph Stevie
Seller's Agent in 2026
Joseph Stevie
Sparen Realty
(859) 991-6331
1 in this area
51 Total Sales
-
Bobbie Richerson
BR
Buyer's Agent in 2026
Bobbie Richerson
Fathom Realty Ohio
(859) 446-1779
1 in this area
11 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1875623
APN: 500-0263-0005
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.
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 535 Rollingrock Ln
- 480 Tam o Shanter Ct
- 436 Heathgate Rd
- 863 Woodlyn Dr S
- 7373 Woodcroft Dr
- 7976 Villas of Cross Creek
- 3601 Nine Mile Tobasco Rd
- 1783 Robinwood Ln
- 0 Forest Rd Unit 1884842
- 7977 Nagel Village Dr
- 7712 Coldstream Woods Dr
- 786 Maidstone Ct
- 7382 Ridgepoint Dr
- 7382 Ridgepoint Dr
- 824 Shawnee Trace Ct
- 7343 Ridgepoint Dr
- 1037 Markley Rd
- 937 Alnetta Dr
- 136 Coldstream Villa Dr
- 830 Sunderland Dr
- 7335 5 Mile Rd
- 7371 5 Mile Rd
- 523 Rollingrock Ln
- 509 Rollingrock Ln
- 547 Rollingrock Ln
- 7410 Indiancreek Rd
- 493 Rollingrock Ln
- 7315 5 Mile Rd
- 7416 Indiancreek Rd
- 7404 Indiancreek Rd
- 559 Rollingrock Ln
- 524 Rollingrock Ln
- 473 Rollingrock Ln
- 542 Rollingrock Ln
- 506 Rollingrock Ln
- 548 Rollingrock Ln
- 571 Rollingrock Ln
- 7413 Indiancreek Rd
- 490 Rollingrock Ln
- 7419 Indiancreek Rd
Your Personal Tour Guide
Ask me questions while you tour the home.