SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "CO" AND (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 3
Blah
$480,000719 Main StreetCanon City CO 81212View Listing
$465,000700 Macon AvenueCanon City CO 81212View Listing
$464,9001208 S 9th StreetCanon City CO 81212View Listing
$463,000116 W Main StreetFlorence CO 81226View Listing
$425,000621-623 Main StreetCanon City CO 81212View Listing
$408,0002285 Fremont DriveCanon City CO 81212View Listing
$400,0001717 E Main StreetCanon City CO 81212View Listing
$399,999605 3rd StreetPenrose CO 81240View 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 .