Gun Storage Solutions Rifle Rod Starter Kit 10pk
|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 = 'RR10SK-OR' AND (upper(f.web_text) = 'GUN STORAGE SOLUTIONS' or upper(f.orig_text) = 'GUN STORAGE SOLUTIONS' or upper(a.brand) = 'GUN STORAGE SOLUTIONS') 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|
Condense and organize long guns into a smaller space and access them easier than ever with Rifle Rods. Rifle Rods are a patented hook and loop based system that individually stabilizes each long gun in the upright position (leaning, as required in standard gun racks, wastes valuable storage space).
This system allows you to stack your long guns as many as four rows deep, freeing up as much as 50% additional space in your safe. The included Shelf Liner works in gun safes, closets, cabinets, or anywhere there is a shelf. The Rifle Rods measure 16” and will fit calibers as small as .22. Injection molded plastic Rifle Rods will not damage your barrel, and they work equally well for scoped rifles, shotguns or modern sporting rifles. Don't buy another safe, retrofit your gun safe today!
Rifle Rods Kit Includes:
- Fits as small as 22 caliber (Smaller caliber Rifle Rods available: 17 Caliber - 2 Pack)
- Total length - 16"
- Injection molded plastic product
- Ultra-sonically welded "hook fabric" coin on top
- Industrial grade 100% nylon woven "loop fabric" - will not fray over time.
- Required for best use with Rifle Rods.
- For proper application, attach to wooden shelf with a staple gun
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review