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

744 Fairfield Avenue
Gretna, LA 70056
Lulu Latham with Epique Realty, original listing - (888) 893-3537

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $439,999
Beds: 4
Baths: Full: 2, ½: 2
Status: Active
SqFt: 3614 Square Feet
Agency: Epique Realty
Agency Phone: (888) 893-3537

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Indulge in comfort in this 4-bedroom, 2 bath, and two ½ bath home equipped with Generac Guardian Series home generator situated in the partially gated Timberlane community. Nestled amidst trees gracing the front lawn and some that welcome and offer tranquility in the back yard. Step through the foyer and be welcomed by the cozy den that provides space for quiet leisure. The expansive living room serves as the heart of the home for grand or small celebrations. For family dinners or formal gatherings, celebrate memorable meals with lively conversations in the dining room or dine in the cozy breakfast area. A spacious bonus room provides endless possibilities for customization, whether you envision a home office, a media room, a playroom, or a fitness center. This versatile space can be tailored to suit your unique needs and preferences, offering a blank canvas for your creativity to flourish. Unwind in the natural light in the sunroom while enjoying the views of the pool and backyard. Outside, a lavish pool invites you to indulge in leisurely afternoons spent basking in the sun or cooling down and enjoying a swim. Surrounded by a large backyard, this outdoor oasis offers a private retreat where you can escape the cares of the world and immerse yourself in the beauty of nature. The French doors of the primary bedroom offer a connection between nature and a place of rest. From the sunroom to the inviting pool and expansive living spaces, this home has been thoughtfully crafted to enhance your living experience. Make lasting memories and create a lifetime of cherished moments of quiet, family time to large gatherings with family and friends. This home offers ample space inside and out. It beckons you to unwind and recharge in any space you choose as a retreat. Vsit https://tnibd.org/ for Timberlane HOA benefits and golf course membership.
MlsNumber: --
ListingId: 2445192


Listing Provided By: Epique Realty, original listing
Phone: (504) 912-0966
Office Phone: (888) 893-3537
Agent Name: Lulu Latham
Disclaimer: Copyright © 2024 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