SELECT *, CASE WHEN `locality` LIKE "davis%" 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 = "CA" AND (locality IN ("davis") 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 2
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "CA" 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 2
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.
$27,500,00045496 County Road 35Davis CA 95618View Listing
$5,549,00033033 State Highway 16Woodland CA 95695View Listing
$2,495,00035795 Yellowstone AveDavis CA 95616View Listing
$2,300,00020900 County Road 95Woodland CA 95695View Listing
$1,799,00034378 County Road 17Woodland CA 95695View Listing
$1,400,00034910 Louise LnWoodland CA 95695View Listing
$1,399,90034186 County Road 25Woodland CA 95695View Listing
$1,394,00023603 County Road 96Woodland CA 95695View Listing
$1,269,00022510 Myrtle LnWoodland CA 95695View Listing
$1,000,00016023 County Road 99Woodland CA 95695View Listing
$984,90039909 County Road 17AWoodland CA 95695View Listing
$950,00017775 County Road 97Woodland CA 95695View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "CA" 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 2
Blah
Commercial
Land
Ranch
Single Family
