SELECT *, CASE WHEN `locality` LIKE "las animas 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 ("las animas 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
$199,00023478 Highway 12Trinidad CO 81082View Listing
$190,00032200 Vista VwAguilar CO 81020View Listing
$190,00032200 Vista View RdAguilar CO 81020View Listing
$190,000Tract 27 No Site AddressAguilar CO 81020View Listing
$175,00013490 Big Pine Ridge RdWeston CO 81091View Listing
$165,00034444 Tin Cup CtTrinidad CO 81082View Listing
$150,00023519 Highway 12Trinidad CO 81082View Listing
$150,000Tbd Highway 12Trinidad CO 81082View Listing
$120,00014341 Northridge Rd Lot 6Weston CO 81091View 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-04-2024 3:51:24 am.