- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
$4,850,000
Monthly Est:$24,140
6 Beds
7 Baths6 full baths + 1 half bath
10,533sqft
7803 Ayers Rd, Anderson Twp, OH 45255
$4,850,000
$24,140/moEst:
Get Pre-Approved
Single Family Residence
Built in 1952
$83.33/mo HOA
4.89 acres lot
$460/sq.ft
Description
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.
- Houzeo last checked: 12 hours ago
- Listing updated: September 8, 2026 at 2:06 pm
- Listing Provided by: Christopher Shepherd , Mark S Shepherd | Plum Tree Realty
- Source: Cincinnati MLS-OH | MLS#: 1885489
Property Details
Status
Active
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
1952
HOA Fees
$83.33/mo
Finished Area
10,533 sqft
Lot Size
4.89 acres lot
Basement Area
- sqft
MLS Name
Cincinnati MLS
MLS Number
1885489
MLS Status
Active
Days on Market
96
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
HOA Management
N/A
HOA Fees
$1,000/ Annually
Amenities
Amenities and services may be covered by one or multiple associations and service providers.
AssociationDues
Disclaimer: Amenities are based on third-party information and may vary; buyers must independently verify all amenities, as information is deemed reliable but not guaranteed.
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 6
Bathrooms: 7
Interior
Window Features
Double Pane, Vinyl
Appliances
Dishwasher, Double Oven, Gas Cooktop, Microwave, Refrigerator
Interior Features
9ft + Ceiling, Crown Molding, Multi Panel Doors, Natural Woodwork
Heating
Electric, Forced Air, Heat Pump
Sewer
Public Sewer
Exterior Features
Balcony, Fire Pit, Fireplace, Patio
Cooling
Central Air
Construction
Year Built
Year Built: 1952
Home type
Single Family Residence
Architectural Style
Chalet, Historical
Construction Materials
Stone, Wood Siding
Roof
Slate
Foundation Details
Poured
Utilities & Energy
Fireplace Features
Wood
Water Source
Public
Parking Features
Asphalt, Driveway
Basement
Full
Price History
| Date | Event | Price |
|---|---|---|
09/08/2026 Source: | Listed for Sale | $4,850,000 $460/sqft |
Nearby Homes
Find Homes by Property Features in Anderson Twp, OH
Nearby New Homes For Sale
Based on information from the Multiple Listing Service of Greater Cincinnati (alternatively the REALTOR Alliance of Greater Cincinnati) through Oct 07, 2026, 06:00AM. IDX information is provided exclusively for consumers’ personal, non-commercial use, it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and the data is deemed reliable but is not guaranteed accurate by the MLS. The listings of some real estate brokerage firms have been excluded. The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed. Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Advertising Broker: Nicholas Huscroft | Chosen Realty