Stack-On 8 Gun Security Cabinet Black
|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 = 'GCB-908' AND (upper(f.web_text) = 'STACK ON' or upper(f.orig_text) = 'STACK ON' or upper(a.brand) = 'STACK ON') 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|
Holds 8 Rifles or Shotguns up to 54" Tall. Available in Black Gloss Paint Finish.
California DOJ-approved firearms safety device. Approved by the California Department of Justice as meeting their standards for firearm safety. 3-point locking system with double-bitted, key coded lock provides greater security.
Adjustable shelves are included. Cabinet holds 8 rifles or shotguns up to 54" tall. A removable shelf is included. Shelf is positioned in the back of the cabinets so longer guns can be stored in the front along the side walls. (There is a gap between the back of the shelf and the back wall of the cabinet). Foam padded bottom and barrel rests reduce scratches.
Exterior Dimensions: 21" W (53.3cm), 10" D (25.7cm), 55" H (140cm)
Shipping Weight: 69.80 lbs.
Interior Capacity: 8 guns plus removable shelf
Number of Shelves: 1
Locking Points: 3
Master Carton Dimensions: 21-1/2" W, 10-3/4" D, 57-5/8" H
Color: Black gloss paint finish with chrome accents
Notes: Not recommended for storing CD's or other electronic storage devices. Fastening hardware is included with each safe.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review