SELECT *, CASE WHEN `locality` LIKE "bowie county%" AND `slide_location` = "county-agent" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "county-agent" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "TX" AND (locality IN ("bowie county") OR locality IS NULL) AND slide_location IN ("county-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[2] matching rows / [0.00 msec]
Blog ID 37
Blah
$95,00001 County Road 2311Texarkana TX 75503View Listing
$65,0001947 County Road 4009New Boston TX 75570View Listing
$64,9992018 County Road 4009New Boston TX 75570View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-03-2024 5:35:58 am.