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.
$14,000,00011001 Highland RdBaton Rouge LA 70810View Listing
$7,900,0006088 Moss Side LnBaton Rouge LA 70808View Listing
$6,250,0001100 Knollwood DrBaton Rouge LA 70808View Listing
$4,999,0007666 Bocage BlvdBaton Rouge LA 70809View Listing
$4,490,0004979 Highland RdBaton Rouge LA 70808View Listing
$3,900,00010112 Wood Duck DrBaton Rouge LA 70817View Listing
$3,675,00017835 E Augusta DrBaton Rouge LA 70810View Listing
$3,590,00019411 N Muirfield DrBaton Rouge LA 70810View Listing
$3,195,0002930 Svendson DrBaton Rouge LA 70809View Listing
$3,000,00011048 N Oak Hills PkwyBaton Rouge LA 70810View Listing
$2,995,0003033 Torrance DrBaton Rouge LA 70809View Listing
$2,985,000110 Valhalla BlvdBaton Rouge LA 70810View Listing
$2,900,00019460 S Muirfield CirBaton Rouge LA 70810View Listing
$2,889,0006020 Highland RdBaton Rouge LA 70808View Listing
$2,650,0006204 Province LnBaton Rouge LA 70808View Listing
$2,500,0007121 Lanes EndBaton Rouge LA 70810View Listing
$2,500,000Highland Rd Lot B3Baton Rouge LA 70808View Listing
$2,499,50016056 Highland Bluff CtBaton Rouge LA 70810View Listing
$2,450,0006500 Burden LnBaton Rouge LA 70808View Listing
$2,350,0006752 Fountain LnBaton Rouge LA 70809View Listing
$2,200,000121 Main StBaton Rouge LA 70801View Listing
$2,200,0007845 Highland RdBaton Rouge LA 70808View Listing
$2,000,00011736 Silo DrBaton Rouge LA 70810View Listing
$2,000,000Highland Rd Lot B2Baton Rouge LA 70808View 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-02-2024 7:17:01 pm.
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