Skip main navigation
For sale
  • $1,895,000

    508 Interstate Highway 49 Service Rd N, Sunset, LA 70584

    1beds
    4,619sqft
    : 
    Single Family Residence
    Built in 2010
    18.09 Acres Lot
    $-- Zestimate®
    $410/sqft
    $-- HOA

    What's special

    Two private stocked pondsOne shared lakeLush landscapingSecret gardenFields of hybridized irises
    Welcome to Thistlewood Estate where the views are magnificent & marvelous and the architecture is simply stunning. This expansive 18 acre estate contains two private stocked ponds & one shared lake. All property boundaries are lined with mature trees and shrubbery. The lush landscaping includes fields of hybridized irises brought to you by the original owner of the great estate. Find solace in the secret garden & smell the sweet scents of ''camellia alley''. The attached guest suite offers 712 square feet with its own kitchenette-perfect for visitors, or the in-laws. The crown jewel is the 4600 square foot structure that presents a number of mixed uses to its future owner. For ones with an entrepreneurial spirit, the opportunity to own this sophisticated sanctuary has now presented itself.
    567 days
    |
    472
    |
    37
    |

    Zillow last checked: 8 hours ago

    Listing updated: December 12, 2025 at 11:48pm

    Listed by:

    Charles Hiller,

    Parish Realty Acadiana 337-735-1223,

    Jessica LeJeune,

    Parish Realty Acadiana

    Source: RAA,MLS#: 24004353MLS Logo

    Tour with a local agent

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 1
    • Bathrooms: 2
    • Full bathrooms: 1
    • 1/2 bathrooms: 1
    • Main level bathrooms: 1
    • Main level bedrooms: 1
    Rooms
    • Room types: Office, Dining Room, Game Room, Great Room, Kitchen, Living Room, Utility Room
    Heating
    • Central, Electric
    Cooling
    • Multi Units, Central Air
    Appliances
    • Included: Dishwasher, Disposal, Freezer, Microwave, Refrigerator
    • Laundry: Electric Dryer Hookup, Washer Hookup
    Features
    • High Ceilings, Beamed Ceilings, Bidet, Bookcases, Built-in Features, Cathedral Ceiling(s), Computer Nook, Dual Closets, Guest Suite, Kitchen Island, Other, Separate Shower, Varied Ceiling Heights, Vaulted Ceiling(s), Walk-in Pantry, Wet Bar, Pantry, Granite Counters, Stone Counters, Other Counters
    • Flooring: Brick, Stained/Scored Concrete, Tile, Wood
    • Windows: Window Treatments, Bay Window(s), Double Pane Windows, Wood Frames
    • Number of fireplaces: 2
    • Fireplace features: 2 Fireplaces, Wood Burning
    Interior area
    • Total structure area: 5,331
    • Total interior livable area: 4,619 sqft

    Property

    Parking
    • Total spaces: 1
    • Parking features: Attached, Boat, Carport, RV Access/Parking
    • Carport spaces: 1
    • Details: Carport SqFt(412.00)
    Features
    • Stories: 2
    • Patio & porch: Covered, Open, Porch
    • Exterior features: Lighting
    • Fencing: None
    • Has view: Yes
    • On waterfront: Yes
    • Waterfront features: Lake, Pond
    Lot
    • Size: 18.09 Acres
    • Features: 11 to 19.99 Acres, Additional Land Available, Easements, Landscaped, Level, Sloped, Views, Waterfront, Wooded
    Details
    • Additional structures: Guest House, See Remarks
    • Parcel number: 0201178400
    • Horses can be raised: Yes

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Acadian,French,Traditional
    • Property subtype: Single Family Residence
    Materials
    • Brick Veneer, Other Siding, Frame
    • Foundation: Slab
    • Roof: Metal,Tile
    Condition
    • Resale
    • Year built: 2010

    Utilities & green energy

    • Electric: Elec: Entergy
    • Gas: Gas: Atmos
    • Sewer: Public Sewer

    Community & HOA

    Community
    • Features: Acreage, Elevator
    • Subdivision: None
    Location
    • Region: Sunset

    Financial & listing details

    • Price per square foot: $410/sqft
    • Date on market: 6/5/2024
    • Exclusions: Other - See Remarks
    • Electric utility on property: Yes
    Get pre-qualifiedBe ready to make an offer.
    Connect with an agentGet info on this home, tour, and more.
    Calculate monthly paymentSee if you can afford this home.

    Estimated market value

    Not available

    Estimated sales range

    Not available

    Not available

    Price history

    Price history
    DateEventPrice
    1/16/2025Price change$1,895,000-15.8%$410/sqft
    Source: RAA #24004353 Report a problem
    11/26/2024Price change$2,250,000-18.2%$487/sqft
    Source: RAA #24004353 Report a problem
    6/5/2024Listed for sale$2,750,000$595/sqft
    Source: RAA #24004353 Report a problem

    Public tax history

    Public tax history
    Tax history is unavailable.

    BuyAbility℠ payment

    Est. payment
    $8,595/mo
    Principal & interest
    $7348
    Home insurance
    $663
    Property taxes
    $584

      Climate risks

      Neighborhood: 70584

      Nearby schools

      GreatSchools rating

      Similar homes

      Skip to the end of the carouselSkip to the beginning of the carousel
      • Loading
      • Loading