3028 SUNRISE Boulevard, Slidell, LA 70461
$1,260,000
Property Type:
Residential
Bedrooms:
5
Baths:
5.1
Square Footage:
5,386
Status:
Active
Current Price:
$1,260,000
List Date:
6/17/2025
Last Modified:
2/03/2026
Description
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
Supplements: ********
More Information MLS# NO2506611
Listing Info
Delayed Marketing: No
List Price/SqFt: 316.58
Document Modified: 2026-02-03 09:52:45.159271
Status: Active
Listing Date: 2025-06-17
Listing Price: 1260000
Current Price: $1,260,000
Type: Single Family Residence
Modification Timestamp: 2026-02-03T15:52:45Z
Photo Modified: 2026-02-03T15:47:43Z
Location, Tax & Legal Info
Legal Desc: Lot 245 Lakeshore Estates Sub Ph 1A4
General Property Description
Lot Dimensions: 90x250
Stories: 2
SqFt - Living: 3980
SqFt - Source: Measured
SqFt - Total: 5386
Assn Fee $: 1500
Assn Fee Terms: Yearly
Acreage Range: 0 - 0.5
Pool on Subject Property: No
# Bedrooms: 5
Baths - Full: 5
Baths - 1/2: 1
Total Baths: 5.1
Year Built: 2025
Remarks & Misc
Remarks: 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
Office/Member/Contract Info
List AOR: NOMAR
Style
Traditional: 1
Siding
Stucco: 1
Parking
Garage: 1
Foundation
Slab: 1
Patio
Covered: 1
Fireplace
Other: 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
Rooms
Bedroom 1: 1
Kitchen: 1
Laundry: 1
Living Room: 1
Primary Bedroom: 1
Office: 1
Bedroom 2: 1
Bedroom 3: 1
Bedroom 4: 1
Bedroom 5: 1
Bedroom 6: 1
Bedroom 7: 1
Bedroom 8: 1
Waterfront
Lake/Pond: 1
Fencing
Other: 1
Lot
Water Frontage: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 51489203
Originating System Listing ID: 2506611
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 3028
Street Name: SUNRISE Boulevard
Parish: St. Tammany
State: LA
Zip Code: 70461
Tax Assessment Number: 126591
Directions: Bounding Streets: Lakeshore Blvd
Property Features
Style: Traditional
Siding: Stucco
Parking: Garage
Foundation: Slab
Roof: Composition
Fireplace: Other
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Disposal; Microwave; Refrigerator
Rooms: Bedroom 1; Kitchen; Laundry; Living Room; Office; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4; Bedroom 5; Bedroom 6; Bedroom 7; Bedroom 8
Fencing: Other
Lot: Water Frontage
Patio: Covered
Waterfront: Lake/Pond
Room Information
Living Room
Length: 21.00
Width: 22.50
Remarks: Living Room
Living Room
Length: 21.00
Width: 22.50
Remarks: Living Room
Bedroom 1
Length: 11.90
Width: 14.00
Remarks: Bedroom
Kitchen
Length: 10.20
Width: 21.00
Remarks: Kitchen
Kitchen
Length: 10.20
Width: 21.00
Remarks: Kitchen
Laundry
Length: 10.30
Width: 14.40
Remarks: Laundry
Laundry
Length: 10.30
Width: 14.40
Remarks: Laundry
Office
Length: 11.30
Width: 17.90
Remarks: Office
Office
Length: 11.30
Width: 17.90
Remarks: Office
Bedroom 2
Length: 11.90
Width: 14.00
Remarks: Bedroom
Bedroom 3
Length: 15.40
Width: 18.30
Remarks: Bedroom
Bedroom 4
Length: 13.30
Width: 14.40
Remarks: Bedroom
Bedroom 5
Length: 15.00
Width: 15.00
Remarks: Bedroom
Primary Bedroom
Length: 15.90
Width: 21.00
Remarks: Primary Bedroom
Primary Bedroom
Length: 15.90
Width: 21.00
Remarks: Primary Bedroom
Bedroom 6
Length: 15.00
Width: 15.00
Remarks: Bedroom
Bedroom 7
Length: 15.40
Width: 18.30
Remarks: Bedroom
Bedroom 8
Length: 13.30
Width: 14.40
Remarks: Bedroom
Documents
Listing Office:
Compass Slidell (LATT14)
IDX
Last Updated: February - 03 - 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.
Flood Declaration ›