SELECT *, CASE WHEN `name` LIKE "grants pass%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "grants pass" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "grants pass" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "grants pass" 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 = "OR" AND (locality IN ("grants pass") 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 56
Blah
SELECT *, CASE WHEN `name` LIKE "grants pass%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "grants pass" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "grants pass" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "grants pass" 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 = "OR" AND (locality IN ("grants pass") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[1] matching rows / [0.00 msec]
Blog ID 56
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.
$2,275,0001212 Greentree LoopGrants Pass OR 97527View Listing
$2,200,0001489 Granite Hill RdGrants Pass OR 97526View Listing
$1,900,0006155 Tunnel Loop RdGrants Pass OR 97526View Listing
$1,800,0004124 Lower River RdGrants Pass OR 97526View Listing
$1,800,0006550 Donaldson Rd Unit R302661Grants Pass OR 97526View Listing
$1,700,00012201 Williams HwyGrants Pass OR 97527View Listing
$1,500,000980 Kubli RdGrants Pass OR 97527View Listing
$1,399,000505 Tower Heights DrGrants Pass OR 97527View Listing
$1,295,000700 Seclusion LoopGrants Pass OR 97526View Listing
$1,295,0001340 SE Priscilla LnGrants Pass OR 97526View Listing
$1,250,000700 Missouri Flat RdGrants Pass OR 97527View Listing
$1,200,0004995 Fish Hatchery RdGrants Pass OR 97527View Listing
$1,195,000501 SE M StGrants Pass OR 97526View Listing
$1,190,000200 Curtis DrGrants Pass OR 97527View Listing
$1,188,000313 and 235 Eagle Ridge DrGrants Pass OR 97526View Listing
$1,150,000376 Hixson DrGrants Pass OR 97526View Listing
$1,100,000764 NW 4th StGrants Pass OR 97526View Listing
$1,100,000940 Palomino DrGrants Pass OR 97526View Listing
$1,100,000250 Skyline DrGrants Pass OR 97527View Listing
$1,095,000580 Opal LnGrants Pass OR 97526View Listing
$1,095,0001261 NW Cooke AveGrants Pass OR 97526View Listing
$1,095,0001219 W Jones Creek RdGrants Pass OR 97526View Listing
$1,000,000377 Wolf Song DrGrants Pass OR 97526View Listing
$999,9003320 Upper River RdGrants Pass OR 97526View 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-04-2024 5:07:59 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "OR" 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 56
Blah