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

9533 Hwy 5
Keatchie, LA 71046
Stan McLaughlin with Realnova Inc, original listing - (678) 495-1475

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $695,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 2774 Square Feet
Agency: Realnova Inc
Agency Phone: (678) 495-1475

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1848
Notes: The Crawford Williams Home, built in 1848, sits on 6.5 acres in historic Keatchie, Louisiana. Just 25 miles south of Shreveport. This magnificent antebellum home is 2774 heated and cooled sq ft, completely restored with all of the modern amenities and lavishly decorated to complement the era of its time. The living room parlor has a wood burning fireplace with antique mantle, and a stately dining room, this home is perfect for gatherings. The fully equipped kitchen provides access to both sides of the wrap around porch, that hosts an abundance of columns that lay homage to the Greek revival style home. There are two beautiful bedrooms. The primary bedroom features an ensuite bathroom. Elegant chandeliers adorn each room throughout the home, adding to the beauty and grandeur. This home is not only perfect for a family home but also has the opportunity for a bed and breakfast, wedding and event venue, and much more. In addition to the home, there is a 3,000 square foot, beautifully designed, heated and cooled, vaulted ceiling barn, adorned with 3 elegant chandeliers, 2 AC units and a bathroom. You will also find multiple electrical outlets and water access throughout the grounds, making it an ideal location for events, markets, etc. Also on the property, is a 2000 square foot 3 stall, 2 story animal barn with a tack feed room. In addition, there is a 36 by 24 workshop. Lastly, there is a quant, beautiful she shed in the backyard. The opportunity to purchase the main home, fully furnished is available. Let this be your next family estate, bed and breakfast, or venue.
MlsNumber: --
ListingId: 20760016


Listing Provided By: Realnova Inc, original listing
Phone: (404) 425-3258
Office Phone: (678) 495-1475
Agent Name: Stan McLaughlin
Disclaimer: Copyright © 2024 North Texas Real Estate Information Systems, Inc. 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