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.
Pending
Price cut: $50K (6/22)
$1,749,900
7788 White Rd, Rising Sun, IN 47040
5beds
5,298sqft
:
Get pre-qualified$10,298/mo
Single Family Residence
Built in 1997
40 Acres Lot
$1,652,500 Zestimate®
$330/sqft
$-- HOA
What's special
Serene pondBeautifully landscaped spacesModern comfortStunning fountain and waterfallWooded trailsCovered dock housePanoramic water views
- 281 days |
- 915 |
- 46 |
Zillow last checked:
Listing updated:
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
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: $330/sqft
- Tax assessed value: $814,000
- Annual tax amount: $9,914
- Date on market: 10/16/2025
- Listing terms: No Special Financing
Estimated market value
$1,652,500
$1.57M - $1.74M
$3,791/mo
Price history
| Date | Event | Price |
|---|---|---|
| 7/23/2026 | Pending sale | $1,749,900$330/sqft |
Source:  Cincy MLS #1858862 Report a problem | ||
| 6/22/2026 | Price change | $1,749,900-2.8%$330/sqft |
Source: Cincy MLS #1858862 Report a problem | ||
| 5/13/2026 | Price change | $1,799,900-2.7%$340/sqft |
Source: Cincy MLS #1858862 Report a problem | ||
| 3/20/2026 | Price change | $1,849,900-5.1%$349/sqft |
Source: Cincy MLS #1858862 Report a problem | ||
| 10/16/2025 | Listed for sale | $1,950,000+65.3%$368/sqft |
Source: MLS of Southeastern Indiana #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
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $9,914 +15.1% | $814,000 +21.5% |
| 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% |
| 2021 | $3,854 +2.5% | $448,300 +17% |
| 2020 | $3,760 -5.9% | $383,000 +1.4% |
| 2019 | $3,998 +4.3% | $377,600 -0.5% |
| 2018 | $3,832 +0.5% | $379,500 +1.3% |
| 2017 | $3,811 +7.2% | $374,600 -2.2% |
| 2016 | $3,556 +42.7% | $382,900 +4.2% |
| 2014 | $2,492 +10.7% | $367,300 -3.8% |
| 2013 | $2,251 +0.9% | $381,900 -4.5% |
| 2010 | $2,231 +28% | $400,000 +1.7% |
| 2009 | $1,743 -36.3% | $393,300 +3.9% |
| 2006 | $2,736 | $378,700 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 47040
Nearby schools
GreatSchools rating
- 6/10Ohio County Elementary-Middle SchoolGrades: PK-5Distance: 5.5 mi
- 4/10Ohio County Middle SchoolGrades: 6-8Distance: 5.5 mi
- 6/10Rising Sun High SchoolGrades: 9-12Distance: 5.7 mi
- $270,6003 bd2 ba1.3k sqft7661 White Rd, Rising Sun, IN 47040Off Market
- $733,7003 bd2 ba2.3k sqft7898 White Rd, Rising Sun, IN 47040Off Market
- $642,8002 bd1 ba1.1k sqft7442 White Rd, Rising Sun, IN 47040Off Market
- $436,800-- bd2 ba1.9k sqft7907 White Rd, Rising Sun, IN 47040Off Market
- $453,9003 bd3 ba1.3k sqft7354 White Rd, Rising Sun, IN 47040Off Market
- $332,9004 bd1 ba1.2k sqft8030 White Rd, Rising Sun, IN 47040Off Market
- $372,5002 bd1 ba1.2k sqft4498 Stahl Rd, Rising Sun, IN 47040Off Market
- $385,0003 bd2 ba1.8k sqft7949 White Rd, Rising Sun, IN 47040Sold
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
Similar homes
- $1,549,0005 bd7 ba6k sqft2424 Royal Castle Way, Union, KY 41091For Sale
MLS ID #643373, Douglas Lloyd, Home Advantage Concepts. NKMLS - $1,450,0004 bd4 ba4.8k sqft10832 Silver Charm Ln, Union, KY 41091For Sale
MLS ID #644881, Jennifer Oney-Hill, RE/MAX Victory + Affiliates. NKMLS - $1,420,0003 bd5 ba5.7k sqft11600 Long Branch Rd, Moores Hill, IN 47032For Sale
MLS ID #1829221, Regina M. Hamilton, Sibcy Cline, Inc.. Cincy MLS - $1,950,0004 bd1 ba4.1k sqft20401 Platt Rd, Guilford, IN 47022For Sale
MLS ID #1885915, Myra A. Clary, Sibcy Cline -Lawrenceburg. Cincy MLS - $1,200,0005 bd5 ba5.3k sqft1839 Harmony Hill Dr, Union, KY 41091For SaleMLS ID #644213, Kent Dailey, RE/MAX Victory + Affiliates. NKMLS
- $1,390,0004 bd3 ba2.8k sqft15110 Veterans Ln, Dillsboro, IN 47018For SaleMLS ID #206664, Pamela J. Ginder. MLS of Southeastern Indiana
- $1,500,0004 bd4 ba5.3k sqft20283 Meercham Way, Lawrenceburg, IN 47025For SaleMLS ID #207003, Deborah Tanner. MLS of Southeastern Indiana
- $1,199,9003 bd3 ba3.7k sqft4982 State Highway 47, Ghent, KY 41045For SaleMLS ID #644475, James Mirick, Pivot Realty Group. NKMLS
- $878,0005 bd5 ba3k sqft568 Lassing Way, Walton, KY 41094For SaleMLS ID #644874, Cindy Shetterly, Keller Williams Realty Service. NKMLS
- $2,500,0004 bd2 ba4.1k sqft7812 E Bend Rd, Burlington, KY 41005For SaleMLS ID #642073, Missy Bricking, Keller Williams Realty Service. NKMLS
- $995,0004 bd4 ba2.7k sqft635 Sunnybrook Dr, Florence, KY 41042For SaleMLS ID #644368, Christon Belden, Huff Realty - Florence. NKMLS
- $898,0005 bd5 ba6.1k sqft1342 Coastal Ct, Union, KY 41091For SaleMLS ID #645005, Cindy Shetterly, Keller Williams Realty Service. NKMLS
- $995,0004 bd4 ba3.7k sqft10667 Bridlepath Ln, Union, KY 41091For SaleMLS ID #643138, Susan Huff, Huff Realty - Florence. NKMLS
- $1,275,0004 bd4 ba3.2k sqft1525 Grapevine Rdg, Walton, KY 41094For SaleMLS ID #643125, Ann McMahan, Sibcy Cline, REALTORS-Florence. NKMLS
- $1,650,0004 bd3 ba4.3k sqft1709 Ledgestone Way, Hebron, KY 41048New ConstructionMLS ID #638568, Susan Huff, Huff Realty - Florence. NKMLS
- $999,9003 bd3 ba3k sqft3896 Long Run Rd, Vevay, IN 47043ActiveMLS ID #22067741, Brad Garrison, Whitetail Properties. MIBOR as distributed by MLS GRID
- $1,315,0005 bd4 ba5k sqft1465 Topaz Trace Ct, Hebron, KY 41048New ConstructionMLS ID #639247, Catherine Kennard, Keller Williams Advisors. NKMLS
- $1,260,0004 bd4 ba4k sqft1450 Topaz Trace Ct, Hebron, KY 41048New ConstructionMLS ID #641520, Catherine Kennard, Keller Williams Advisors. NKMLS
- $1,375,0004 bd5 ba3.3k sqft10900 Triple Crown Blvd, Union, KY 41091For SaleMLS ID #641087, Michele O'Brien, Huff Realty - Ft. Mitchell. NKMLS
- $895,0004 bd3 ba3.7k sqft3279 Ballantree Way, Verona, KY 41092For SaleMLS ID #644258, The Apex Group, Keller Williams Realty Service. NKMLS
