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

16052 Highway 26 Highway
Jennings, LA 70546
JOE TUPPER with TUPCO REALTY, original listing - (337) 824-2790

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $895,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5108 Square Feet
Agency: TUPCO REALTY
Agency Phone: (337) 824-2790

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 17 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Set your sights up! It is a new day in the neighborhood, seldom does a property of this size and caliber find its way into the marketplace. This property has a prime location being just minutes from I-10 and all of the amenities that Jennings has to offer. 17 acres to do as you please. This large lot affords you the opportunity to participate in almost to <br /> any kind of activity that you would desire. This custom home was designed by Vic Guidry and constructed by renown local contractor Lynn Richard. Solid brick on slab construction with plywood sheeting both inside and out makes this building extra sturdy. You will have to see for yourself to experience the many high-end custom features of this fine home. As you approach, you will notice the full front porch, perfectly suited for enjoying a morning cup of coffee or watching the sunset. A large carport provides covered parking for all of your vehicles. Once inside the home you will be greeted a chef's kitchen and a large utility room and bath. This home has both his and her offices making working from home a real possibility. Downstairs is a large foyer leading into a great room perfect for entertaining family and friends. On the first floor are two additional bedrooms, which share a bath. The Master suite is large and inviting as well as the elegant bath with separate his and her closets. The grand staircase invites you up tO the second floor where this open area is ready for your design touches. With the additional kitchen this upstairs loft can provide additional living space or the ultimate relaxation and gaming area or home theater. Step out onto the covered veranda in the rear of the home to experience everything this pool and aquatic paradise can offer. This is party central in the summertime for your friends, children, grandchildren, and extended family. This home offers so much, it is just too numerous to list everything, schedule your appointment today to see for yourself!
MlsNumber: --
ListingId: SWL24007269


Listing Provided By: TUPCO REALTY, original listing
Phone: (337) 824-2790
Office Phone: (337) 824-2790
Agent Name: JOE TUPPER
Disclaimer: Copyright © 2024 Greater Southern MLS. 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