3028 Sunrise Blvd Boulevard BLVD, Slidell, LA 70461 (MLS # NO2573410)
Twitter
Facebook
Email
|
Step into elegance with this stunning new construction in the waterfront gated and guarded Lakeshore Estates. Designed for luxury and convenience, this home welcomes you with soaring 18-foot barrel ceilings and an open-concept layout that puts your dream kitchen and living space front and center. A chef's delight, the kitchen features a sleek design, a six-burner gas range and breathtaking Taj Mahal quartz countertops - perfect for cooking and entertaining at your home. The private primary suite is a sanctuary, offering a spacious marble shower, dual vanities, and an exquisite round soaking tub. A custom walk-in dressing room connects seamlessly to the laundry room for ultimate convenience. Enjoy superior custom lighting throughout, no carpet anywhere, and a versatile upstairs retreat - ideal as a bedroom or game room. A separate downstairs office and private en suite with its own entrance provide flexible living options to suit your lifestyle. This exceptional home is a true masterpiece in modern living
| DAYS ON MARKET | 3 | LAST UPDATED | 8/20/2026 |
|---|---|---|---|
| TRACT | Lakeshore Estates | YEAR BUILT | 2025 |
| COUNTY | St. Tammany | STATUS | Active |
| PROPERTY TYPE(S) | Single Family |
| ADDITIONAL DETAILS | |
| AIR | Central Air, Multi Units |
|---|---|
| AIR CONDITIONING | Yes |
| APPLIANCES | Dishwasher, Disposal, Microwave, Refrigerator |
| CONSTRUCTION | Stucco |
| FIREPLACE | Yes |
| GARAGE | Yes |
| HEAT | Central |
| HOA DUES | 1500 |
| LOT | 0.5165 acre(s) |
| LOT DESCRIPTION | Waterfront |
| LOT DIMENSIONS | 90 x 250 |
| PARKING | Garage |
| STORIES | 2 |
| STYLE | Traditional |
| SUBDIVISION | Lakeshore Estates |
| WATERFRONT | Yes |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
Listed with Compass Slidell
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 Dwight Andrus Real Estate Agency, LLC are marked with the MLS approved icon for IDX (a little black house).
IDX information is provided exclusively for consumers’ personal, non-commercial use, that it 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.
Copyright 2026 REALTOR® Association of Acadiana MLS. All rights reserved
This IDX solution is (c) Diverse Solutions 2026.
| SATELLITE VIEW |
| / | |
We respect your online privacy and will never spam you. By submitting this form with your telephone number
you are consenting for Matt
Andrus to contact you even if your name is on a Federal or State
"Do not call List".