Welcome to Thistlewood Estate where the views are magnificent & marvelous and the architecture is simply stunning. This expansive 15 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.
For sale
$1,895,000
508 Interstate Highway 49 Service Rd N, Sunset, LA 70584
1beds
4,619sqft
Est.:
Single Family Residence
Built in 2010
15.1 Acres Lot
$-- Zestimate®
$410/sqft
$-- HOA
What's special
Attached guest suiteOwn kitchenettePrivate stocked pondsShared lakeLush landscapingSecret gardenMature trees
- 427 days
- on Zillow |
- 630 |
- 58 |
Zillow last checked: 7 hours ago
Listing updated: June 12, 2025 at 11:14am
Listed by:
Charles Hiller,
Parish Realty Acadiana 337-735-1223,
Jessica LeJeune,
Parish Realty Acadiana
Source: RAA,MLS#: 24004353

Travel times
Tour with a buyer's agent
Tour with a buyer's 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: 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
- Waterfront features: Lake, Pond
Lot
- Size: 15.1 Acres
- Features: 11 to 19.99 Acres, Additional Land Available, Easements, 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
- 11 - 15 Years
- New construction: No
- 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
- Loading
- Loading