SELECT *, CASE WHEN `locality` LIKE "larimer 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 ("larimer 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.
$5,326,000County Road 60Fort Collins CO 80524View Listing
$4,850,0003733 E Harmony RdFort Collins CO 80528View Listing
$4,600,000Emmaus LnFort Collins CO 80524View Listing
$3,700,000Boyd Lake RdLoveland CO 80538View Listing
$3,500,000201 E Harmony RdFort Collins CO 80525View Listing
$3,052,2498760 Bonfire DrWellington CO 80549View Listing
$3,000,0003309 Fox Crossing Pl Lots 814151617Loveland CO 80537View Listing
$2,580,000Tract P Windsor VlgsFort Collins CO 80528View Listing
$2,389,7018752 Bonfire DrWellington CO 80549View Listing
$1,950,000Centennial DrFort Collins CO 80526View Listing
$1,900,0003530 Garfeild AveWellington CO 80549View Listing
$1,729,415W Eisenhower BlvdLoveland CO 80538View Listing
$1,400,000Highway 402Loveland CO 80537View Listing
$1,300,0003420 N Garfield AveLoveland CO 80538View Listing
$1,227,9743955 Peralta DrLoveland CO 80538View Listing
$1,152,5973935 Peralta DrLoveland CO 80538View Listing
$1,100,0001800 Cascade AveLoveland CO 80538View Listing
$1,000,000Washington AveWellington CO 80549View Listing
$958,3203950 Peralta DrLoveland CO 80538View Listing
$925,000120 Triangle DrFort Collins CO 80525View Listing
$775,0005224 E Highway 14Fort Collins CO 80524View Listing
$683,8926345 Rockwell CtLoveland CO 80538View Listing
$670,000395 Wood StFort Collins CO 80524View Listing
$670,0001800 Vista Shores CtFort Collins CO 80524View 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-08-2024 8:51:12 am.