SELECT *, CASE WHEN `locality` LIKE "monument hills%" 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 ("monument hills") 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.
$8,675,00011930 Road 89Esparto CA 95627View Listing
$5,549,00033033 State Highway 16Woodland CA 95695View Listing
$2,300,00020900 County Road 95Woodland CA 95695View Listing
$1,999,99924321 County Road 23Esparto CA 95627View Listing
$1,799,00034378 County Road 17Woodland CA 95695View Listing
$1,430,0007985 County Road 85Esparto CA 95627View Listing
$1,400,00014624 Gottlob Mast WayEsparto CA 95627View 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
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
