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.
ATTENTION INVESTORS! Welcome to 811 Main Street in Rising Sun! This 3-bedroom 1 bath home sits on over a half-acre lot, just outside of the historic district in Rising sun. The property has a rural feeling but sits just steps from town and is within a short walking distance to the Ohio River. The current owner has made some improvements including updated appliances, paint and a fireplace insert, however the home could use some TLC. This is a perfect home for someone who would like to add their own personal touches or a great opportunity for an investment property! The home has a full walkout basement with plenty of additional storage space. The property also includes a large barn.
Welcome to 811 Main Street in Rising Sun! Owner has to relocate for work so this wonderful property has become available! This 3 bedroom 1 bath home sits on nearly an acre lot, just outside of downtown Rising sun. The property has a rural feeling but sits just steps from town and is within a short walking distance to the Ohio River. The current owner has made some improvements including updated appliances, paint and a fireplace insert. This is a perfect home for someone who would like to add their own personal touches or a great opportunity for an investment property! The home has a full walkout basement with plenty of additional storage space. The property also includes a 30x30 barn. Don't miss out on your opportunity to own this wonderful home on a huge lot!
This amazing house is a beautiful balance of modern finishes and historical details. The combination of exposed brick, ceramic tile, stained wood, and barn doors is a decorator's delight. The open floorplan on the first floor lends itself to a warm and inviting home, perfect for entertaining. The 4 bedrooms upstairs are all quite spacious. The primary bedroom has a full bathroom attached. The outdoor space is second to none, boasting 2.65 partially wooded acres and an above-ground pool. Don't miss this meticulously maintained and lovingly cared for home, set your showing today!
Unplug and relax. Executive style historic stone house overlooking the Ohio River and nestled on a 5 acre hillside. Fully furnished with a wireless Apple device in each main room. The property line includes the hillâs summit down to the riverâs edge. The main suite on the top level presents a spectacular perch for observing all manner of river life and river commerce. The main living area presents an open floor plan, opening to a Florida room, with panoramic window placement to embrace the riverscape! A large glass door walks you out to the front deck- furnished with a fire pit. On the kitchen side, a large grilling deck is positioned with metal roofing. At the top of the long driveway is a large, heated 4 car garage, with a wall to wall workbench. Next to this is a finished parking area for your boat or recreational vehicles. The landscaping includes all varietal trees, magnolias, knock-out roses, boxwoods, azaleas, and ornamental grasses. Deer, turkey, and other wildlife are your neighbors here, and the birdwatching is spectacular- especially with the bald eagles nesting along the Ohio. Enjoy the hiking along deer trails to the summit. Also, nature has provided secluded locations above the main house for the buyer to design a potential day-cabin or artist-studio-Annex. Here, enjoy experiencing the four seasons, from sunrise to sunset, on the Ohio River!
![]() |
| The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity™ program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than Xome Inc. are marked with the Broker Reciprocity™ logo (the small house as shown above) and detailed information about them includes the name of the listing brokers. Copyright 2025 MLS of Greater Cincinnati, Inc. All rights reserved. The data relating to real estate for sale on this page is courtesy of the MLS of Greater Cincinnati, and the MLS of Greater Cincinnati is the source of this data. |
Albert Wright Page, License RB14038157, Xome Inc., License RC51300094, [email protected], 844-400-XOME (9663), 4471 North Billman Estates, Shelbyville, IN 46176

Information is provided exclusively for consumers personal, non - commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Copyright 2025, Southern Indiana Realtors Association. All rights reserved.
Rising Sun is located in Indiana. Rising Sun, Indiana 47040has a population of 2,271. Rising Sun 47040 is less family-centric than the surrounding county with 21.68% of the households containing married families with children. The county average for households married with children is 24.78%.
The median household income in Rising Sun, Indiana 47040 is $41,603. The median household income for the surrounding county is $63,036 compared to the national median of $69,021. The median age of people living in Rising Sun 47040 is 48.9 years.
The average high temperature in July is 85.9 degrees, with an average low temperature in January of 22.2 degrees. The average rainfall is approximately 44.3 inches per year, with 15.1 inches of snow per year.