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
Active
Price cut: $25K (5/26)
$1,175,000
3028 Sunrise Blvd, Slidell, LA 70461
5beds
3,980sqft
Single Family Residence
Built in 2025
0.52 Acres Lot
$-- Zestimate®
$295/sqft
$125/mo HOA
What's special
- 386 days |
- 393 |
- 16 |
Zillow last checked:
Listing updated:
Listed by:
Wendy Tynes 504-462-0044,
Compass Mandeville 985-626-5695,
Patrice McCoy 504-650-8608,
Compass Mandeville
Source: GSREIN,MLS#: 2506611
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 6
- Full bathrooms: 5
- 1/2 bathrooms: 1
Primary bedroom
- Description: Flooring: Engineered Hardwood
- Level: First
- Dimensions: 15.9x21
Bedroom
- Description: Flooring: Engineered Hardwood
- Level: First
- Dimensions: 11.9x14
Bedroom
- Description: Flooring: Engineered Hardwood
- Level: First
- Dimensions: 13.3x14.4
Bedroom
- Description: Flooring: Engineered Hardwood
- Level: First
- Dimensions: 15.4x18.3
Bedroom
- Description: Flooring: Engineered Hardwood
- Level: Second
- Dimensions: 15x15
Kitchen
- Description: Flooring: Engineered Hardwood
- Level: First
- Dimensions: 10.2x21
Laundry
- Description: Flooring: Engineered Hardwood
- Level: First
- Dimensions: 10.3x14.4
Living room
- Description: Flooring: Engineered Hardwood
- Level: First
- Dimensions: 21x22.5
Office
- Description: Flooring: Engineered Hardwood
- Level: First
- Dimensions: 11.3x17.9
Heating
- Central, Multiple Heating Units
Cooling
- Central Air, 3+ Units
Appliances
- Included: Dishwasher, Disposal, Microwave, Oven, Range, Refrigerator
- Laundry: Washer Hookup, Dryer Hookup
Features
- Ceiling Fan(s), Pantry, Stone Counters, Stainless Steel Appliances
- Has fireplace: Yes
- Fireplace features: Other
Interior area
- Total structure area: 5,386
- Total interior livable area: 3,980 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage, Two Spaces, Garage Door Opener
- Has garage: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered, Other
- Exterior features: Fence
- Pool features: None
- On waterfront: Yes
- Waterfront features: Waterfront, Lake
Lot
- Size: 0.52 Acres
- Dimensions: 90 x 250
- Features: Outside City Limits, Rectangular Lot
Details
- Parcel number: 126591
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Stucco
- Foundation: Slab
- Roof: Shingle
Condition
- New Construction
- New construction: Yes
- Year built: 2025
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Subdivision: Lakeshore Estates
HOA
- Has HOA: Yes
- HOA fee: $1,500 annually
Location
- Region: Slidell
Financial & listing details
- Price per square foot: $295/sqft
- Tax assessed value: $175,000
- Annual tax amount: $2,198
- Date on market: 6/17/2025
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 5/26/2026 | Price change | $1,175,000-2.1%$295/sqft |
Source: | ||
| 5/1/2026 | Price change | $1,200,000-4.8%$302/sqft |
Source: | ||
| 1/5/2026 | Price change | $1,260,000-3.1%$317/sqft |
Source: | ||
| 11/22/2025 | Price change | $1,300,000+1.6%$327/sqft |
Source: Latter and Blum #2506611 Report a problem | ||
| 11/22/2025 | Price change | $1,280,000-1.5%$322/sqft |
Source: | ||
| 6/17/2025 | Listed for sale | $1,300,000+584.2%$327/sqft |
Source: | ||
| 6/20/2024 | Listing removed | $190,000$48/sqft |
Source: Latter and Blum #2427361 Report a problem | ||
| 12/27/2023 | Listed for sale | $190,000$48/sqft |
Source: | ||
| 12/24/2023 | Listing removed | -- |
Source: | ||
| 6/7/2023 | Listing removed | $190,000$48/sqft |
Source: | ||
| 6/7/2023 | Price change | $190,000-5%$48/sqft |
Source: | ||
| 8/17/2022 | Listed for sale | $200,000$50/sqft |
Source: | ||
| 3/21/2022 | Sold | -- |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $2,198 -4% | $17,500 |
| 2024 | $2,289 +101.8% | $17,500 +118.8% |
| 2023 | $1,134 -2% | $8,000 |
| 2022 | $1,157 +0.1% | $8,000 |
| 2021 | $1,156 +0.5% | $8,000 |
| 2020 | $1,150 -3.6% | $8,000 |
| 2019 | $1,193 -0.4% | $8,000 |
| 2018 | $1,198 -0.7% | $8,000 |
| 2017 | $1,206 -2.3% | $8,000 |
| 2016 | $1,234 | $8,000 -15.8% |
| 2015 | $1,234 -18.1% | $9,500 |
| 2014 | $1,507 +1.5% | $9,500 |
| 2013 | $1,485 | $9,500 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 70461
Nearby schools
GreatSchools rating
- 4/10W.L. Abney Elementary SchoolGrades: 1-5Distance: 3.3 mi
- 3/10St. Tammany Junior High SchoolGrades: 6-8Distance: 4 mi
- 3/10Salmen High SchoolGrades: 9-12Distance: 2.8 mi
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Louisiana
- Saint Tammany Parish
- Slidell
- 70461
- 3028 Sunrise Blvd






