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

Currently Filtered by

Category

Footrests

Refine Search

  GO
Brand

Safco(7)

Fellowes(5)

Alera(3)

Kensington(2)

Rubbermaid Commercial(2)

Victor(1)

Safco Active(1)

3M(1)

Kantek(1)

Height

4" to 6 1/2"(3)

3 1/2" to 5"(2)

4 1/8" to 6 5/8"(2)

3 1/2"(2)

3 1/4" to 5"(1)

3 1/2" to 21 1/2"(1)

2 1/8"(1)

6 1/4"(1)

5 1/2" to 15"(1)

8"(1)

4" to 4 3/4"(1)

3 3/8" to 5 1/8"(1)

4 1/2" to 6 3/4"(1)

3 3/4"(1)

5 1/2" to 6 1/2"(1)

3 3/4" to 7 1/2"(1)

4 1/8" to 5 5/8"(1)

5"(1)

Color(s)

Black(11)

Charcoal(2)

Black/Silver(2)

Two-Tone Gray(1)

Charcoal Gray(1)

Aluminum/Black(1)

Gray/Black(1)

Graphite(1)

Black/Gray(1)

Charcoal/Blue/Gray(1)

Platinum/Gray(1)

Depth

11 1/2"(4)

14 1/4"(2)

14 1/2"(2)

13"(2)

13 3/4"(2)

13 1/8"(2)

17 3/4"(2)

13 1/4"(2)

26"(1)

12"(1)

10"(1)

19 5/8"(1)

14"(1)

Manufacturer Part Number

2120BL(1)

2106(1)

2105(1)

4653CT(1)

2122BL(1)

2129BL(1)

ST570(1)

FFR1000(1)

92311(1)

5124(1)

4653(1)

FR330(1)

8030901(1)

48121(1)

FS312(1)

FS212(1)

8035001(1)

8067001(1)

FR750(1)

56146(1)

56144(1)

8068001(1)

FS112(1)

Country of Origin

TW(10)

CN(9)

US(3)

DK(1)

Width

17 1/2"(3)

13 3/4"(2)

18 1/8"(2)

18 1/2"(2)

18"(2)

14"(2)

20 1/2"(1)

22 1/2"(1)

20"(1)

15 1/2"(1)

21 1/2"(1)

17 5/8"(1)

16 1/2"(1)

17 3/4"(1)

17 7/8"(1)

19 3/4"(1)

Material(s)

Plastic(6)

HPS(4)

Hypoallergenic Medical-Grade Foam;Nylon(1)

Aluminum(1)

Powder Coated Tubular Steel(1)

Luxurious memory foam(1)

Polypropylene(1)

Heavy-Duty Steel(1)

For Use With

Standing Desks(1)

Weight

14 lbs.(2)

24 lbs.(1)

20 lbs.(1)

7 lbs.(1)

5.5 lbs.(1)

25 lbs.(1)

27 lbs.(1)

3.71 lbs.(1)

4.2 lbs.(1)

4.9 lbs.(1)

5.38 lbs.(1)

3.13 lbs.(1)

Adjustability

Tilt Angle(2)

3-Position Height;Tilt Flat To 15°(2)

3-Position Height; Up To 30° Tilt(1)

Height;Tilt 20° To -20°(1)

Four Angle Tilt 6-25°(1)

Multiposition(1)

9-Position Height(1)

Height(1)

30° Angle; Height adjusts 3 1/2" to 5"(1)

Angle; Height; Position Lock(1)

2-Position Height(1)

Stepless Adjustment Within 20° Range(1)

3-Position Height; Tilt 20° To 70°(1)

2-Position Height; 2-Angle Tilt(1)

3-Position Height;Position Lock;Tilt 30° To -30°(1)

3-Position Height; Tilt 25°(1)

3-Position Height; Up To 25° Tilt(1)

2-Position Height; Tilt 20° To 40°(1)

Surface Features

Massage Bumps(4)

Surface Bumps(3)

Nonskid(2)

Anti-Slip;Textured(1)

Antislip Rubber Mat(1)

Raised Ridges(1)

Non-Slip(1)

Machine Washable;Nonslip(1)

Rollers; Surface Bumps(1)

Ribbed(1)

Textured(1)

Microban(1)

Anti-Fatigue; Non-Slip(1)

Contoured Nonskid(1)

Price Range

$0-$99.99(19)

$100-$199.99(3)

$200-$299.99(1)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved