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

Catrice Ambrose, REALTOR® Sales Associate
337-446-6053


$1,175,000
400 Acorn Drive
Lafayette, LA 70507
MLS# 2600004234
5 beds  |  5 baths


1-web-or-mls-401 Acorn Dr-6
  1 / 56  
1-web-or-mls-401 Acorn Dr-6 1_001_dsc05749 10-web-or-mls-401 Acorn Dr-9 11-web-or-mls-401 Acorn Dr-10 9-web-or-mls-401 Acorn Dr-8 14-web-or-mls-401 Acorn Dr-12 11_010_dsc05623 12_011_dsc05626 21_020_dsc05629 22_021_dsc05632 16_015_dsc05635 19_018_dsc05647 18_017_dsc05641 17_016_dsc05638 20_019_dsc05650 13_012_dsc05653 14_013_dsc05656 10_009_dsc05659 2-web-or-mls-401 Acorn Dr-1 30_028_dsc05674 29_027_dsc05671 37_035_dsc05677 38_036_dsc05680 6-web-or-mls-401 Acorn Dr-5 44_042_dsc05698 4-web-or-mls-401 Acorn Dr-3 5-web-or-mls-401 Acorn Dr-4 36_034_dsc05704 31_029_dsc05707 55_82895710-38fa-4352-a312-4b9c873e81a3_ 32_030_dsc05713 45_044_dsc05719 33_031_dsc05725 28_026_dsc05728 15_014_dsc05731 25_023_dsc05734 26_024_dsc05737 27_025_dsc05740_reedit_a7722949-c4d4-4d2 34_032_dsc05743 47_046_dsc05746 50_049_dsc05791 8_007_dsc05782 20-web-or-mls-401 Acorn Dr Aerials-6 7_006_dsc05779 52_051_dsc05764 51_050_dsc05767 48_047_dsc05773 18-web-or-mls-401 Acorn Dr Aerials-4 19-web-or-mls-401 Acorn Dr Aerials-5 17-web-or-mls-401 Acorn Dr Aerials-3 Track A-1 Photo 1 with lot lines (1) Track A-1 Photo 2 with lot lines (1) 56_with pin drop 58_dji_fly_20260319_145700_312_177395072 dji_fly_20260319_145828_316_177395071605 60_dji_fly_20260319_145758_314_177395072

Property Description
Open House: Sunday, MAY 17th from 2-4 PM. Three and half private acres beneath a canopy of majestic oak trees - this exceptional residence blends architectural character, thoughtful upgrades, and refined living. Designed to balance elevated entertaining with everyday comfort, the property offers a rare combination of privacy, functionality, and timeless style just minutes from Lafayette, I-10, I-49, shopping, dining, and neighboring the beautifully landscaped Sterling Farms. Inside, the over 5,500-square-foot home features 5 bedrooms and 5 bathrooms with spaces curated for both gathering and retreat. The main living area is anchored by a striking wood-burning brick fireplace and flows seamlessly into the chef's kitchen, where a dramatic waterfall island, crisp white cabinetry, double ovens, integrated appliances, and abundant storage create a space equally suited for entertaining and daily living. A dedicated bar area with a sink and Scotsman ice maker further enhances the home's hosting capabilities. The primary suite offers a true private retreat, complete with its own exterior access, hidden bookcase entry, direct double-door access to the main living area, and a spa-inspired en suite bath featuring dual vanities, a soaking tub, oversized walk-in shower, private water closet, and expansive marble-tiled walk-in closet. Upstairs, the home continues to impress with a fully immersive theater experience featuring a projection system, retractable screen, surround sound, an synchronized lighting. Additional spaces include a private guest suite with en suite bath, office space, and thoughtfully designed reading and play nooks that add flexibility for modern living. Extensive improvements throughout the property include a custom iron front door, Andersen windows and exterior doors, three new HVAC systems, a roof replaced in 2023, full brick repointing, renovated bathrooms, and numerous systems upgrades that enhance both aesthetics and long-term value.

Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 213.64
Property Attached: No
Document Modified: 2026-05-13 12:00:14.843038
Status: Active
Listing Date: 2026-05-13
Listing Price: 1175000
Current Price: $1,175,000
Type: Single Family Residence
Modification Timestamp: 2026-06-10T14:41:36Z
Photo Modified: 2026-06-10T14:41:22Z
Location, Tax & Legal Info
Flood Zone: X
School District: Lafayette Parish
Legal Desc: (See FULL legal Description Attached in Documents Tab) - Tract A-1 (3.52 Acres)
General Property Description
Approximate Age: 41 - 50 Years
Condition: Excellent
Lot Dimensions: 3.525 Acres
Stories: 2
SqFt - Living: 5500
SqFt - Source: Approximate
Mineral Rights: Conveyed
Assn Fee: None
Property Condition: Updated/Remodeled
Acreage Range: 3 - 5.99
Pool on Subject Property: No
# Bedrooms: 5
Baths - Full: 5
Total Baths: 5
Year Built: 1983
Acres: 3.52
Remarks & Misc
Remarks: Open House: Sunday, MAY 17th from 2-4 PM. Three and half private acres beneath a canopy of majestic oak trees - this exceptional residence blends architectural character, thoughtful upgrades, and refined living. Designed to balance elevated entertaining with everyday comfort, the property offers a rare combination of privacy, functionality, and timeless style just minutes from Lafayette, I-10, I-49, shopping, dining, and neighboring the beautifully landscaped Sterling Farms. Inside, the over 5,500-square-foot home features 5 bedrooms and 5 bathrooms with spaces curated for both gathering and retreat. The main living area is anchored by a striking wood-burning brick fireplace and flows seamlessly into the chef's kitchen, where a dramatic waterfall island, crisp white cabinetry, double ovens, integrated appliances, and abundant storage create a space equally suited for entertaining and daily living. A dedicated bar area with a sink and Scotsman ice maker further enhances the home's hosting capabilities. The primary suite offers a true private retreat, complete with its own exterior access, hidden bookcase entry, direct double-door access to the main living area, and a spa-inspired en suite bath featuring dual vanities, a soaking tub, oversized walk-in shower, private water closet, and expansive marble-tiled walk-in closet. Upstairs, the home continues to impress with a fully immersive theater experience featuring a projection system, retractable screen, surround sound, an synchronized lighting. Additional spaces include a private guest suite with en suite bath, office space, and thoughtfully designed reading and play nooks that add flexibility for modern living. Extensive improvements throughout the property include a custom iron front door, Andersen windows and exterior doors, three new HVAC systems, a roof replaced in 2023, full brick repointing, renovated bathrooms, and numerous systems upgrades that enhance both aesthetics and long-term value.
Office/Member/Contract Info
REO: No
Style
Acadian: 1
Contemporary: 1
Traditional: 1
Levels
Two: 1
Siding
Brick: 1
Parking
Attached: 1
Carport: 1
Carport Spaces: 3
Garage Faces Side: 1
RV Access/Parking: 1
Equipment
Ceiling Fans: 1
Cable Available: 1
Cable Ready: 1
Road Frontage
Paved: 1
Construction
Brick: 1
Frame: 1
Foundation
Slab: 1
Exterior
Double Gate Access: 1
Outside Light: 1
Other: 1
Patio
Covered: 1
Open: 1
Fireplace
1 Fireplace: 1
Wood Burning: 1
Roof
Composition: 1
Heating
Central: 1
Zoned: 1
Interior
Attic Access: 1
Bookcases: 1
Built-Ins: 1
Computer Nook: 1
Crown Molding: 1
Double Vanity: 1
Electric Dryer Con: 1
Electric Stove Con: 1
Electric Washer Con: 1
Guest Suite: 1
Kitchen Island: 1
Primary Bath: 1
Multi-Head Shower: 1
Separate Shower: 1
Special Bath: 1
Standalone Tub: 1
Varied Ceiling Heights: 1
Walk-in Pantry: 1
Walk-In Closet(s): 1
Wet Bar: 1
Window Treatments: 1
Cooling
2 or More Units: 1
Central Air: 1
Zoned: 1
Flooring
Marble: 1
Tile: 1
Vinyl Plank: 1
Sewer
Public Sewer: 1
Sewer Company: LUS
Water Source
Public: 1
Water Company: LUS
Appliances
Built-In Electric Oven: 1
Dishwasher: 1
Disposal: 1
Electric Cooktop: 1
Freezer: 1
Ice Machine: 1
Microwave: 1
Refrigerator: 1
Washer: 1
Water Purifier: 1
Other: 1
Utilities
Elec: City: 1
Countertops
Marble: 1
Other: 1
Quartz: 1
Waterfront
Pond: 1
View: 1
Documents
Property Disclosure: 1
Amenities
Acreage: 1
Security Features
Carbon Monoxide Detector(s): 1
Security System Owned: 1
Smoke Detector(s): 1
Fencing
Chain Link: 1
Full: 1
Split Rail: 1
Lot
Back Yard Access: 1
Corner: 1
Landscaped: 1
Level: 1
Sprinklers In Front: 1
Sprinklers In Rear: 1
Window Features
Double Pane Windows: 1
Financing
1031 Exchange: 1
Cash: 1
Conventional: 1
FHA: 1
Private Banking: 1
Rural Development: 1
VA: 1
Showing
See Remarks: 1
Miscellaneous
Horse Property: 1
Originating Details
Originating System ID: M00000300
Originating System Key: 20260512163225268814
Originating System Listing ID: 2600004234
Originating System Name: RAA Flex
Location Tax Legal Info
Street Number: 400
Street Name: Acorn
St Suffix: Drive
Parish: Lafayette
State: LA
Zip Code: 70507
Subdivision: None
Area: D
Tax Assessment Number: 6018603
Zone: Residential
Elementary School: Evangeline
Middle School: Acadian
High School: Carencro
Directions: From the intersection of Hwy 90 and Louisiana Ave northeast. Turn left onto Acorn Drive and the property is your right hand side before the curve OR From the intersection of I-10 and I-49, head north on I-10, exit onto E Pont Des Mouton Road and left onto Country Hwy 728. Turn right onto Acorn drive and the house is on the left after the curve.
Property Features
Style: Acadian; Contemporary; Traditional
Levels: Two
Siding: Brick
Parking: Attached; Carport; Garage Faces Side; RV Access/Parking
Construction: Brick; Frame
Foundation: Slab
Road Frontage: Paved
Roof: Composition
Interior: Attic Access; Bookcases; Built-Ins; Computer Nook; Crown Molding; Double Vanity; Electric Dryer Con; Electric Stove Con; Electric Washer Con; Guest Suite; Kitchen Island; Multi-Head Shower; Primary Bath; Separate Shower; Special Bath; Standalone Tub; Varied Ceiling Heights; Walk-in Pantry; Walk-In Closet(s); Wet Bar; Window Treatments
Fireplace: 1 Fireplace; Wood Burning
Flooring: Marble; Tile; Vinyl Plank
Heating: Central; Zoned
Cooling: 2 or More Units; Central Air; Zoned
Appliances: Built-In Electric Oven; Dishwasher; Disposal; Electric Cooktop; Freezer; Ice Machine; Microwave; Refrigerator; Washer; Water Purifier; Other
Countertops: Marble; Quartz; Other
Security Features: Carbon Monoxide Detector(s); Security System Owned; Smoke Detector(s)
Fencing: Chain Link; Full; Split Rail
Lot: Back Yard Access; Corner; Landscaped; Level; Sprinklers In Front; Sprinklers In Rear
Patio: Covered; Open
Amenities: Acreage
Exterior: Double Gate Access; Outside Light; Other
Window Features: Double Pane Windows
Waterfront: Pond; View
Sewer: Public Sewer
Water Source: Public
Utilities: Elec: City
Miscellaneous: Horse Property
Financing: 1031 Exchange; Cash; Conventional; FHA; Private Banking; Rural Development; VA
Showing: See Remarks
Documents: Property Disclosure; Property Disclosure
Listing Documents
View Document Plat Map
View Document Property Disclosure

IDX
Listing Office: Compass

Last Updated: June - 10 - 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.


Broker Attribution: 337-233-9700

Search powered by FBS Products

Find Us

Get Directions
 

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

 

AGENT ON CALL | 337-446-6053
 

 

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