SELECT *, CASE WHEN `name` LIKE "terrebonne%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "terrebonne" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "terrebonne" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "terrebonne" 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 ("terrebonne") 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.
$3,700,0003887 NE Smith Rock WayTerrebonne OR 97760View Listing
$2,225,00011560 NE Canyons Ranch DrTerrebonne OR 97760View Listing
$1,999,00010801 NW 43rd StTerrebonne OR 97760View Listing
$1,300,00070955 NW Lower Bridge WayTerrebonne OR 97760View Listing
$1,100,0009461 NE Smith Rock LoopTerrebonne OR 97760View Listing
$899,50013714 SW Chipmunk RdTerrebonne OR 97760View Listing
$849,9992487 NW Odem AveTerrebonne OR 97760View Listing
$775,0009727 SW Shad RdTerrebonne OR 97760View Listing
$749,9004975 SW Antelope DrTerrebonne OR 97760View Listing
$749,00014295 SW Peninsula DrTerrebonne OR 97760View Listing
$719,000282 Foss DrTerrebonne OR 97760View Listing
$699,9997702 NW 19th StTerrebonne OR 97760View Listing
$695,0005880 N Highway 97Terrebonne OR 97760View Listing
$675,0009010 13th StTerrebonne OR 97760View 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 11:11:53 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