SELECT *, CASE WHEN `locality` LIKE "university of california 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 ("university of california 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
Leading Brokers in university of california davis, CA
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
Street View data not found for this location.
FEATURED PROPERTIES OF UNIVERSITY OF CALIFORNIA DAVIS
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