Estimated payment $29,007/month
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.
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 Assessment Tax 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 |
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 |
|---|---|---|---|---|
| 05/02/2026 05/02/26 | For Sale | $5,000,000 | -- | $475 / Sq Ft |
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 |
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 | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Closed | $1,250,000 | Unknown |
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
$275,000
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
Chris Shepherd Plum Tree Realty
$215,000 Pending
Welcome home to this charming and beautifully updated 2-bedroom, 1-bath ranch situated on over a half-acre lot in Goshen! This move-in ready home offers the perfect blend of modern updates and small-town charm. Start your mornings with a cup of coffee on the inviting covered front porch and enjoy the peaceful surroundings. Inside, you'll find updated finishes and a comfortable layout designed for
Chris Shepherd Plum Tree Realty
$339,000 New Construction
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
Chris Shepherd Plum Tree Realty
$225,000 Pending
Welcome home to this turn-key ready 4-bedroom, 1-bath gem located in the heart of the Village of Williamsburg. Situated on a quiet street, this home offers comfortable living with a fenced-in backyard perfect for kids, pets, or outdoor gatherings. Start your mornings relaxing with coffee on the porch and enjoy all the charm this peaceful neighborhood has to offer. Whether you are a first-time
Chris Shepherd Plum Tree Realty
$1,150,000
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
Chris Shepherd Plum Tree Realty
$265,000 Pending
No Showings until 5/8/26. Spacious 4 bed, 2 bath bi-level offering versatile living space throughout! The main level features comfortable living areas with ceiling fans in all bedrooms. The finished lower level includes a cozy family room with a woodburning fireplace, perfect for relaxing or entertaining, plus a dedicated study ideal for a home office or flex space. Enjoy the convenience of a
Chris Shepherd Plum Tree Realty
$1,350,000
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.
Chris Shepherd Plum Tree Realty
$1,350,000
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!
Chris Shepherd Plum Tree Realty
$299,000 $50K PRICE DROP
Looking for country living? This beautifully renovated 3 bed, 2 bath home sits on a wooded lot and blends rustic charm with modern updates. Features include an eat-in kitchen, spacious great room with cathedral wood ceiling, and oak plank hardwood floors. The primary suite offers a private ensuite bath. Enjoy the covered porch overlooking peaceful surroundings. A partial unfinished basement
Chris Shepherd Plum Tree Realty
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1877729
APN: 500-0184-0032
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
Ask me questions while you tour the home.