SELECT *, CASE WHEN `locality` LIKE "coyote flats%" AND `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "TX" AND (locality IN ("coyote flats") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 37
Blah
SELECT *, CASE WHEN `locality` LIKE "coyote flats%" AND `slide_location` = "city-agent" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "city-agent" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "TX" AND (locality IN ("coyote flats") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[4] matching rows / [0.00 msec]
Blog ID 37
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$11,211,4614300 County Road 1224Cleburne TX 76033View Listing
$7,000,0002209 N Nolan River RdCleburne TX 76033View Listing
$6,600,0001000 County Road 904Joshua TX 76058View Listing
$5,472,000County 1224 Rd Unit 2Cleburne TX 76033View Listing
$4,609,750County 1224A Rd Unit 3Cleburne TX 76033View Listing
$4,524,6604925 County Road 1124Cleburne TX 76033View Listing
$4,200,0002532 S Highway 171Cleburne TX 76031View Listing
$4,000,0001513 County Road 801BCleburne TX 76031View Listing
$4,000,0008271 County Road 206Grandview TX 76050View Listing
$3,900,0004326 FM 67Grandview TX 76050View Listing
$3,854,2007811 County Road 1208Rio Vista TX 76093View Listing
$3,800,000364 County Road 1102Rio Vista TX 76093View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, CASE WHEN `locality` LIKE "coyote flats%" AND `slide_location` = "city-lenders-title-lower" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "city-lenders-title-lower" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "TX" AND (locality IN ("coyote flats") OR locality IS NULL) AND slide_location IN ("city-lenders-title-lower") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[2] matching rows / [0.00 msec]
Blog ID 37
Blah