SELECT *, CASE WHEN `locality` LIKE "joseph%" 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 = "OR" AND (locality IN ("joseph") 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 56
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "OR" 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 56
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.
$13,777,00065131 McFetridge RdEnterprise OR 97828View Listing
$13,499,00084525 Walker LnJoseph OR 97846View Listing
$10,999,00084587 Walker LnJoseph OR 97846View Listing
$2,650,00071919 Eden LnEnterprise OR 97828View Listing
$2,500,00076815 Mallory LnEnterprise OR 97828View Listing
$2,500,00062994 Hurricane Creek RdJoseph OR 97846View Listing
$2,200,00067213 Crow Creek RdEnterprise OR 97828View Listing
$2,200,00083837 E Russell LnJoseph OR 97846View Listing
$1,997,00064434 Alder Slope RdEnterprise OR 97828View Listing
$1,400,00088229 Bartlett RdEnterprise OR 97828View Listing
$1,190,000603 E Wallowa RdJoseph OR 97846View Listing
$950,00080117 Countryside RdJoseph OR 97846View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "OR" 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 56
Blah
Commercial
Land
Ranch
Single Family
