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 "AV Mounts, Arms & Hardware") 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 ('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)

BALT(9)

Ergotron(7)

Alera(6)

3M(6)

Fellowes(5)

Kantek(3)

Safco(2)

SMK-Link Electronics(1)

Kensington(1)

Kelly Computer Supply(1)

Quartet(1)

Height

27"(4)

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

17 1/2"(3)

7 7/8" to 16"(2)

10"(2)

7"(2)

42 1/4"(2)

4"(2)

15 3/4"(1)

26"(1)

19 3/4"(1)

5 3/4"(1)

23"(1)

15 1/2"(1)

2 1/4"(1)

9 1/2"(1)

35 1/8"(1)

4 5/8"(1)

3 1/2"(1)

11 1/8"(1)

4 3/8"(1)

6 3/8"(1)

18 1/2"(1)

16 1/2"(1)

9 1/2" to 18"(1)

16 3/4"(1)

11 7/8"(1)

17 3/4"(1)

20"(1)

24"(1)

21"(1)

16" to 24"(1)

13 3/8"(1)

35"(1)

24 1/2"(1)

22"(1)

11"(1)

Color(s)

Black(31)

Silver(10)

Gray(5)

Black/Gray(3)

Silver/Black(3)

Polished Aluminum(2)

White(1)

Gray/Black(1)

Depth

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

3"(4)

2 7/8"(2)

6"(2)

29"(2)

10"(2)

9"(2)

11 1/2"(2)

1 7/8"(2)

16 1/2"(1)

13 1/2"(1)

12"(1)

7/8"(1)

9 1/2"(1)

10 3/4"(1)

2 1/4"(1)

2"(1)

5" to 20 3/8"(1)

24"(1)

21"(1)

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

22"(1)

15"(1)

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

19 3/8"(1)

3 1/2"(1)

38 3/4"(1)

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

14 1/2"(1)

27"(1)

13"(1)

Overall Width

4 1/2"(4)

8 1/2"(3)

5"(3)

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

26"(2)

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

10 1/4"(2)

4 3/8"(2)

6 1/2"(1)

14 1/8"(1)

6 3/4"(1)

3 3/4"(1)

1 3/4"(1)

22"(1)

8 3/4"(1)

9 1/8"(1)

15 1/2"(1)

27"(1)

9 1/2"(1)

10"(1)

53"(1)

19"(1)

34 1/4"(1)

36.22"(1)

24"(1)

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

11"(1)

25 1/8"(1)

19 1/2"(1)

17"(1)

32"(1)

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

33 1/2"(1)

2"(1)

4 3/4"(1)

32'(1)

Overall Depth

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

3"(3)

29"(2)

6"(2)

19 1/2"(2)

2 7/8"(2)

25 1/2"(2)

1 7/8"(2)

28"(2)

3 1/2"(2)

21 1/4"(2)

12"(1)

14 1/8"(1)

7/8"(1)

5" to 20 3/8"(1)

2 1/4"(1)

9 1/2"(1)

2"(1)

1 1/4"(1)

16 1/2"(1)

13"(1)

21"(1)

31"(1)

22"(1)

5"(1)

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

23 1/8"(1)

27"(1)

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

38 3/4"(1)

24"(1)

14 1/2"(1)

12 1/4"(1)

Manufacturer Part Number

MALAPTOP2(1)

MA265S(1)

AW6Q(1)

2130SL(1)

VP3665(1)

2132SL(1)

MA260MB(1)

MA245S(1)

MA220(1)

MA210(1)

MA225(1)

MA140MB(1)

MA240MB(1)

DCPU1(1)

DCTM(1)

DWM2655M(1)

DWM1742MN(1)

DWT2655XE(1)

DWT3270X(1)

DWT3770X(1)

DWM1742MA(1)

DWM1327SE(1)

DDR1026MQ(1)

DDR0310SC(1)

DDR1026SD(1)

DWF1327M(1)

DWF3770L(1)

60904(1)

17915(1)

66586(1)

66585(1)

66587(1)

66648(1)

66649(1)

66584(1)

66582(1)

AEMA1L(1)

AEMA1H(1)

AEMA2B(1)

AEMA2H(1)

AEMA2L(1)

90377(1)

90378(1)

8041601(1)

8038201(1)

8041701(1)

8042501(1)

8042601(1)

97582009(1)

80105064(1)

45228026(1)

45214026(1)

45235194(1)

45306101(1)

60577195(1)

AEMA1B(1)

Country of Origin

CN(42)

TW(11)

CA(2)

US(1)

Width

3"(2)

32"(2)

26"(2)

10 1/4"(2)

9"(2)

4 3/8"(2)

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

17"(2)

3 1/2" to 10"(1)

5 3/8"(1)

6 1/2"(1)

4" to 6"(1)

37" to 70"(1)

9 1/2"(1)

32" to 70"(1)

8 3/4"(1)

8 1/2"(1)

55"(1)

11 7/8"(1)

17" to 42"(1)

6 3/4"(1)

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

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

2"(1)

34 1/4"(1)

19"(1)

27"(1)

42"(1)

2 7/8"(1)

4 1/2"(1)

33 1/2"(1)

53"(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 29 3/4"(1)

Material(s)

Steel/Aluminum(13)

Steel(12)

Metal(5)

Aluminum Alloy; Metal(4)

Aluminum(3)

Iron(2)

Aircraft Aluminum/Plastic(2)

Plastic(2)

Plastic/Steel(2)

Powder-Coated Steel/Plastic(2)

Aluminum; ABS Plastic(2)

Aluminum Die Cast(1)

ABS Plastic(1)

Powder-Coated Metal(1)

Plastic; 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, laptops and tablets(5)

Monitors; Flat Panel TVs(3)

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

2 LCD Monitors(2)

Flat panel TVs(2)

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

Monitors; TVs; Plasma(1)

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

Monitors; TVs(1)

Phones; Tablets(1)

LCD; Plasma; Flat Panel TVs(1)

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

iPads and similar size tablets(1)

Flat Screen Monitors(1)

Ergotron WorkFit-D Sit-Stand Desk(1)

BALT Economy Wall Mount Workstation(1)

1 LCD Monitor(1)

Monitor arms and laptops(1)

CPU; Computers; UPS(1)

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

Flat Panel Monitors; TVs; Projectors(1)

Weight

3 lbs.(3)

4.4 lbs.(2)

9 lbs.(2)

5.3 lbs.(2)

3.3 lbs.(1)

1.6 lbs.(1)

5.52 lbs.(1)

18 1/2"(1)

9.9 lbs.(1)

12.8 lbs.(1)

1 lb.(1)

1 lbs.(1)

20"(1)

9.4 lbs.(1)

3.63 lbs.(1)

18.6 lbs.(1)

5.94 lbs.(1)

7.26 lbs.(1)

7.9 lbs.(1)

2.7 lbs.(1)

8.1 lbs.(1)

1.43 lbs.(1)

3.4 lbs.(1)

15.6 lbs.(1)

10 1/2 lbs.(1)

26 lbs.(1)

10.25 lbs.(1)

8.3 lbs.(1)

7.3 lbs.(1)

36 lbs.(1)

20 lbs.(1)

4 lbs.(1)

13 lbs.(1)

16 lbs.(1)

2 lbs.(1)

7.56 lbs.(1)

6 1/2 lbs.(1)

7 lbs.(1)

6.3 lbs.(1)

8 lbs.(1)

8.7 lbs.(1)

10.1 lbs.(1)

11 1/4 lbs.(1)

17.25 lbs.(1)

6.4 lbs.(1)

Mounting

Wall(19)

Desk(12)

Desk; Clamp/Grommet(10)

Clamp/Grommet(5)

Monitor Arm(2)

Wall; Desk(2)

Workstation(2)

Clamp; Desk(1)

Ceiling(1)

Underdesk(1)

Monitor(1)

Swivel

360°(18)

180°(6)

135°(4)

45°(3)

90°(2)

80°(1)

120°(1)

70°(1)

60°(1)

For Monitors (Size, Weight)

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

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)

9" to 11"(1)

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

Up to 37", up to 80 lbs.(1)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Up to 30 lbs.(1)

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

20"; up to 50 lbs.(1)

25 lbs(1)

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

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

32", 65", 185 lbs(1)

26", 52", 75 lbs(1)

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

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

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

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

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

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

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

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

Up to 24 lbs. per Arm(1)

Up to 24 lbs.(1)

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

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

up to 20 lbs.(1)

Up to 27", up to 15 lbs. per arm.(1)

Wall/Ceiling Mounts & Hardware Type

Desk Mount(11)

Clamp Mount Hardware/Grommet Mount Hardware(6)

Full-Mount Wall Mount(3)

Tilt Wall Mount(3)

Flat Panel Wall Mount(3)

Flat Panel LCD/Plasma TV Bracket(2)

Desk Mount Grommet or Clamp(2)

VESA MIS-D(2)

Fixed Wall Mount(2)

Ceiling Mount(1)

Fixed-Motion Wall Mount with Arms(1)

CPU Computer Mount(1)

Desk Mount Base(1)

Vertical Mount Base/VESA Adaptor Brackets(1)

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

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

Screen Bracket(1)

C-Clamp Desk Mount with Anti-Theft Feature(1)

Arm Rotation

360°(22)

180°(8)

90°(2)

60°(1)

Platform Height

27"(4)

15 3/4"(4)

16"(2)

42 1/4"(2)

1/2"(2)

18 1/2"(1)

9 1/2"(1)

2 1/4"(1)

3" to 15"(1)

35"(1)

21"(1)

20"(1)

17 3/4"(1)

4 3/4"(1)

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

22"(1)

24"(1)

15 1/2"(1)

Platform Extension Size

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

19 1/2"(2)

22"(2)

12 1/4"(2)

4" to 6"(1)

180°(1)

3 1/2" to 10"(1)

5" to 20 3/8"(1)

13 1/2"(1)

11" to 20"(1)

3 1/2” to 16 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)

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

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

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

26 1/2"(1)

Overall Height

15 3/4"(5)

27"(4)

17 1/2"(3)

16"(3)

42 1/4"(2)

11 7/8"(2)

21 1/4"(2)

19 3/4"(1)

23"(1)

26"(1)

11"(1)

4 3/8"(1)

11 1/8"(1)

9 1/2"(1)

35 1/8"(1)

2 1/4"(1)

4 5/8"(1)

6 3/8"(1)

3 1/2"(1)

5 3/4"(1)

18 1/2"(1)

51 1/4"(1)

4 3/4"(1)

20"(1)

17 3/4"(1)

5"(1)

18"(1)

24"(1)

35"(1)

13 3/8"(1)

24 1/2"(1)

22"(1)

21"(1)

7 1/2"(1)

Tilt (Degrees)

30°(8)

180°(5)

45°(4)

80°(3)

+0°/-10°(2)

+ 85°, - 20°(2)

90°/-15°(2)

+30°/-30°(2)

+55°/-90°(2)

15°(2)

37°(2)

+5°/-5°(1)

+15°/-15°(1)

+10°/-10°(1)

+15°/-5°(1)

35°(1)

-15°(1)

165°(1)

-30°(1)

+15°/-90°(1)

+15°/-10°(1)

Price Range

$0-$499.99(54)

$500-$999.99(2)

To  GO

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

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