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

Tripp Lite(6)

3M(6)

Alera(6)

Fellowes(6)

Ergotron(4)

Safco Mayline(2)

Kelly Computer Supply(1)

Kensington(1)

Quartet(1)

 
Height

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

27"(4)

42 1/4"(2)

7"(2)

7 7/8" to 16"(2)

4 3/8"(1)

13 3/8"(1)

5 3/4"(1)

35 1/8"(1)

15 1/2"(1)

11 1/8"(1)

18 1/2"(1)

19 3/4"(1)

22"(1)

11 7/8"(1)

20"(1)

17 3/4"(1)

4"(1)

16 1/2"(1)

9 1/2" to 18"(1)

24 1/2"(1)

21"(1)

24"(1)

35"(1)

 
Color(s)

Black(20)

Silver(9)

Gray(4)

Black/Gray(3)

Silver/Black(3)

White(1)

Gray/Black(1)

 
Depth

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

6"(2)

3"(2)

2 7/8"(2)

38 3/4"(1)

24"(1)

10 3/4"(1)

12"(1)

2 1/4"(1)

7/8"(1)

14 1/2"(1)

13 1/2"(1)

3 1/2"(1)

9"(1)

15"(1)

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

11 1/2"(1)

22"(1)

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

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

21"(1)

27"(1)

 
Overall Width

4 1/2"(4)

5"(3)

4 3/8"(2)

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

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

26"(2)

3 3/4"(1)

53"(1)

33 1/2"(1)

6 3/4"(1)

27"(1)

8 3/4"(1)

15 1/2"(1)

9 1/2"(1)

10"(1)

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

2 7/8"(2)

21 1/4"(2)

25 1/2"(2)

19 1/2"(2)

6"(2)

12 1/4"(1)

12"(1)

2 1/4"(1)

3"(1)

7/8"(1)

38 3/4"(1)

1 1/4"(1)

14 1/2"(1)

22"(1)

3 1/2"(1)

5"(1)

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

21"(1)

31"(1)

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

27"(1)

23 1/8"(1)

24"(1)

 
Manufacturer Part Number

MA240MB(1)

MA245S(1)

MA260MB(1)

MA265S(1)

MA140MB(1)

60904(1)

8042501(1)

8042601(1)

17915(1)

MALAPTOP2(1)

AW6Q(1)

DWM1327SE(1)

DWM1742MA(1)

DWT3770X(1)

DWF1327M(1)

DDR0310SC(1)

2130SL(1)

2132SL(1)

DCPU1(1)

8041701(1)

8041601(1)

66582(1)

66584(1)

66585(1)

66586(1)

AEMA2L(1)

AEMA2H(1)

AEMA1H(1)

AEMA1L(1)

AEMA2B(1)

66648(1)

66649(1)

97582009(1)

8034801(1)

8038201(1)

80105064(1)

60577195(1)

90377(1)

90378(1)

45235194(1)

AEMA1B(1)

 
Country of Origin

CN(28)

TW(10)

CA(3)

 
Width

4 3/8"(2)

26"(2)

9"(2)

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

8 3/4"(1)

53"(1)

33 1/2"(1)

4" to 6"(1)

3 1/2" to 10"(1)

9 1/2"(1)

5 3/8"(1)

4 3/4"(1)

11 7/8"(1)

4 1/2"(1)

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

27"(1)

19"(1)

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

2"(1)

34 1/4"(1)

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

 
Material(s)

Steel(8)

Steel/Aluminum(6)

Aluminum Alloy; Metal(4)

Metal(4)

Iron(2)

Aircraft Aluminum/Plastic(2)

Plastic/Steel(2)

Plastic(2)

Powder-Coated Steel/Plastic(2)

Aluminum(1)

Steel/Phenolic Resin(1)

Powder-Coated Metal(1)

Plastic; Aluminum; Steel(1)

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)

Flat panel TVs(2)

Phones; Tablets(1)

Monitors; Flat Panel TVs(1)

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

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

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

CPU; Computers; UPS(1)

Monitor arms and laptops(1)

BALT Economy Wall Mount Workstation(1)

Ergotron WorkFit-D Sit-Stand Desk(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)

 
Weight

3 lbs.(3)

4.4 lbs.(2)

1 lb.(1)

12.8 lbs.(1)

8.1 lbs.(1)

6.4 lbs.(1)

1 lbs.(1)

9.9 lbs.(1)

20"(1)

7.9 lbs.(1)

7.26 lbs.(1)

2.7 lbs.(1)

1.43 lbs.(1)

6.3 lbs.(1)

1.6 lbs.(1)

18 1/2"(1)

8.7 lbs.(1)

26 lbs.(1)

8.3 lbs.(1)

36 lbs.(1)

20 lbs.(1)

4 lbs.(1)

13 lbs.(1)

5.3 lbs.(1)

2 lbs.(1)

17.25 lbs.(1)

7 lbs.(1)

11 1/4 lbs.(1)

10.1 lbs.(1)

7.56 lbs.(1)

8 lbs.(1)

 
Mounting

Wall(12)

Desk; Clamp/Grommet(8)

Desk(7)

Clamp/Grommet(5)

Workstation(2)

Wall; Desk(2)

Clamp; Desk(1)

Monitor Arm(1)

Underdesk(1)

Clamp(1)

Monitor(1)

 
Swivel

360(12)

180(7)

135(4)

70(1)

90(1)

60(1)

 
For Monitors (Size, Weight)

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

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

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

Up to 11 lbs.(2)

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

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

Up to 30 lbs.(1)

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

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

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

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

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

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

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

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

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

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

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

Up to 24 lbs.(1)

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

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

26", 52", 75 lbs(1)

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

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

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

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

32", 65", 185 lbs(1)

20"; up to 50 lbs.(1)

19", up to 10 lbs.(1)

up to 20 lbs.(1)

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

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

25 lbs(1)

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

Up to 24 lbs. per Arm(1)

 
Wall/Ceiling Mounts & Hardware Type

Desk Mount(9)

Clamp Mount Hardware/Grommet Mount Hardware(5)

Flat Panel Wall Mount(3)

Fixed Wall Mount(1)

Fixed-Motion Wall Mount with Arms(1)

Tilt Wall Mount(1)

CPU Computer Mount(1)

Full-Mount Wall Mount(1)

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

Flat Panel LCD/Plasma TV Bracket(1)

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

VESA MIS-D(1)

Screen Bracket(1)

 
Arm Rotation

360(14)

180(8)

90(2)

60(1)

 
Platform Height

27"(4)

15 3/4"(4)

16"(2)

42 1/4"(2)

3" to 15"(1)

35"(1)

18 1/2"(1)

15 1/2"(1)

21"(1)

20"(1)

17 3/4"(1)

4 3/4"(1)

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

24"(1)

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

42 1/4"(2)

7 1/2"(1)

13 3/8"(1)

18 1/2"(1)

4 3/8"(1)

35 1/8"(1)

11 1/8"(1)

5 3/4"(1)

19 3/4"(1)

35"(1)

21"(1)

20"(1)

17 3/4"(1)

21 1/4"(1)

5"(1)

51 1/4"(1)

4 3/4"(1)

22"(1)

24"(1)

9 1/4"(1)

18"(1)

24 1/2"(1)

 
Tilt (Degrees)

30(8)

180(4)

+ 85, - 20(2)

90/-15(2)

45(2)

+55/-90(2)

37(2)

15(2)

+15/-10(1)

+10/-10(1)

+15/-5(1)

80(1)

35(1)

+15/-90(1)

-15(1)

 
 
 

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