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;

781 Fairfield Avenue
Gretna, LA 70056
Joey Walker with REVE, REALTORS, original listing - (504) 300-0700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $520,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3165 Square Feet
Agency: REVE, REALTORS
Agency Phone: (504) 300-0700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: This remarkable custom-built and architect designed, one-owner home is a light-filled sanctuary overlooking Timberlane Golf Course. Meticulously maintained and thoughtfully updated, it’s designed for both entertaining and comfortable living. High ceilings give the add to the home's spaciousness. The roomy living and dining rooms seamlessly flow into a gourmet kitchen featuring abundant counter space and storage, pantry, high-end appliances, and a six-burner gas downdraft cooktop. Large windows flood the home with natural light and create a seamless connection to the outdoors, where a large deck offers serene views of the golf course, lovely gardens, and a tranquil pond.<br /> <br /> Inside, the home offers 3-4 bedrooms, including a grand primary suite overlooking the golf course with two full bathrooms and two large walk-in closets. One of the primary baths includes a large jacuzzi tub and separate walk-in shower, while the second primary bath offers a spacious walk-in shower. A separate wing houses an ensuite guest bedroom, two additional bedrooms (one functioning as a home office), and a hall bath. There’s also a powder room, perfect for guests.<br /> <br /> Additional features include an oversized laundry room located between the kitchen and the attached two-car garage, which comes with a dedicated workshop. The home is equipped with a whole-house gas generator and an irrigation system for the yard. As a resident of Timberlane, you'll enjoy access to the country club’s amenities, including a swimming pool, tennis and pickleball courts, and golf. This exceptional single-level home offers a unique opportunity for luxury living in a prime location!
MlsNumber: --
ListingId: 2467204


Listing Provided By: REVE, REALTORS, original listing
Phone: (504) 610-5637
Office Phone: (504) 300-0700
Agent Name: Joey Walker
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