SELECT *, CASE WHEN `locality` LIKE "pacific junction%" AND `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "IA" AND (locality IN ("pacific junction") 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
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "IA" 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
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.
$823,00022848/52 CayuseGlenwood IA 51534View Listing
$650,00058668 Iowa RdGlenwood IA 51534View Listing
$550,000Lake Ohana Lot 80Glenwood IA 51534View Listing
$550,00051115 243rd StGlenwood IA 51534View Listing
$540,00060246 Levi RdGlenwood IA 51534View Listing
$506,000Cattail Bnd Lot 92Glenwood IA 51534View Listing
$499,50022945 Cimarron DrGlenwood IA 51534View Listing
$491,00022966 Cat Tail Bend StGlenwood IA 51534View Listing
$419,50050912 240th StGlenwood IA 51534View Listing
$360,00056302 220th StGlenwood IA 51534View Listing
$349,00051436 Ashton RdGlenwood IA 51534View Listing
$310,00021598 Jinkins AvePacific Junction IA 51561View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "IA" 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
Blah
Commercial
Land
Ranch
Single Family
