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

2549 Highway 1 Highway
Labadieville, LA 70372

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $434,900
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 1325 Square Feet
Agency: Berkshire Hathaway HomeServices Preferred, REALTOR
Agency Phone: (504) 799-1702

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 32 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Rare opportunity for extensive acreage with a house in Assumption! This adorable 2/1 farmhouse sits on 32 acres of land, 14 of which are cleared and ready for farming and another 18 natural acres full of hardwood trees in the rear. The house was completely renovated in 2005 and sits in an X Flood Zone. There is a large barn, a garage, and an attached covered carport. The house features a roomy kitchen with a six burner gas stove and double oven, a large primary suite, original hardwood floors, a bonus room, and a deep soaking tub with Jacuzzi in the bathroom. Den has a view of all the acreage back to the woods. There is plenty of room to build a large home behind the current house with space for a pool and recreation area. The fields are fenced North and South and feature a raised levee running all the way to the back of the property. There is also a direct right of way access to Highway 398. Fire hydrant right out front. Ample acreage in the wooded area to build other homes or develop for hunting. Recent renovation included installation of energy efficient dual-paned windows, insulation in the walls and attic, new HVAC, new six burner gas stove. Exterior repainted in 2023, roof replaced 2018. Located under ten minutes from Thibodaux where you can find Walmart, Rouses, most of the big box stores, restaurants, entertainment, and Nicholls State University. If Green Acres is the place for you, and farm living's what you'd like to do, land stretching out so far and wide, leave the city and move to the countryside!
MlsNumber: --
ListingId: 2437373


Listing Provided By: Berkshire Hathaway HomeServices Preferred, REALTOR, original listing
Phone: (504) 202-0777
Office Phone: (504) 799-1702
Agent Name: CHRIS R TURGEON
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