SELECT *, CASE WHEN `name` LIKE "island park%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "island park" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "island park" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "island park" 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 = "ID" AND (locality IN ("island park") 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 49
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "ID" 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 49
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.
$12,000,0005218 N Highway 20Island Park ID 83429View Listing
$9,500,0002780 Icehouse Creek RdIsland Park ID 83429View Listing
$4,970,0003884 Bills Loop Rd NIsland Park ID 83429View Listing
$2,200,0003832 Jefferson DrIsland Park ID 83429View Listing
$1,975,0003795 Taylor DrIsland Park ID 83429View Listing
$1,975,0003795 Taylor Mountain DrIsland Park ID 83429View Listing
$1,950,0003774 Century DrIsland Park ID 83429View Listing
$1,550,0003425 KestrelIsland Park ID 83429View Listing
$1,550,0003425 KestrelIsland Park ID 83429View Listing
$1,500,0004426 Deer Crest DrIsland Park ID 83429View Listing
$1,500,0003807 Vista CtIsland Park ID 83429View Listing
$1,500,0004509 Jm LoopIsland Park ID 83429View Listing
$1,465,0002825 Morning Dew DrIsland Park ID 83429View Listing
$1,450,0003783 Century DrIsland Park ID 83429View Listing
$1,400,0003784 Reas CtIsland Park ID 83429View Listing
$1,399,0003755 Cove RdIsland Park ID 83420View Listing
$1,375,0005085 TrumpeterIsland Park ID 83429View Listing
$1,350,0003424 Mallard DrIsland Park ID 83429View Listing
$1,300,0004238 Grandview RdIsland Park ID 83429View Listing
$1,250,0003519 Yale Kilgore RdIsland Park ID 83429View Listing
$1,250,0003621 Island DrIsland Park ID 83429View Listing
$1,250,0003716 Snake River RdIsland Park ID 83429View Listing
$1,250,0003773 Bills Loop Rd NIsland Park ID 83429View Listing
$1,125,0003505 Joseph DrIsland Park ID 83429View 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-07-2024 4:30:08 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "ID" 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 49
Blah