Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1140 AND i.igate IN ('usahud','lahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'lahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1140 AND i.igate IN ('usahud','lahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'lahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1140 AND i.igate IN ('usahud','lahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'lahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

7503 Sugar Oaks Road
New Iberia, LA 70563
Ashley Verret with McGeeScott Realty, original listing - (337) 735-4040

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,599,900
Beds: 6
Baths: Full: 4, ½: 2
Status: Active
SqFt: 6686 Square Feet
Agency: McGeeScott Realty
Agency Phone: (337) 735-4040

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Welcome to your Southern-Traditional dream estate, gracefully situated near the heart of Loreauville on 5.16 acres of serene, bayou-front land. An iconic fleur-de-lis fountain welcomes guests to this exceptional Acadian retreat and blends timeless elegance with modern luxury, offering 6 spacious bedrooms, 4 full baths, and 2 half baths. Designed for both grand entertaining and everyday comfort, this home invites you into a world of sophistication.Step into the soaring 20+ foot-high foyer, where double curved staircases frame a breathtaking 10-foot chandelier, illuminated by the glow of custom inset fleur-de-lis slate flooring. A formal dining room awaits lavish gatherings, while the expansive office provides a peaceful retreat.At the heart of this estate lies the chef's kitchen, equipped with premium Thermador appliances, ample counter space, and an island for culinary creations. The luxurious master suite is a sanctuary of its own, featuring a cozy fireplace, an expansive double walk-through shower, and a customized walk-in closet with moveable islands for ultimate convenience.The outdoor space is your private oasis, boasting a 30,000-gallon heated pool, ideal for year-round enjoyment. The 60x40 workshop offers limitless possibilities, while the whole-home generator ensures uninterrupted comfort.This meticulously crafted home was built with enduring quality, including solid-sheeted walls, spray foam insulation, and a post-tension slab with added rebar. With direct bayou frontage, enjoy tranquil outdoor adventures on your expansive property.Additional adjacent 4.97 acres are available for purchase, offering even more opportunity to expand your estate.Don't miss your chance to experience this enchanting property. Call today to schedule your private showing! *Pre approval/Proof of funds required prior to showings.*
MlsNumber: --
ListingId: 24009116


Listing Provided By: McGeeScott Realty, original listing
Phone: (337) 735-4040
Office Phone: (337) 735-4040
Agent Name: Ashley Verret
Disclaimer: Copyright © 2024 Realtor Association of Acadiana. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App