SELECT *, CASE WHEN `sub_cat` IS NULL AND `cat` = "" AND `locality` = "LEADVILLE" THEN 6 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "LEADVILLE" THEN 5 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL THEN 0 END as `rank` FROM `wp_3_slides` WHERE (locality = "LEADVILLE" OR locality IS NULL) AND (cat IS NULL) ORDER BY `rank` DESC LIMIT 20 [7] matching rows / [0.00 msec] Blog ID 3 Blah


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

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

Ready to start exploring Leadville? EXPLORE NOW