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;

1149 Oak Ridge 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: $1,199,000
Beds: 6
Baths: Full: 6, ½: 1
Status: Active
SqFt: 4204 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: 1999
Notes: Nestled along the shores of expansive waters with stunning views and breathtaking sunsets, this remarkable property offers a unique retreat experience. This beautiful log and brick home boasts two guest houses and a bunk house, providing ample space to comfortably sleep 20 guests, with potential for more. Spanning approximately 4,204 square feet of heated and cooled living space, the main home features 6 bedrooms and 6.5 bathrooms, including a cozy wood-burning fireplace. Situated on 1.92 fenced and gated acres, this estate is designed for outdoor living with a spacious 16x20 covered porch complete with an outdoor kitchen. The kitchen is outfitted with granite countertops, two Green Eggs in different sizes, a Frostonics refrigerator, sink, and plenty of prep space. Enjoy the outdoors with a 55" outdoor television surrounded by Breezesta furniture. The property is well-equipped with a 22KW generator, ensuring 70% power to the main house and full power to the guest houses. For added convenience, there are two 55-gallon Spider Be Gone systems, one for the house and one for the boathouse, sprinkler system in place to nourish the beautiful landscaping. Boating enthusiasts will appreciate the large detached garage with a covered lean-to for boat storage for two boats with room for your accessories too, an asphalt circle driveway, storage building to the right of the guest house and a 25' concrete boat launch ideal for jet skis. The property also features a sea wall with a beach area, a 32x35 boathouse with three lifts including a HPU 300 hydraulic Lunmar Shore Station Boat lift, and jet ski and pedal boat lifts. A 12x35 drop-down swim deck provides a fantastic entertainment area, complete with Breezesta furniture. Additional amenities include a 10x8 storage shed with a refrigerator and fresh water on the boathouse, plus a fully furnished interior ready for you to enjoy lake life from the moment you arrive. Amazing luxury rental potential!!! Must have pre approval or proof of funds to view this property!
MlsNumber: --
ListingId: 11333639


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