Opportunities like this are exceptionally rare. Privately situated on nearly 5 acres in prestigious Riverview Estates at Coldstream, this iconic estate offers over 10,000 sq ft of luxury living with what may be the most coveted panoramic Ohio River view in all of Cincinnati. Originally part of the historic Chaswil Farm, the property helped pioneer one of the region's most exclusive luxury communities. Designed for elevated entertaining and executive living, the home features a hidden third-story private theatre/media retreat, custom wine cellar, expansive entertaining spaces, and a heated 4-car garage. Unmatched privacy, breathtaking sunsets, and sweeping 180-degree river vistas create a true legacy property just minutes from downtown, private aviation, and elite country clubs.
Details
MLS #
1885489
Listing Type
For Sale
Style
House
HOA Dues
$1,000
Sub-Type
Resale
Status
Active
Year
1952
Days On Site
76
Listing Provided By
Plum Tree Realty | Christopher Shepherd
Features
Bed(s)
6
Bath(s)
7 Total
SQ Feet
10,533
Garage
4
Basement
Y
Story(s)
3
Zoning
Residential
Acreage
4.89
Property View
River
Interior
Rooms Total
20
Heating
Electric, Forced Air, Heat Pump
Cooling
Central Air
Window Features
Double Pane, Vinyl
Appliances
Dishwasher, Double Oven, Gas Cooktop, Microwave, Refrigerator
Interior Features
9Ft + Ceiling, Crown Molding, Multi Panel Doors, Natural Woodwork
Fireplace Features
Wood
Fireplaces Total
3
Exterior
Roof
Slate
Exterior Features
Balcony, Fire Pit, Fireplace, Patio
Construction Materials
Stone, Wood Siding
Topography
Cleared, Level, Steep
Foundation Details
Poured
Parking
Parking Features
Asphalt, Driveway
Utilities
Sewer
Public Sewer
Gas
Natural
Taxes
Property
23640
Area Information
State
OH
County
Hamilton
City
Anderson Twp
Zip Code
45255
Area
Hamilton E07
Subarea
Hamilton E07
Community Name
Anderson Twp.
School District
Forest Hills Local S
High School
Forest Hills Local S
Listing VS Median (in Anderson Twp.)
Price: $4,850,000
low | high
Med: $402,450
100% of Average
sqft: 10,533
low | high
Med: 1,867
100% of Average
$ / sqft: $460
low | high
Med: $225
100% of Average
On site: 76
low | high
Med: 73.5
100% of Average
Sourced by Back At You
Market Activity 45255
Date
Sales
Avg $ Per SqFt
Min Sale Price
Max Sale Price
Med Sale Price
Date: Aug 2026
Sales: 6
Avg $ Per SqFt: $200.31
Min Sale Price: $226,000
Max Sale Price: $541,000
Med Sale Price: $380,000
Date: Jul 2026
Sales: 26
Avg $ Per SqFt: $200.12
Min Sale Price: $206,000
Max Sale Price: $1,625,000
Med Sale Price: $376,000
Date: Jun 2026
Sales: 23
Avg $ Per SqFt: $198.92
Min Sale Price: $150,000
Max Sale Price: $1,762,500
Med Sale Price: $349,900
Date: May 2026
Sales: 17
Avg $ Per SqFt: $200.71
Min Sale Price: $104,000
Max Sale Price: $1,593,400
Med Sale Price: $365,000
Date: Apr 2026
Sales: 31
Avg $ Per SqFt: $204.6
Min Sale Price: $145,000
Max Sale Price: $4,578,000
Med Sale Price: $367,500
Date: Mar 2026
Sales: 26
Avg $ Per SqFt: $203.63
Min Sale Price: $68,500
Max Sale Price: $800,000
Med Sale Price: $365,000
Date: Feb 2026
Sales: 11
Avg $ Per SqFt: $185.29
Min Sale Price: $213,000
Max Sale Price: $600,000
Med Sale Price: $330,000
Date: Jan 2026
Sales: 19
Avg $ Per SqFt: $171.91
Min Sale Price: $126,000
Max Sale Price: $948,000
Med Sale Price: $265,000
Date: Dec 2025
Sales: 13
Avg $ Per SqFt: $174.44
Min Sale Price: $195,000
Max Sale Price: $555,000
Med Sale Price: $300,000
Date: Nov 2025
Sales: 20
Avg $ Per SqFt: $187.16
Min Sale Price: $126,000
Max Sale Price: $395,000
Med Sale Price: $287,450
Date: Oct 2025
Sales: 25
Avg $ Per SqFt: $173.08
Min Sale Price: $135,500
Max Sale Price: $685,000
Med Sale Price: $369,000
Date: Sep 2025
Sales: 8
Avg $ Per SqFt: $163.48
Min Sale Price: $215,000
Max Sale Price: $600,000
Med Sale Price: $357,500
Sourced by Back At You
Aug 2026
Sales:
6
Avg $ Per SqFt:
$200.31
Min Sale Price:
$226,000
Max Sale Price:
$541,000
Med Sale Price:
$380,000
Jul 2026
Sales:
26
Avg $ Per SqFt:
$200.12
Min Sale Price:
$206,000
Max Sale Price:
$1,625,000
Med Sale Price:
$376,000
Jun 2026
Sales:
23
Avg $ Per SqFt:
$198.92
Min Sale Price:
$150,000
Max Sale Price:
$1,762,500
Med Sale Price:
$349,900
May 2026
Sales:
17
Avg $ Per SqFt:
$200.71
Min Sale Price:
$104,000
Max Sale Price:
$1,593,400
Med Sale Price:
$365,000
Apr 2026
Sales:
31
Avg $ Per SqFt:
$204.6
Min Sale Price:
$145,000
Max Sale Price:
$4,578,000
Med Sale Price:
$367,500
Mar 2026
Sales:
26
Avg $ Per SqFt:
$203.63
Min Sale Price:
$68,500
Max Sale Price:
$800,000
Med Sale Price:
$365,000
Feb 2026
Sales:
11
Avg $ Per SqFt:
$185.29
Min Sale Price:
$213,000
Max Sale Price:
$600,000
Med Sale Price:
$330,000
Jan 2026
Sales:
19
Avg $ Per SqFt:
$171.91
Min Sale Price:
$126,000
Max Sale Price:
$948,000
Med Sale Price:
$265,000
Dec 2025
Sales:
13
Avg $ Per SqFt:
$174.44
Min Sale Price:
$195,000
Max Sale Price:
$555,000
Med Sale Price:
$300,000
Nov 2025
Sales:
20
Avg $ Per SqFt:
$187.16
Min Sale Price:
$126,000
Max Sale Price:
$395,000
Med Sale Price:
$287,450
Oct 2025
Sales:
25
Avg $ Per SqFt:
$173.08
Min Sale Price:
$135,500
Max Sale Price:
$685,000
Med Sale Price:
$369,000
Sep 2025
Sales:
8
Avg $ Per SqFt:
$163.48
Min Sale Price:
$215,000
Max Sale Price:
$600,000
Med Sale Price:
$357,500
MLS Number: 1885489
Christopher Shepherd – chris@soldbyshep.com
Plum Tree Realty – (513) 443-5060
Request a showing
Request a showing
The information is being provided by CincyMLS. Information deemed accurate but not guaranteed. Information is provided for consumers personal, non-commercial use, and may not be used for any purpose other than the identification of potential properties for purchase. Copyright 2026 CincyMLS. All Rights Reserved.
© 2023 Dayton Area Board of Realtors. All rights reserved. Information deemed to be reliable but not guaranteed. The data relating to real estate for sale on this website comes from Dayton Area Board of Realtors and the Broker Reciprocity Program. Real estate listings held by brokerage firms other than Dayton Ohio MLS (DTON) - 48 - OH are marked with the BR logo and detailed information about them includes the name of the listing brokers. Listing broker has attempted to offer accurate data, but buyers are advised to confirm all items.