SELECT *, CASE WHEN `locality` LIKE "camp pendleton north%" 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 ("camp pendleton north") 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.
$75,000,0005820 W Lilac RdBonsall CA 92003View Listing
$11,500,0006036 Rainbow Heights RdFallbrook CA 92028View Listing
$10,000,0001522 Sunset DrVista CA 92081View Listing
$9,500,0001200 S Ditmar St Unit 6Oceanside CA 92054View Listing
$4,050,00040635 DE Luz RdFallbrook CA 92028View Listing
$3,999,9974633 Olive Hill RdFallbrook CA 92028View Listing
$3,999,0001808 Santa Margarita DrFallbrook CA 92028View Listing
$3,800,0002317-19 Grande DrVista CA 92084View Listing
$3,595,0004522 Pala RdFallbrook CA 92028View Listing
$3,500,0001225 N Santa Fe AveVista CA 92084View Listing
$3,499,90031460 Aquaduct RdBonsall CA 92003View Listing
$3,250,0004716 S Mission RdFallbrook CA 92028View 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