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

 Yeti Rambler 20 Oz Travel Mug With Stronghold Lid Hover to Zoom

yeti coolers

YETI Rambler 20 oz Travel Mug With Stronghold Lid

 Item# 21071500946

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

$29.97 to $38.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] Seafoam N STK 2 26074 YETI Rambler 20 oz Travel Mug With Stronghold Lid [empty string] 609622 [empty string] 21070060048 1822274 [empty string] 21071500946 1
2 [empty string] [empty string] Offshore Blue N STK 2 26825 YETI Rambler 20 oz Travel Mug With Stronghold Lid [empty string] 736634 [empty string] 21071500969 1830778 [empty string] 21071500946 5
3 [empty string] [empty string] Navy N STK 1 26981 YETI Rambler 20 oz Travel Mug With Stronghold Lid [empty string] 609621 [empty string] 21070060047 1822273 [empty string] 21071500946 6
CACHED false
EXECUTIONTIME 47
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 = '21071500946' 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
2

This double-duty, on-the-go drink handler is topped with the Rambler® Stronghold™ Lid—a leak-resistant, twist-on upgrade that’s backed with dual-slider magnet technology. This lid easily rotates to fasten for both right-and left-handed users, adding a strong layer between your free-flowing drink and the outside world. And if we’re talkin’ about where to take it, its elevated handle lets you enjoy cupholder convenience just about anywhere.


Features:

 

  • 18/8 Stainless Steel - Made with kitchen-grade stainless steel, so they're puncture-and-rust-resistant.
  • Double-Wall Vacuum Insulation - Keeps hot drinks hot and cold drinks cold.
  • Dishwasher Safe - Because no one needs more work to do.
  • Leak-Resistant Lid - Twist-on, twist-off lid backed with dual-slider magnet technology to keep your coffee full and worries away. (As long as it's closed.)


Please Note: The Stronghold™ Lid is specially made for the Rambler® 20 oz. Travel Mug and won’t fit other Rambler® Drinkware models. The Travel Mug Stronghold™ Lid has 4 placement options and plays nice with both righties and lefties, just like all other Rambler® Drinkware.

 

CAUTION: Not for use with carbonated beverages and should not be used as storage for food or perishables.

 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


3 Styles Available

YETI Rambler 20 oz Travel Mug With Stronghold Lid Seafoam Seafoam $38.00
YETI Rambler 20 oz Travel Mug With Stronghold Lid Offshore Blue Offshore Blue $38.00
YETI Rambler 20 oz Travel Mug With Stronghold Lid Navy Navy $38.00

arrow to add to cart button
Add to Wish List

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.