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

Currently Filtered by

Category

AV Mounts Arms And Hardware

Refine Search
  GO
 
Brand

Tripp Lite(14)

Fellowes(10)

Alera(6)

3M(6)

Kantek(3)

Safco(2)

Ergotron(1)

 
Height

27"(4)

3 7/8" to 15 3/4"(4)

17 1/2"(3)

7 7/8" to 16"(2)

42 1/4"(2)

6 3/8"(1)

81 1/2"(1)

5 3/4"(1)

11 1/8"(1)

15 1/2"(1)

9 1/2"(1)

35 1/8"(1)

2 1/4"(1)

15 9/10"(1)

3 1/2"(1)

4 5/8"(1)

26"(1)

13 3/8"(1)

35"(1)

24 1/2"(1)

22"(1)

21"(1)

16 1/2"(1)

20 1/4"(1)

18 1/2"(1)

11"(1)

18 4/5"(1)

27 1/5"(1)

4 3/8"(1)

 
Color(s)

Black(29)

Silver(5)

Black/Gray(3)

Black/Silver(1)

Gray(1)

Silver/Black(1)

 
Depth

3 7/8" to 20 1/8"(4)

3"(3)

1 7/8"(2)

6"(2)

7/8"(1)

27 3/5"(1)

29"(1)

12"(1)

2"(1)

9 1/2"(1)

2 1/4"(1)

1 4/5"(1)

5" to 20 3/8"(1)

13 1/2"(1)

2 7/8"(1)

13"(1)

38 3/4"(1)

24"(1)

27"(1)

3 7/8" to 14 7/8"(1)

5 1/2"(1)

4 3/10"(1)

3 7/8" to 17 3/4"(1)

35 1/2"(1)

20 1/4"(1)

3 1/4"(1)

10 3/4"(1)

 
Overall Width

4 1/2"(4)

26"(2)

4 3/8"(2)

8 1/2"(2)

3 7/8" to 20 1/8"(2)

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

5"(2)

27"(1)

32 3/5"(1)

10 1/4"(1)

1 3/4"(1)

9 1/8"(1)

8 3/4"(1)

23 9/10"(1)

22"(1)

15 1/2"(1)

9 1/2"(1)

32'(1)

28 1/2"(1)

18"(1)

53"(1)

33 1/2"(1)

3 7/8" to 29 3/4"(1)

35 2/5"(1)

8 7/8"(1)

3 7/8" to 17 3/4"(1)

32"(1)

17"(1)

15 3/10"(1)

3 3/4"(1)

 
Overall Depth

3 7/8" to 20 1/8"(4)

3"(3)

28"(2)

6"(2)

25 1/2"(2)

21 1/4"(2)

1 7/8"(2)

29"(1)

27 3/5"(1)

12"(1)

2 7/8"(1)

1 4/5"(1)

2 1/4"(1)

5" to 20 3/8"(1)

9 1/2"(1)

2"(1)

7/8"(1)

19 1/2"(1)

38 3/4"(1)

12 1/2"(1)

24"(1)

27"(1)

3 7/8" to 14 7/8"(1)

19 7/10"(1)

18 1/2"(1)

3 7/8" to 17 3/4"(1)

13"(1)

35 1/2"(1)

22 1/5"(1)

12 1/4"(1)

 
Manufacturer Part Number

2132SL(1)

DCPU1(1)

DDR1026MQ(1)

DMCS3270XP(1)

2130SL(1)

MALAPTOP2(1)

MA245S(1)

MA260MB(1)

MA265S(1)

DMR1015X3(1)

DWF1327M(1)

DWM3770PLX(1)

DWT2655XE(1)

DWT3270X(1)

DWT3770X(1)

DWM2655M(1)

DWM1742MN(1)

DWF3770L(1)

DWM1327SE(1)

DWM1742MA(1)

MA240MB(1)

MA140MB(1)

97582009(1)

8041601(1)

8041701(1)

8042501(1)

AEMA2L(1)

AEMA2H(1)

AEMA1H(1)

AEMA1L(1)

AEMA2B(1)

8042601(1)

8042801(1)

MA210(1)

MA220(1)

MA225(1)

8044001(1)

8043501(1)

8042901(1)

8043301(1)

8043401(1)

AEMA1B(1)

 
Country of Origin

CN(34)

TW(6)

CA(2)

 
Width

32"(2)

4 3/8"(2)

26"(2)

3 7/8" to 20 1/8"(2)

5 3/8"(1)

37" to 70"(1)

10 1/4"(1)

9 1/2"(1)

32 3/5"(1)

17" to 42"(1)

32" to 70"(1)

8 3/4"(1)

8 1/2"(1)

23.9(1)

4" to 6"(1)

55"(1)

11 7/8"(1)

17"(1)

9"(1)

33 1/2"(1)

3 7/8" to 40 1/4"(1)

3 7/8" to 40 1/4""(1)

3 7/8" to 29 3/4"(1)

53"(1)

28 1/2"(1)

15 3/10"(1)

8 9/10"(1)

35 2/5"(1)

18"(1)

3 7/8" to 17 3/4"(1)

 
Material(s)

Steel/Aluminum(12)

Steel(10)

ABS Plastic; Aluminum; Polypropylene Plastic; Steel(4)

Aluminum Alloy; Metal(4)

Metal(4)

Aircraft Aluminum/Plastic(2)

Iron(2)

Aluminum Steel(1)

Steel/Phenolic Resin(1)

 
For Use With

Alera Lifting Workstations; Alera Valencia Series, Alera Open Office Desk Series; Alera Sedina Series(6)

Monitors(5)

Monitors, laptops and tablets(5)

Monitors; Flat Panel TVs(4)

2 LCD Monitors(2)

Monitors; Flat Screen TVs; Plasma; LED; LCD(2)

Monitors; Flat Screen TVs; Plasma; LCD(1)

LCD; Plasma; Flat Panel TVs(1)

Monitors; TVs(1)

Monitors; LCD; Plasma; Flat Panel TVs(1)

Monitors; Flat Screen TVs; Plasma; LED(1)

CPU; Computers; UPS(1)

Ergotron WorkFit-D Sit-Stand Desk(1)

1 LCD Monitor(1)

Monitor arms and laptops(1)

Flat Panel TVs(1)

 
Weight

12.8 lbs.(2)

1.43 lbs.(1)

3.4 lbs.(1)

46.2 lbs.(1)

15.6 lbs.(1)

18 1/2"(1)

20"(1)

4.4 lbs.(1)

2.7 lbs.(1)

7.9 lbs.(1)

5.94 lbs.(1)

7.26 lbs.(1)

5.3 lbs.(1)

9.75 lbs.(1)

3.63 lbs.(1)

18.6 lbs.(1)

1 lb.(1)

9.9 lbs.(1)

6.2 lbs.(1)

8.4 lbs.(1)

17.25 lbs.(1)

11 1/4 lbs.(1)

7.56 lbs.(1)

10.1 lbs.(1)

10.58 lbs.(1)

9.37 lbs.(1)

6.4 lbs.(1)

8.1 lbs.(1)

6.3 lbs.(1)

10 1/2 lbs.(1)

6 1/2 lbs.(1)

9 lbs.(1)

3 lbs.(1)

 
Mounting

Wall(11)

Desk; Clamp/Grommet(10)

Desk(7)

Clamp/Grommet(4)

Clamp or Grommet(3)

Floor(1)

Wall; Desk(1)

Monitor Arm(1)

Underdesk(1)

Grommet(1)

 
Swivel

360(12)

180(4)

135(4)

45(3)

90(1)

120(1)

80(1)

3(1)

 
For Monitors (Size, Weight)

13" to 27", up to 18 lbs.(3)

Up to 32", up to 22 lbs.(2)

Up to 11 lbs.(2)

Up to 20 lbs. per Arm(2)

Up to 30", up to 20 lbs.(2)

37" to 70", up to 143 lbs.(1)

13" to 27", up to 33 lbs.(1)

13" to 27", up to 88 lbs.(1)

32" to 70", up to 110 lbs.(1)

4" - 6 1/4"; Up to 40 lbs(1)

10" to 26", up to 30 lbs.(1)

17" to 42", up to 77 lbs.(1)

17" to 42", up to 115 lbs.(1)

32" to 70", up to 165 lbs.(1)

37" to 70", up to 200 lbs.(1)

26" to 55", up to 165 lbs.(1)

37" to 70"(1)

26" to 55", up to 110 lbs.(1)

Up to 32", up to 14.3 lbs.(1)

Up to 13 1/2" x 9 4/5"(1)

Up to 30”, up to 20 lbs.(1)

Up to 27", up to 22 lbs.(1)

Up to 27", up to 13 lbs.(1)

Up to 32", up to 14.3 lbs. per arm.(1)

Up to 24 lbs. per Arm(1)

Up to 42", up to 66 lbs.(1)

Up to 32", up to 17 lbs.(1)

Up to 30", up to 22 lbs. per arm.(1)

Up to 20 lbs and <= 27"(1)

Up to 20 lbs. and <= 27"(1)

Up to 30 lbs.(1)

Up to 32", up to 22 lbs. per arm.(1)

Up to 24 lbs.(1)

 
Wall/Ceiling Mounts & Hardware Type

Desk Mount(9)

Clamp Mount Hardware/Grommet Mount Hardware(5)

Monitor Arm(4)

Tilt Wall Mount(3)

Full-Mount Wall Mount(3)

Desk Mount Grommet or Clamp(2)

Fixed Wall Mount(2)

Flat Panel Wall Mount(1)

Fixed-Motion Wall Mount with Arms(1)

Mounts to 3M Easy-Adjust Monitor Arms - MA260MB, MA240MB, MA265S, and MA245S(1)

Monitor Arm Kit(1)

Desk Mount Base(1)

CPU Computer Mount(1)

Flat Panel Floor Stand(1)

 
Arm Rotation

360(18)

180(4)

90(1)

 
Platform Height

15 3/4"(4)

27"(4)

16"(2)

42 1/4"(2)

11"(1)

18 4/5"(1)

18 1/2"(1)

27 1/5"(1)

2 1/4"(1)

28 1/2"(1)

21"(1)

(+0"/-6")(1)

22"(1)

15 1/2"(1)

35"(1)

20 1/4"(1)

 
Platform Extension Size

3 7/8" to 15 3/4"(4)

12 1/4"(2)

8 9/10"(1)

35 2/5"(1)

15 3/10"(1)

13 1/2"(1)

4" to 6"(1)

18"(1)

5" to 20 3/8"(1)

12 1/2"(1)

10 3/4"(1)

3 7/8" to 29 3/4"(1)

3 1/2” to 16 1/2”(1)

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

26 1/2"(1)

19 1/2"(1)

3 7/8" to 17 3/4"(1)

 
Overall Height

27"(4)

15 3/4"(4)

17 1/2"(3)

16"(2)

42 1/4"(2)

6 3/8"(1)

81 1/2"(1)

5 3/4"(1)

11 1/8"(1)

11 7/8"(1)

9 1/2"(1)

35 1/8"(1)

2 1/4"(1)

15 9/10"(1)

3 1/2"(1)

4 5/8"(1)

26"(1)

13 3/8"(1)

35"(1)

24 1/2"(1)

22"(1)

21"(1)

16 1/2"(1)

20 1/4"(1)

18 1/2"(1)

11"(1)

18 1/5"(1)

27 1/5"(1)

4 3/8"(1)

 
Tilt (Degrees)

30(6)

45(3)

+0/-10(2)

90/-15(2)

+55/-90(2)

+ 85, - 20(2)

37(2)

180(2)

+15/-15(1)

+5/-5(1)

-15(1)

+10/-10(1)

+15/-5(1)

+30/-30(1)

+60/-60(1)

+15/-90(1)

+10/-15(1)

+5/- 12(1)

+15/-10(1)

 
 
 

© 2018-2019 Gateway Business Products, All Rights Reserved

Powered byDealer Commander