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

130 Catfish Drive
Zwolle, LA 71486
Kelly Girouard with Toledo Bend Lakeside Realty, original listing - (318) 645-4243

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,300,000
Beds: 5
Baths: Full: 5, ½: 2
Status: Active
SqFt: 4400 Square Feet
Agency: Toledo Bend Lakeside Realty
Agency Phone: (318) 645-4243

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Experience true tranquility and privacy in this stunning, gated custom waterfront home, nestled on two point lots spanning 1.17 acres. Boasting nearly 1000 linear feet of water frontage, this French Mediterranean masterpiece offers unparalleled views and serenity. The exterior showcases a blend of stucco and European style sacked brick, crowned by a Decrabond tile roof crafted from steel and stone. Welcomed by antique double entry doors, approximately 309 years old, the home exudes timeless elegance. Indulge in breathtaking sunsets from the covered porches overlooking San Miguel, while observing the majestic eagles, pelicans, and other waterfowl that frequent the area. Inside, discover 5 bedrooms, 5 baths, and two 1/2 baths, along with luxurious features such as 2x6 outside walls, 9 inches of insulation, and ample storage throughout. The expansive primary suite offers comfort and tranquility, complemented by a wood-burning fireplace, double ovens, stainless appliances, and a large pantry. Custom, insulated windows flood the home with natural light and offer picturesque views from nearly every room. The downstairs area boasts Sicilian tile flooring accents and includes a full kitchen, living area, and laundry, seamlessly flowing out to a lakeside covered porch and screened-in patio. A floating boat dock, recently constructed within the last two years, and a 12x16 storage space added in 2023, cater to outdoor enthusiasts. Additional amenities include an irrigation system, well-maintained seawall, and lush yard space for family enjoyment. Embrace the epitome of waterfront living in this meticulously designed oasis.
MlsNumber: --
ListingId: 11261589


Listing Provided By: Toledo Bend Lakeside Realty, original listing
Phone: (318) 645-4243
Office Phone: (318) 645-4243
Agent Name: Kelly Girouard
Disclaimer: Copyright © 2024 My State 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