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.
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
18.09 Acres Lot
$-- Zestimate®
$410/sqft
$-- HOA
What's special
Two private stocked pondsOne shared lakeLush landscapingSecret gardenFields of hybridized irises
- 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#: 24004353
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
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 1/16/2025 | Price change | $1,895,000-15.8%$410/sqft |
Source: | ||
| 11/26/2024 | Price change | $2,250,000-18.2%$487/sqft |
Source: | ||
| 6/5/2024 | Listed for sale | $2,750,000$595/sqft |
Source: | ||
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
- 8/10Grand Coteau Elementary SchoolGrades: PK-4Distance: 2.3 mi
- 9/10Arnaudville Elementary SchoolGrades: 5-8Distance: 7.1 mi
- 3/10Beau Chene High SchoolGrades: 9-12Distance: 3.3 mi
- Loading
- Loading




