SELECT *, CASE WHEN `locality` LIKE "gunnison county%" AND `slide_location` = "county-agent" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "county-agent" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "CO" AND (locality IN ("gunnison county") OR locality IS NULL) AND slide_location IN ("county-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[3] matching rows / [0.00 msec]
Blog ID 3
Blah
$6,720,00062598 US Highway 50Gunnison CO 81230View Listing
$5,950,000County Road 887Gunnison CO 81230View Listing
$5,000,000644 McCormick Ranch RdCrested Butte CO 81224View Listing
$3,999,00021000 Highway 135Crested Butte CO 81224View Listing
$3,500,0001041 County Road 24UUGunnison CO 81230View Listing
$3,000,000Crest View DrGunnison CO 81230View Listing
$2,895,000Slate River RdCrested Butte CO 81224View Listing
$2,100,000455 Phoenix WayCrested Butte CO 81224View Listing
$2,000,000285 Saddle Ridge Ranch RdCrested Butte CO 81224View Listing
$2,000,00057 Mariposa LnCrested Butte CO 81224View Listing
$1,950,000370 Saddle Ridge Ranch RdCrested Butte CO 81224View Listing
$1,950,000565 Saddle Ridge Ranch RdCrested Butte CO 81224View Listing
$1,900,000W Denver AveGunnison CO 81230View Listing
$1,850,0003125 Aspen Mountain RdCrested Butte CO 81224View Listing
$1,800,0003410 Aspen Mountain RdCrested Butte CO 81224View Listing
$1,750,00011 Kokanee LnCrested Butte CO 81225View Listing
$1,600,000235 Lupine DrCrested Butte CO 81224View Listing
$1,575,0003078 Aspen Mountain RdCrested Butte CO 81224View Listing
$1,500,000107 Bear Scratch LnCrested Butte CO 81225View Listing
$1,498,000376 Wapiti LnCrested Butte CO 81224View Listing
$1,495,000674 Country Club DrCrested Butte CO 81224View Listing
$1,495,000Pristine Point WayCrested Butte CO 81224View Listing
$1,300,000Mm134 Highway 50Gunnison CO 81230View 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-03-2024 8:27:58 pm.