Tabatha Hamilton, REALTOR®

eXp Realty · Greater Cincinnati

(513) 520-4491

Active · MLS of Greater Cincinnati

7803 Ayers Road

Anderson Twp, OH, 45255

$4,850,000

6 bd · 6.5 ba · 10,533 sqft · 119 days on market

Listing courtesy of Plum Tree Realty · Listed by Christopher Shepherd

Showing 12 thumbnails of 99 photos. Use the arrows in the larger view to see them all.

Status

Active

MLS #

1885489

Beds

6

Baths

6.5

Living area

10,533 sqft

Lot

4.9 ac

Year built

1952

Type

Residential

Listed

Jul 3, 2026

County

Hamilton

About this home

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.

Listing courtesy of Plum Tree Realty. Listed by Christopher Shepherd.

Tabatha Hamilton is not the listing agent for this home. She can help you as a buyer's agent.

Courtesy of the MLS of Greater Cincinnati.

© 2026 MLS of Greater Cincinnati, Inc. All rights reserved.

The data relating to real estate for sale on this website comes in part from the Internet Data Exchange (IDX) program of the MLS of Greater Cincinnati. Information is deemed reliable but not guaranteed. All measurements are approximate, and listing details may have changed since they were last refreshed. The brokerage named on each listing is the listing office.