$1,139,900
Slidell, LA 70461
MLS# NO2549844
4 beds | 3.2 baths | 5711 sqft
1 / 35
Property Description
This 3-story waterfront home offers over 5,700 sq ft of thoughtfully designed space for everyday comfort and easy entertaining. Featuring 4 bedrooms, 4 full baths, and 2 half baths, the home also includes a theater room, office, third-floor bonus room with full bath, and two living areas. Interior highlights include all new ThinQ smart appliances, marble flooring in main living areas, and a striking marble staircase. A gas fireplace connects the living room and primary suite. The primary retreat opens to the pool and features a spa-like bath with garden tub, waterfall shower, double closets, and makeup vanity. The kitchen and butler's pantry are fully equipped with an ice machine and wine cooler, plus a temperature-controlled wine cellar. Upstairs offers three bedrooms, including a Jack-and-Jill layout, an additional full bath, theater room with projector and surround sound, private office, and a living area opening to a balcony overlooking the pool, boathouse, and water. The third floor provides flexible bonus space, and the floored attic includes a full bathroom. Outdoors, enjoy a large backyard with a pool featuring barstools, safety net, outdoor kitchen, and outdoor bath. Additional features include a dog run, two storage sheds, and a boathouse with two electric hoists, sink, storage, electricity, and ice machine. A 3-car garage with built-ins, security system, surround sound, spray foam attic insulation, new waterproof front door, and new back doors (valued at $20K) complete this well-appointed waterfront property.
Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 247.7
Document Modified: 2026-03-27 19:28:49.308420
Status: Active
Listing Date: 2026-03-27
Listing Price: 1139900
Current Price: $1,139,900
Type: Single Family Residence
Modification Timestamp: 2026-06-11T16:04:49Z
Photo Modified: 2026-03-28T00:28:51Z
Location, Tax & Legal Info
Legal Desc: LOT 210 LAKESHORE ESTATES PH 1A3 INST NO 1013835 INST NO 1450529 INST NO 1727684 INST NO 2025863 INST NO 2176350
General Property Description
Lot Dimensions: 90x25081x250
Stories: 3
SqFt - Living: 4602
SqFt - Source: Measured
SqFt - Total: 5711
Assn Fee $: 1500
Assn Fee Terms: Yearly
Acreage Range: 0 - 0.5
# Bedrooms: 4
Baths - Full: 3
Baths - 1/2: 2
Total Baths: 3.2
Year Built: 2006
Remarks & Misc
Remarks: This 3-story waterfront home offers over 5,700 sq ft of thoughtfully designed space for everyday comfort and easy entertaining. Featuring 4 bedrooms, 4 full baths, and 2 half baths, the home also includes a theater room, office, third-floor bonus room with full bath, and two living areas. Interior highlights include all new ThinQ smart appliances, marble flooring in main living areas, and a striking marble staircase. A gas fireplace connects the living room and primary suite. The primary retreat opens to the pool and features a spa-like bath with garden tub, waterfall shower, double closets, and makeup vanity. The kitchen and butler's pantry are fully equipped with an ice machine and wine cooler, plus a temperature-controlled wine cellar. Upstairs offers three bedrooms, including a Jack-and-Jill layout, an additional full bath, theater room with projector and surround sound, private office, and a living area opening to a balcony overlooking the pool, boathouse, and water. The third floor provides flexible bonus space, and the floored attic includes a full bathroom. Outdoors, enjoy a large backyard with a pool featuring barstools, safety net, outdoor kitchen, and outdoor bath. Additional features include a dog run, two storage sheds, and a boathouse with two electric hoists, sink, storage, electricity, and ice machine. A 3-car garage with built-ins, security system, surround sound, spray foam attic insulation, new waterproof front door, and new back doors (valued at $20K) complete this well-appointed waterfront property.
Office/Member/Contract Info
List AOR: NOMAR
Style
Traditional: 1
Siding
Stucco: 1
Parking
Attached: 1
Garage: 1
Foundation
Slab: 1
Exterior
Balcony: 1
Outside Kitchen: 1
Fireplace
Gas Log: 1
Roof
Composition: 1
Heating
Central: 1
Interior
Cathedral Ceiling: 1
Cooling
2 or More Units: 1
Central Air: 1
Appliances
Dishwasher: 1
Disposal: 1
Ice Machine: 1
Countertops
Granite: 1
Rooms
Bathroom 1: 1
Bedroom 1: 1
Bonus Room: 1
Den: 1
Dining Room: 1
Foyer: 1
Kitchen: 1
Laundry: 1
Living Room: 1
Primary Bathroom: 1
Primary Bedroom: 1
Office: 1
Other: 1
Bedroom 2: 1
Bedroom 3: 1
Bedroom 4: 1
Bedroom 5: 1
Bathroom 2: 1
Bathroom 3: 1
Bathroom 4: 1
Bathroom 5: 1
Bedroom 6: 1
Bedroom 7: 1
Bedroom 8: 1
Waterfront
Dock/Mooring: 1
Lake/Pond: 1
Fencing
Wood: 1
Other: 1
Lot
Water Frontage: 1
Other Structures
Workshop: 1
Pool
Inground: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 57537356
Originating System Listing ID: 2549844
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 2273
Street Name: SUNSET Boulevard
Parish: St. Tammany
State: LA
Zip Code: 70461
Tax Assessment Number: 126311
Directions: Bounding Streets: Lakeshore Blvd South
Property Features
Style: Traditional
Siding: Stucco
Parking: Attached; Garage
Foundation: Slab
Roof: Composition
Interior: Cathedral Ceiling
Fireplace: Gas Log
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Disposal; Ice Machine
Countertops: Granite
Rooms: Bathroom 1; Bedroom 1; Bonus Room; Den; Dining Room; Foyer; Kitchen; Laundry; Living Room; Office; Other; Primary Bathroom; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4; Bedroom 5; Bathroom 2; Bathroom 3; Bathroom 4; Bathroom 5; Bedroom 6; Bedroom 7; Bedroom 8
Fencing: Wood; Other
Lot: Water Frontage
Exterior: Balcony; Outside Kitchen
Other Structures: Workshop
Waterfront: Dock/Mooring; Lake/Pond
Pool: Inground
Room Information
| Room Name | Length | Width | Remarks |
| Bonus Room | 15.40 | 11.50 | Bonus Room |
| Bonus Room | 15.40 | 11.50 | Bonus Room |
| Bonus Room | 15.40 | 11.50 | Bonus Room |
| Bathroom 1 | 7.00 | 6.00 | Bathroom |
| Laundry | 8.50 | 7.00 | Laundry |
| Laundry | 8.50 | 7.00 | Laundry |
| Laundry | 8.50 | 7.00 | Laundry |
| Foyer | 15.30 | 11.40 | Foyer |
| Foyer | 15.30 | 11.40 | Foyer |
| Foyer | 15.30 | 11.40 | Foyer |
| Bedroom 1 | 14.70 | 14.90 | Bedroom |
| Office | 10.00 | 8.20 | Office |
| Office | 10.00 | 8.20 | Office |
| Office | 10.00 | 8.20 | Office |
| Other | 10.50 | 9.30 | Other |
| Other | 10.50 | 9.30 | Other |
| Other | 10.50 | 9.30 | Other |
| Den | 16.90 | 14.20 | Den |
| Den | 16.90 | 14.20 | Den |
| Den | 16.90 | 14.20 | Den |
| Bedroom 2 | 16.00 | 13.10 | Bedroom |
| Kitchen | 16.00 | 13.00 | Kitchen |
| Kitchen | 16.00 | 13.00 | Kitchen |
| Kitchen | 16.00 | 13.00 | Kitchen |
| Bedroom 3 | 16.00 | 13.10 | Bedroom |
| Primary Bedroom | 18.40 | 15.00 | Primary Bedroom |
| Primary Bedroom | 18.40 | 15.00 | Primary Bedroom |
| Primary Bedroom | 18.40 | 15.00 | Primary Bedroom |
| Living Room | 32.60 | 19.80 | Living Room |
| Living Room | 32.60 | 19.80 | Living Room |
| Living Room | 32.60 | 19.80 | Living Room |
| Bathroom 2 | 7.30 | 5.30 | Half Bath |
| Bathroom 3 | 13.90 | 5.30 | Bathroom |
| Bedroom 4 | 16.60 | 11.80 | Bedroom |
| Bathroom 4 | 7.00 | 6.00 | Bathroom |
| Dining Room | 15.60 | 12.60 | Dining Room |
| Dining Room | 15.60 | 12.60 | Dining Room |
| Dining Room | 15.60 | 12.60 | Dining Room |
| Primary Bathroom | 20.00 | 11.80 | Primary Bathroom |
| Primary Bathroom | 20.00 | 11.80 | Primary Bathroom |
| Primary Bathroom | 20.00 | 11.80 | Primary Bathroom |
| Bedroom 5 | 14.70 | 14.90 | Bedroom |
| Bathroom 5 | 13.90 | 5.30 | Bathroom |
| Bedroom 6 | 14.70 | 14.90 | Bedroom |
| Bedroom 7 | 16.60 | 11.80 | Bedroom |
| Bedroom 8 | 16.00 | 13.10 | Bedroom |
2273 Sunset Blvd property disc IDX
Listing Office: ABEK Real Estate
Last Updated: June - 11 - 2026
The data relating to real estate for sale or lease on this website comes in part from the IDX program of the REALTOR® Association of Acadiana MLS. The IDX information is provided exclusively for consumers’ personal, non-commericial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS.
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.