SELECT *, CASE WHEN `name` LIKE "COLORADO SPRINGS%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "COLORADO SPRINGS" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "COLORADO SPRINGS" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "COLORADO SPRINGS" 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_3_slides` WHERE (locality IN ("COLORADO SPRINGS") OR locality IS NULL) AND (cat IS NULL) AND active = 1 ORDER BY `rank` DESC LIMIT 20 [7] matching rows / [0.00 msec] Blog ID 3 Blah

Colorado Springs

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

Easily navigate to the best places to visit in Colorado Springs. Explore the top family fun activities via breathtaking pictures and videos from your desktop. Check out the latest events in Colorado Springs from your mobile device. Plan weekend trips with a few clicks or screen taps.

Ready to start exploring Colorado Springs? EXPLORE NOW