SELECT *, CASE WHEN `name` LIKE "baton rouge%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "baton rouge" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "baton rouge" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "baton rouge" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "LA" AND (locality IN ("baton rouge") 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 *, CASE WHEN `name` LIKE "baton rouge%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "baton rouge" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "baton rouge" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "baton rouge" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "LA" AND (locality IN ("baton rouge") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[3] 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,475,00019210 S Lakeway AveBaton Rouge LA 70810View Listing
$1,450,0007208 Adelia LnBaton Rouge LA 70806View Listing
$1,449,50019444 E Lakeway AveBaton Rouge LA 70810View Listing
$1,425,0002113 Woodchase BlvdBaton Rouge LA 70808View Listing
$1,418,8909657 Inniswold Park LnBaton Rouge LA 70809View Listing
$1,395,000241 Granville CtBaton Rouge LA 70810View Listing
$1,360,0007110 Sheffield AveBaton Rouge LA 70806View Listing
$1,299,0002226 Tiger Crossing DrBaton Rouge LA 70810View Listing
$1,295,0008601 Kelly Lynn AveBaton Rouge LA 70809View Listing
$1,279,90019405 S Lakeway AveBaton Rouge LA 70810View Listing
$1,275,0007716 Lanes EndBaton Rouge LA 70810View Listing
$1,228,0007455 Farm Row AveBaton Rouge LA 70810View Listing
$1,200,0003847 Broussard StBaton Rouge LA 70808View Listing
$1,200,0002967 Pointe Marie DrBaton Rouge LA 70820View Listing
$1,200,00011611 Willow Garden LnBaton Rouge LA 70810View Listing
$1,200,00011745 Petit Pierre AveBaton Rouge LA 70810View Listing
$1,199,00011428 Center Court BlvdBaton Rouge LA 70810View Listing
$1,185,00014836 Audubon Lakes DrBaton Rouge LA 70810View Listing
$1,165,0003008 Tradition AveBaton Rouge LA 70810View Listing
$1,155,0003177 McClendon CtBaton Rouge LA 70810View Listing
$1,144,000225 Amherst AveBaton Rouge LA 70808View Listing
$1,100,000707 Adelia LnBaton Rouge LA 70806View Listing
$1,100,0001103 Park BlvdBaton Rouge LA 70806View Listing
$1,100,00018926 Lake Harbour AveBaton Rouge LA 70816View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-17-2024 6:51:03 am.
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