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

Agent on Call

agent

Andrea Laborde, REALTOR® Sales Associate
337-277-6503


$999,995
3028 SUNRISE BLVD Boulevard
Slidell, LA 70461
MLS# 2573410
5 beds  |  6 baths  |  5386 sqft


Photo 1
  1 / 55  
Photo 1 Photo 2 AI generated of what your dream home could look like with a pool AI generated with a pool. With a blank slate, your backyard osasis can be anything you want it to be! AI generated to include a pool AI generated of pool & patio clean slate for your imagination clean slate Photo 9 Photo 10 Photo 11 Photo 12 Photo 13 Photo 14 Photo 15 Photo 16 pantry Photo 18 Photo 19 Photo 20 Photo 21 Photo 22 Photo 23 Photo 24 Photo 25 Photo 26 Photo 27 half bath Photo 29 Photo 30 primary closet primary closet Photo 33 Photo 34 Photo 35 Photo 36 Photo 37 en suite bedroom en suite bath with each bedroom pool house/game room/private en suite Photo 41 laundry room Photo 43 Photo 44 Photo 45 Photo 46 Photo 47 Photo 48 Photo 49 Photo 50 Photo 51 Photo 52 Photo 53 Photo 54 Photo 55
Open House (11/01/2026 - 1:00 pm - 3:00 pm)

Property 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

Details
Listing Information
Price Change Timestamp: 2026-10-15T22:16:46Z
Comp Sale YN: No
Property Sub Type: Single Family Residence
Status Change Information
Status Change Timestamp: 2026-10-27
Delayed Marketing: No
Address
Parish or County: St. Tammany
Street Number: 3028
Street Name: SUNRISE BLVD
Street Suffix: Boulevard
City Limits YN: No
State: LA
Postal Code (Zip): 70461
Parcel Number: 126591
Cross Street: Lakeshore Blvd
Contract
Current Price: $999,995
Original List Price: 1155000
Status: Active
Listing Contract Date: 2026-08-20
List Price: $999,995
Listing Agreement: Exclusive Right To Sell
Listing Service: Full Service
List Price/SqFt: 251.26
Interior
Bedrooms Total: 5
Bathrooms Total: 6
Bathrooms Full: 5
Bathrooms Half: 1
Living Area: 3980
Living Area Source: Measured
Building Area Total: 5386
Fireplace YN: Yes
Parking Information
Garage YN: Yes
Parking Total: 2
Building
Year Built: 2025
Approximate Age: 1 - 3 Years
Year Built Source: Builder
Property Attached YN: No
Builder Name: Unknown
Home Warranty YN: No
Lot
Lot Size Dimensions: 90x250
Waterfront YN: Yes
Remarks
Public 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
Utility Providers
Electric Provider: CLECO
Room Types
Bedroom Level: Second
Kitchen Level: First
Laundry Level: First
Living Room Level: First
Office Level: First
Primary Bedroom Level: First
Tax Legal
Subdivision Name: Lakeshore Estates
Property Features
Utilities: Natural Gas Available; Natural Gas Available
Appliances: Dishwasher; Disposal; Microwave; Oven; Range; Refrigerator; Stainless Steel Appliance(s)
Architectural Style: Traditional
Construction Materials: Stucco
Cooling: Ceiling Fan(s); Central Air; Multi Units
Disclosures: Covenants, Conditions & Restrictions; Property As Is
Fencing: Other
Fireplace Features: Other
Flooring: Engineered Hardwood
Foundation Details: Slab
Heating: Central; Multiple Units
Interior Features: Pantry; Stone Counters
Laundry Features: Electric Dryer Hookup; Washer Hookup
Levels: Two
Lot Features: Other
Patio And Porch Features: Covered; Patio; Porch
Roof: Shingle
Sewer: Public Sewer
Structure Type: House
Water Source: Public
Waterfront Features: Lake Front; Navigable Water
Showing Requirements: Appointment Only; Lockbox; Showing Service
Room Types: Bedroom; Kitchen; Laundry; Living Room; Office; Primary Bedroom
Room Information
Room Name Level Dimensions Remarks
Living RoomFirst21x22.5Ceiling Ht: 18, Flooring: Engineered Wood
KitchenFirst10.2x21Ceiling Ht: 12, Flooring: Engineered Wood
LaundryFirst10.3x14.4Ceiling Ht: 10, Flooring: Engineered Wood
Primary BedroomFirst15.9x21Ceiling Ht: 10, Flooring: Engineered Wood
OfficeFirst11.3x17.9Ceiling Ht: 10, Flooring: Engineered Wood
BedroomFirst11.9x14Ceiling Ht: 10, Flooring: Engineered Wood
BedroomFirst13.3x14.4Ceiling Ht: 10, Flooring: Engineered Wood
BedroomFirst15.4x18.3Ceiling Ht: 10, Flooring: Engineered Wood
BedroomSecond15x15Ceiling Ht: 10, Flooring: Engineered Wood

IDX
Listing Office: Compass Slidell

Office Phone: 985-641-1000

Office Email: Beverly.Tynes@Compass.com

Last Updated: October - 30 - 2026

Information deemed reliable but not guaranteed.


Broker Attribution: 985-641-1000

Search powered by FBS Products

Find Us

Get Directions
 

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

 

AGENT ON CALL | 337-277-6503

 

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®
  • Blog
  • Success Coaching
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate