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

Currently Filtered by

Category

Garment Care

Refine Search

  GO
Brand

Rainbow Accents(45)

Safco(39)

Jonti-Craft(11)

young Time(10)

Quartet(9)

Alba(6)

Lorell(5)

ECR4KIDS(4)

Command(4)

Advantus(3)

Fellowes(3)

Onyx it!(1)

Artistic(1)

deflecto(1)

Buddy(1)

Color

Black(29)

Baltic(20)

Silver(17)

Purple(5)

Blue(5)

Teal(5)

Yellow(5)

Green(5)

Orange(5)

Red(5)

Navy(4)

Natural(4)

White(4)

Navy Blue(4)

Hook(3)

Charcoal(3)

Cherry(3)

Mahogany Base(3)

Black Hook(2)

Black Hanger(2)

Charcoal Gray(2)

Brown(2)

Brass Hook(2)

Chrome Hook(2)

Oak Base(2)

Chrome(1)

Cream(1)

Mahogany(1)

Black Base(1)

Wood Grain(1)

Green Hook(1)

Brass(1)

Slate Gray(1)

Gray Hook(1)

Metallic Holder(1)

Black Peg(1)

Walnut(1)

Gray(1)

Chrome Base(1)

Black Powder Coat(1)

Recycled

No(137)

Yes(1)

Manufacturer Part Number

2015M(1)

20213(1)

20214(1)

2013(1)

17067MPES(1)

17002MPES(1)

17003MPES(1)

20224(1)

20225(1)

4160(1)

4161(1)

4162(1)

4148CH(1)

20702(1)

20314(1)

20701(1)

17001MPES(1)

80665(1)

7040YR441(1)

7040YT441(1)

7045YR441(1)

7025YT441(1)

7025YR441(1)

6686JCWW119(1)

6686JCWW180(1)

7045YT441(1)

7104YR441(1)

01065(1)

02587(1)

69880(1)

01064(1)

7106YT441(1)

7104YT441(1)

7106YR441(1)

4163BL(1)

4163CR(1)

4229BL(1)

4240MH(1)

4246CR(1)

4228BL(1)

4226BL(1)

4217MH(1)

4217MO(1)

4255CH(1)

4256BL(1)

4663BL(1)

6401BL(1)

6402BL(1)

4601GR(1)

4601BL(1)

4256CRM(1)

4257CH(1)

4216MO(1)

4216MH(1)

4192NC(1)

4193CY(1)

4200(1)

4191NC(1)

4168BL(1)

4166(1)

4167(1)

4201(1)

4202(1)

4214BL(1)

4214CY(1)

4214MH(1)

4212BL(1)

4205SL(1)

4203SL(1)

4204SL(1)

6686JCWW114(1)

6686JCWW112(1)

0268JCWW007(1)

0268JCWW008(1)

0268JCWW112(1)

0268JCWW005(1)

0268JCWW004(1)

0268JC(1)

0268JCWW003(1)

0268JCWW114(1)

0268JCWW119(1)

0468JCWW007(1)

0468JCWW008(1)

0468JCWW112(1)

0468JCWW005(1)

0468JCWW004(1)

0268JCWW180(1)

0468JCWW003(1)

75510(1)

7501101(1)

PMS3P(1)

1309(1)

40804(1)

PMHOOK2(1)

PMHOOK1(1)

PM2PARTBO(1)

PMCINMET(1)

40807(1)

40808(1)

ELR-17232(1)

ELR-17233(1)

22315(1)

ELR-17231(1)

ELR-17230(1)

9299-17(1)

36809(1)

0468JCWW114(1)

0468JCWW119(1)

4682JCWW008(1)

4682JCWW112(1)

4682JCWW114(1)

4682JCWW007(1)

4682JCWW005(1)

4682JCWW003(1)

4682JCWW004(1)

4682JCWW119(1)

4682JCWW180(1)

6686JCWW005(1)

6686JCWW007(1)

6686JCWW008(1)

6686JCWW004(1)

6686JCWW003(1)

5141JC(1)

6686JC(1)

4682JC(1)

2687JC(1)

2681JCWW005(1)

2681JCWW007(1)

2681JCWW008(1)

2681JCWW004(1)

2681JCWW003(1)

0468JCWW180(1)

2681JC(1)

2681JCWW112(1)

2681JCWW114(1)

26858JC(1)

26859JC(1)

2685JC(1)

26857JC(1)

2682JC(1)

2681JCWW119(1)

2681JCWW180(1)

PM1PARTBO(1)

Material

Steel(19)

Steel Hook(13)

Wood(11)

Metal(6)

Metal Hook(6)

Wood Base(5)

Birch(4)

Aluminum(4)

Aluminum Base(3)

Medium Density Fiberboard (MDF)(3)

Plastic(3)

Birch Plywood(3)

Plastic Hook(3)

Acrylic(3)

Polycarbonate(2)

Steel Frame(2)

Wooden Tip(2)

Wood Tip(2)

Solid Wood(2)

Polypropylene(2)

Plastic Hanger(2)

Baltic Birch Plywood(2)

Cast Aluminum(1)

Brass(1)

ABS Plastic Peg(1)

Brass Hook(1)

Plastic Cap(1)

Wood Hook(1)

Metal Wire(1)

Steel Pole(1)

Steel Base(1)

Steel Plate(1)

Metal Base(1)

Width

48"(34)

20"(11)

39"(10)

24"(10)

36"(4)

60"(4)

18"(4)

14.5"(3)

1.5"(3)

16.5"(2)

40.3"(2)

35.5"(2)

17"(2)

21"(2)

2.4"(2)

1.8"(2)

4"(2)

22"(2)

0.9"(2)

26"(2)

7"(2)

18.5"(1)

17.1"(1)

4.3"(1)

21.5"(1)

14.8"(1)

8.5"(1)

18.1"(1)

10.8"(1)

6.5"(1)

7.9"(1)

19"(1)

14"(1)

15"(1)

14.3"(1)

1.6"(1)

12"(1)

37.5"(1)

Height

50.5"(55)

48"(6)

61.5"(5)

6.8"(5)

70"(4)

26.5"(4)

2"(3)

7"(3)

5.3"(2)

20"(2)

5"(2)

4.6"(2)

6.5"(2)

58.8"(2)

21.5"(2)

72.8"(2)

68.8"(2)

68"(2)

67"(2)

69"(2)

5.5"(2)

8.5"(2)

13"(1)

9.5"(1)

19"(1)

68.4"(1)

3.9"(1)

4.5"(1)

67.5"(1)

0.9"(1)

3.7"(1)

7.8"(1)

6.1"(1)

3"(1)

63.4"(1)

17"(1)

25"(1)

6"(1)

7.3"(1)

Depth

15"(30)

17.5"(30)

12"(7)

3.3"(4)

4.3"(3)

3"(3)

14.5"(3)

5.3"(2)

21"(2)

3.8"(2)

4.5"(2)

7.9"(2)

2.8"(2)

2.6"(2)

1.8"(2)

29.8"(2)

13"(2)

26"(2)

16.5"(2)

2.3"(1)

0.2"(1)

18.5"(1)

20"(1)

7.3"(1)

4.6"(1)

0.7"(1)

14"(1)

2.5"(1)

0.9"(1)

5.1"(1)

4.1"(1)

16"(1)

Length

18"(1)

Style

Contemporary/Modern(2)

Modern(2)

Thickness

159.1 mil(1)

Number of Tiers

4(3)

Placement

Wall(8)

Wall Mountable(5)

Door(2)

Floor(1)

Freestanding(1)

Surface(1)

Maximum Load Capacity

20 lb(1)

Weight Capacity

10 lb (4.54 kg)(6)

80 lb (36.29 kg)(4)

20 lb (9.07 kg)(2)

60 lb (27.22 kg)(2)

40 lb (18.14 kg)(1)

30 lb (13.61 kg)(1)

8 oz (226.8 g)(1)

5 lb (2.27 kg)(1)

44.09 lb (20 kg)(1)

66.14 lb (30 kg)(1)

15 lb (6.80 kg)(1)

3 lb (1.36 kg)(1)

1 lb (453.6 g)(1)

Country of Origin

United States(71)

China(62)

Taiwan(6)

Mexico(4)

Price Range

$0-$499.99(108)

$500-$999.99(47)

To  GO

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

© 2018-2019 Shop Our Solutions is a Division of American Office Solutions,Inc., All Rights Reserved