SELECT *, CASE WHEN `name` LIKE "walla walla%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "walla walla" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "walla walla" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "walla walla" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "WA" AND (locality IN ("walla walla") 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 58
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "WA" 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 58
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.
$1,995,0001648 Stateline RdWalla Walla WA 99362View Listing
$1,399,00098 Pearmain AveWalla Walla WA 99362View Listing
$1,300,000397 Martin Field LnWalla Walla WA 99362View Listing
$1,100,0001240 Lancer DrWalla Walla WA 99362View Listing
$1,050,0001105 Valley Vista AveWalla Walla WA 99362View Listing
$949,0001263 Country Club RdWalla Walla WA 99362View Listing
$925,000101 Equestrian WayWalla Walla WA 99362View Listing
$899,9998049 Lewis Peak RdWalla Walla WA 99329View Listing
$899,000132 Swegle RdWalla Walla WA 99362View Listing
$887,000707 E Tietan StWalla Walla WA 99362View Listing
$875,0003340 Morrison LnWalla Walla WA 99362View Listing
$850,000715 Washington StWalla Walla WA 99362View Listing
$849,000463 Five Mile RdWalla Walla WA 99362View Listing
$825,00010381 Misty Ridge RdWalla Walla WA 99362View Listing
$825,0001275 Doc Bar PlWalla Walla WA 99362View Listing
$824,9001389 Havstad DrWalla Walla WA 99362View Listing
$800,000138 Hill RdWalla Walla WA 99362View Listing
$799,00018 Sweet Onion LnWalla Walla WA 99362View Listing
$799,0001615 Sturm AveWalla Walla WA 99362View Listing
$799,0001206 Southview DrWalla Walla WA 99362View Listing
$799,0003105 Canberra DrWalla Walla WA 99362View Listing
$795,0001289 Doc Bar PlWalla Walla WA 99362View Listing
$786,5001434 Durant StWalla Walla WA 99362View Listing
$779,900958 Abbott RdWalla Walla WA 99362View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-08-2024 6:00:11 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "WA" 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 58
Blah