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_10` 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 ('112008')) 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 '%Multimedia Carts' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Multimedia +Carts' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Multimedia +Carts' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Multimedia Carts"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Multimedia Carts"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Multimedia Carts"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Multimedia Carts"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Multimedia +Carts' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Carts',`category_4` ='Carts') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Carts,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Carts', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Multimedia Carts

Refine Search

  GO
 
Brand

Lorell(2)

OneScreen(2)

MooreCo(2)

Safco(1)

 
Color

Black(4)

Mahogany(1)

Silver Black(1)

Gray(1)

 
Recycled

No(5)

 
Packaged Quantity

1 Each(6)

 
Assembly Required

Yes(3)

No(2)

 
Limited Warranty

1 Year(1)

 
Weight (Approximate)

112 lb(1)

 
Warranty

Manufacturer's limited lifetime warranty.(1)

 
Number of Casters

4(2)

6(1)

 
Total Number of Shelves

2(1)

 
Maximum Screen Size Supported

70"(1)

 
Caster Size

4"(2)

2.50"(1)

 
Number of Devices Supported

32(2)

 
Manufacturer Part Number

99755(1)

8919MH(1)

25958(1)

MCHA86(1)

27726A(1)

MC75(1)

27698A(1)

 
Country of Origin

China(4)

Taiwan(2)

US(1)

 
Material

Steel(4)

Anodized Aluminum(1)

Plastic(1)

 
Height

55"(2)

64"(1)

39.5"(1)

36.8"(1)

 
Width

26.3"(2)

29.5"(1)

41.3"(1)

31.8"(1)

 
Depth

28"(1)

23.8"(1)

20.1"(1)

 
Material(s)

Laminated; Wood(1)

 
Maximum Load Capacity

100 lb(2)

300 lb(2)

 
Length

42.7"(1)

51"(1)

 
Frame Material

Steel(1)

 
Overall Width

29 1/2"(1)

 
Overall Depth

20 1/2"(1)

 
Caster/Glide/Wheel

Four 2" Casters (2 Locking)(1)

 
Power Source

AC (Alternating Current)(2)

 
Height Maximum

40 3/4"(1)

 
Top Thickness

3/4"(1)

 
Shelf Count

3(1)

 
Sound System

N(1)

 
 
 

© 2019-2020 Legal Name, All Rights Reserved