SELECT *, CASE WHEN `name` LIKE "duvall%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "duvall" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "duvall" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "duvall" 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 ("duvall") 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.
$2,299,50031555 NE Big Rock RdDuvall WA 98019View Listing
$1,649,99514159 269th Ln NEDuvall WA 98019View Listing
$1,574,99514155 269th Ln NE Lot 266Duvall WA 98019View Listing
$1,559,43114171 269th Ln NE Lot 265Duvall WA 98019View Listing
$1,431,99526806 NE 141st Pl Lot 203Duvall WA 98019View Listing
$1,429,45014131 Site 270 269th Ln NEDuvall WA 98019View Listing
$1,393,80514187 Site 263 269th Ln NEDuvall WA 98019View Listing
$1,382,32014171 270th Ln NEDuvall WA 98019View Listing
$1,359,68027018 Site 223 Ne 141st PlDuvall WA 98019View Listing
$1,334,04514179 Site 264 269th Ln NEDuvall WA 98019View Listing
$1,315,75027016 NE 141st PlDuvall WA 98019View Listing
$1,312,21326910 NE 141st Pl Lot 212Duvall WA 98019View Listing
$1,308,08414147 269th Ln NEDuvall WA 98019View Listing
$1,308,08414147 269th Ln NE Lot 268Duvall WA 98019View Listing
$1,303,00026917 NE Walden WayDuvall WA 98019View Listing
$1,302,52414167 Site 249 270th Ln NEDuvall WA 98019View Listing
$1,300,26627012 Site 220 Ne 141st PlDuvall WA 98019View Listing
$1,295,00012415 Kelly Rd NEDuvall WA 98019View Listing
$1,268,65426915 Site 291 Ne Walden WayDuvall WA 98019View Listing
$1,249,99514152 268th Ln NEDuvall WA 98019View Listing
$1,211,47514188 269th Ln NEDuvall WA 98019View Listing
$1,209,99527006 NE 141st PlDuvall WA 98019View Listing
$1,209,99527006 Site 217 Ne 141st PlDuvall WA 98019View Listing
$1,206,63426818 NE 141st PlDuvall WA 98019View 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-04-2024 6:37:45 am.
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