Save
Ask
Tour
Hide
$5,000,000
18 Days On Site
7803 Ayers RoadAnderson Twp, OH 45255
For Sale|Single Family Residence|Active
6
Beds
7
Total Baths
6
Full Baths
1
Partial Bath
10,533
SqFt
$475
/SqFt
1952
Built
County:
Hamilton
Listing courtesy of Christopher Shepherd of Plum Tree Realty
Call Now: (513) 496-2967
Is this the listing for you? We can help make it yours.
(513) 496-2967
Save
Ask
Tour
Hide
Mortgage Calculator
Monthly Payment (Est.)
$22,812Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.
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.
Save
Ask
Tour
Hide
Listing Snapshot
Price
$5,000,000
Days On Site
18 Days
Bedrooms
6
Inside Area (SqFt)
10,533 sqft
Total Baths
7
Full Baths
6
Partial Baths
1
Lot Size
4.8934 Acres
Year Built
1952
MLS® Number
1877729
Status
Active
Property Tax
N/A
HOA/Condo/Coop Fees
$83.33 monthly
Sq Ft Source
N/A
Friends & Family
Recent Activity
| 3 weeks ago | Listing updated with changes from the MLS® | |
| 3 weeks ago | Listing first seen on site |
General Features
Acres
4.8934
Attached Garage
Yes
Garage
Yes
Garage Spaces
4
Levels
Three Or More
Parking
Garage Door OpenerAsphaltDrivewayAttached
Property Sub Type
Single Family Residence
Security
Security SystemSmoke Detector(s)
Sewer
Public Sewer
Style
ChaletHistorical
Utilities
Natural Gas Available
Water Source
Public
Zoning
Residential
Interior Features
Appliances
Electric Water HeaterDishwasherDouble OvenGas CooktopMicrowaveRefrigerator
Basement
FinishedFull
Cooling
Central Air
Fireplace
Yes
Fireplace Features
Wood BurningLiving RoomGreat Room
Fireplaces
3
Flooring
Wood
Heating
ElectricForced AirHeat Pump
Interior
Eat-in KitchenKitchen IslandPantryWalk-In Closet(s)Crown MoldingNatural WoodworkBookcases
Laundry Features
In Basement
Bathroom 1
Level - First
Bathroom 2
Level - Second
Bathroom 3
Level - Second
Bathroom 4
Level - Second
Bedroom 2
Dimensions - 15 x 13Level - SecondArea - 195
Bedroom 3
Dimensions - 16 x 12Level - SecondArea - 192
Bedroom 4
Dimensions - 19 x 17Level - SecondArea - 323
Bedroom 5
Dimensions - 15 x 20Level - SecondArea - 300
Bedroom 6
Dimensions - 17 x 10Level - FirstArea - 170
Dining Room
Dimensions - 20 x 18Level - FirstArea - 360
Entry Room
Level - FirstArea - 90
Family Room
Dimensions - 15 x 12Level - FirstArea - 180
Great Room
Level - Basement
Kitchen
Dimensions - 21 x 18Area - 378
LaundryRoom
Dimensions - 20 x 18Level - BasementArea - 360
Living Room
Dimensions - 25 x 13Area - 325
Master Bedroom
Dimensions - 23 x 14Level - FirstArea - 322
RecreationRoom
Dimensions - 16 x 9Level - BasementArea - 144
StudyLibDen
Dimensions - 15 x 12Level - FirstArea - 180
Save
Ask
Tour
Hide
Exterior Features
Construction Details
StoneWood Siding
Exterior
BalconyFire Pit
Lot Features
ClearedLevel
Patio And Porch
Patio
Roof
Slate
View
River
Waterview
River
Community Features
Association Dues
1000
Community Features
Golf
HOA Fee Frequency
Annually
MLS Area
Hamilton-E07
School District
Forest Hills Local S
Township
Anderson Twp
Schools
School District
Forest Hills Local S
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Christopher Shepherd of Plum Tree Realty
Listing information is provided by Participants of the Cincy MLS. 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. Copyright 2026, Cincy MLS.
Last checked: 2026-05-20 10:31 PM UTC
Listing information is provided by Participants of the Cincy MLS. 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. Copyright 2026, Cincy MLS.
Last checked: 2026-05-20 10:31 PM UTC
Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
What are you waiting for ?
