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 = 1172 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 1172 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 1172 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;

4017 Benton Dr
Bourg, LA 70343

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $350,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3389
Agency: Propriete Shoppe Real Estate LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1982
Notes: Love to entertain and spend time outdoors? This sprawling Bourg home is awaiting you, just in time for summer! Let's start outside. A 24' diameter above ground pool surrounded by a treated wood deck is fully visible from TWO outdoor areas via the covered patio and back porch. A rear entrance into the home under the porch accesses the bar in the living room complete with overhead wine glass rack and refrigerator. Cozy and inviting, tongue and groove solid wood adorns the spacious living room and foyer vaulted ceilings. Finishing touches such as custom window treatments and a full living room set & speakers will remain if desired. Located to the rear of the home is the Primary Bedroom with a bay window looking out to the backyard, en suite bath and two sizable closets. An armoire is also available for the new owners. Three additional bedrooms are situated on the same side of the home as the primary, stretching the entire depth of the dwelling. A well thought out kitchen containing granite countertops, island, double wall oven and gas cooktop is flanked by a spacious laundry room (with built in ironing board) and breakfast room which leads straight into a formal dining room. Working from home? No worries, this home offers a private office and the desk is also available to remain. In addition to all of these amenities, a regularly maintained 27kw whole home generator is also included. Offering nearly 3400sf of living space on approximately an acre of land, relaxation is on the horizon for this listing's new owners. Transferable flood policy is current. Roof, gutters and fascia have been replaced since Hurricane Ida. Buyer to verify all measurements and flood zone. Seller is willing to remove pool at no expense to Buyer(s) if desired.
MlsNumber: 2023005158


Listing Provided By: Propriete Shoppe Real Estate LLC, original listing
Name: Propriete Shoppe Real Estate LLC
Phone: (985) 232-6901
Office Name: PROPRIE'TE' SHOPPE, LLC
Office Phone: (985) 232-6901
Agent Name: Kacy Amador
Disclaimer: Copyright © 2024 Bayou Board of Realtors. 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