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

Currently Filtered by

Category

Ladders

Refine Search

  GO
 
Brand

Louisville(13)

Cramer(3)

Cosco(2)

 
Color

Orange(3)

 
Recycled

No(3)

 
Height

96"(3)

72"(3)

23"(1)

32.75"(1)

66.25"(1)

55"(1)

75.5"(1)

28.38"(1)

50"(1)

81 1/4"(1)

36"(1)

48"(1)

2 ft(1)

 
Color(s)

Beige(3)

Orange(3)

Aluminum/Green(2)

Green/Black(2)

Aluminum/Red(2)

Black(1)

Aluminum(1)

 
Depth

31"(2)

7.25"(2)

20.25"(1)

27.25"(1)

33.75"(1)

40"(1)

39.38"(1)

4 3/4"(1)

40.06"(1)

51.88"(1)

9 1/2"(1)

38.25"(1)

 
Quantity

1 each(2)

 
Manufacturer Part Number

FS1504(2)

FS40-06(1)

FS1508(1)

FS1506(1)

L2346-04(1)

L2346-03(1)

FXP1704BX(1)

FS40-08(1)

1020-19(1)

1030-19(1)

FS1502(1)

AS40-08(1)

AS40-06(1)

2061AABLD(1)

11880PBLW1(1)

1041L-19(1)

FY8002(1)

 
Country of Origin

MX(10)

CN(5)

Mexico(3)

 
Width

21.5"(2)

25"(2)

22"(1)

21.25"(1)

20.56"(1)

23 3/16"(1)

16.63"(1)

19"(1)

21.81"(1)

24.81"(1)

18.38"(1)

19.63"(1)

19.5"(1)

22.5"(1)

18"(1)

 
Material

Fiberglass(3)

 
Limited Warranty

1 Year(3)

 
Material(s)

Aluminum(8)

Fiberglass(6)

Steel(1)

 
Weight (Approximate)

14 lb(1)

20 lb(1)

26 lb(1)

 
Length

7"(2)

 
Maximum Load Capacity

300 lb(3)

 
Duty Rating

300 lbs(8)

225 lbs(5)

200 lbs(2)

 
Number of Steps

3(5)

4(4)

2(3)

5(3)

7(3)

 
Working Height

8 ft(5)

23"(2)

6 ft(2)

32.75"(1)

66.25"(1)

55"(1)

26"(1)

45 3/4"(1)

2 ft(1)

 
Spread Size

31"(2)

40"(1)

39.38"(1)

51 1/4"(1)

18.25"(1)

28.9"(1)

40.06"(1)

51.88"(1)

44 1/2"(1)

38.25"(1)

21"(1)

 
Product Type

Ladder(3)

 
Packaged Quantity

1 Each(3)

 
Assembly Required

No(3)

 
Folded Depth

4.75"(3)

7.25"(2)

3"(1)

5.5"(1)

9 1/2"(1)

 
Folded Width

3"(6)

16.63"(1)

18.9"(1)

25"(1)

 
Step Size (w x d)

3"(4)

16 x 8(2)

3" x 15.25"(2)

16" x 8"(1)

14.75" x 12"(1)

18" x 2.5"(1)

3" x 14.875"(1)

15" x 2.75"(1)

16" x 2.75"(1)

18" x 6"(1)

 
 
 

© 2020-2021 Hi Tech Office Products, All Rights Reserved