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;

572 Glen Oaks Drive
Florien, LA 71429
LYDIA HOLLAND with RE/MAX ONE, original listing - (337) 725-4663

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $559,500
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2136 Square Feet
Agency: RE/MAX ONE
Agency Phone: (337) 725-4663

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 31,363 sqft
Property Type: Residential-Single Family Residence
Year Built: 1972
Notes: Approaching completion, but this one is still A MUST SEE on Glen Oaks in Toledo Bend. This stunning, like new home is the perfect place to relax and enjoy lake life. Nestled on the main lake of Toledo Bend Reservoir, you will find yourself immersed in beautiful views and peace that only this area can provide. Inside this 4 bedroom, 3 bath completely remodeled home, you will find everything you need for comfortable living whether this is a primary residence, weekend/seasonal retreat or investment property. Gutted down to the studs and redone from top to bottom with new plumbing, electrical, roof, HVAC, etc., this property is beautifully finished and boasts 2 master en suites, an open floor plan, spacious rooms and no wasted space. The kitchen will feature new appliances, custom built cabinetry with plenty of workspace for all your cooking and entertaining needs and an eat-in island/breakfast bar where friends and family can gather together comfortably while enjoying all the beauty that nature has to offer just outside your windows. The tranquil water of Toledo Bend Reservoir and the Pleasure Point area are the perfect location for unwinding after a long day or hosting summer gatherings. Every bedroom comes complete with large windows offering incredible views and tons of natural light throughout each room as well as ample closet space so storage won't be an issue when it comes time to move in. The master suite features its own private entrance into the backyard oasis where you can take advantage of all it has to offer including lush landscaping, fruit trees, and direct access down into your very own boat dock! Talk about convenience - now there's no need to drive anywhere else when it's time hit up some fishing spots or explore what this great lake has in store! Not only does this amazing home have much more than meets the eye but also offers great incentives such as energy-efficient heating/cooling systems helping keep costs low while maintaining maximum comfort year-round - talk about value! Plus if boating isn't quite your thing then don't worry because right around corner are other amenities such as golf courses, parks, hiking trails, etc. making every day something new and exciting.
MlsNumber: --
ListingId: SWL23003831


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