SELECT *, CASE WHEN `locality` LIKE "forest hill%" 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 = "LA" AND (locality IN ("forest hill") 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 40
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "LA" 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 40
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.
$1,795,0009039 Highway 165 SWoodworth LA 71485View Listing
$750,000951 Hidden Ridge DrWoodworth LA 71485View Listing
$499,9002329 Coulee Crossing RdWoodworth LA 71485View Listing
$410,000805 Highway 497Glenmora LA 71433View Listing
$385,0001202 Turkey Creek RdGlenmora LA 71433View Listing
$374,90041 Ed Johnson RdGlenmora LA 71433View Listing
$300,0001200 Highway 456Lecompte LA 71346View Listing
$188,500106 Boundary DrWoodworth LA 71485View Listing
$179,500884 Robinson Bridge RdWoodworth LA 71485View Listing
$120,00012866 Highway 165 SGlenmora LA 71433View Listing
$100,000Spring CrkForest Hill LA 71430View Listing
$98,500Clubhouse Drive Clubhouse Way DrWoodworth LA 71485View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "LA" 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 40
Blah