SELECT *, CASE WHEN `locality` LIKE "green forest%" 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 = "AR" AND (locality IN ("green forest") 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 38
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "AR" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 38
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.
$4,950,000964 County Road 663Oak Grove AR 72660View Listing
$1,850,000215 County Road 6082Berryville AR 72616View Listing
$1,700,0002562 County Road 818Green Forest AR 72638View Listing
$1,700,0001723 Highway 21Berryville AR 72616View Listing
$1,500,00014889 Highway 311Green Forest AR 72638View Listing
$1,264,00016078 Highway 311Green Forest AR 72638View Listing
$900,000875-01675-001 Highway 21Berryville AR 72616View Listing
$885,500001-04973-000 S Tbd Highway 21Berryville AR 72616View Listing
$885,500S Highway 21Berryville AR 72616View Listing
$850,5004918 County Road 501Berryville AR 72616View Listing
$799,000384 County Road 9284Green Forest AR 72638View Listing
$799,000348 County Road 9284Green Forest AR 72638View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "AR" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 38
Blah
Commercial
Land
Ranch
Single Family
