SELECT *, CASE WHEN `locality` LIKE "nances creek%" 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 = "AL" AND (locality IN ("nances creek") 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 24
Blah
SELECT *, CASE WHEN `locality` LIKE "nances creek%" AND `slide_location` = "city-agent" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "city-agent" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "AL" AND (locality IN ("nances creek") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[2] matching rows / [0.00 msec]
Blog ID 24
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,150,000Jd&L DriveJacksonville AL 36265View Listing
$1,395,0001021 Jd&L DriveJacksonville AL 36265View Listing
$479,0001051 Jd&L DriveJacksonville AL 36265View Listing
$449,900112 CLINTON STREETJACKSONVILLE AL 36265View Listing
$440,000505 HIGHWAY 278PIEDMONT AL 36272View Listing
$349,9000 HIGHWAY 21JACKSONVILLE AL 36265View Listing
$299,900201 MEMORIAL DRIVEPIEDMONT AL 36272View Listing
$279,0001001 Jd&L DriveJacksonville AL 36265View Listing
$259,9000 E LITTLEJOHN ROADJACKSONVILLE AL 36265View Listing
$199,9000 NEW LIBERTY ROADJACKSONVILLE AL 36265View Listing
$189,000355 EMILYS CIRCLEJACKSONVILLE AL 36265View Listing
$179,9008786 COUNTY ROAD 19PIEDMONT AL 36272View Listing
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "AL" 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 24
Blah
Commercial
Land
Ranch