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.
Outside Features: Balcony, Fire Pit, Fireplace, Patio
Foundation: Poured
Listing Price: 4850000.00
Acres: 4.8934
New Construction: No
Garage/Parking
Garage Spaces: 4.00
Garage Carport: Garage Attached
Parking: Asphalt, Driveway
Utilities
Gas: Natural
Sewer: Public Sewer
Water Source: Public
Condo/Co-op/Association
HOA Fees: 1000.00
Fee Frequency: Annually
HOA Yes/No: Yes
Association: Cincinnati Area Multiple Listing Service
Fee Information
Inc.In HOA/Condo Fee: Association Dues
Schools
District: Forest Hills Local S
Green Features
Energy Green Features: No
Lot Info
Lot Size Sq Ft: 213157.00
Total Assessed Value: of record
Rental Info
Sub Lease: No
Tax Info
Tax Abatement: No
Map
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Source: Public Records
Average Home Value in this Area
Source: Public Records
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Year
Tax Paid
Tax AssessmentTax Assessment
Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property.
Land
Improvement
2025
$23,661
$377,678
$163,940
$213,738
2024
$23,066
$377,678
$163,940
$213,738
2023
$21,897
$377,678
$163,940
$213,738
2022
$25,731
$394,657
$176,397
$218,260
2021
$25,184
$394,657
$176,397
$218,260
2020
$25,396
$394,657
$176,397
$218,260
2019
$24,782
$349,255
$156,104
$193,151
2018
$23,163
$349,255
$156,104
$193,151
2017
$21,887
$349,255
$156,104
$193,151
2016
$24,579
$383,832
$213,252
$170,580
2015
$11,543
$383,832
$213,252
$170,580
2014
$11,551
$383,832
$213,252
$170,580
2013
$11,254
$376,303
$209,069
$167,234
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Event
Price
List to Sale
Price per Sq Ft
07/03/202607/03/26
For Sale
$4,850,000
--
$460 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Type
Sale Price
Title Company
Warranty Deed
$1,100,000
Attorney
Fiduciary Deed
$2,250,000
None Available
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
The Sold By Shep Team, led by brothers Mark and Chris Shepherd with extensive sales experience, offers specialized services in listing and marketing homes, military veteran assistance, relocation, and new construction. With unparalleled communication skills, personalized service, relentless energy and a deep understanding of the challenges of the current real estate market, our top-performing team is committed to helping our clients buy or sell properties quickly and efficiently. Our passion
Welcome home to this charming 3-bedroom, 2-bath home conveniently located just minutes from Sands Montessori School! Inside, you'll find beautiful original hardwood floors that add warmth and timeless character throughout the home. The functional layout offers comfortable living spaces perfect for everyday life. Step outside to enjoy the spacious back deck, ideal for entertaining, grilling, or
Welcome home to this charming 3-bedroom, 1-bath ranch conveniently located just minutes from Mt. Carmel, shopping, restaurants, and everyday amenities. Situated on over a half-acre lot, this home offers the perfect combination of privacy and convenience. Inside, you'll find new LVP flooring throughout, creating a fresh, modern feel and low-maintenance living. Step outside to enjoy the spacious,
Welcome home to this spacious quad-level brick home located on a quiet street in the heart of the Village of Bethel! Offering 4 bedrooms, 2.5 baths, this well-maintained property provides plenty of room for both everyday living and entertaining. The huge family room is the perfect gathering space for game nights, holidays, or relaxing with friends and family. Enjoy the comfort of multiple living
Brand new construction from Arnett Builders in desirable Williamsburg with NO HOA. This two-story 1,785 Sq Ft home on a corner lot offers 3 bedrooms, 2.5 baths, with an open concept and higher end finishes throughout. Main level features spacious 9 foot ceilings, built-in electric fireplace with durable LVP flooring. The gorgeous kitchen includes stainless steel appliances, beautiful granite
Welcome to your dream retreat! This beautiful home on 32+ acres blends comfort, charm, and nature. Inside, enjoy geothermal heating, propane fireplace, whole-house vacuum, Anderson windows, and Beech hardwood floors. The spacious primary suite features his & hers walk-in closets, Jacuzzi tub, walk-in shower, and raised double vanity. The kitchen offers cherry cabinets, granite counters, and opens
This property includes 21.19 acres of land ideally situated adjacent to railroad tracks and in close proximity to the Mt Orab mega site. Property includes two homes. A 3-bed, 1-bath ranch home with a second manufactured home and a couple barns/sheds on property. Value is in the land.
This property includes 19.36 acres of land ideally situated adjacent to railroad tracks and close proximity to the Mt Orab mega site with a 4-bed, 2-bath ranch home. Property also includes 36x56 pole barn, offering plenty of space for storage or work. Value is in the land!
Welcome home to this charming 2-bedroom, 1.5-bath home in the heart of Georgetown! Offering over 1,700 square feet of living space, this home is full of timeless character and thoughtful updates. Fresh interior and exterior paint provide a move-in ready feel, while the new metal roof (2023) offers added peace of mind. Inside, you'll love the decorative original fireplace, beautiful stained glass
Welcome home to this well-maintained 3-bedroom, 2-bath ranch tucked away at the end of a quiet cul-de-sac in desirable Lebanon! This home offers comfortable one-level living with the added bonus of a partially finished basement, providing extra space for a recreation room, home office, or hobbies. The oversized family room is perfect for entertaining family and friends, while the updated primary
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity. 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. Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded. Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
