SELECT *, CASE WHEN `locality` LIKE "joshua tree%" 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 ("joshua tree") 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.
$1,800,000Aberdeen RdYucca Valley CA 92284View Listing
$1,749,00060875 Mountain View TrlJoshua Tree CA 92252View Listing
$1,700,00061624 Kessler PlJoshua Tree CA 92252View Listing
$1,695,0004974 Avenida Del SolJoshua Tree CA 92252View Listing
$1,585,00065181 Mars StJoshua Tree CA 92252View Listing
$1,500,00065600 Twentynine PalmsJoshua Tree CA 92252View Listing
$1,495,00053806 Ridge RdYucca Valley CA 92284View Listing
$1,349,9955323 Wallaby StYucca Valley CA 92284View Listing
$1,290,0009314 CereusYucca Valley CA 92284View Listing
$1,275,0005546 Grand AveYucca Valley CA 92284View Listing
$1,250,00061979 Campanula StJoshua Tree CA 92252View Listing
$1,200,00060300 Mountain TrlJoshua Tree CA 92252View 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