Introducing the Epitome of Luxury Living at 2005 Sunset Boulevard in Slidell, Louisiana - a Breathtaking Waterfront Estate, nestled in a Prestigious Guard Gated Community. This magnificent 6 bedroom, 4.5 bathroom single-family residence boasts 4,429 square feet of exquisite living space, set on a sprawling . 41-acre tropical oasis. * As you approach this stunning home, you'll be greeted by majestic Cantera wrought iron front entry doors revealing a grand foyer adorned with coffered ceilings. Entertain in style in the elegant dining room, showcasing 14-foot coffered ceilings and the adjoining spacious living room with its spectacular waterfront views, 24-foot cathedral ceiling w/ chandelier lift, custom built-ins, and opulent triple crown molding. * The gourmet kitchen is a chef's dream, featuring a DCS Fisher & Paykel professional gas range and double oven, built-in microwave drawer, oversized island and brushed gold accents - all enhanced by ambient above cabinet lighting. * Retreat to the lavish primary suite, boasting a dome ceiling, serene waterfront views, and a luxurious ensuite with massive walk-in shower, dual rain shower heads, large soaking tub, and expansive dual vanity. * The entertainment possibilities are endless with the stunning game room, complete with a built-in gas cooktop & grill, bar sink, ice maker, wine cooler, and drink refrigerator. Step outside to your private backyard paradise, featuring a saltwater pool, infinity edge hot tub, rock waterfall feature, gas fire pit & a travertine patio & pool deck - all surrounded by lush tropical landscaping. * Energy efficiency abounds with spray foam insulation, GEO thermal HVAC, and a whole house vac system. With its prime waterfront location, minutes by boat to Lake Pontchartrain and waterfront dining, this luxurious haven is truly a dream come true for the most discerning homebuyers. Don't miss your chance to call this exceptional residence your own - schedule your private showing today!
Single-familyProperty Type
2012Year Built
0.41 acresLot Size
$178Est. Price/Sq.Ft.
2 spacesParking
Listed by Kerri Lawless• eXp Realty, LLC
Contact: 337-522-7554
Bought with Jeff Breland• Century 21 Investment Realty
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
0.41 Acres
Year renovated
—
Sq. Ft.
4,429
Year built
2008
Style
Single Family Residential
County
St. Tammany Parish
APN
125933
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 18, 2026.
PUD
Planned Unit Development District.
A planned unit development or PUD describes a zoning designation and a process whereby limited deviation from the standards of this UDC is permitted to provide flexibility to accommodate innovative, high-quality site and building design that is otherwise not possible through the application of existing standards prescribed in the UDC. PUD applications shall be reviewed according to the procedures outlined in Chapter 200, Sec. 200-3.12. To be eligible to submit an application for a PUD zoning district map amendment, a proposed development must: Contain a mix of residential and commercial uses, where uses customarily permitted inresidential areas such as golf or community clubs or recreational areas do not qualify as a commercial use meeting this requirement; and Must include the following approaches in innovative land use planning: Environmentally sensitive design that includes preservation of existing natural features of a site that is of a higher quality than would be possible under the regulations otherwise applicable to the property that reduces the risk of flood damage to life and property and enhances drainage functions.; Diversification and variation in the relationship of residential uses, open space, setbacks, and the height of structures compatible with surrounding neighborhoods, which creates a variety of housing types, environments and living units characterized by a cohesive building, sign, and site development program. Minor changes to setbacks or lot width are not considered a variety of housing types; see Ch. 100 definition of housing types for more information.
Dec 6, 2023 • Final
Residential
Install a new generator.
Gas
Generator
Dec 6, 2023 • Final
Residential
Install a generator and carbon monoxide detectors in all bedrooms and living areas.
Electrical
Generator
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking Information
Parking Features: Attached Garage
Has Garage: Yes
Interior
Virtual Tour Information
Bathroom Information
# of Bathrooms (Full): 4
# of Bathrooms (Half): 1
Interior Features
Has Fireplace: Yes
Fireplace Features: Gas
Plank, Vinyl, Wood
Room Information
Rooms Total: 11
Exterior
Exterior Features
Dock
Foundation Details: Slab
Fencing: Wrought Iron
Roof: Asphalt, Shingle
Property Information
Residential
Property Sub Type: Single Family Residence
Structure Type: House
Traditional
Pool Features: Heated, Salt Water
Levels: Two
Lot Information
Lot Size Dimensions: 90 x 252 x 83 x 248
On Waterfront: Yes
Waterfront Features: Navigable Water
Financial
Tax Information
Parcel Number: 125933
Utilities
Utilities Information
Green Energy Efficient: Insulation
Water Source: Public
Utilities: Natural Gas Available
Sewer: Public Sewer
Location
HOA Information
Association Fee: $1,200
Association Fee Frequency: Annually
Has Association: Yes
Location Information
Subdivision Name: Lakeshore Estates
Community Features: Gated
Public facts
Beds: —
Baths: —
Sq. Ft.: 4,429
Stories: —
Lot Size: 0.41 acres
Style: Single Family Residential
Year Built: 2008
Year Renovated: —
County: St. Tammany Parish
APN: 125933
Home facts updated by county records on Sep 18, 2026
Around this home
Schools
K - 12
Preschool & daycare
Abney Elementary Early Childhood Center
Public PreK-K • Assigned • 3.4mi
St. Tammany Junior High School
Public 6-8 • Assigned • 4.1mi
3/10
Salmen High School
Public 9-12 • Assigned • 2.8mi
3/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
7/10 Flood Factor
Estimated 74-82% chance 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
10/10 Heat Factor
7 days above 108° expected this year, 21 days in 30 years
10/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
Slidell, LA • 70461
Average low and high temperatures (°F)
61°
42°
69°
50°
75°
57°
80°
63°
84°
69°
90°
75°
92°
77°
90°
75°
89°
71°
82°
63°
75°
57°
66°
47°
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 8.8 hours in
June and 5.2 hours in December, which is comparable to the
U.S. average for solar exposure.
8.8 hrs
5.2 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$749,000 – $907,000
Reach more buyers when you sell with Redfin. Save up to $7,882 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.