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 `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` IN ('Compact & Student Desks','Workstations/Computer Desks')) 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 ('Desks' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Desks' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Desks"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Desks"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Desks"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Desks"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+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

Desks

Refine Search

  GO
Brand

Safco(22)

Lorell(19)

Mayline(10)

HON(6)

MooreCo(5)

Early Childhood Resources(3)

Bush(3)

Fellowes(2)

Safco Mayline(2)

Iceberg(1)

Designer Sign Systems(1)

Berries(1)

Kantek(1)

Color

Hansen Cherry(3)

Black(2)

Navy(1)

Frosted/Black(1)

Light Gray(1)

Charcoal(1)

White(1)

Gray(1)

Putty(1)

Recycled

No(10)

Yes(2)

Manufacturer Part Number

950MEC(1)

950ANT(1)

948ANT(1)

1201BE(1)

1202BE(1)

1908BL(1)

1207BE(1)

1206BE(1)

946MEC(1)

946ANT(1)

99915(1)

99914(1)

99893(1)

8350MRANT(1)

8432SOGRYBLK(1)

945MEC(1)

945ANT(1)

8432SOMECBLK(1)

1927CY(1)

1927MO(1)

1951BL(1)

1950WH(1)

1950BL(1)

1951WH(1)

1956BH(1)

1957WL(1)

1957BH(1)

1956WL(1)

1943CYBL(1)

1943BLSL(1)

1929MO(1)

1929GR(1)

1929CY(1)

1935GR(1)

1939EB(1)

1943BHWH(1)

1941TG(1)

87825(1)

84847(1)

8080201(1)

ELR-24103(1)

ELR-24102(1)

8080301(1)

34002RQQ(1)

38247Q(1)

38247L(1)

38246S(1)

ELR-24101(1)

DOWD024888(1)

89843(1)

89829(1)

42551(1)

90082(1)

WC36490-03(1)

WC36492A2-03(1)

WC36492A1-03(1)

LL3060DPMOCH(1)

LL3072DPMOCH(1)

81913(1)

81912(1)

81911(1)

81914(1)

81915(1)

84839(1)

84838(1)

81916(1)

81910(1)

59663(1)

STS240(1)

6310JCS000(1)

72002(1)

14337(1)

14339(1)

59545(1)

48085(1)

25983(1)

Quantity

1 each(1)

Material

Steel(21)

Wood(5)

Metal(4)

Polyvinyl Chloride (PVC)(3)

Laminate(3)

Fiberboard(3)

Polypropylene(2)

Wood Grain Modesty Panel(2)

Particleboard(2)

Metal Handle(2)

Plastic(1)

Thermofoil(1)

Medium Density Fiberboard (MDF)(1)

Polyethylene(1)

Aluminum(1)

Powder Coated Steel(1)

Hardwood(1)

Overall Width

16"(1)

Overall Depth

20"(1)

Overall Height

25 5/8"(1)

Drawer Quantity

3(1)

Material(s)

Tempered Glass; Steel(1)

Laminate; Steel(1)

Engineered Wood(1)

Caster/Glide/Wheel

Adjustable Leveling Glides(1)

Four Casters (Two Locking)(1)

Four Casters(1)

Top Thickness

3/8"(1)

Base Material

Steel(8)

Tubular Steel(2)

Aluminum(2)

Metal(2)

Thermally Fused Laminate Over Engineered Wood(1)

Weight Capacity (text)

200 lbs.(1)

Weight

45 lbs.(1)

Width

30"(2)

32.8"(2)

29.5"(1)

48"(1)

28"(1)

Height

16"(3)

5.5"(2)

30"(2)

Depth

24.3"(2)

20"(1)

18"(1)

Document Size Accommodation

A4; Legal; Letter(1)

Color/Finish

Black(9)

Laminate(7)

Mahogany(7)

Laminated(7)

Latte(3)

Charcoal Black(3)

Gray(3)

Silver(3)

Powder Coated(2)

Mocha(2)

Maple(2)

White(2)

Thermofused Laminate (TFL)(2)

Black Lock(2)

Silver Handle(2)

Medium Oak(1)

Ebony(1)

Rich Cherry(1)

Natural(1)

Beech(1)

Veneer(1)

Cherry(1)

Light Gray(1)

Oak(1)

Navy(1)

Anthracite(1)

Medium Cherry(1)

Top Material

Medium Density Fiberboard (MDF)(4)

Wood Veneer(2)

Fiberboard(2)

Melamine(2)

Kydex(1)

Laminate(1)

Frame Material

Steel(12)

Metal(4)

Tubular Steel(2)

Powder Coated Steel(2)

Top Shape

Rectangular(3)

Height Maximum

63"(2)

49"(1)

42"(1)

Drawer Configuration

Box/Box/File(1)

Height Minimum

41 3/4"(1)

Anti-Tip Mechanism

Yes(1)

Width Maximum

64 1/2"(2)

35"(1)

39 1/2"(1)

Depth Maximum

32 1/4"(2)

23"(1)

23 1/4"(1)

Maximum Load Capacity

150 lb(3)

35 lb(2)

250 lb(1)

100 lb(1)

Height Adjustment

38" to 50"(4)

1" of Printer Shelf(3)

35" to 49" of Workstation(3)

14" of Keyboard Shelf(3)

1" of Storage Shelf(3)

14" of Monitor Shelf(3)

5" of Monitor Shelf(2)

29" to 34" of Workstation(2)

26" to 42" of Tabletop(2)

5" of Keyboard Shelf(2)

28.70" to 40.90"(2)

26" to 42" of Desk(1)

18" to 29"(1)

23.50" to 30.50"(1)

22" to 30" of Work Surface(1)

14" to 48" of Storage Shelf(1)

27" to 38" of Workstation(1)

27" to 38" of Table(1)

27" to 52" of Workstation(1)

Worksurface Platform Width

38 1/2"(1)

Worksurface Platform Depth

23 1/4"(1)

Number of Drawers

1(1)

Frame Color/Finish

Powder Coated(13)

Black(8)

White(1)

Country of Origin

China(32)

Taiwan(22)

United States(16)

CN(4)

TW(1)

Brazil(1)

Price Range

$0-$499.99(86)

$500-$999.99(4)

To  GO

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

© 2018-2019 Supply Owl Office is A Division of Supply Owl, Inc., All Rights Reserved