Skip to content

Request a tour

Tell us when, and we'll take it from there.

Optional - usually gets you a faster reply.
← Back to search
1 / 99
For Sale
$4,850,000

7803 Ayers Road, Anderson Twp, OH, 45255

6
Beds
6.5
Baths
10,533
Sq ft

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.

Details

Type
Single Family Residence
Full baths
6
Half baths
1
Year built
1952
Lot (acres)
4.8934
Days on market
82
MLS #
1885489
County
Hamilton

Sale history

  1. Jul 3, 2026Listed
    Source: CincyMLS
    $4,850,000
  2. Jan 8, 2008Sold
    Warranty deed · Source: Hamilton County Auditor
    $1,100,000

Sold history: Hamilton County Auditor public records, retrieved Sep 19, 2026.

Listing dates and prices from CincyMLS.

Public-record transfers include non-sale deeds; a Transfer shows no price. Sold or Transfer follows each county's own sale-validity flag where it publishes one. Sale and deed dates are as recorded by each source; a price change is dated when our listing feed first showed it.

Location

Anderson Twp, OH 45255

Map shows the approximate property location.

Listed by Christopher Shepherd · 513-328-0905. Listing courtesy of Plum Tree Realty · 513-443-5060. Data via Cincinnati Multiple Listing Service.

Broker Reciprocity — MLS of Greater Cincinnati

The data relating to real estate appearing on this site comes in part from the Broker Reciprocity program of the Multiple Listing Service of Greater Cincinnati. Properties marked with the Broker Reciprocity icon are provided courtesy of the MLS of Greater Cincinnati. Information is deemed reliable but not guaranteed — independently verify all details. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Equal Housing Opportunity. Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved.

CincyMLS data last updated September 24, 2026 at 4:16 AM ET.

$4,850,000
For Sale