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.
| MLS # | 1885489 |
|---|---|
| Listing Type | For Sale |
| Style | House |
| HOA Dues | $1,000 |
| Sub-Type | Resale |
| Status | Active |
| Year | 1952 |
| Days On Site | 65 |
| Listing Provided By | Plum Tree Realty | Christopher Shepherd |
| Bed(s) | 6 |
|---|---|
| Bath(s) | 7 Total |
| SQ Feet | 10,533 |
| Garage | 4 |
| Basement | Y |
| Story(s) | 3 |
| Zoning | Residential |
| Acreage | 4.89 |
| Property View | River |
| Rooms Total | 20 |
|---|---|
| Heating | Electric, Forced Air, Heat Pump |
| Cooling | Central Air |
| Window Features | Double Pane, Vinyl |
| Appliances | Dishwasher, Double Oven, Gas Cooktop, Microwave, Refrigerator |
| Interior Features | 9Ft + Ceiling, Crown Molding, Multi Panel Doors, Natural Woodwork |
| Fireplace Features | Wood |
| Fireplaces Total | 3 |
| Roof | Slate |
|---|---|
| Exterior Features | Balcony, Fire Pit, Fireplace, Patio |
| Construction Materials | Stone, Wood Siding |
| Topography | Cleared, Level, Steep |
| Foundation Details | Poured |
| Parking Features | Asphalt, Driveway |
|---|
| Sewer | Public Sewer |
|---|---|
| Gas | Natural |
| Property | 23640 |
|---|
| State | OH |
|---|---|
| County | Hamilton |
| City | Anderson Twp |
| Zip Code | 45255 |
| Area | Hamilton E07 |
| Subarea | Hamilton E07 |
| Community Name | Anderson Twp. |
| School District | Forest Hills Local S |
| High School | Forest Hills Local S |
| Listing VS Median (in Anderson Twp.) | |
Price: $4,850,000 low | high Med: $407,500 sqft: 10,533 low | high Med: 2,046 $ / sqft: $460 low | high Med: $214 On site: 65 low | high Med: 58 | |
| State | OH |
|---|---|
| County | Hamilton |
| City | Anderson Twp |
| Zip Code | 45255 |
| Area | Hamilton E07 |
| Subarea | Hamilton E07 |
| Community Name | Anderson Twp. |
| School District | Forest Hills Local S |
| High School | Forest Hills Local S |
| Listing VS Median (in Anderson Twp.) | |
Price: $4,850,000 low | high Med: $407,500 sqft: 10,533 low | high Med: 2,046 $ / sqft: $460 low | high Med: $214 On site: 65 low | high Med: 58 | |