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
    • Professional Development
  • Who’s Your REALTOR®?
  • Blog
  • Reviews

Agent on Call

Jennifer Guidry, REALTOR® Sales Associate
337-349-8076


$1,350,000
2009 SUNSET Boulevard
Slidell, LA 70461
MLS# NO2532087
4 beds  |  3.1 baths  |  6127 sqft


Photo 1
  1 / 42  
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 Photo 25 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 Photo 42

Property Description
Imagine a waterfront home where luxury meets smart design, featuring all the best amenities for a truly elevated living experience. With 4 spacious bedrooms, 3 1/2 baths and an office, this home offers both comfort and sophistication. The downstairs features beautiful local Old Chicago brick flooring, adding a timeless touch of character and warmth to the living spaces. The spacious gourmet kitchen features state-of-the-art appliances with a large center island. For those who love to entertain, the dedicated pool table room/media room area with a full bar is the ultimate social hub, making it perfect for game and movie night. This is a haven for entertainment and relaxation. This dream home also includes a brilliantly designed laundry chute, strategically placed for effortless laundry care. Nestled within the beautiful wood staircase is a cozy book nook, a haven for book lovers. Triple crown molding throughout. Step out back to discover a lush, high-end backyard that has everything you need for a tropical retreat! The centerpiece is a sparkling saltwater swimming pool, complemented by a relaxing Jacuzzi, a cozy fire pit for intimate evenings, and a high-end grill island, For the boating and fishing enthusiast, there is a private dock and boat lift to call your own! Current flood $702/yr

Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 276.87
Document Modified: 2026-03-13 11:10:08.457207
Status: Active
Listing Date: 2025-11-22
Listing Price: 1350000
Current Price: $1,350,000
Type: Single Family Residence
Modification Timestamp: 2026-03-13T20:44:17Z
Photo Modified: 2026-02-23T22:31:32Z
Location, Tax & Legal Info
Legal Desc: Lot 226 Lakeshore Estates PH 1A3
General Property Description
Lot Dimensions: 89x248x84x249
Stories: 2
SqFt - Living: 4876
SqFt - Source: Blueprint
SqFt - Total: 6127
Assn Fee $: 1500
Assn Fee Terms: Yearly
Acreage Range: 0 - 0.5
# Bedrooms: 4
Baths - Full: 3
Baths - 1/2: 1
Total Baths: 3.1
Year Built: 2015
Remarks & Misc
Remarks: Imagine a waterfront home where luxury meets smart design, featuring all the best amenities for a truly elevated living experience. With 4 spacious bedrooms, 3 1/2 baths and an office, this home offers both comfort and sophistication. The downstairs features beautiful local Old Chicago brick flooring, adding a timeless touch of character and warmth to the living spaces. The spacious gourmet kitchen features state-of-the-art appliances with a large center island. For those who love to entertain, the dedicated pool table room/media room area with a full bar is the ultimate social hub, making it perfect for game and movie night. This is a haven for entertainment and relaxation. This dream home also includes a brilliantly designed laundry chute, strategically placed for effortless laundry care. Nestled within the beautiful wood staircase is a cozy book nook, a haven for book lovers. Triple crown molding throughout. Step out back to discover a lush, high-end backyard that has everything you need for a tropical retreat! The centerpiece is a sparkling saltwater swimming pool, complemented by a relaxing Jacuzzi, a cozy fire pit for intimate evenings, and a high-end grill island, For the boating and fishing enthusiast, there is a private dock and boat lift to call your own! Current flood $702/yr
Office/Member/Contract Info
List AOR: NOMAR
Style
Traditional: 1
Siding
Stucco: 1
Parking
Garage: 1
Construction
Brick: 1
Foundation
Slab: 1
Fireplace
Gas Log: 1
Roof
Composition: 1
Heating
Central: 1
Cooling
2 or More Units: 1
Central Air: 1
Appliances
Dishwasher: 1
Disposal: 1
Microwave: 1
Refrigerator: 1
Countertops
Granite: 1
Rooms
Bedroom 1: 1
Den: 1
Dining Room: 1
Kitchen: 1
Laundry: 1
Living Room: 1
Primary Bathroom: 1
Primary Bedroom: 1
Office: 1
Bedroom 2: 1
Bedroom 3: 1
Waterfront
Dock/Mooring: 1
Lake/Pond: 1
Fencing
Full: 1
Other: 1
Lot
Water Frontage: 1
Pool
Inground: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 53449124
Originating System Listing ID: 2532087
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 2009
Street Name: SUNSET Boulevard
Parish: St. Tammany
State: LA
Zip Code: 70461
Tax Assessment Number: 125932
Directions: Exit 261 (Oak Harbor Blvd). Head toward convention center. Turn right into Lakeshore Estates. Left on Sunset Bounding Streets: Lakeshore Blvd
Property Features
Style: Traditional
Siding: Stucco
Parking: Garage
Construction: Brick
Foundation: Slab
Roof: Composition
Fireplace: Gas Log
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Disposal; Microwave; Refrigerator
Countertops: Granite
Rooms: Bedroom 1; Den; Dining Room; Kitchen; Laundry; Living Room; Office; Primary Bathroom; Primary Bedroom; Bedroom 2; Bedroom 3
Fencing: Full; Other
Lot: Water Frontage
Waterfront: Dock/Mooring; Lake/Pond
Pool: Inground
Room Information
Room Name Length Width Remarks
Office10.2012.90Office
Den20.6018.70Den
Living Room21.6012.00Living Room
Kitchen17.9017.40Kitchen
Primary Bathroom11.5013.00Primary Bathroom
Bedroom 111.0010.00Bedroom
Laundry15.508.60Laundry
Primary Bedroom18.0016.80Primary Bedroom
Bedroom 212.0012.00Bedroom
Dining Room13.0012.70Dining Room
Bedroom 315.5012.80Bedroom
Listing Documents
View Document Floor Plan
View Document Flood Declaration
View Document property disclosure
View Document Flood Determination

IDX
Listing Office: Compass Slidell (LATT14)

Last Updated: March - 13 - 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.


Search powered by FBS Products

Find Us

Get Directions
 

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

 

AGENT ON CALL | 337-349-8076
 

 

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®
    • Professional Development
  • Blog
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate
Thank you for visiting Guidry & Co. Real Estate, for more information please register here:

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name*

 

Return To Homepage