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

BALT(9)

Tripp Lite(8)

3M(6)

Alera(6)

Fellowes(6)

Ergotron(5)

Safco Mayline(2)

Kelly Computer Supply(1)

Kensington(1)

Quartet(1)

 
Height

27"(4)

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

7 7/8" to 16"(2)

42 1/4"(2)

4"(2)

7"(2)

4 3/8"(1)

13 3/8"(1)

19 3/4"(1)

6 3/8"(1)

35 1/8"(1)

15 1/2"(1)

11 1/8"(1)

5 3/4"(1)

26"(1)

24 1/2"(1)

11 7/8"(1)

10"(1)

20"(1)

17 3/4"(1)

16 1/2"(1)

9 1/2" to 18"(1)

35"(1)

22"(1)

21"(1)

24"(1)

18 1/2"(1)

 
Color(s)

Black(22)

Silver(10)

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)

2 7/8"(2)

3"(2)

6"(2)

13 1/2"(1)

10 3/4"(1)

38 3/4"(1)

12"(1)

29"(1)

2 1/4"(1)

2"(1)

7/8"(1)

24"(1)

27"(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)

3 1/2"(1)

4 3/4" to 23 1/8"(1)

14 1/2"(1)

 
Overall Width

4 1/2"(4)

5"(3)

26"(2)

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

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

4 3/8"(2)

6 3/4"(1)

53"(1)

10"(1)

3 3/4"(1)

27"(1)

15 1/2"(1)

8 3/4"(1)

9 1/2"(1)

1 3/4"(1)

33 1/2"(1)

10 1/4"(1)

13"(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)

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

8 1/2"(1)

2"(1)

19 1/2"(1)

4 3/4"(1)

 
Overall Depth

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

28"(3)

19 1/2"(2)

2 7/8"(2)

25 1/2"(2)

3 1/2"(2)

6"(2)

21 1/4"(2)

12 1/4"(1)

1 1/4"(1)

29"(1)

2 1/4"(1)

3"(1)

2"(1)

7/8"(1)

12"(1)

24"(1)

21"(1)

22"(1)

5"(1)

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

31"(1)

23 1/8"(1)

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

14 1/2"(1)

27"(1)

38 3/4"(1)

 
Manufacturer Part Number

MA245S(1)

MA260MB(1)

MA265S(1)

MALAPTOP2(1)

MA240MB(1)

MA140MB(1)

8042501(1)

8042601(1)

17915(1)

60904(1)

AW6Q(1)

2130SL(1)

DWF3770L(1)

DWM1327SE(1)

DWM1742MA(1)

DWT3770X(1)

DWF1327M(1)

DDR1026MQ(1)

2132SL(1)

DCPU1(1)

DDR0310SC(1)

8041701(1)

8041601(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)

80105064(1)

97582009(1)

8034801(1)

8038201(1)

60577195(1)

45235194(1)

90377(1)

90378(1)

45228026(1)

AEMA1B(1)

 
Country of Origin

CN(32)

TW(10)

CA(3)

 
Width

9"(2)

26"(2)

4 3/8"(2)

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

4" to 6"(1)

33 1/2"(1)

3 1/2" to 10"(1)

53"(1)

5 3/8"(1)

11 7/8"(1)

8 3/4"(1)

9 1/2"(1)

37" to 70"(1)

4 3/4"(1)

10 1/4"(1)

4 1/2"(1)

17"(1)

27"(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)

42"(1)

19"(1)

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

2"(1)

3"(1)

34 1/4"(1)

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

 
Material(s)

Steel(9)

Steel/Aluminum(8)

Aluminum Alloy; Metal(4)

Metal(4)

Iron(2)

Aircraft Aluminum/Plastic(2)

Plastic(2)

Powder-Coated Steel/Plastic(2)

Plastic/Steel(2)

Powder-Coated Metal(1)

Aluminum(1)

Aluminum Die Cast(1)

Steel/Phenolic Resin(1)

Plastic; Aluminum; Steel(1)

Aluminum; ABS Plastic(1)

ABS Plastic(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 Screen TVs; Plasma; LED; LCD(2)

Flat panel TVs(2)

Monitors; Flat Panel TVs(1)

Monitors; TVs(1)

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

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

Phones; Tablets(1)

Monitor arms and laptops(1)

Ergotron WorkFit-D Sit-Stand Desk(1)

BALT Economy Wall Mount Workstation(1)

Monitors up to 27", up to 20 lbs. per arm(1)

Flat Screen Monitors(1)

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

CPU; Computers; UPS(1)

 
Weight

3 lbs.(3)

4.4 lbs.(2)

1 lb.(1)

1 lbs.(1)

12.8 lbs.(1)

9.9 lbs.(1)

6.4 lbs.(1)

8.1 lbs.(1)

18 1/2"(1)

1.6 lbs.(1)

2.7 lbs.(1)

7.9 lbs.(1)

7.26 lbs.(1)

3.4 lbs.(1)

1.43 lbs.(1)

6.3 lbs.(1)

15.6 lbs.(1)

20"(1)

8.7 lbs.(1)

36 lbs.(1)

26 lbs.(1)

10.25 lbs.(1)

20 lbs.(1)

16 lbs.(1)

4 lbs.(1)

13 lbs.(1)

8.3 lbs.(1)

5.3 lbs.(1)

17.25 lbs.(1)

7 lbs.(1)

11 1/4 lbs.(1)

10.1 lbs.(1)

2 lbs.(1)

7.56 lbs.(1)

8 lbs.(1)

 
Mounting

Wall(15)

Desk; Clamp/Grommet(8)

Desk(8)

Clamp/Grommet(5)

Workstation(2)

Wall; Desk(2)

Clamp; Desk(1)

Monitor Arm(1)

Underdesk(1)

Clamp(1)

Monitor(1)

 
Swivel

360(14)

180(7)

135(4)

70(1)

90(1)

60(1)

 
For Monitors (Size, Weight)

Up to 11 lbs.(2)

Up to 27", up to 20 lbs. per arm(2)

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

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

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

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

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

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

Up to 30 lbs.(1)

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

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

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

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

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

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

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

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

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

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

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

Up to 24 lbs.(1)

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

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

26", 52", 75 lbs(1)

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

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

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

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

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

32", 65", 185 lbs(1)

20"; up to 50 lbs.(1)

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

19", up to 10 lbs.(1)

up to 20 lbs.(1)

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

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

25 lbs(1)

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

Up to 24 lbs. per Arm(1)

 
Wall/Ceiling Mounts & Hardware Type

Desk Mount(10)

Clamp Mount Hardware/Grommet Mount Hardware(5)

Flat Panel Wall Mount(3)

Flat Panel LCD/Plasma TV Bracket(2)

Fixed Wall Mount(2)

Full-Mount Wall Mount(1)

Tilt Wall Mount(1)

Fixed-Motion Wall Mount with Arms(1)

CPU Computer Mount(1)

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

Vertical Mount Base/VESA Adaptor Brackets(1)

Two Extensions; LCD Energy Pivot; Desk Clamp Base; Grommet Mount Base(1)

VESA MIS-D(1)

Screen Bracket(1)

 
Arm Rotation

360(16)

180(8)

90(2)

60(1)

 
Platform Height

15 3/4"(4)

27"(4)

16"(2)

42 1/4"(2)

35"(1)

15 1/2"(1)

18 1/2"(1)

22"(1)

3" to 15"(1)

24"(1)

20"(1)

17 3/4"(1)

4 3/4"(1)

1/2"(1)

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

21"(1)

 
Platform Extension Size

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

22"(2)

12 1/4"(2)

19 1/2"(2)

26 1/2"(1)

13 1/2"(1)

4" to 6"(1)

3 1/2" to 10"(1)

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

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

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

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

10 3/4"(1)

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

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

 
Overall Height

15 3/4"(4)

27"(4)

16"(3)

11 7/8"(2)

21 1/4"(2)

42 1/4"(2)

13 3/8"(1)

4 3/8"(1)

7 1/2"(1)

26"(1)

11 1/8"(1)

35 1/8"(1)

6 3/8"(1)

5 3/4"(1)

18 1/2"(1)

19 3/4"(1)

22"(1)

51 1/4"(1)

20"(1)

17 3/4"(1)

5"(1)

4 3/4"(1)

18"(1)

24 1/2"(1)

21"(1)

24"(1)

9 1/4"(1)

35"(1)

 
Tilt (Degrees)

30(8)

180(4)

+ 85, - 20(2)

90/-15(2)

45(2)

+55/-90(2)

37(2)

80(2)

15(2)

+15/-5(1)

+10/-10(1)

+15/-10(1)

+30/-30(1)

35(1)

-15(1)

+15/-90(1)

 
 
 

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