SELECT *, CASE WHEN `locality` LIKE "baker city%" 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 ("baker city") 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.
$3,200,00046310 Cook RdBaker City OR 97814View Listing
$3,100,000155 Elm StBaker City OR 97814View Listing
$1,700,000483 AcresBaker City OR 97814View Listing
$1,250,00036020 Alder Creek RdBaker City OR 97814View Listing
$1,100,00036928 Denny Creek RdBaker City OR 97814View Listing
$895,00015710 Goodrich Creek LnBaker City OR 97814View Listing
$850,00044185 Highway 30Baker City OR 97814View Listing
$785,00043049 Old Wingville RdBaker City OR 97814View Listing
$599,9003890 Indiana AveBaker City OR 97814View Listing
$599,90044414 Pocahontas RdBaker City OR 97814View Listing
$500,000995 Idlewood DrBaker City OR 97814View Listing
$499,9004196 Cedar StBaker City OR 97814View 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
