Browning Hawg 49 Gun Safe E-Lock
|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 = 'HAWG49E' AND (upper(f.web_text) = 'BROWNING' or upper(f.orig_text) = 'BROWNING' or upper(a.brand) = 'BROWNING') 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|
What is so great about the Hawg?
Getting the Hawg gives you a safe designed to handle everything you throw at it and provide ferocious protection against theft and fire, with storage for both long guns, handguns and copious amounts of irreplaceable valuables. The intelligent dimensions of the Hawg maximize storage capacity while keeping it short enough to fit in a tight space as well as preventing it from projecting too far into a room that already has its "feng shui" figured out.
Fire Rating: 60 Minute/1400°
Security: 12 Gauge
Capacity: 49 Total (26/39+10)
Gun Capacity: 49 total (26/39+10)
Body Thickness: 12 Gauge
Bolts: 8 (5 Active)
Cubic Feet: 33
Fire Rating: 60 Minute / 1400°Overall
Weight: 630 lbs 0 oz
Handle: Type 3-spoke
Door Type: 1" Formed
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review