SELECT *, CASE WHEN `locality` LIKE "abita springs%" 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 ("abita springs") 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.
$4,500,000189 E Highway 22Madisonville LA 70447View Listing
$3,999,500131 Northlake DrMandeville LA 70448View Listing
$2,999,99917409 Blackwell RdCovington LA 70435View Listing
$2,950,000120 Tranquility DrMandeville LA 70471View Listing
$2,900,0001950 Highway 1088 Other Lot 6Mandeville LA 70448View Listing
$2,750,00083510 Highway 437Covington LA 70435View Listing
$2,500,00016407 Summerhill RdCovington LA 70435View Listing
$2,350,00011 Lake Forest Dr Lot 1Covington LA 70433View Listing
$2,250,00097 E Thistle StMandeville LA 70471View Listing
$2,200,000828 Bonfouca LnMandeville LA 70471View Listing
$2,195,00015402 S Milloit LnCovington LA 70433View Listing
$2,195,00098 Cardinal LnMandeville LA 70471View 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
Commercial
Land
Ranch
Single Family
