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

593 Bessie Crow Road
Coushatta, LA 71019
Chrissie McWilliams with Pinnacle Realty Advisors, original listing - (318) 233-1045

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $120,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 924 Square Feet
Agency: Pinnacle Realty Advisors
Agency Phone: (318) 233-1045

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1978
Notes: LOOKING FOR A PEACEFUL CABIN RETREAT? BESSIE CROW HAS ALL NEW INTERIOR PAINT, A NEW FRONT PORCH ROOF, ALL ELECTRIC OUTLETS HAVE BEEN UPGRADED TO 20 AMP, SEPTIC WAS INSPECTED AND PUMPED IN 2024, WATER HEATER WAS REPLACED IN FEBRUARY 2024, METAL ROOF IS ONLY 3 YESRS OLD, WAS RECENTLY TESTED FOR TERMITES IN OCTOBER (ALL CLEAR). THIS CUTIE EVEN HAS A NEW CHIMNEY FLU IF YOU WANT TO ADD A WOOD BURNING STOVE OR FIREPLACE. WHILE BESSIE IS A LITTLE ON THE SMALLER SIDE, SHE MAKES UP FOR THAT WITH THE OPEN CONCEPT AND SPACIOUS YARD OF 1.68 ACRES (ALL CLEARED). THE TWO NICE SIZED BEDROOMS FEATURE A JACK AND JILL FULL BATHROOM WITH A TUB AND SHOWER COMBO, AND NEW GFCI PLUGS. THIS LOOKER IS PERFECT FOR A FIRST TIME BUYER OR SOMEONE LOOKING TO DOWNSIZE. GOOD THINGS COME IN SMALL PACKAGES!! SCHEDULE A SHOWING WITH YOUR FAVORITE REALTOR TODAY!!
MlsNumber: --
ListingId: 20813593


Listing Provided By: Pinnacle Realty Advisors, original listing
Phone: (318) 584-2858
Office Phone: (318) 233-1045
Agent Name: Chrissie McWilliams
Disclaimer: Copyright © 2025 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