SELECT *, CASE WHEN `locality` LIKE "clarkson%" 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 ("clarkson") 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.
$574,900276 Moutardier Woods RdLeitchfield KY 42754View Listing
$541,000Levita Township RdClarkson KY 42726View Listing
$529,000118 John LnLeitchfield KY 42754View Listing
$499,9001703 Hardin Springs RdBig Clifty KY 42712View Listing
$489,00027 Pine TrlLeitchfield KY 42754View Listing
$479,00048 Wilderness Ridge DrClarkson KY 42726View Listing
$460,000339 Oakmont BlvdLeitchfield KY 42754View Listing
$450,000325 Lake Front RdLeitchfield KY 42754View Listing
$439,000181 Clees Point RdLeitchfield KY 42754View Listing
$434,0002149 Shrewsbury RdLeitchfield KY 42754View Listing
$397,500409 Mill StLeitchfield KY 42754View Listing
$389,000150 Lookout Ridge DrLeitchfield KY 42754View 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