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

1112 Bayou Tortue Road
Broussard, LA 70518
C. Leigh Ann Meche with Choice Realty, original listing - (337) 258-0235

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $925,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3128 Square Feet
Agency: Choice Realty
Agency Phone: (337) 258-0235

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1991
Notes: Gorgeous setting in this one of a kind rustic retreat on the bayou exemplifies life in South Louisiana. Situated on 2.15 acres on Bayou Tortue/Cypress Bayou, this Acadian style home and grounds has it all. The main house consists of 3 bedrooms and 3.5 baths and boasts 3,128 square feet with 20+ foot vaulted ceilings, double-sided brick fireplace, as well as a gourmet kitchen with large island and peninsula with bar-stool seating. The main home is situated on the lot to take advantage of the majestic Live Oaks and the beauty of Bayou Tortue/Cypress Bayou. In addition, the lot features multiple fruit trees including Satsuma and Fig along with French Mulberry. Stately Cypress trees also line the yard on the bank of the bayou. The rear yard landscaping is lush and private, with a salt water in-ground pool with new pool pump and water features including 3 water-falls and a trickling stream built into the pool landscaping area which adds to the retreat feel. The pool area is fully fenced with wrought-iron fencing and equipped with a above ground hot tub off master, brick wood burning fireplace and Pergola. A separate 1,100 sqft guest house offers the perfect space for in-laws or guests, office or and income producer. This space includes a full kitchen, W/D hook-ups, full bath and loft bedroom space upstairs. Property also includes an elevated deck that extends over the Bayou to enjoy fishing or entertaining on the water. While this home feels secluded, it is only minutes from shopping, restaurants, schools and church. The majority of the frontage and drive entrance is fenced with beautiful wrought-iron fencing and very private. ADT security system including 3 outdoor cameras and 2 door bell cameras remain with home. Home is on well water and also has a new Hoot mechanical sewage pump. Large Propane tank for the gas range. This is a one of a kind property and must be seen in person to truly appreciate the pride of ownership.
MlsNumber: --
ListingId: 24008439


Listing Provided By: Choice Realty, original listing
Phone: (337) 258-0235
Office Phone: (337) 258-0235
Agent Name: C. Leigh Ann Meche
Disclaimer: Copyright © 2024 Realtor Association of Acadiana. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 1146 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;
Lisa Day
ASCIIeXp Realty
Call Today!: (337) 852-1913

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App