SELECT *, CASE WHEN `locality` LIKE "chaffee 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 ("chaffee 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
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.
$315,000Ponderosa Ln Lot 22Buena Vista CO 81211View Listing
$310,0009090 Sheridan Loop Lot 1Salida CO 81201View Listing
$300,00016805 Pine Grove Pkwy Lot 7Buena Vista CO 81211View Listing
$299,00014565 N Stagecoach Ln Lot 14Buena Vista CO 81211View Listing
$299,00013685 Highway 291 Lot 12Salida CO 81201View Listing
$299,00013944 Meadow Ln Lot 21Buena Vista CO 81211View Listing
$299,0009781 Rgp Rd Lot 3Salida CO 81201View Listing
$299,0009783 Rgp Rd Lot 2Salida CO 81201View Listing
$289,00015110 Granite Pkwy Lot 63Salida CO 81201View Listing
$275,0009583 Mint Ln Lot 8Salida CO 81201View Listing
$265,000Lead St Parcel ESalida CO 81201View Listing
$265,00024231 Castaway Ct Lot 28Buena Vista CO 81211View Listing
$265,000217 Tomkins LnBuena Vista CO 81211View Listing
$265,0008106 County Road 250 RdSalida CO 81201View Listing
$265,0009115 Sheridan Loop Lot 11Salida CO 81201View Listing
$265,0009062 Sheridan Loop Lot 15Salida CO 81201View Listing
$265,000Lead St Parcel FSalida CO 81201View Listing
$260,000T B D Highway 285Salida CO 81201View Listing
$255,0009058 Sheridan Loop Lot 16Salida CO 81201View Listing
$255,0009109 Sheridan Loop Lot 12Salida CO 81201View Listing
$250,0007505 County Road 156Salida CO 81201View Listing
$250,000Control Ave Parcel HSalida CO 81201View Listing
$250,000Slag Ave Parcel GSalida CO 81201View Listing
$245,0009054 Sheridan Loop Lot 17Salida CO 81201View 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-18-2024 7:32:02 pm.