SELECT *, CASE WHEN `name` LIKE "prineville%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "prineville" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "prineville" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "prineville" 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 ("prineville") 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 *, "0" as `rank` FROM `wp_slides` WHERE st = "OR" 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 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,250,0007337 NW Ryegrass RdPrineville OR 97754View Listing
$1,899,0002250 S Main StPrineville OR 97754View Listing
$1,730,00012750 SE Carey LnPrineville OR 97754View Listing
$1,698,00015850 NE Allen Creek RdPrineville OR 97754View Listing
$1,490,0009395 SE Paulina HwyPrineville OR 97754View Listing
$1,295,0004200 NW Grimes RdPrineville OR 97754View Listing
$1,100,00018439 SE Boulder LnPrineville OR 97754View Listing
$949,90010906 SE View Top LnPrineville OR 97754View Listing
$945,0007680 SE Madison AvePrineville OR 97754View Listing
$945,00013021 SE Sierra WayPrineville OR 97754View Listing
$925,00011828 NW Madras HwyPrineville OR 97754View Listing
$899,000750 NE Wyoming DrPrineville OR 97754View Listing
$895,00010449 SE Ridge View RdPrineville OR 97754View Listing
$879,0002675 NW Century DrPrineville OR 97754View Listing
$849,900SE Texas Cir Lot 37Prineville OR 97754View Listing
$839,9956162 NE Timber LnPrineville OR 97754View Listing
$799,90013881 NW Grizzly Mountain RdPrineville OR 97754View Listing
$790,0006811 SE Riverdance RdPrineville OR 97754View Listing
$779,9007060 SE Madison AvePrineville OR 97754View Listing
$775,0007208 NE Ochoco HwyPrineville OR 97754View Listing
$769,0001492 SE Texas CirPrineville OR 97754View Listing
$750,0007353 NW Lucas LnPrineville OR 97754View Listing
$743,000714 NW Reata RdPrineville OR 97754View Listing
$725,00012003 NW Madras HwyPrineville OR 97754View 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-08-2024 3:42:19 am.
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