California's #1 Hunting, Shooting & Fishing Headquarters Since 1971 0 View Cart CART My Account

 Yeti Rambler 12 Oz Colster Can Insulator Hover to Zoom

yeti coolers

YETI Rambler 12 oz Colster Can Insulator

 Item# 21071500655

rating 1.0rating 2.0rating  3.0rating 4.0rating 5.0 0 Reviews

$19.97 to $25.00

query
RESULTSET
query
  ATTR1ID ATTR2ID CAPACITY NON_INVT OF8 OVERALLQOH PICTURE_ID REALNAME SCALEID SKU_ID SKU_OF7 STYLE STYLE_ID USEPACKAGE WEBSTYLE WEBSTYLE_SORT
1 [empty string] [empty string] White N STK 4 19423 YETI Rambler 12 oz Colster Can Insulator [empty string] 560823 [empty string] 21070090074 1773331 [empty string] 21071500655 1
2 [empty string] [empty string] Stainless Steel N STK 4 19424 YETI Rambler 12 oz Colster Can Insulator [empty string] 560820 [empty string] 21070090060 1773328 [empty string] 21071500655 2
3 [empty string] [empty string] Black N STK 80 19422 YETI Rambler 12 oz Colster Can Insulator [empty string] 560821 [empty string] 21070090063 1773329 [empty string] 21071500655 3
4 [empty string] [empty string] Seafoam N STK 112 19425 YETI Rambler 12 oz Colster Can Insulator [empty string] 560822 [empty string] 21070090062 1773330 [empty string] 21071500655 4
5 [empty string] [empty string] Highlands Olive N DNR 4 23522 YETI Rambler 12 oz Colster Can Insulator [empty string] 599510 [empty string] 21071500693 1812160 [empty string] 21071500655 5
6 [empty string] [empty string] Harvest Red N DNR 74 23521 YETI Rambler 12 oz Colster Can Insulator [empty string] 599500 [empty string] 21071500655 1812150 [empty string] 21071500655 6
7 [empty string] [empty string] Sandstone Pink N DNR 4 24320 YETI Rambler 12 oz Colster Can Insulator [empty string] 610978 [empty string] 21071500918 1823631 [empty string] 21071500655 8
8 [empty string] [empty string] Alpine Yellow N STK 0 26966 YETI Rambler 12 oz Colster Can Insulator [empty string] 842395 [empty string] 21071501039 1840427 [empty string] 21071500655 9
9 [empty string] [empty string] Bimini Pink N STK 74 26982 YETI Rambler 12 oz Colster Can Insulator [empty string] 736604 [empty string] 21071501002 1830771 [empty string] 21071500655 10
10 [empty string] [empty string] Offshore Blue N STK 153 26983 YETI Rambler 12 oz Colster Can Insulator [empty string] 736606 [empty string] 21071500965 1830772 [empty string] 21071500655 11
CACHED false
EXECUTIONTIME 46
SQL SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,90,4) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = '21071500655' AND (upper(f.web_text) = 'YETI COOLERS' or upper(f.orig_text) = 'YETI COOLERS' or upper(a.brand) = 'YETI COOLERS') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id
SQLPARAMETERS
array
1 OBS
2 RS
3 SM
4 DNR
5 DNRFD
6 CSN
7 SPDNR
8 DOA
1


The 12-ounce size is perfect for sparkling water, soft drinks, and good old-fashioned beer, all kept straight-from-the-cooler cold while kicking back on the boat, at camp, or whenever good times are going down. If you know the original, this one's just like it, but with a sleeker design an an updated gasket.


Features:

 

  • 18/8 Stainless Steel - Made with kitchen-grade stainless steel, so they're puncture-and-rust-resistant.
  • Double-Wal Vacuum Insulation - Keeps cold drinks cold and hot drinks hot until the last sip.
  • Dishwasher Safe - Because no one needs more work to do.
  • No Sewat Design - Prevents condensation, keeping hands dry.
 Warning - Cancer and reproductive harm WARNING 
Cancer and Reproductive Harm

 www.P65Warnings.ca.gov

No reviews have been written for this product.
Be the first one!  – Write a Review


We Also Recommend Next Prev

x

We use cookies to improve your browsing experience. By continuing to browse our website you agree to our use of cookies. To learn more about how we use cookies, please review our privacy policy  click here.