SELECT *, CASE WHEN `locality` LIKE "rio vista%" 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 ("rio vista") 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 "rio vista%" 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 ("rio vista") 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
$8,280,0001226 FM 67Covington TX 76636View Listing
$7,000,0002209 N Nolan River RdCleburne TX 76033View 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
$3,854,2007811 County Road 1208Rio Vista TX 76093View Listing
$3,800,000364 County Road 1102Rio Vista TX 76093View Listing
$3,795,000522 N Country Meadow CirCleburne TX 76033View Listing
$3,775,000County 1224 Rd Unit 1Cleburne TX 76033View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, CASE WHEN `locality` LIKE "rio vista%" 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 ("rio vista") 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
Commercial
Land
Ranch
Single Family
