SELECT *, CASE WHEN `locality` LIKE "imperial beach%" 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 ("imperial beach") 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.
$6,900,0001 Vista Santo DomingoOtay Mesa CA 92154View Listing
$4,500,0003600 Paradise Valley RdNational City CA 91950View Listing
$1,999,0003442 Malpazo CtBonita CA 91902View Listing
$1,425,0001575 Wishing Star DrChula Vista CA 91915View Listing
$1,300,0003502 Proctor Valley RdBonita CA 91902View Listing
$949,9004301 Lynwood DrChula Vista CA 91910View Listing
$829,9991482 Caminito SardiniaChula Vista CA 91915View Listing
$799,8882110 Northshore Dr Unit BChula Vista CA 91913View Listing
$786,0001765 Cripple Creek Dr Unit 4Chula Vista CA 91915View Listing
$767,0001615 Osprey Ave Unit 5Chula Vista CA 91913View Listing
$725,000427 Corte Maria AveChula Vista CA 91910View Listing
$680,0001299 Blue Jean Way Unit 4Chula Vista CA 91913View 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
