SELECT *, CASE WHEN `name` LIKE "marana%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "marana" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "marana" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "marana" 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 ("marana") 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.
$7,500,00014155 N Luckett RdMarana AZ 85653View Listing
$3,900,00020801 W Manville RdMarana AZ 85653View Listing
$3,750,0004175 W Horizon Ridge DrMarana AZ 85658View Listing
$3,177,84414260 N Moon Gaze Dr Unit 5Marana AZ 85658View Listing
$2,988,00014771 N Dove Canyon PassMarana AZ 85658View Listing
$2,850,00014338 N Dove Canyon PassMarana AZ 85658View Listing
$2,385,0004316 W Cactus Crest CtMarana AZ 85658View Listing
$1,700,9236862 W Patina Dr Lot 3Marana AZ 85658View Listing
$1,649,00014180 N Los Saguaros DrMarana AZ 85658View Listing
$1,535,99914615 N Silver Ravine Pl Lot 50Marana AZ 85658View Listing
$1,350,0005771 W Silent Wash PlMarana AZ 85658View Listing
$1,330,34612614 N Desert Prospect Dr Lot 17Marana AZ 85658View Listing
$1,303,36114605 N Silver Ravine Pl Lot 49Marana AZ 85658View Listing
$1,300,0006042 W Double Green LnMarana AZ 85658View Listing
$1,220,0006055 W Sonoran Links LnMarana AZ 85658View Listing
$1,150,0006636 W Ironwood PlMarana AZ 85658View Listing
$1,050,00012210 N Carpas Wash DrMarana AZ 85658View Listing
$1,050,0006485 W Triangle Cross WayMarana AZ 85658View Listing
$1,013,64112645 N Sonoran Preserve BlvdMarana AZ 85658View Listing
$1,003,7506957 W Patina Dr Lot 34Marana AZ 85658View Listing
$1,000,0007643 W Sage Palm LnMarana AZ 85658View Listing
$995,1623840 W Sabrina Wash PlMarana AZ 85658View Listing
$992,0843845 W Suizo Wash PlMarana AZ 85658View Listing
$990,00014406 N Wild Burro Canyon PlMarana AZ 85658View 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-06-2024 2:58:01 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
Ranch
Single Family
