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 = 1162 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 = 1162 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 = 1162 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;

161 Avenue Of Oaks Drive
Destrehan, LA 70047
Webb Jay with Webb Jay & Associates, LLC, original listing - (985) 317-3370

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,500
Beds: 6
Baths: Full: 3, ½: 3
Status: Active
SqFt: 4727 Square Feet
Agency: Webb Jay & Associates, LLC
Agency Phone: (985) 317-3370

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Southern Charm with open living spaces great for entertaining both inside and out. This southern grand acadian home features all the amenities you are looking for. Open space, the main house includes 5 Bedrooms, 3 Full baths, and 1 half bath, with an additional bedroom and 2 half baths in the guest quarters. Additionally, the main house features, Large open kitchen with gas range, custom vent hood, wall oven, built in microwave and large french door refrigerator freezer. Extra large primary suite with tons of walk in closet space and a large primary bathroom with double vanity, extra large jetted tub, a separate shower. 4 additional large bedrooms upstairs, with plenty of closet and storage space as well as a multipurpose room, that could be used as a office or upstairs living space. And, if you didn't already have enough storage there is a walk in attic space as well. Outside on this large lot shaded by established oak trees there is plenty of space to unwind, relax or entertain with a covered patio, a inground pool, spa and outdoor kitchen with wet bar. The double car - drive through garage has doors on both ends allowing for access to the back yard, and also features additional living space with a living space downstairs and a billiard room upstairs that includes a wet bar of it's own that was previously used as a bedroom as well. If you are looking for home with endless possibilities and room to spread out you must see this home to fully appreciate. Located in desirable X flood zone.
MlsNumber: --
ListingId: 2487449


Listing Provided By: Webb Jay & Associates, LLC, original listing
Phone: (504) 915-2944
Office Phone: (985) 317-3370
Agent Name: Webb Jay
Disclaimer: Copyright © 2025 Gulf South Real Estate Information Network. 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