Stealth Safes Handgun Hanger Biometric Safe
|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 = 'STL-HH-SAFE-BIO' AND (upper(f.web_text) = 'STEALTH SAFES' or upper(f.orig_text) = 'STEALTH SAFES' or upper(a.brand) = 'STEALTH SAFES') 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|
- 3-Way Access System: This safe comes with a 3-Way Access System - Biometric Fingerprint Scanner, Push Button Electronic Keypad & Back-Up Laser Cut Override Key.
- Quick Access: This Quick Access Biometric Handgun Safe gives the owner immediate access to the interior of the safe. Spring loaded, the door quickly drops right after the correct combination is entered. The heavy door is supported with a speed reducer to catch the door for a soft open.
- Solid Steel Construction: The body of this safe is made of 16 Gauge Solid Steel with a ?" Thick 2-Piece Solid Steel Door. With its construction, this safe offers extreme pry resistance.
- Interior Gun Rack: Three Gun Rods come included in the interior of this safe. These rods are coated in a Heat Shrink Tubing to protect the inside barrel of your three favorite firearms from getting scratched.
- Interior Red Light: An Interior Red Light activates when the correct combination is entered and safe door opens, allowing you to easily see inside your safe during the day or night.
- Power Port: The Safe comes with a Power Port & Cable adding Power to the safe. An included security cable allows you to secure down the safe to a fixed object. The entire interior of the safe is lined with foam to protect your handguns or other valuables.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$7.99 to $29.99