Loading...

Rising Sun, IN, 47040 • 47040 • Ohio County
$349/sqft
-$100,100 since Mar 20, 2026
Down payment assistance available
5Beds
4Baths
5,298Sqft
40 acLot
1997Built
Waterfront Property
Lake/Pond
Scenic Views
Lake/Pond · Trees/Woods
Chalet Style
Built 1997 · 29 years of history
Outdoor Living
Covered Deck/Patio · Deck · Patio · Porch
4 Fireplaces
Gas · Wood Burning · Outside · Basement · Dining Room · Great Room · Living Room · Master Bedroom
Special Features
Barn(s) · Guest House · Shed(s) · Workshop
3-Car Garage
Driveway
This home is getting attention
Listed 175 days ago · 1,587 views · 92 saves
Demand and pricing signals for this listing
1,587 views
People checking out this listing
92 saves
Buyers have saved this home
175 days on market
Established listing
$349/sqft
Price per square foot
Single Family · Built 1997
Escape to your own private paradise on 40 breathtaking acres surrounded by nature. This extraordinary property features a serene pond, wooded trails, and multiple structures blending rustic charm with modern comfort. The lodge-style main home offers panoramic water views and a stunning fountain and waterfall flowing through the circle drive into the pond, creating an unforgettable setting. Currently a successful short-term rental property, the estate includes a fully restored 1800s log cabin, a large workshop, and an oversized garage with an apartmentperfect for guests or caretakers. Outdoor living shines with multiple decks, a covered dock house, and beautifully landscaped spaces ideal for gatherings, relaxation, or recreation. Enjoy fishing, hiking, kayaking, and wildlife watchingall just a short drive from Cincinnati and CVG. A one-of-a-kind property with endless potential as a private estate, income-producing getaway, or family retreat.
Standout features identified
Our analysis highlights serene pond, beautifully landscaped spaces, and modern comfort as key attractions of this home.
Based on current rates
Est. 6.75% rate · 30yr fixed · $1,479,920 loan
Full calculator →Key facts and listing details
14 categories of property features
16 rooms detailed
Master Bedroom
FirstBedroom2
SecondBedroom3
LowerBedroom4
LowerBedroom5
LowerMaster Bathroom
Market data and value estimates
3 schools rated nearby
Rising Sun, IN, 47040
5 events
14 years of records
Local context around this listing
Rising Sun, IN • Ohio County
Nearby cities
Nearby zip codes
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 Zillow, Inc. 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. Zillow, Inc. 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
No obligation · Same-day response