SELECT *, CASE WHEN `locality` LIKE "archuleta 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 ("archuleta county") OR locality IS NULL) AND slide_location IN ("county-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[4] matching rows / [0.00 msec]
Blog ID 3
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$250,00063 W McCabe StPagosa Springs CO 81147View Listing
$249,950177 Glade DrPagosa Springs CO 81147View Listing
$249,00090 Incline CirPagosa Springs CO 81147View Listing
$245,0001944 Antelope AvePagosa Springs CO 81147View Listing
$239,9001180 Beucler LnPagosa Springs CO 81147View Listing
$235,9791208 S RockcliffPagosa Springs CO 81147View Listing
$221,0001279 Harvard AvePagosa Springs CO 81147View Listing
$215,0002308 Bull Elk PlPagosa Springs CO 81147View Listing
$210,0002922 Bull Elk PlPagosa Springs CO 81147View Listing
$210,0003292 Bull Elk PlPagosa Springs CO 81147View Listing
$200,000806 and 824 Circle DrPagosa Springs CO 81147View Listing
$199,9001260 Crooked RdPagosa Springs CO 81147View Listing
$199,0002612 Bull Elk PlPagosa Springs CO 81147View Listing
$195,000294 Bristlecone DrPagosa Springs CO 81147View Listing
$195,00027 D PlPagosa Springs CO 81147View Listing
$195,000106 Georges CtPagosa Springs CO 81147View Listing
$190,000219 Casey CtPagosa Springs CO 81147View Listing
$185,00087 Ute LnPagosa Springs CO 81147View Listing
$180,000919 Roush DrPagosa Springs CO 81147View Listing
$175,0001153 Scenic AvePagosa Springs CO 81147View Listing
$175,000139 Coronado CirPagosa Springs CO 81147View Listing
$175,000718 Estates CirPagosa Springs CO 81147View Listing
$175,000283 Crestview DrPagosa Springs CO 81147View Listing
$175,000427 Carino PlPagosa Springs CO 81147View 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-17-2024 6:24:22 am.