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,232,500
3012 SUNRISE Boulevard
Slidell, LA 70461
MLS# NO2536766
4 beds  |  3.1 baths  |  6767 sqft


Photo 1
  1 / 53  
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 Photo 43 Photo 44 Photo 45 Photo 46 Photo 47 Photo 48 Photo 49 Photo 50 Photo 51 Photo 52 Photo 53

Property Description
This stunning home is built of Aerated Autoclave Blocks engineered to withstand 150mph. 3 bedrooms, 2 1/2 baths downstairs and additional living/bedroom area upstairs along with an enormous media room. Both upper and lower screened in porches to enjoy your beautiful waterfront view in the sought after Lakeshore Estates community. Wood and tile floors, granite counters, stainless appliances complete the lower level. The oversized garage is perfect for all your storage needs. Boat dock is ready for you to enjoy those days on the lake this summer. Don't wait! Schedule your private showing today.

Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 258.98
Document Modified: 2026-01-07 16:21:23.846171
Status: Active
Listing Date: 2026-01-06
Listing Price: 1232500
Current Price: $1,232,500
Type: Single Family Residence
Modification Timestamp: 2026-01-12T18:36:40Z
Photo Modified: 2026-01-07T22:16:21Z
Location, Tax & Legal Info
Legal Desc: Lot 241 Lakeshore Estates
General Property Description
Lot Dimensions: 90x200
Stories: 2
SqFt - Living: 4759
SqFt - Source: Appraiser
SqFt - Total: 6767
Assn Fee $: 1500
Assn Fee Terms: Yearly
Acreage Range: 0 - 0.5
Pool on Subject Property: No
# Bedrooms: 4
Baths - Full: 3
Baths - 1/2: 1
Total Baths: 3.1
Year Built: 2012
Remarks & Misc
Remarks: This stunning home is built of Aerated Autoclave Blocks engineered to withstand 150mph. 3 bedrooms, 2 1/2 baths downstairs and additional living/bedroom area upstairs along with an enormous media room. Both upper and lower screened in porches to enjoy your beautiful waterfront view in the sought after Lakeshore Estates community. Wood and tile floors, granite counters, stainless appliances complete the lower level. The oversized garage is perfect for all your storage needs. Boat dock is ready for you to enjoy those days on the lake this summer. Don't wait! Schedule your private showing today.
Office/Member/Contract Info
List AOR: NOMAR
Style
Traditional: 1
Siding
Stucco: 1
Vinyl Siding: 1
Parking
Attached: 1
Garage: 1
Foundation
Slab: 1
Patio
Covered: 1
Fireplace
Gas Log: 1
Roof
Composition: 1
Appliances
Dishwasher: 1
Disposal: 1
Dryer: 1
Microwave: 1
Refrigerator: 1
Washer: 1
Countertops
Granite: 1
Rooms
Bedroom 1: 1
Dining Room: 1
Kitchen: 1
Living Room: 1
Primary Bedroom: 1
Other: 1
Bedroom 2: 1
Bedroom 3: 1
Waterfront
Dock/Mooring: 1
Lake/Pond: 1
Lot
Water Frontage: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 56607283
Originating System Listing ID: 2536766
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 3012
Street Name: SUNRISE Boulevard
Parish: St. Tammany
State: LA
Zip Code: 70461
Tax Assessment Number: 126587
Directions: Bounding Streets: Lakeshore Blvd South
Property Features
Style: Traditional
Siding: Stucco; Vinyl Siding
Parking: Attached; Garage
Foundation: Slab
Roof: Composition
Fireplace: Gas Log
Appliances: Dishwasher; Disposal; Dryer; Microwave; Refrigerator; Washer
Countertops: Granite
Rooms: Bedroom 1; Dining Room; Kitchen; Living Room; Other; Primary Bedroom; Bedroom 2; Bedroom 3
Lot: Water Frontage
Patio: Covered
Waterfront: Dock/Mooring; Lake/Pond
Room Information
Room Name Length Width Remarks
Living Room18.0023.00Living Room
Dining Room14.0014.00Dining Room
Bedroom 113.0012.00Bedroom
Bedroom 220.0026.00Bedroom
Other10.0014.00Other
Kitchen16.0013.00Kitchen
Primary Bedroom15.0018.00Primary Bedroom
Bedroom 312.0012.00Bedroom
Listing Documents
View Document New Attachment
View Document New Attachment
View Document New Attachment

IDX
Listing Office: Engel & Volkers Slidell - Mandeville

Last Updated: January - 12 - 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