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 = 1137 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 1137 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 1137 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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;

3232 Bond Road
Mamou, LA 70554

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,500
Beds: 4
Baths: 4
Status: Active
SqFt: 4949
Agency: RE/MAX ONE

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 14 acre(s)
Property Type: Residential
Year Built: 2004
Notes: BACK ON THE MARKET WITH MUCH MORE TO OFFER!! Now offering 14 ACRES of LAND along with a 36x30 Horse Stable that includes a hay loft, 5- 10x12 stalls, and a tack room. This beautiful perfectly maintained home is a truly rare find! This spacious Acadian style home offers everything a family needs. As you walk in, you will walk into a large entertainment room that has it all. It could be used as an outdoor kitchen or mother-in-law suite as it has a full kitchen, living area and full bath. You can open the door and step onto the fenced in outdoor oasis where you will find a nice, shaded patio area overlooking the inground pool and enjoy entertaining or relaxing. Or you can walk through to the breakfast area, joining the kitchen where you can enjoy cooking or drinking coffee next to the double-sided gas fireplace. The moveable island has ample amount of storage with large pullout pot drawers and a bookshelf. Cabinets have pull out drawers for more storage, a lazy Susan cabinet, along with pull out pan storage. The kitchen also features a built-in electric range/oven and a double sink with a middle rinsing sink. Through the French doors you will find a formal dining room with custom built-in China cabinets. As the hallway opens to the tall, vaulted ceiling in the living area you can enjoy the other side of the gas fireplace with family. Through the master bedroom you can sit quietly in the sitting/nursing room that has ample amount of storage. The master bath includes a large step up soaking jacuzzi tub, separate shower, makeup vanity area, and his and her walk-in closets. Upstairs you will walk into an open office space, multiple closet doors into the attic for storage, 3 walkout doghouse dormers, 1bedroom and 1 bath. Home also features a central vacuum system, 3 water heaters, 3 HVACs, built sturdy with layers of plywood then sheetrock, recess lighting, crown molding throughout, large walk-in laundry room with utility sink, storage closet in garage, and lots and lots of other storage. Additional Land is also available to purchase when purchasing the home. Located in Flood Zone X. All measurements M/L.
MlsNumber: SWL24003054


Listing Provided By: RE/MAX ONE, original listing
Name: RE/MAX ONE
Phone: (337) 794-7848
Office Name: RE/MAX ONE
Office Phone: (337) 725-4663
Agent Name: Kelley Richardson
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