SELECT *, CASE WHEN `locality` LIKE "crystal 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 = "AZ" AND (locality IN ("crystal 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 17
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "AZ" 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 17
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.
$9,999,90095 Highway 95Lake Havasu City AZ 86404View Listing
$8,700,0000001 Havasu Heights Dr Lot 9Lake Havasu City AZ 86404View Listing
$4,300,0003009 Camino De La EnclavesLake Havasu City AZ 86406View Listing
$4,250,0004124 Black Hill PlLake Havasu City AZ 86406View Listing
$4,000,0002250 Marina View Ave Lot 75Lake Havasu City AZ 86406View Listing
$3,750,0002040 Circula De HaciendaLake Havasu City AZ 86406View Listing
$3,200,0003015 Camino De La EnclavesLake Havasu City AZ 86406View Listing
$2,995,0004132 Black Hill PlLake Havasu City AZ 86406View Listing
$2,799,9993696 Kicking Horse CtLake Havasu City AZ 86404View Listing
$2,399,8003021 Circula De HaciendaLake Havasu City AZ 86406View Listing
$2,250,000421 N Lake Havasu Ave Lot 12Lake Havasu City AZ 86403View Listing
$1,590,0007753 N Rice DrLake Havasu City AZ 86404View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "AZ" 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 17
Blah
Commercial
Land
Ranch
Single Family
