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
Range of Values:
--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics
Collateral Analytics
Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.
Not Available
Collateral Analytics does not have data for the current month. Please view the chart for historical values.
ICE
ICE Mortgage Technology
ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.
Not Available
ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.
First American
First American
First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.
Not Available
First American does not have data for the current month. Please view the chart for historical values.
Quantarium
Quantarium
Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.
Not Available
Quantarium does not have data for the current month. Please view the chart for historical values.
Average Value
Not Available
List Price
Sold Price
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
$24,737
$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, 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,
Discover the perfect private retreat on this picturesque 10.49-acre property in Batavia. Tucked away in a peaceful setting, this scenic parcel features Back Bone Creek winding through the land, creating two stunning waterfalls that make this property truly one of a kind. Enjoy breathtaking views overlooking the Batavia Valley and spectacular sunset vistas. Whether you're looking for a weekend
This charming 3-bedroom, 1.5-bath brick ranch situated on 3 beautiful acres is available at 0% down in a USDA qualifying area! Offering comfortable one-level living, this home features an inviting eat-in kitchen and a screened-in back porch that's perfect for enjoying your morning coffee or tea while overlooking the peaceful, wooded backyard. The spacious acreage provides plenty of room to enjoy
This updated 3-bedroom, 1.5-bath ranch is tucked away at the end of a quiet street in the Goshen Local School District! Offering comfortable one-level living, the home features a fully remodeled eat-in kitchen completed in 2020. Major improvements include a new roof and siding in 2020, along with a new hot water heater in 2024. With a practical layout, valuable updates, and a convenient Goshen
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!
Privacy, space, and country livingthis one has it all, with not a single neighbor in sight! From the moment you turn onto the blacktop driveway leading into the tree-lined valley to this beautiful 3-bedroom, 2.5-bath home on 2+ acres, you'll know you've found something special. Inside, enjoy an oversized eat-in kitchen, dedicated office/den, huge bonus rec room, cozy wood-burning stove, and
Available at 0% down in USDA qualifying area. Welcome to this beautifully renovated 1,300 sq ft 3-bedroom, 2-bath ranch in the heart of Georgetown! This home has undergone a complete studs-out renovation, with everything from the foundation to the roof brought brand new. Updates include a new 200-amp electrical service, all-new plumbing and electrical, new sewer line, new HVAC, new siding, and a
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
