Land.US is a premier publishing resource for U.S. land investors and legacy buyers.
SELECT *, CASE WHEN `locality` LIKE "hemphill 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 slide_location IN ("county-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
 matching rows / [0.00 msec]
Blog ID 37
Street View data not found for this location.
Would you like us to send you recommendations?
Skip the hard work of searching for trustworthy local professionals on your own. Let us help you connect with professionals who will help you buy and sell land.