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_1` 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 ('112035')) 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 '%MetalLateralFiles' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('MetalLateralFiles' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+MetalLateralFiles' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"MetalLateralFiles"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"MetalLateralFiles"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"MetalLateralFiles"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"MetalLateralFiles"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+MetalLateralFiles' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='MetalLateralFiles',`category_4` ='MetalLateralFiles') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'MetalLateralFiles,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('MetalLateralFiles', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Metal Lateral Files

Refine Search

  GO
 
Brand

HON(139)

Lorell(24)

Basyx by HON(6)

 
Color

Light Gray(50)

Putty(49)

Black(35)

Charcoal(35)

 
Recycled

Yes(163)

No(6)

 
Packaged Quantity

1 Each(169)

 
Assembly Required

No(166)

Yes(3)

 
Limited Warranty

Lifetime(163)

5 Year(6)

 
Weight (Approximate)

169 lb(8)

182 lb(8)

190 lb(6)

132 lb(5)

196 lb(5)

240 lb(5)

209 lb(5)

247 lb(5)

214 lb(5)

230 lb(4)

120 lb(4)

163 lb(4)

179 lb(4)

211 lb(4)

158 lb(3)

336 lb(3)

274 lb(3)

264 lb(3)

176 lb(3)

178 lb(3)

129 lb(3)

165 lb(3)

144 lb(3)

206 lb(3)

143 lb(3)

236 lb(2)

267 lb(2)

177 lb(2)

128 lb(2)

148 lb(2)

90 lb(2)

145 lb(2)

106 lb(1)

307 lb(1)

110 lb(1)

160 lb(1)

140 lb(1)

162 lb(1)

97 lb(1)

212 lb(1)

 
Drawer Type

File(149)

 
Total Number of Drawers

2(57)

4(43)

5(32)

3(26)

 
Media Size Supported

Letter(165)

Legal(162)

A4(154)

 
Total Number of Shelves

2(29)

6(8)

3(5)

1(4)

5(3)

 
Number of Adjustable Shelves

2(14)

 
Total Number of Doors

1(16)

2(14)

 
Number of Fixed Shelves

5(3)

 
Door Type

Side Open(6)

 
Manufacturer Part Number

432LL(1)

882LL(1)

795LP(1)

795LQ(1)

795LS(1)

795LSL(1)

795LSP(1)

795LSQ(1)

795LSS(1)

882LQ(1)

794LS(1)

882LS(1)

883LL(1)

883LQ(1)

883LS(1)

884LL(1)

884LQ(1)

884LS(1)

885LL(1)

795LL(1)

794LQ(1)

885LS(1)

785LSS(1)

785LL(1)

785LP(1)

785LQ(1)

785LS(1)

785LSL(1)

785LSP(1)

785LSQ(1)

792LL(1)

794LP(1)

792LP(1)

792LQ(1)

792LS(1)

793LL(1)

793LP(1)

793LQ(1)

793LS(1)

794LL(1)

885LQ(1)

885LSL(1)

784LQ(1)

60551(1)

60441(1)

60442(1)

60444(1)

60445(1)

60447(1)

60448(1)

60550(1)

60552(1)

60438(1)

60553(1)

60554(1)

60555(1)

60556(1)

60557(1)

60558(1)

60559(1)

60560(1)

60439(1)

60436(1)

885LSQ(1)

894LQ(1)

885LSS(1)

892LL(1)

892LQ(1)

892LS(1)

893LL(1)

893LQ(1)

893LS(1)

894LL(1)

894LS(1)

60435(1)

895LL(1)

895LQ(1)

895LS(1)

895LSL(1)

895LSQ(1)

895LSS(1)

60432(1)

60433(1)

784LS(1)

784LP(1)

432LP(1)

672LS(1)

626LL(1)

626LQ(1)

626LS(1)

626NQ(1)

672LL(1)

672LP(1)

672LQ(1)

673LL(1)

626CLS(1)

673LP(1)

673LQ(1)

673LS(1)

674LL(1)

674LP(1)

674LQ(1)

674LS(1)

675LL(1)

626CNQ(1)

626CLQ(1)

675LQ(1)

574LL(1)

432LQ(1)

434LL(1)

434LP(1)

434LQ(1)

572LL(1)

572LP(1)

572LQ(1)

574LP(1)

626CLL(1)

582LL(1)

582LQ(1)

584LL(1)

584LP(1)

584LQ(1)

625LL(1)

625LQ(1)

625LS(1)

675LP(1)

675LS(1)

784LL(1)

695LQ(1)

693LS(1)

694LL(1)

694LP(1)

694LQ(1)

694LS(1)

695LL(1)

695LP(1)

695LS(1)

693LP(1)

782LL(1)

782LP(1)

782LQ(1)

782LS(1)

783LL(1)

783LP(1)

783LQ(1)

783LS(1)

693LQ(1)

693LL(1)

682LL(1)

684LP(1)

682LP(1)

682LQ(1)

682LS(1)

683LL(1)

683LP(1)

683LQ(1)

683LS(1)

684LL(1)

684LQ(1)

692LS(1)

684LS(1)

685LL(1)

685LP(1)

685LQ(1)

685LS(1)

692LL(1)

692LP(1)

692LQ(1)

60561(1)

 
Country of Origin

United States(161)

Thailand(6)

United Kingdom(2)

 
Material

Steel(153)

Anodized Aluminum Door(5)

Metal(4)

 
Height

67"(40)

28.4"(34)

53.3"(34)

40.9"(26)

52.5"(9)

28.1"(9)

75.9"(8)

67.7"(6)

64.3"(3)

 
Width

36"(76)

42"(60)

30"(33)

 
Depth

19.3"(134)

18.6"(24)

13.8"(7)

16.8"(4)

 
 
 

© 2019-2020 Edwards Office System, All Rights Reserved