One of a Kind, Stunning, Amazing! Words Cannot Describe the Magnitude & Feel of this Truly Remarkable Property. 40 acres Situated at the Base of the Foothills of the Appalachian Mountains Overlooking the Valley on Brush Creek, in the Heart of Protected Nature Conservancy Lands Makes this Something Very Special. Breathtaking Custom Contemporary Home Features 7000 sq ft 5 Bed/6 Bath Open Floor Plan, Impressive Great Room w/Huge Picture Windows & 2 Commercial Kitchen/Bar Areas Overlooking 4 Acre Lake. 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 Overlooking Brush Creek w/2000' of Secluded Deep Water River Frontage Along w/30x80 Custom Greenhouse that is State Approved Event/Wedding Venue. Unbelievable Opportunity, Far Too Many Features to List!
Pending
$2,950,000
1805 Waggoner Riffle Rd, West Union, OH 45693
5beds
7,051sqft
Est.:
Single Family Residence
Built in 2009
40.05 Acres Lot
$-- Zestimate®
$418/sqft
$-- HOA
What's special
Creek side cabinCustom contemporary homeOpen floor planCustom greenhouseDeck overlooking brush creekBeach areaScreened in porch
- 125 days |
- 45 |
- 0 |
Zillow last checked: 8 hours ago
Listing updated: December 18, 2025 at 06:53am
Listed by:
G. Tyler McConnell 513-582-1126,
Comey & Shepherd REALTORS
Source: DABR MLS,MLS#: 942881
Originating MLS: Dayton Area Board of REALTORS
Originating MLS: Dayton Area Board of REALTORSFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 6
- Full bathrooms: 5
- 1/2 bathrooms: 1
- Main level bathrooms: 3
Primary bedroom
- Level: Main
- Dimensions: 17 x 17
Bedroom
- Level: Main
- Dimensions: 18 x 18
Bedroom
- Level: Second
- Dimensions: 18 x 19
Bedroom
- Level: Main
- Dimensions: 16 x 17
Bedroom
- Level: Second
- Dimensions: 14 x 24
Dining room
- Level: Main
- Dimensions: 12 x 20
Entry foyer
- Level: Main
- Dimensions: 7 x 10
Family room
- Level: Main
- Dimensions: 14 x 26
Kitchen
- Level: Main
- Dimensions: 20 x 20
Laundry
- Level: Main
- Dimensions: 8 x 16
Living room
- Level: Main
- Dimensions: 19 x 26
Heating
- Forced Air, Geothermal
Cooling
- Central Air
Appliances
- Included: Cooktop, Dryer, Dishwasher, Refrigerator, Washer, Gas Water Heater
Features
- Cathedral Ceiling(s), Kitchen Island, Pantry, Quartz Counters, Solid Surface Counters, Walk-In Closet(s)
- Windows: Bay Window(s), Casement Window(s), Double Pane Windows, Insulated Windows
- Basement: Crawl Space
- Number of fireplaces: 2
- Fireplace features: Two, Gas, Wood Burning
Interior area
- Total structure area: 7,051
- Total interior livable area: 7,051 sqft
Property
Parking
- Total spaces: 2
- Parking features: Detached, Garage, Two Car Garage
- Garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Patio
- Exterior features: Deck, Patio, Propane Tank - Leased
Lot
- Size: 40.05 Acres
- Dimensions: 40.05 ac
Details
- Parcel number: 1610000011002
- Zoning: Agricultural,Unzoned
- Zoning description: Agricultural,Unzoned
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Fiber Cement, Stone
Condition
- Year built: 2009
Utilities & green energy
- Sewer: Septic Tank
- Water: Public
- Utilities for property: Septic Available, Water Available
Community & HOA
Community
- Security: Surveillance System
HOA
- Has HOA: No
Location
- Region: West Union
Financial & listing details
- Price per square foot: $418/sqft
- Date on market: 9/4/2025
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 10/2/2025 | Pending sale | $2,950,000$418/sqft |
Source:  Cincy MLS #1853936 Report a problem | ||
| 9/4/2025 | Listed for sale | $2,950,000$418/sqft |
Source: Cincy MLS #1853936 Report a problem | ||
Public tax history
Public tax history
Tax history is unavailable.BuyAbility℠ payment
Est. payment
$14,512/mo
Principal & interest
$11439
Property taxes
$2040
Home insurance
$1033
Climate risks
Neighborhood: 45693
Nearby schools
GreatSchools rating
- 6/10Manchester Elementary SchoolGrades: PK-6Distance: 7.2 mi
- 6/10Manchester High SchoolGrades: 7-12Distance: 7.2 mi
Schools provided by the listing agent
- District: Adams County
Source: DABR MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- Loading
