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.Start of property details
Property Description
Property Highlights
Location
Property Details
Building
Community
Local Schools
Interior Features
Bedrooms and Bathrooms
Rooms and Basement
Area and Spaces
Appliances
Interior Features
Heating and Cooling
Building Details
Construction
Materials
Terms
Terms
Taxes
HOA
Heating, Cooling & Utilities
Utilities
Lot
Exterior Features
Parking
Payment Calculator
Property History
Similar Properties
7803 Ayers Road
Anderson Twp, OH 45255
FOR
SALE
$4,850,000
Active
6
Beds
7
Baths
4
Garage
4.89
Acres
1952
Yr. Built
MLS# 1885489
Cumulative Days on Market: 104
· Includes prior listings
· Currently listed since 07/03/26
· Data provided by the MLS.
Property Type
Residential
Property Sub Type
Single Family Residence
Architectural Style
Chalet, Historical
Bedrooms
6
Total Bathrooms
7
Living Area
10,533
Price / Sqft
$460
Acres
4.89
Year Built
1952
Cumulative Days On Market
78
Area
Hamilton-E07
City/Township
Anderson Twp
View
River
County
Hamilton
Price
$4,850,000
Property Type
Residential
Property Sub Type
Single Family Residence
Suburb SIC
Anderson Twp.
Levels
Three+
School District
Forest Hills Local S
Total Bathrooms
7
Full Bathrooms
6
1/2 Bathrooms
1
Bedrooms
6
Total Rooms
20
Basement Features
Full
Living Area
10,533
Appliances
Dishwasher, Double Oven, Gas Cooktop, Microwave, Refrigerator
Interior Features
9Ft + Ceiling, Crown Molding, Multi Panel Doors, Natural Woodwork
Window Features
Double Pane, Vinyl
Fireplace Features
Wood
Heating Features
Electric, Forced Air, Heat Pump
Fireplaces
3
Architectural Style
Chalet, Historical
Year Built
1952
Foundations
Poured
Construction Materials
Stone, Wood Siding
Roof
Slate
Cumulative Days On Market
78
Has HOA
Yes
Association Fee
$1,000 /yr
Association Fee Includes
Association Dues
Cooling Features
Central Air
Sewer
Public Sewer
Water Source
Public
Acres
4.89
Lot Size Area Sq Ft
213,157
Exterior Features
Balcony, Fire Pit, Fireplace, Patio
Fencing
Metal
Garage Capacity
4
Parking Features
Asphalt, Driveway
Listed by Christopher Shepherd, Plum Tree Realty, 513-443-5060
Listing Data last updated 10/04/2026 01:20 pm
Get a Link to this Property: Copy To Clipboard
Phone:
per month.
fixed.
% interest.
$
%
$
%
Principal & Interest
+ Home Insurance
+ Property Tax
+ HOA Fees
Total interest paid over s will be:
All estimates and provided for informational purposes only. Actual amounts may vary. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice.
Information, rates, programs and loan scenarios shown are for example only as of 4-Oct-2026 and are subject to change without notice.
Interest rates provided by the St. Louis Federal Reserve Economic Data (FRED).
All products are subject to credit and property approval. Not all products are available in all states or for all loan amounts. Other restrictions and limitations apply.
Contact your preferred lender for the pricing associated with your specific transaction.
Calculations are generated by Open Source mortgage calculation software tools using common mathematical formulas. All calculations should be independently verified.
Get Walk Score Content
15 days ago
Property information last updated
92 days ago
Status Active. This is the date the listing was placed on market.
82821 days ago
Date Sold
Cumulative Days on Market: 104 days (includes prior listings)
· Currently listed since July 3, 2026.
Data provided by the MLS.