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;

925 S Kenner Avenue
Waggaman, LA 70094
Vickie Mumphrey with KELLER WILLIAMS REALTY 455-0100, original listing - (504) 455-0100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $815,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5127 Square Feet
Agency: KELLER WILLIAMS REALTY 455-0100
Agency Phone: (504) 455-0100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: This beautiful Acadian home is situated on 10 sprawling acres in desirable Waggaman. The property offers the perfect blend of spacious living and outdoor adventure, great for families who love to entertain and embrace the beauty of country living. The home features 5 bedrooms, 3 full baths, and 1 half bath, providing ample space for family and guests. Th den and kitchen area are open and offer great flow. Imagine relaxing in the evenings by the cozy fireplace, or whipping up culinary delights in the large kitchen. The primary bedroom has two walk-in closets and a large en suite. There is room for everyone in this home! Besides the main living area there is a fabulous game room with a built in wet bar, a sitting room and an office, which are all on the all on the main floor. The suite upstairs has a den, kitchen, private bedroom and a full bathroom. So many possibilities… a guest or an in-law suite or additional living quarters for your family. Another bonus is a space with its own entrance and separate meter that can be used for a business or possible rental. Step outside and discover your own private oasis. An outdoor entertainment area with a sparkling in ground pool beckons you to relax after a long day and host gatherings with family and friends on the weekends! The acreage is beautiful and has a pond that adds a touch of tranquility. There are endless possibilities for the property such as horse or animal pastures, agriculture pursuits, a private retreat, or building a family compound. <br /> Need storage for your boat, RV, or collection of cars? This property has you covered with ample car storage options, including a carport and off-street parking. The property also has a workshop for the hobbyist or handy homeowner and a stable for horse lovers or animal enthusiasts. Schedule your private showing today and experience the magic of Waggaman living!
MlsNumber: --
ListingId: 2441245


Listing Provided By: KELLER WILLIAMS REALTY 455-0100, original listing
Phone: (504) 236-7884
Office Phone: (504) 455-0100
Agent Name: Vickie Mumphrey
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