SELECT *, CASE WHEN `locality` LIKE "caneyville%" 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 = "KY" AND (locality IN ("caneyville") 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 19
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "KY" 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 19
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.
$329,9001867 Tickridge RdFalls Of Rough KY 40119View Listing
$299,900478 Bentwood LnFalls Of Rough KY 40119View Listing
$289,000Highway 110Falls Of Rough KY 40119View Listing
$269,900369 Old Fat Bruce RdFalls Of Rough KY 40119View Listing
$194,900Coon Hollow RdCaneyville KY 42721View Listing
$129,90010990 Beaver Dam RdCaneyville KY 42721View Listing
$120,000N Lonnie Ln Lots 21 & 22Millwood KY 42762View Listing
$120,0002161 Morgantown RdCaneyville KY 42721View Listing
$97,0001193 Patriots Landing Ln Lots 35B & 35CFalls Of Rough KY 40119View Listing
$95,00066 Patriots Landing Ln Lot 66Falls Of Rough KY 40119View Listing
$89,0005692 Beaver Dam Rd Lot 4Millwood KY 42754View Listing
$69,777350 Bentwood Heritage Farm Ln Lot 13Falls Of Rough KY 40119View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "KY" 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 19
Blah