PICTURESQUE POSTCARD VIEW!! * ALMOST 2 ACRES !! RARE DEEP WATER TCHEFUNCTE RIVER FRONT ~ Vacation hm/corporate/short term rental/snowbird escape!! READY FOR MOVE-IN. .. 3 bed / 4 bath + bonus room w/ full bath! (could be 4th bed room/in-law suite/office) Sprawling Estate in a manicured, park-like setting, with a lovely gazebo and a rock waterfall pool! Enjoy the tranquil atmosphere while fishing off the pier or taking a boat ride on the beautiful, deep-water Tchefuncte River, which conveniently leads to restaurants & Lake Pontchartrain. The home features a stunning gunite waterfall pool with views that can be enjoyed from inside/outside. Flip of a switch-lowers your boat into the water. Take a leisurely stroll to the riverbank and relax on your swing while watching boats pass by. For boating enthusiasts, there is easy access to the river. Additionally, there is a separate detached garage with roll-up doors on two sides, providing ample storage space for multiple vehicles, boats, trailers, and more. (4 car storage) Step inside the home, and you'll have immediate views of the breathtaking Tchefuncte River, rear yard, and oasis pool! The open split floor plan allows for a seamless flow between rooms. The home boasts a 14-foot wet bar, perfect for hosting guests. There is also a separate 12 x 24 bonus room that can be utilized as an in-law/ guest suite/office/pool house/4th bed rm, complete w/ full bath offers optional private entrance. The primary suite is a true retreat, with private access to the pool/rear yard, a private enclosed sun room, and a spacious oversized 17 x 17 walk-in closet featuring a three-way full-length mirror. Cozy fireplace in the sitting area. Kitchen offers a well-equipped space, JENN-AIR double oven, fridge/freezer, double bar. Additional features of this remarkable property include a commercial-grade whole-home generator w/ separate in-ground propane tank (largest tank) w/ warranty, a sprinkler system, remote blinds, & FULL HOUSE SURVEILLANCE SYSTEM W/ remote view. Covered areas for grilling, RV parking, and a detached garage that offers even more storage space, this property has everything you need and more. Don't miss the opportunity to own this breathtaking view and endless amenities.
PICTURESQUE POSTCARD VIEW!! *ALMOST 2 ACRES !! RARE DEEP WATER TCHEFUNCTE RIVER FRONT ~ Vacation hm/corporate/short term rental/snowbird escape!! READY FOR MOVE-IN... 3 bed / 4 bath + bonus room w/full bath! (could be 4th bed room/in-law suite/office) <br Sprawling Estate in a manicured, park-like setting, with a lovely gazebo and a rock waterfall pool! Enjoy the tranquil atmosphere while fishing off the pier or taking a boat ride on the beautiful, deep-water Tchefuncte River, which conveniently leads to restaurants & Lake Pontchartrain.
The home features a stunning gunite waterfall pool with views that can be enjoyed from inside/outside. Flip of a switch-lowers your boat into the water. Take a leisurely stroll to the riverbank and relax on your swing while watching boats pass by.
For boating enthusiasts, there is easy access to the river. Additionally, there is a separate detached garage with roll-up doors on two sides, providing ample storage space for multiple vehicles, boats, trailers, and more. (4 car storage)
Step inside the home, and you'll have immediate views of the breathtaking Tchefuncte River, rear yard, and oasis pool! The open split floor plan allows for a seamless flow between rooms. The home boasts a 14-foot wet bar, perfect for hosting guests. There is also a separate 12 x 24 bonus room that can be utilized as an in-law/guest suite/office/pool house/4th bed rm, complete w/full bath offers optional private entrance. The primary suite is a true retreat, with private access to the pool/rear yard, a private enclosed sun room, and a spacious oversized 17 x 17 walk-in closet featuring a three-way full-length mirror. Cozy fireplace in the sitting area. Kitchen offers a well-equipped space, JENN-AIR double oven, fridge/freezer, double bar.
Additional features of this remarkable property include a commercial-grade whole-home generator w/separate in-ground propane tank (largest tank) w/warranty, a sprinkler system, remote blinds, & FULL HOUSE SURVEILLANCE SYSTEM W/remote view. Covered areas for grilling, RV parking, and a detached garage that offers even more storage space, this property has everything you need and more. Don't miss the opportunity to own this breathtaking view and endless amenities.
AcadianaMLS #NO2491712
Mar 7, 2026
Relisted
—
Jan 8, 2026
Price Changed
$1,175,000
$259/sq ft
Jul 30, 2025
Price Changed
$1,385,000
$305/sq ft
Mar 17, 2025
Listed
$1,395,000
$307/sq ft
GSREIN #3
Jan 8, 2026
Price Changed
$1,175,000
$259/sq ft
Jul 30, 2025
Price Changed
$1,385,000
$305/sq ft
AcadianaMLS #NO2470740
Oct 5, 2024
Listed
$1,495,000
$329/sq ft
AcadianaMLS #NO2456737
Jul 3, 2024
Listed
$1,495,000
$329/sq ft
GSREIN #2
Jun 3, 2024
Price Changed
$1,495,000
$329/sq ft
AcadianaMLS #NO2441411
Apr 2, 2024
Listed
$1,495,000
$329/sq ft
GSREIN #1
Aug 24, 2023
Price Changed
$1,895,000
$417/sq ft
AcadianaMLS #NO2400786
Jun 26, 2023
Listed
$1,895,000
$417/sq ft
Public Records
May 15, 1997
Sold
$530,000
$117/sq ft
GSREIN #309835
Jan 13, 1997
Listed
$550,000
$121/sq ft
AcadianaMLS #NO309835
Jan 13, 1997
Listed
$550,000
$121/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$6,290 (−4.4%)
$12,000 + $51,558
$63,558
2024
$6,583 (+4.2%)
$12,000 + $51,943
$63,943
2023
$6,318
$12,000 + $46,121
$58,121
2022
$6,318 (+0.2%)
$12,000 + $46,121
$58,121
2021
$6,305 (+0.1%)
$12,000 + $46,121
$58,121
2020
$6,296 (−7.3%)
$12,000 + $46,121
$58,121
2019
$6,790 (−0.8%)
$11,730 + $40,992
$52,722
2018
$6,848 (−0.7%)
$11,730 + $40,992
$52,722
2017
$6,899 (−0.4%)
$11,730 + $40,992
$52,722
2016
$6,930 (+3.4%)
$11,730 + $40,992
$52,722
2014
$6,701 (−0.6%)
$11,225 + $39,227
$50,452
2013
$6,739
$11,225 + $39,227
$50,452
Public record
Public record
Zoning
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
0.41 Acres
Year renovated
—
Finished Sq. Ft.
4,605
Unfinished Sq. Ft.
—
Total Sq. Ft.
4,605
Year built
1985
Style
Single Family Residential
County
St. Tammany Parish
APN
23958
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jun 29, 2026.
S-1
Suburban Residential District.
The S-1 Suburban Residential District is intended to provide single-family residential
dwellings in a setting of moderate urban density. Central utility systems, convenience to
commercial and employment centers and efficient access to major transportation routes are
characteristics of this district. To protect the intention of the district, permitted activities are limited to single-family dwellings and certain utility uses. All commercial uses are prohibited in
the S-1 District.
Permitted uses
Include but are not limited to:
Agriculture
Housing-Single unit
Wastewater treatment
Climate risks
2/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
9/10 Heat Factor
7 days above 109° expected this year, 21 days in 30 years
9/10 Wind Factor
99% chance of strong winds in next 30 years
2/10 Air Factor
1 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Covington, LA • 70435
Average low and high temperatures (°F)
61
41
70
49
77
56
81
63
84
68
91
75
92
76
92
75
88
71
83
61
74
55
65
47
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
94/ 100
Exceptional sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10 hrs
7.5 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 17239 Three Rivers Rd
$1,124,409
$51K under list price of $1.18M
Nearby comparable homes
The Redfin Estimate uses 5 recent nearby sales, priced between $605K to $1.4M.