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

Currently Filtered by

Category

Workstations Computer Desks

Refine Search
  GO
 
Brand

Lorell(25)

Lacasse(11)

Mayline(6)

Safco(6)

Victor(3)

Fellowes(2)

HON(1)

3M(1)

 
Recycled

Yes(14)

No(6)

 
Packaged Quantity

1 Each(54)

 
Assembly Required

Yes(37)

No(6)

 
Limited Warranty

Lifetime(23)

5 Year(11)

1 Year(4)

 
Weight (Approximate)

50 lb(4)

38 lb(2)

38.50 lb(1)

39.50 lb(1)

44.50 lb(1)

 
Dimensions

29.5" Height x 60" Width x 30" Depth(4)

29.5" Height x 48" Width x 30" Depth(4)

1" Thickness - Table Top(4)

29.5" Height x 45.5" Width x 24" Depth(3)

23.1" Height x 29.5" Width x 22" Depth(2)

1.1" Thickness - Top(2)

12" Height x 47.3" Width x 11.9" Depth(2)

12" Height x 74.3" Width x 11.9" Depth(2)

47.8" Height x 25.3" Width x 19.8" Depth(2)

36" Height x 59" Width x 15" Depth(1)

1.1" Thickness - Table Top(1)

20.5" Width x 16" Depth(1)

 
Drawer Type

File(12)

Box(11)

Storage(2)

 
Number of Casters

4(7)

5(2)

 
Total Number of Drawers

4(1)

2(1)

 
Number of Legs

2(1)

 
Table Top Shape

Rectangle(12)

Bow(4)

 
Edge Style

T-mold(7)

Band(4)

Contoured(4)

Square(3)

 
Table Top Width

36.50"(2)

47.25"(2)

34"(2)

23.60"(1)

40"(1)

47"(1)

28.25"(1)

35.50"(1)

29.50"(1)

 
Base Included

Yes(13)

 
Pedestal Type

Single(7)

Double(4)

 
Table Top Thickness

0.75"(2)

0.71"(1)

 
Pedestal Position

Right(7)

 
Base Style

U-shaped(2)

 
Table Top Length

19.25"(2)

15"(1)

 
Table Top Depth

24"(4)

35.40"(1)

21"(1)

23.75"(1)

18.75"(1)

20.50"(1)

 
Total Number of Shelves

2(3)

3(1)

 
Form Factor

Desktop(4)

Tabletop(1)

 
Maximum Screen Size Supported

24"(1)

25"(1)

 
Caster Type

Locking Wheels(7)

Swivel Casters(1)

 
Maximum Adjustable Stand Height

20"(3)

 
Number of Pedestals

2(4)

1(3)

 
Manufacturer Part Number

0007901(1)

946ANT(1)

82092(1)

84390(1)

84393(1)

84838(1)

84847(1)

PMC4814ES(1)

PMC4814MY(1)

PMC7643ES(1)

PMC7643MY(1)

945ANT(1)

945MEC(1)

946MEC(1)

66949(1)

950ANT(1)

950MEC(1)

SD60B(1)

1943BLSL(1)

1943CYBL(1)

1944NA(1)

1944WH(1)

1958DG(1)

1958TN(1)

DC300(1)

DC400(1)

82016(1)

66948(1)

8080301(1)

4YS4272FAC(1)

HON34962CL(1)

4LF3060FE(1)

4LF3672FE(1)

4LS4272FAC(1)

4XF3066SB(1)

4XF3672FB(1)

4XF3672SE(1)

4YF3672FC(1)

4YF4272FAB(1)

4YF4272FAC(1)

4YS3066FB(1)

14337(1)

66947(1)

16231(1)

16232(1)

16240(1)

48085(1)

66939(1)

66940(1)

66941(1)

66943(1)

66944(1)

66945(1)

66946(1)

DC450(1)

 
Country of Origin

China(25)

Canada(15)

Mexico(10)

Taiwan(4)

 
Height

5.5"(2)

29"(2)

51.50"(2)

20"(2)

35.20"(1)

29.50"(1)

49"(1)

36"(1)

41"(1)

29.75"(1)

31.25"(1)

35.4"(1)

15.5"(1)

 
Width

28"(3)

32.8"(2)

33"(2)

41.38"(1)

48"(1)

29.75"(1)

23.2"(1)

 
Depth

23"(3)

24.3"(2)

30"(2)

23.63"(1)

26"(1)

23.50"(1)

6.2"(1)

 
Color/Finish

Black(6)

Cherry(5)

Bourbon Cherry(4)

Hard Rock Maple(3)

Silver(2)

Charcoal Black(2)

Maple(1)

Mahogany(1)

Laminated(1)

Medium Cherry(1)

 
Maximum Load Capacity

35 lb(3)

150 lb(2)

25 lb(2)

176 lb(1)

127 lb(1)

250 lb(1)

 
Frame Material

Steel(13)

Tubular Steel(2)

Fabric(2)

Metal(1)

 
Base Material

Steel(1)

Aluminum(1)

Tubular Steel(1)

 
Style

Modern(4)

 
Top Material

High Density Fiberboard (HDF)(1)

Medium Density Fiberboard (MDF)(1)

Polyvinyl Chloride (PVC)(1)

Melamine(1)

Carbon Fiber(1)

Fiberboard(1)

 
Frame Color/Finish

Powder Coated(6)

Black(5)

Platinum(3)

Putty(1)

Charcoal Gray(1)

Dark Gray(1)

Tan(1)

 
 
 

© 2023-2024 Office Hub, All Rights Reserved

Powered by Dealer Commander