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

17115 Highway 171 Highway
Ragley, LA 70657
ROBBIE INGLE with COLDWELL BANKER INGLE SAFARI, original listing - (337) 478-1601

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2502 Square Feet
Agency: COLDWELL BANKER INGLE SAFARI
Agency Phone: (337) 478-1601

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1962
Notes: Discover the charm of country living in Ragley, where this Ranch-style home is perfectly situated on a generous 1.5-acre lot adorned with majestic oak trees. Boasting 3 cozy bedrooms and 2.5 well-appointed bathrooms, this residence ensures comfort for everyone. Embrace the ease of single-floor living with three distinct living spaces offering room to relax, play, or entertain. The open kitchen and dining area serve as the heart of the home, where meals and memories will be made. An impressive 30x50 insulated workshop provides ample space for projects or storage, while the 20kw generator ensures peace of mind. Key updates include a roof, A/C, and mechanical sewer system, all replaced within the last three years, signifying a home that's been maintained with care. The property also presents commercial potential thanks to its Highway 171 frontage, making it a versatile investment. Ready for move-in and part of the esteemed South Beauregard school district, this home is poised for its next chapter. And with its location in flood zone X, you'll have one less thing to worry about, as no flood insurance is needed. Could this be the backdrop for your new beginning? Reach out today to schedule a showing and see how this property can cater to both your residential dreams and business ventures!
MlsNumber: --
ListingId: SWL24000305


Listing Provided By: COLDWELL BANKER INGLE SAFARI, original listing
Phone: (337) 304-0481
Office Phone: (337) 478-1601
Agent Name: ROBBIE INGLE
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