SELECT *, CASE WHEN `name` LIKE "carefree%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "carefree" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "carefree" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "carefree" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "AZ" AND (locality IN ("carefree") 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 *, CASE WHEN `name` LIKE "carefree%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "carefree" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "carefree" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "carefree" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "AZ" AND (locality IN ("carefree") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[2] 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.
$1,495,0007840 E Serene StCarefree AZ 85377View Listing
$1,395,0007533 E Tranquil PlCarefree AZ 85377View Listing
$1,250,00037081 N Bloody Basin RdCarefree AZ 85377View Listing
$1,229,00036410 N Romping RdCarefree AZ 85377View Listing
$1,199,9008502 E Cave Creek Rd Unit 36Carefree AZ 85377View Listing
$1,150,0001116 E Ocotillo CirCarefree AZ 85377View Listing
$1,050,0007199 E Ridgeview Pl Unit 221Carefree AZ 85377View Listing
$1,050,0008956 E Venus DrCarefree AZ 85377View Listing
$1,000,0001062 E Boulder DrCarefree AZ 85377View Listing
$999,1681 Easy St Unit 30Carefree AZ 85377View Listing
$995,00036801 N Tom Darlington DrCarefree AZ 85377View Listing
$989,00035846 N Tom Darlington DrCarefree AZ 85377View Listing
$950,0007090 E Ridgeview PlCarefree AZ 85377View Listing
$945,0008502 E Cave Creek Rd Unit 40Carefree AZ 85377View Listing
$945,0007715 E Cave Creek RdCarefree AZ 85377View Listing
$905,8901 Easy St Unit 3Carefree AZ 85377View Listing
$875,0001 Easy St Unit 13Carefree AZ 85377View Listing
$866,4507199 E Ridgeview Pl Unit 102Carefree AZ 85377View Listing
$850,0007830 E Estates CirCarefree AZ 85377View Listing
$829,0008712 E Eastwood CirCarefree AZ 85377View Listing
$788,0001 Easy St Unit 10Carefree AZ 85377View Listing
$780,00036601 N Mule Train Rd Unit B31Carefree AZ 85377View Listing
$765,00080 Almarte CirCarefree AZ 85377View Listing
$755,6711 Easy St Unit 25Carefree AZ 85377View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-05-2024 9:14:47 pm.
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