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_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

3M(6)

Tripp Lite(5)

Fellowes(2)

Ergotron(1)

 
Height

18"(2)

21"(1)

22"(1)

13 3/8"(1)

4 3/8"(1)

5 3/4"(1)

11 1/8"(1)

15 1/2"(1)

35 1/8"(1)

 
Color(s)

Black(7)

Black/Gray(3)

Silver(2)

Silver/Black(1)

Gray(1)

 
Depth

27"(1)

24"(1)

38 3/4"(1)

12"(1)

7/8"(1)

2 7/8"(1)

3"(1)

2 1/4"(1)

 
Overall Width

4 1/2"(4)

4 3/8"(2)

5"(2)

3 3/4"(1)

27"(1)

9 1/2"(1)

15 1/2"(1)

8 3/4"(1)

 
Overall Depth

19"(2)

27"(1)

24"(1)

38 3/4"(1)

25 1/2"(1)

19 1/2"(1)

11 1/2"(1)

12 1/4"(1)

12"(1)

7/8"(1)

2 7/8"(1)

3"(1)

2 1/4"(1)

 
Manufacturer Part Number

97582009(1)

8041601(1)

8041701(1)

MA140MB(1)

MA240MB(1)

MA245S(1)

MA260MB(1)

MA265S(1)

MALAPTOP2(1)

DCPU1(1)

DWF1327M(1)

DWM1327SE(1)

DWM1742MA(1)

DWT3770X(1)

 
Country of Origin

CN(6)

TW(6)

CA(2)

 
Width

4 3/8"(2)

9"(1)

4" to 6"(1)

5 3/8"(1)

9 1/2"(1)

11 7/8"(1)

8 3/4"(1)

 
Material(s)

Steel/Aluminum(4)

Aluminum Alloy; Metal(3)

Iron(2)

Steel/Phenolic Resin(1)

Metal(1)

 
For Use With

Flat screen monitors(3)

Monitors, laptops and tablets(2)

Ergotron WorkFit-D Sit-Stand Desk(1)

Monitor arms and laptops(1)

CPU; Computers; UPS(1)

Monitors; Flat Panel TVs(1)

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

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

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

 
Weight

3 lbs.(1)

7.56 lbs.(1)

10.1 lbs.(1)

8.1 lbs(1)

12.8 lbs(1)

1 lb(1)

5 lbs.(1)

1.43 lbs.(1)

2.7 lbs.(1)

7.9 lbs.(1)

7.26 lbs.(1)

 
Mounting

Wall(4)

Desk(3)

Monitor Arm(3)

Clamp/Grommet(2)

Underdesk(1)

Wall; Desk(1)

 
Swivel

180(4)

360(2)

240(2)

 
For Monitors (Size, Weight)

Up to 20 lbs.(2)

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

Up to 24 lbs.(1)

Up to 24 lbs. per Arm(1)

Up to 30 lbs.(1)

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

Up to 40 lbs(1)

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

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

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

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

 
Wall/Ceiling Mounts & Hardware Type

Clamp Mount Hardware/Grommet Mount Hardware(5)

100 x 100mm Bracket(1)

CPU Computer Mount(1)

Fixed Wall Mount(1)

Full-Mount Wall Mount(1)

Fixed-Motion Wall Mount with Arms(1)

Tilt Wall Mount(1)

 
Arm Rotation

360(7)

 
Platform Height

21"(3)

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

22"(1)

27"(1)

18 1/2"(1)

15 1/4"(1)

 
Platform Extension Size

19"(2)

10 3/4"(1)

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

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

4" to 6"(1)

 
Overall Height

27"(2)

18"(2)

21"(1)

22"(1)

15"(1)

13 3/8"(1)

4 3/8"(1)

5 3/4"(1)

11 1/8"(1)

11 7/8"(1)

35 1/8"(1)

 
Tilt (Degrees)

37(2)

Forward 55, Backward 90(2)

90/-15(2)

-15(1)

Forward 15, Backward 90(1)

+15/-10(1)

+15/-5(1)

+10/-10(1)

 
 
 

© 2019-2020 gemlaser, Inc., All Rights Reserved