SELECT *, CASE WHEN `locality` LIKE "north edwards%" 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 ("north edwards") 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.
$750,420Twenty Mule Team PkwyCalifornia City CA 93505View Listing
$742,750California City BlvdCalifornia City CA 93501View Listing
$635,0007027 Poppy BlvdCalifornia City CA 93505View Listing
$600,000Lindbergh BlvdCalifornia City CA 93505View Listing
$597,200California City BlvdCalifornia City CA 93501View Listing
$549,90016716 Hacienda BlvdCalifornia City CA 93505View Listing
$500,000California City BlvdCalifornia City CA 93505View Listing
$490,000Flint StNorth Edwards CA 93523View Listing
$450,000Isabella BlvdCalifornia City CA 93505View Listing
$400,0009955 Crest RdCalifornia City CA 93505View Listing
$399,0007884 ChapiniteCalifornia City CA 93519View Listing
$389,200California City BlvdCalifornia City CA 93501View 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