Banner1 Banner1
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_36` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('504')) AND `pinfo`.`status` IN ('active','discontinued') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%Safes' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Safes' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Safes' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Safes"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Safes"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Safes"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Safes"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Safes' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Safes',`category_4` ='Safes') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Safes,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Safes', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Safes

Refine Search

  GO
 
Brand

Sentry Safe(20)

SureSeal By FireKing(4)

FireKing(3)

 
Color(s)

Black(17)

Taupe(4)

Gunmetal Gray(2)

Charcoal Gray(2)

Silver(1)

Gunmetal/Black(1)

 
Manufacturer Part Number

SFW123CSB(1)

SFW123ES(1)

SFW123BSC(1)

SFW082FTC(1)

SFW082CTB(1)

SFW205BPC(1)

SFW205CWB(1)

X041E(1)

X105(1)

X014E(1)

UC025K(1)

SFW205EVB(1)

HD2100(1)

FHW40100(1)

SS103(1)

SS104(1)

SS102(1)

SB2414BLEL(1)

SB2014BLEL(1)

SS106(1)

1200(1)

EF3428E(1)

EF4738E(1)

DH-109E(1)

DH-074E(1)

CFW20201(1)

HS1207(1)

 
Country of Origin

CN(15)

MX(12)

 
Material(s)

Steel(19)

Plastic(5)

Cement/Captured Fire Insulation(3)

 
Capacity (text)

0.8 cu. ft.(2)

2 cu ft(2)

1.23 cu. ft.(2)

1.23 cu ft(1)

0.37 cu ft.(1)

0.66 cu. ft.(1)

2 cu. ft.(1)

1.0 cu. ft.(1)

0.41 cu. ft.(1)

0.14 cu. ft.(1)

0.23 cu ft(1)

4.71 cu ft(1)

3.4 cu ft(1)

0.27 cu. ft.(1)

0.15 cu. ft.(1)

2.722 cu. ft.(1)

0.95 cu. ft.(1)

0.38 cu. ft.(1)

0.60 cu. ft.(1)

1.3 cu. ft.(1)

0.94 cu. ft.(1)

0.28 cu. ft.(1)

0.18 cu ft.(1)

0.3 cu. ft.(1)

 
Inner Height

19 3/5"(2)

9 3/5"(2)

6 1/2"(2)

7 1/2"(2)

5 3/10"(1)

11 5/8"(1)

13 4/5"(1)

13 8/10"(1)

8 11/16"(1)

19 5/8"(1)

35 7/10"(1)

13 7/8"(1)

25 3/4"(1)

3 9/10"(1)

4 1/2"(1)

10.83"(1)

12"(1)

3 4/5"(1)

10 1/10"(1)

10 1/2"(1)

4 2/5"(1)

3.5"(1)

14 1/2"(1)

 
Inner Width

12"(4)

12 3/5"(3)

14 4/5"(3)

12 5/8"(2)

13 1/10"(2)

13 7/10"(2)

14 7/8"(1)

8 9/10"(1)

16 3/4"(1)

11 3/10"(1)

5 4/5"(1)

19 3/8"(1)

23.7"(1)

9 6/10"(1)

12 1/5"(1)

12 4/5"(1)

19 2/5"(1)

 
Inner Depth

11 9/10"(5)

12"(3)

11 3/10"(2)

11 1/2"(2)

8 2/5"(2)

8 1/2"(2)

11 5/8"(1)

6 1/2"(1)

9 1/5"(1)

10 1/2"(1)

11 3/4"(1)

6"(1)

13.4"(1)

7.5"(1)

5 3/4"(1)

11 7/10"(1)

8 1/8"(1)

 
Outer Depth

19 3/10"(5)

19 3/8"(3)

19"(2)

15 3/5"(2)

15 1/2"(1)

13.4"(1)

12 3/10"(1)

6 3/5"(1)

14 9/16"(1)

10 2/5"(1)

14 2/5"(1)

13 7/8"(1)

12 1/2"(1)

17"(1)

11 1/5"(1)

14 3/10"(1)

9 4/5"(1)

7 3/4"(1)

12 2/5"(1)

 
Outer Height

17 7/8"(2)

23 4/5"(2)

6 3/5"(2)

7 3/10"(2)

20"(2)

13 7/10"(1)

17 4/5"(1)

8 1/2"(1)

8 7/8"(1)

7 3/5"(1)

13 7/10""(1)

23 7/8"(1)

37 7/10"(1)

13"(1)

6 1/2"(1)

10.83"(1)

6 1/10"(1)

24"(1)

14 1/8"(1)

7 3/4"(1)

27 3/4"(1)

7 4/5"(1)

 
Outer Width

16 3/10"(3)

14"(3)

16 3/8"(2)

18 3/5"(2)

15 1/2"(1)

18 2/3"(1)

6"(1)

16 15/16"(1)

11 2/5"(1)

9"(1)

16 5/8"(1)

21 7/10"(1)

15 9/10"(1)

12 1/5"(1)

24"(1)

19 9/10"(1)

16"(1)

21 3/4"(1)

15 2/5"(1)

14 3/10"(1)

12 1/4"(1)

 
Lock Type

Key(6)

Electronic Keypad(5)

Electronic(3)

Combination(2)

Biometric Fingerprint; Electronic Keypad; Key(2)

Programmable Electronic lock with time delay(2)

Tubular Key(2)

Dual-key(1)

Electronic with override key(1)

Programmable Electronic (w/Override Key)(1)

Digital Keypad(1)

Dual Mechanical Combination Lock(1)

 
Fire Rating

UL-1 Hour/1700F Fire Rating(5)

UL-1 Hour/1700F Fire Rating; ETL Verified 1 Hour/1700 Fire Rating for digital media devices(3)

UL Classified 1/2 Hour/1550 F(2)

UL Class 350 30-Minute Fire(2)

UL Class 350 30-Minute Fire Rating(1)

UL-1 Hour/1700F Fire Rating; ETL Verified 1 Hour/1700 Fire Rating for Digital Media Devices(1)

UL Classified hour of Fire Protection at 1550F(1)

ETL Verified 1/2 Hour/1400F(1)

UL Class 350 1-Hour Fire(1)

ETL verified 1/2 hour/1550F Fire Rating(1)

 
 
 

© 2019-2020 Gateway Business Products, All Rights Reserved