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.
For sale
$1,950,000
7788 White Rd, Rising Sun, IN 47040
5beds
5,298sqft
Est.:
Single Family Residence
Built in 1997
40 Acres Lot
$1,846,100 Zestimate®
$368/sqft
$-- HOA
What's special
Serene pondBeautifully landscaped spacesModern comfortStunning fountain and waterfallWooded trailsCovered dock housePanoramic water views
- 99 days |
- 1,128 |
- 65 |
Zillow last checked: 9 hours ago
Listing updated: November 10, 2025 at 06:35am
Listed by:
Adam J Hayhow 513-315-1501,
Coldwell Banker Realty 513-321-9944
Source: Cincy MLS,MLS#: 1858862
Originating MLS: Cincinnati Area Multiple Listing Service
Originating MLS: Cincinnati Area Multiple Listing Service
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Walkout, Fireplace
- Level: First
- Area: 304
- Dimensions: 19 x 16
Bedroom 2
- Level: Second
- Area: 600
- Dimensions: 25 x 24
Bedroom 3
- Level: Lower
- Area: 140
- Dimensions: 14 x 10
Bedroom 4
- Level: Lower
- Area: 150
- Dimensions: 15 x 10
Bedroom 5
- Level: Lower
- Area: 182
- Dimensions: 14 x 13
Primary bathroom
- Features: Built-In Shower Seat, Shower, Tile Floor
Bathroom 1
- Features: Full
- Level: First
Bathroom 2
- Features: Full
- Level: Second
Bathroom 3
- Features: Full
- Level: Lower
Bathroom 4
- Features: Partial
- Level: First
Dining room
- Features: Built-in Features, Chandelier, Walkout, Fireplace
- Level: First
- Area: 304
- Dimensions: 19 x 16
Family room
- Features: Walkout
- Area: 475
- Dimensions: 25 x 19
Great room
- Features: Walkout, Fireplace
- Level: First
- Area: 575
- Dimensions: 25 x 23
Kitchen
- Features: Pantry, Planning Desk, Eat-in Kitchen, Tile Floor, Gourmet, Kitchen Island, Wood Cabinets, Marble/Granite/Slate
- Area: 150
- Dimensions: 15 x 10
Living room
- Features: Walkout, Fireplace
- Area: 1
- Dimensions: 1 x 1
Office
- Features: Bookcases
- Level: First
- Area: 130
- Dimensions: 13 x 10
Heating
- Electric, Forced Air, Geothermal
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Dishwasher, Double Oven, Dryer, Microwave, Oven/Range, Refrigerator, Washer, Electric Water Heater
Features
- High Ceilings, Beamed Ceilings, Cathedral Ceiling(s), Vaulted Ceiling(s), Ceiling Fan(s), Recessed Lighting
- Windows: Casement, Vinyl
- Basement: Full,Finished,Walk-Out Access
- Number of fireplaces: 4
- Fireplace features: Gas, Wood Burning, Outside, Basement, Dining Room, Great Room, Living Room, Master Bedroom
Interior area
- Total structure area: 5,298
- Total interior livable area: 5,298 sqft
Property
Parking
- Total spaces: 3
- Parking features: Driveway
- Garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered Deck/Patio, Deck, Patio, Porch
- Exterior features: Balcony, Fire Pit, Fireplace
- Has view: Yes
- View description: Lake/Pond, Trees/Woods
- Has water view: Yes
- Water view: Lake/Pond
- Waterfront features: Lake/Pond
Lot
- Size: 40 Acres
- Dimensions: 1334 x 1339
- Features: Wooded, 20 to 49 Acres, Fountain
- Topography: Lake/Pond,Level,Rolling,Stream/Creek
- Residential vegetation: Partially Wooded
Details
- Additional structures: Barn(s), Guest House, Shed(s), Workshop
- Parcel number: 580511300002.000001
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Chalet
- Property subtype: Single Family Residence
Materials
- Wood Siding
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 1997
Utilities & green energy
- Electric: 220 Volts
- Gas: Propane
- Sewer: Septic Tank
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Rising Sun
Financial & listing details
- Price per square foot: $368/sqft
- Tax assessed value: $670,200
- Annual tax amount: $9,914
- Date on market: 10/16/2025
- Listing terms: No Special Financing
Estimated market value
$1,846,100
$1.75M - $1.94M
$3,673/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 10/16/2025 | Listed for sale | $1,950,000+65.3%$368/sqft |
Source: SEIBR #206180 Report a problem | ||
| 8/25/2020 | Sold | $1,180,000-5.6%$223/sqft |
Source:  MIBOR as distributed by MLS GRID #21699749 Report a problem | ||
| 7/13/2020 | Pending sale | $1,250,000$236/sqft |
Source: MIBOR REALTOR Association #21699749 Report a problem | ||
| 5/1/2020 | Listed for sale | $1,250,000$236/sqft |
Source: Encore Sotheby's International Realty #21699749 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $8,614 +20.3% | $670,200 +18.3% |
| 2023 | $7,160 +1.7% | $566,600 +4.5% |
| 2022 | $7,039 +82.6% | $542,300 +21% |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$11,216/mo
Principal & interest
$9542
Property taxes
$991
Home insurance
$683
Climate risks
Neighborhood: 47040
Nearby schools
GreatSchools rating
- 6/10Ohio County Elementary-Middle SchoolGrades: PK-5Distance: 5.5 mi
- 3/10Ohio County Middle SchoolGrades: 6-8Distance: 5.5 mi
- 6/10Rising Sun High SchoolGrades: 9-12Distance: 5.7 mi
