We Purchase, Trade, Consult & Market Residential & Commercial Real Estate

  • About
  • Contact
  • Careers
  • 337-984-4345
Guidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real Estate
  • 337-984-4345
  • Home
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Inherited Land
  • Who’s Your REALTOR®?
  • Success Coaching
  • Blog
  • Reviews

Agent on Call

agent

Andrea Laborde, REALTOR® Sales Associate
337-277-6503


$1,049,000
17239 Three Rivers Road
Covington, LA 70433
MLS# 2581172
4 beds  |  4 baths  |  6749 sqft


Photo 1
  1 / 41  
Photo 1 Photo 2 Photo 3 Photo 4 Photo 5 Photo 6 Photo 7 Photo 8 Photo 9 Photo 10 Photo 11 Photo 12 Photo 13 Photo 14 Photo 15 Photo 16 Photo 17 Photo 18 Photo 19 Photo 20 Photo 21 Photo 22 Photo 23 Photo 24 Primary bed room w/private sun room Photo 26 Photo 27 Photo 28 Photo 29 Photo 30 Photo 31 Photo 32 Photo 33 Photo 34 Photo 35 Photo 36 Photo 37 Photo 38 Photo 39 Photo 40 Photo 41

Property Description
PICTURESQUE POSTCARD VIEW!! *ALMOST 2 ACRES !! RARE DEEP WATER TCHEFUNCTE RIVER FRONT ~ Vacation hm/corporate/short term rental/snowbird escape!! (4th bedroom/in-law suite/office/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. Relax on your swing while watching boats pass by. For boating enthusiasts Additionally, there is a sep detached garage w/roll-up doors on two sides,multiple vehicles, boats, trailers, and more. (2 separate garages - 1 attached -1 detached) Immediate views of the breathtaking Tchefuncte River, rear yard, and oasis pool! The home boasts a 14-foot wet bar, perfect for hosting guests. There is also a separate 12 x 24 bonus room/4th bed rm that can be utilized as an in-law/guest suite/office/pool house, complete w/full bath offers optional private entrance. The primary suite w/private access to the pool/rear yard, 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.

Details
Listing Information
Comp Sale YN: No
Property Sub Type: Single Family Residence
Status Change Information
Status Change Timestamp: 2026-10-12
Delayed Marketing: No
Address
Parish or County: St. Tammany
Street Number: 17239
Street Name: Three Rivers
Street Suffix: Road
City Limits YN: No
State: LA
Postal Code (Zip): 70433
Directions: Three Rivers just past River Bend Drive on Right
Parcel Number: 23958
Cross Street: HWY 190 N
Contract
Current Price: $1,049,000
Original List Price: 1049000
Status: Active
Listing Contract Date: 2026-10-12
List Price: $1,049,000
Listing Agreement: Exclusive Right To Sell
Listing Service: Full Service
List Price/SqFt: 227.8
Interior
Bedrooms Total: 4
Bathrooms Total: 4
Bathrooms Full: 4
Living Area: 4605
Living Area Units: Square Feet
Living Area Source: Measured
Building Area Total: 6749
Building Area Units: Square Feet
Basement YN: No
Fireplace YN: Yes
Fireplaces Total: 2
Parking Information
Garage YN: Yes
Parking Total: 3
Building
Year Built: 1985
Approximate Age: 41 - 50 Years
Year Built Effective: 2024
Year Built Details: Never Flooded High/Dry- Electric Boat Lift, Whole home Comm Generator- w/warranty, Navigable Water Way, 4 Car Garage storage, boat, RV, 4th rm/bonus rm/pool house/office w/full bath, freshly painted exterior, 12 ft gunite pool (redone 5 yrs ago), New LVP Flooring
Property Attached YN: No
Home Warranty YN: No
Lot
Lot Size Dimensions: 210x417x230
Land Lease YN: No
Waterfront YN: Yes
Remarks
Public Remarks: PICTURESQUE POSTCARD VIEW!! *ALMOST 2 ACRES !! RARE DEEP WATER TCHEFUNCTE RIVER FRONT ~ Vacation hm/corporate/short term rental/snowbird escape!! (4th bedroom/in-law suite/office/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. Relax on your swing while watching boats pass by. For boating enthusiasts Additionally, there is a sep detached garage w/roll-up doors on two sides,multiple vehicles, boats, trailers, and more. (2 separate garages - 1 attached -1 detached) Immediate views of the breathtaking Tchefuncte River, rear yard, and oasis pool! The home boasts a 14-foot wet bar, perfect for hosting guests. There is also a separate 12 x 24 bonus room/4th bed rm that can be utilized as an in-law/guest suite/office/pool house, complete w/full bath offers optional private entrance. The primary suite w/private access to the pool/rear yard, 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.
Utility Providers
Electric Provider: CLECO
Tax Legal
Subdivision Name: River Isles
Property Features
Utilities: Natural Gas Not Available; Natural Gas Not Available
Appliances: Cooktop; Dishwasher; Disposal; Double Oven; Microwave; Range; Refrigerator
Architectural Style: Other
Construction Materials: Brick; Other
Cooling: Heat Pump; Other
Disclosures: Property As Is
Exterior Features: Dock
Fencing: Full; Security; Other
Fireplace Features: Wood Burning
Foundation Details: Slab
Heating: Heat Pump; Multiple Units
Interior Features: Guest Suite; Pantry; Stone Counters; Tray Ceiling(s); Wet Bar
Levels: One
Listing Terms (Financing): 1031 Exchange; Cash; Conventional; FHA; Lease Purchase; USDA/Rural Development; VA Loan
Lot Features: Rear Yard Vehicle Access
Other Equipment: Generator
Other Structures: Cabana
Parking Features: Attached Garage; RV Access/Parking
Patio And Porch Features: Covered; Patio: Oversized
Roof: Shingle
Security Features: Closed Circuit Camera(s)
Sewer: Other
Structure Type: House
Water Source: Well
Waterfront Features: Navigable Water; River Access
Showing Requirements: Appointment Only; Lockbox; Restricted Hours; Showing Service
Room Types: Bedroom; Bonus Room; Breakfast; Dining Room; Kitchen; Living Room; Office; Primary Bedroom
Room Information
Room Name Dimensions Remarks
Primary Bedroom34.00 X 20.00Lower Level
Dining Room25.00 X 17.00Lower Level
Office13.00 X 12.00Lower Level
Kitchen18.00 X 20.00Lower Level
Living Room27.50 X 24.30Lower Level
Breakfast12.00 X 14.00Lower Level
Bedroom13.00 X 16.50Lower Level
Bedroom14.00 X 15.00Lower Level
Bonus Room13.70 X 23.00Lower Level
Bedroom13.3x14.5Lower Level

IDX
Listing Office: NOLA Living Realty

Office Phone: 504-301-9757

Office Email: eric@nolaliving.com

Last Updated: October - 30 - 2026

Information deemed reliable but not guaranteed.


Broker Attribution: 504-301-9757

Search powered by FBS Products

Find Us

Get Directions
 

1232-A Camellia Blvd.
Lafayette, LA 70508
P: 337-984-4345

 

AGENT ON CALL | 337-277-6503

 

CALL US: 337-984-4345

 

GUIDRY & CO. REAL ESTATE, Lafayette, LA. All offices are independently owned and operated. The data relating to real estate for sale on this web site comes in part from the IDX Program of the Realtor® Association of Acadiana; MLS Real Estate listings held by brokerage firms other than GUIDRY & CO. REAL ESTATE are marked with the MLS approved icon for IDX. “Information Deemed Reliable But Not Guaranteed”. Copyright 2016 REALTOR® Association of Acadiana, All rights reserved.

Licensed & Regulated in the jurisdiction of the Louisiana Real Estate Commission, Members of the National Association of Realtors®, Louisiana Realtors®, Realtor® Association of Acadiana, Multiple Listing Service (MLS), Louisiana Commercial (www.lacdb.com), The Realtor® Commercial Alliance, Equal Housing Opportunity.

  • Home
  • 337-984-4345
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Looking to Buy?
    • Inherited Real Estate?
    • Choose Your REALTOR®
  • Blog
  • Success Coaching
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate