SELECT *, CASE WHEN `locality` LIKE "casa grande%" 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 ("casa grande") 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.
$22,000,0001585 N Thornton RdCasa Grande AZ 85122View Listing
$8,670,000E Of Nec E Val Vista Blvd and N Pinal AveCasa Grande AZ 85122View Listing
$6,231,802W Maricopa HwyCasa Grande AZ 85193View Listing
$5,000,000W Earley Rd Lot ACasa Grande AZ 85122View Listing
$4,821,7505633 N Cox RdCasa Grande AZ 85194View Listing
$4,206,000N Camino Mercado Lot 13Casa Grande AZ 85122View Listing
$3,850,0009340 S John Jacob Astor Ave Lot 2Casa Grande AZ 85193View Listing
$3,740,000697 N Lola Lee RdCasa Grande AZ 85194View Listing
$3,136,800N Pinal AveCasa Grande AZ 85122View Listing
$3,032,400W Gila Bend HwyCasa Grande AZ 85193View Listing
$2,397,978E Kortsen RdCasa Grande AZ 85122View Listing
$1,800,000McCartney RdCasa Grande AZ 85122View 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
