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

 Sticky Holster Size Sm- 2 Small .380 Semi Autos Hover to Zoom

sticky holsters

Sticky Holster Size SM-2 Small .380 Semi Autos

 Item# SM-2

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

$29.99

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
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) ) 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 = 'SM-2' AND (upper(f.web_text) = 'STICKY HOLSTERS' or upper(f.orig_text) = 'STICKY HOLSTERS' or upper(a.brand) = 'STICKY HOLSTERS') 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
1


Suitable for Pocket 380's up to 2.5" barrel without lasers. Ambidextrous fit for right and left handed users.
Sticky Holsters allow you to deploy and adjust your firearm in seconds. No bulky clips or straps to get in the way. Our lightweight holsters weigh less than 3 oz. and the closed-end design keeps lint and dust out, while keeping gun oil off of you. Body heat and use conforms holster to your gun, so your holster fit will continue to improve with use.
Fits:
 

 Model / Name  Caliber  Barrel
 Diamondback DB9  9MM  3"
 Kel-Tec P32  32ACP  2.7"
 Kel-Tec P3AT  380ACP

 2.7"

 North American Arms Guardian  All  2.5" 
 Rohrbaugh R9  9MM  2.9"
 Rohrbaugh 380  380ACP  2.9"
 Ruger LCP  380ACP  2.75"
 Taurus 738  380ACP  2.84"
 I.O. Inc Hellcat 380  380ACP  2.75"
 Taurus 22   22LR  2.75"
 Taurus 25  25ACP  2.75"
 Taurus 738 TCP  380ACP  2.84"
 Jimenez J.A. 380  380ACP  2.75"
 Jimenez J.A. 25  25ACP  2.5"
 Jimenez J.A. 22  22LR  2.5"
 S&W Bodyguard  380ACP  2.75"
 Colt Pony  380ACP  2.75"
 Colt Mustang  380ACP  2.67"
 Sig Sauer P238  380ACP  2.75"
 Kahr P380  380ACP  2.5"

 

 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.