Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Reload
 
Listing provided courtesy of Comey & ShepherdMLS# 1853936MLS Provider
  • 299 days on site
  • 46 views

One of a Kind property where Words Cannot Describe the Feel of this Truly Remarkable Place. Custom Home on Rolling 40 acres Situated at the Edge of the Appalachian Mountains Overlooking Brush Creek valley with 2000' of Deep Water River Frontage. Located in the Heart of Protected Nature Conservancy Land holdings makes this Something Very Unique. Breathtaking Contemporary Home Features 7000 sq ft 5 Bed/6 Bath Open Floor Plan with Huge Great Room Overlooking your private 3 Acre Lake and Oasis. Amazing 2nd Story Balcony w/Expansive Long-Range Views of Surrounding Untouched Hill Country. Enormous Patio Runs up to Waters Edge w/Outdoor Kitchen, Pavilion, Dock & Beach area. Added Business/Rental Opportunity if Desired w/Additional 2 Bed Creek Side Cabin w/Screened in Porch & Deck. As well as 30x80 Custom Greenhouse that is State approved for Events. Unbelievable Property with Too Many Features to List. Additional Adjacent 87ac of land with Smaller Home plus Cabin Possibly Available.

Source: CincyMLS, MLS#: 1853936

Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
  • Property Type
    Residential
  • Lot
    40.05 acres

Get in Contact

Would you like to know more about this property? We're here to help! Let's connect and find what you're looking for.

Create a profile so you can receive updates on this property as soon as they happen!

  • Median Age
    43
  • Population Density
    72
  • College Educated
    23%
  • Estimated Median Income
    $40,345
  • Estimated Total Home Owners
    2,209
  • Estimated Total Renters
    1,125
  • Owner / Renter Divide
    66% / 34%
  • Estimated Average Household Size
    3
  • Total Population
    9,041
  • Community data courtesy of LiveBy, Inc.

Owning this Home

$
$ %
%
* All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

Life at 1805 Waggoner Riffle Road

Schools


School data courtesy of LiveBy, Inc.
Ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating. The schools displayed on this website are for informational purposes only and may not represent a complete or up-to-date list. School assignments are subject to change and should be verified directly with the local school district. Please contact the appropriate school district to confirm school zoning and enrollment eligibility for this property.

History

Date Event Value Agent
6/11/2026Source: CincyMLS Price Reduction
$2,650,000 -10.2%
5/20/2026Source: CincyMLS Status Change
Active
10/2/2025Source: CincyMLS Status Change
Pending
9/4/2025Source: CincyMLS Added to Database
September 04, 2025