facebook
 
 
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_name` IN ('Desk Center Drawers','Legs','Mirrors')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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 '%DeskAccessories' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('DeskAccessories' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+DeskAccessories' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"DeskAccessories"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"DeskAccessories"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"DeskAccessories"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"DeskAccessories"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+DeskAccessories' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='DeskAccessories',`category_4` ='DeskAccessories') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'DeskAccessories,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('DeskAccessories', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Desk Accessories

Refine Search

  GO
 
Brand

Lorell(13)

HON(12)

Boss(3)

Angeles(3)

CEP(1)

Children's Factory(1)

Mayline(1)

Creativity Street(1)

See All(1)

 
Color

Black(9)

Chrome(4)

Silver Mist(2)

Multi(1)

Cognac(1)

Platinum Metallic(1)

Charcoal Gray(1)

Silver(1)

Gray(1)

Laminate(1)

 
Recycled

No(16)

Yes(2)

 
Height

29"(3)

28"(3)

0.1"(1)

13"(1)

30"(1)

2.5"(1)

35"(1)

17.8"(1)

11"(1)

 
Depth

23.5"(2)

15.4"(1)

1.5"(1)

28.5"(1)

0.1"(1)

 
Size

24" Width x 48" Length(1)

8.50" Width(1)

24" Diameter(1)

 
Diameter

1.1"(4)

1"(1)

 
Manufacturer Part Number

NTT1XLB(1)

60649(1)

04511(1)

16251(1)

16252(1)

59578(1)

59676(1)

59677(1)

69898(1)

LPLLEG30USVR(1)

99899(1)

99900(1)

99926(1)

99927(1)

MNMTSLLGS(1)

2803(1)

04510(1)

LPLLEG30UBLK(1)

NTT1XLBS(1)

1522LS1(1)

NTT4XLBS(1)

1400011(1)

332132(1)

AB8611(1)

AB8612(1)

AB8650(1)

1526CO(1)

LPLLEG30ASVR(1)

1526LS1(1)

B4LEGT1(1)

LPLLEG24ABLK(1)

LPLLEG24ASVR(1)

LPLLEG24UBLK(1)

LPLLEG24USVR(1)

LPLLEG30ABLK(1)

PVTBAR2X2(1)

 
Country of Origin

China(27)

United States(6)

Canada(2)

France(1)

 
Width

2"(4)

24"(1)

3"(1)

26"(1)

2.4"(1)

27.6"(1)

8.5"(1)

 
Material

Metal(6)

Steel(5)

Metal Frame(2)

Polystyrene(1)

Laminate(1)

Plastic(1)

 
Limited Warranty

Lifetime(6)

1 Year(3)

5 Year(3)

10 Year(2)

90 Day(1)

 
Shape

Rectangular(1)

 
Length

30"(3)

18"(1)

2"(1)

25"(1)

 
Base Material

Powder Coated Steel(1)

 
Style

Contemporary(11)

 
Base Style

Post Leg(1)

 
Mount Type

Ceiling Mountable(1)

 
Additional Information

Length: 48"(1)

 
Product Type

Leg(9)

Worksurface A-Leg(4)

Worksurface U-Leg(4)

Drawer(3)

Mirror(3)

Convex Mirror(2)

Feet(2)

Leg Support(2)

Table Base(1)

Riser(1)

Magnetic Wall Strip(1)

Wide Side Leg(1)

Middle Leg(1)

Peninsula Leg Support(1)

Base(1)

 
Packaged Quantity

1 Each(24)

4 / Carton(3)

4 Carton(3)

1 / Each(2)

2 / Pack(1)

1 / Set(1)

2 / Carton(1)

2 / Set(1)

 
Assembly Required

Yes(20)

No(16)

 
Product Model

H1526(1)

MNMTSL(1)

PVT-Bar 2x2(1)

 
Product Line

Mod(8)

Park Avenue(2)

Relevance(2)

Build(1)

Panaramic(1)

 
Color/Finish

Black(6)

Silver(6)

Sterling Ash(2)

Powder Coated(2)

 
Dimensions

24" Width(4)

30" Width(4)

28" Height x 5" Width x 2.50" Depth(1)

2.5" Height x 22" Width x 15.4" Depth(1)

2.5" Height x 26" Width x 15.4" Depth(1)

28.5" Height x 45.5" Width x 4" Depth(1)

28.5" Height x 38.6" Width x 6.3" Depth(1)

28" Height x 5.9" Width x 5.9" Depth(1)

 
Drawer Type

Pen(2)

Pencil(2)

Accessory(2)

 
Frame Color

Brown(1)

White(1)

 
Frame Material

Wood(2)