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 ('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(12)

BALT(9)

Alera(6)

3M(6)

Fellowes(6)

Ergotron(3)

Safco(2)

Kelly Computer Supply(1)

Kensington(1)

Quartet(1)

 
Height

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

27"(4)

7 7/8" to 16"(2)

42 1/4"(2)

7"(2)

4"(2)

5 3/4"(1)

15 3/4"(1)

26"(1)

6 3/8"(1)

11 1/8"(1)

9 1/2"(1)

35 1/8"(1)

2 1/4"(1)

4 5/8"(1)

15 1/2"(1)

19 3/4"(1)

13 3/8"(1)

9 1/2" to 18"(1)

10"(1)

20"(1)

17 3/4"(1)

24"(1)

21"(1)

18 1/2"(1)

35"(1)

24 1/2"(1)

22"(1)

4 3/8"(1)

 
Color(s)

Black(25)

Silver(9)

Gray(4)

Black/Gray(3)

Silver/Black(3)

White(1)

Gray/Black(1)

Polished Aluminum(1)

 
Depth

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

11 1/2"(2)

6"(2)

2 7/8"(2)

1 7/8"(2)

29"(2)

3"(2)

13 1/2"(1)

10 3/4"(1)

12"(1)

2"(1)

2 1/4"(1)

5" to 20 3/8"(1)

7/8"(1)

24"(1)

22"(1)

9"(1)

15"(1)

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

21"(1)

10"(1)

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

14 1/2"(1)

27"(1)

38 3/4"(1)

 
Overall Width

4 1/2"(4)

8 1/2"(3)

5"(3)

26"(2)

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

10 1/4"(2)

4 3/8"(2)

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

6 3/4"(1)

10"(1)

3 3/4"(1)

1 3/4"(1)

8 3/4"(1)

22"(1)

15 1/2"(1)

9 1/2"(1)

27"(1)

4 3/4"(1)

36.22"(1)

19"(1)

24"(1)

11"(1)

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

34 1/4"(1)

25 1/8"(1)

33 1/2"(1)

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

13"(1)

19 1/2"(1)

53"(1)

 
Overall Depth

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

28"(3)

29"(2)

2 7/8"(2)

25 1/2"(2)

21 1/4"(2)

6"(2)

19 1/2"(2)

3 1/2"(2)

1 7/8"(2)

2 1/4"(1)

12"(1)

5" to 20 3/8"(1)

7/8"(1)

2"(1)

3"(1)

1 1/4"(1)

38 3/4"(1)

21"(1)

22"(1)

5"(1)

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

31"(1)

27"(1)

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

24"(1)

14 1/2"(1)

12 1/4"(1)

 
Manufacturer Part Number

MALAPTOP2(1)

AW6Q(1)

2130SL(1)

2132SL(1)

MA265S(1)

MA260MB(1)

60904(1)

MA140MB(1)

MA240MB(1)

MA245S(1)

DCPU1(1)

DDR0310SC(1)

DWM2655M(1)

DWT2655XE(1)

DWT3270X(1)

DWT3770X(1)

DWM1742MA(1)

DWM1327SE(1)

DDR1026MQ(1)

DDR1026SD(1)

DWF1327M(1)

DWF3770L(1)

17915(1)

8042601(1)

66584(1)

66585(1)

66586(1)

66587(1)

66582(1)

AEMA2L(1)

AEMA1H(1)

AEMA1L(1)

AEMA2B(1)

AEMA2H(1)

66648(1)

66649(1)

8038201(1)

8041601(1)

8041701(1)

8042501(1)

8034801(1)

97582009(1)

90377(1)

90378(1)

45228026(1)

80105064(1)

AEMA1B(1)

 
Country of Origin

CN(34)

TW(10)

CA(3)

 
Width

26"(2)

10 1/4"(2)

9"(2)

4 3/8"(2)

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

5 3/8"(1)

37" to 70"(1)

3 1/2" to 10"(1)

4" to 6"(1)

9 1/2"(1)

11 7/8"(1)

8 3/4"(1)

32" to 70"(1)

8 1/2"(1)

55"(1)

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

53"(1)

42"(1)

19"(1)

27"(1)

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

17"(1)

34 1/4"(1)

3"(1)

33 1/2"(1)

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

4 3/4"(1)

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

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

 
Material(s)

Steel/Aluminum(12)

Steel(9)

Aluminum Alloy; Metal(4)

Metal(4)

Aircraft Aluminum/Plastic(2)

Plastic/Steel(2)

Iron(2)

Powder-Coated Steel/Plastic(2)

Plastic(2)

Aluminum(1)

Steel/Phenolic Resin(1)

Powder-Coated Metal(1)

Aluminum; ABS Plastic(1)

Aluminum Die Cast(1)

 
For Use With

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

Monitors, laptops and tablets(5)

Monitors; Flat Panel TVs(3)

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

Flat panel TVs(2)

Monitors; TVs; Plasma(1)

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

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

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

Monitors; TVs(1)

CPU; Computers; UPS(1)

Ergotron WorkFit-D Sit-Stand Desk(1)

BALT Economy Wall Mount Workstation(1)

Flat Screen Monitors(1)

Monitor arms and laptops(1)

For use with projection screens QRT-660S, QRT-670S, QRT-684S, QRT696S and QRT-770S(1)

Phones; Tablets(1)

 
Weight

3 lbs.(3)

4.4 lbs.(2)

1.6 lbs.(1)

9.4 lbs.(1)

20"(1)

15.6 lbs.(1)

1 lbs.(1)

12.8 lbs.(1)

1 lb.(1)

18 1/2"(1)

1.43 lbs.(1)

5.3 lbs.(1)

5.94 lbs.(1)

7.26 lbs.(1)

18.6 lbs.(1)

7.9 lbs.(1)

3.4 lbs.(1)

2.7 lbs.(1)

9.9 lbs.(1)

6.4 lbs.(1)

36 lbs.(1)

26 lbs.(1)

10.25 lbs.(1)

20 lbs.(1)

16 lbs.(1)

4 lbs.(1)

13 lbs.(1)

2 lbs.(1)

7.56 lbs.(1)

8 lbs.(1)

6.3 lbs.(1)

7 lbs.(1)

8.7 lbs.(1)

17.25 lbs.(1)

10.1 lbs.(1)

11 1/4 lbs.(1)

8.1 lbs.(1)

 
Mounting

Wall(17)

Desk; Clamp/Grommet(8)

Desk(8)

Clamp/Grommet(5)

Wall; Desk(2)

Workstation(2)

Monitor Arm(1)

Clamp; Desk(1)

Clamp(1)

Underdesk(1)

Monitor(1)

 
Swivel

360(15)

180(7)

135(4)

120(1)

90(1)

60(1)

 
For Monitors (Size, Weight)

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

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

Up to 11 lbs.(2)

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

Up to 23", up to 29 lbs.(2)

Up to 20 lbs. per Arm(2)

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

Up to 10", up to 2.2 lbs.(1)

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

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

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

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

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

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

37" to 70", up to 143 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)

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

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

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

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

Up to 30 lbs.(1)

20"; up to 50 lbs.(1)

25 lbs(1)

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

32", 65", 185 lbs(1)

26", 52", 75 lbs(1)

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

Up to 61", up to 220 lbs.(1)

Up to 8 1/2" x 18", up to 50 lbs.(1)

19", up to 10 lbs.(1)

Up to 21", up to 40 lbs.(1)

15" to 24", up to 20 lbs.(1)

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

Up to 24 lbs. per Arm(1)

up to 20 lbs.(1)

Up to 24 lbs.(1)

Up to 23", up to 55 lbs.(1)

 
Wall/Ceiling Mounts & Hardware Type

Desk Mount(11)

Clamp Mount Hardware/Grommet Mount Hardware(5)

Tilt Wall Mount(3)

Flat Panel Wall Mount(3)

Full-Mount Wall Mount(2)

Fixed Wall Mount(2)

Flat Panel LCD/Plasma TV Bracket(2)

Fixed-Motion Wall Mount with Arms(1)

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

Vertical Mount Base/VESA Adaptor Brackets(1)

Screen Bracket(1)

CPU Computer Mount(1)

 
Arm Rotation

360(16)

180(8)

60(1)

90(1)

 
Platform Height

27"(4)

15 3/4"(4)

16"(2)

42 1/4"(2)

2 1/4"(1)

35"(1)

18 1/2"(1)

3" to 15"(1)

15 1/2"(1)

21"(1)

20"(1)

17 3/4"(1)

4 3/4"(1)

1/2"(1)

24"(1)

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

22"(1)

 
Platform Extension Size

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

22"(2)

19 1/2"(2)

12 1/4"(2)

13 1/2"(1)

4" to 6"(1)

3 1/2" to 10"(1)

5" to 20 3/8"(1)

26 1/2"(1)

10 1/2" to 14 1/2"(1)

25 1/8"W x 8 1/8"D(1)

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

10 3/4"(1)

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

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

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

 
Overall Height

15 3/4"(5)

27"(4)

16"(3)

21 1/4"(2)

42 1/4"(2)

26"(1)

19 3/4"(1)

4 3/8"(1)

5 3/4"(1)

11 1/8"(1)

9 1/2"(1)

35 1/8"(1)

2 1/4"(1)

4 5/8"(1)

7 1/2"(1)

11 7/8"(1)

6 3/8"(1)

18 1/2"(1)

51 1/4"(1)

4 3/4"(1)

20"(1)

17 3/4"(1)

5"(1)

18"(1)

9 1/4"(1)

24 1/2"(1)

35"(1)

22"(1)

21"(1)

24"(1)

13 3/8"(1)

 
Tilt (Degrees)

30(8)

180(4)

+55/-90(2)

+30/-30(2)

+ 85, - 20(2)

90/-15(2)

37(2)

15(2)

+0/-10(2)

45(2)

+5/-5(1)

+10/-10(1)

+15/-5(1)

+15/-90(1)

80(1)

-15(1)

+15/-10(1)

 
 
 

© 2018-2019 BonTay Business Products, Inc., All Rights Reserved