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;

310 Diamond Point Road
Many, LA 71449
Kelly Girouard with Toledo Bend Lakeside Realty, original listing - (318) 645-4243

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $798,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1744 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 Attached
Year Built: 2022
Notes: 1.50-Acre plus leaseback Waterfront Retreat with Exceptional Amenities. Discover the perfect lakeside escape on this gated and fenced 1.50 acre point lot that features approximately 575 feet of water frontage!!! Ideally located just down from the Lanan Boat Launch with fantastic waterfront views and no seawall needed, this property combines convenience, beauty, low maintenance living and huge add on potential!!! The open concept home is designed for effortless enjoyment featuring a durable metal exterior with the lakeside being a log metal siding, concrete floors and a seamless layout ready for expansion. Step inside to find premium details including Commercial Kitchen Appliances, a 47 cu ft. stainless refrigerator and a double oven with 10 burner commercial stove! Includes features are soft close cabinets, tankless water heater, hot and cold water inside and out, There is an office and laundry room behind a sliding barn door. Yamaha surround sound, three sets of french doors that open to the lakeside covered porch for a true version of indoor-outdoor living and much more! This lakeside retreat is entertainment ready with furnishing and appliances included in the sale! Outside the property offers unmatched functionality with a whole house water filtration system, gas hookups for outdoor cooking, Back up Power with a 20KW Generac that ensures peace of mind. Every guys dream with a 40x40 Storable Building that includes a slab foundation, three 12x12 roll up doors, one walk in door and additional 30x40 lean-to on both sides creating a massive 40x100 roofed area on its own electric meter and has city water in place. There is also a 12x20 storage building! Don't miss this rare opportunity to own a versatile, waterfront retreat with endless possibilities!
MlsNumber: --
ListingId: 11365012


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