SELECT *, CASE WHEN `name` LIKE "EAU CLAIRE%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "EAU CLAIRE" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "EAU CLAIRE" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "EAU CLAIRE" 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_33_slides` WHERE (locality IN ("EAU CLAIRE") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND active = 1 ORDER BY `rank` DESC LIMIT 12 [6] matching rows / [0.00 msec] Blog ID 33 Blah

Eau Claire

The best things to do in Eau Claire, top professionals, and exclusive Eau Claire real estate for sale.

Easily navigate to the best places to visit in Eau Claire. Explore the city via breathtaking pictures and videos from your desktop. Check out the latest events in Eau Claire from your mobile device. Plan weekend trips with a few clicks or screen taps.

Ready to start exploring Eau Claire? EXPLORE NOW

[instagram-feed num=9 cols=3 colsmobile=3 showheader=false showfollow=true type=user user=exploreus.wi]