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 ('Coat/Garment Racks','Coat/Garment Hangers','Coat/Garment Hooks')) 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 '%GarmentCare' THEN 1 ELSE 0 END DESC, 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(15)

Jonti-Craft(11)

young Time(10)

Lorell(5)

Quartet(5)

Command(4)

Advantus(3)

Fellowes(2)

Deflecto(1)

ECR4KIDS(1)

Onyx it!(1)

 
Color

Baltic(20)

Black(15)

Silver(9)

Teal(5)

Orange(5)

Red(5)

Yellow(5)

Green(5)

Purple(5)

Blue(5)

Navy Blue(4)

White(4)

Navy(4)

Hook(3)

Black Hanger(2)

Charcoal(2)

Charcoal Gray(2)

Cherry(1)

Wood Grain(1)

Natural(1)

Gray Hook(1)

Black Hook(1)

Walnut(1)

Black Powder Coat(1)

Black Base(1)

Cream(1)

 
Recycled

No(99)

Yes(1)

 
Height

50.5"(55)

26.5"(4)

7"(3)

48"(3)

61.5"(3)

72.8"(2)

5"(2)

21.5"(2)

20"(2)

2"(2)

68"(2)

70"(2)

4.5"(1)

68.4"(1)

5.3"(1)

8.5"(1)

63.4"(1)

3.9"(1)

17"(1)

25"(1)

6"(1)

6.1"(1)

6.5"(1)

5.5"(1)

 
Depth

15"(30)

17.5"(29)

12"(7)

1.8"(2)

3"(2)

2.6"(2)

4.3"(2)

3.8"(2)

16.5"(2)

0.9"(1)

2.5"(1)

5.1"(1)

4.1"(1)

13"(1)

4.5"(1)

14.5"(1)

20"(1)

 
Manufacturer Part Number

40804(1)

7040YR441(1)

02587(1)

01065(1)

01064(1)

7106YT441(1)

7106YR441(1)

7104YT441(1)

7104YR441(1)

7045YT441(1)

7045YR441(1)

7040YT441(1)

7025YT441(1)

80665(1)

7025YR441(1)

6686JCWW180(1)

6686JCWW119(1)

6686JCWW114(1)

6686JCWW112(1)

6686JCWW008(1)

6686JCWW007(1)

6686JCWW005(1)

6686JCWW004(1)

6686JCWW003(1)

69880(1)

17001MPES(1)

5141JC(1)

4168BL(1)

4257CH(1)

4256CRM(1)

4256BL(1)

4255CH(1)

4229BL(1)

4214BL(1)

4205SL(1)

4203SL(1)

4202(1)

4201(1)

4166(1)

17002MPES(1)

4162(1)

4161(1)

4160(1)

20314(1)

20225(1)

20224(1)

2015M(1)

2013(1)

17067MPES(1)

17003MPES(1)

6686JC(1)

4682JCWW180(1)

40807(1)

0268JCWW112(1)

0468JCWW114(1)

0468JCWW112(1)

0468JCWW008(1)

0468JCWW007(1)

0468JCWW005(1)

0468JCWW004(1)

0468JCWW003(1)

0268JCWW180(1)

0268JCWW119(1)

0268JCWW114(1)

0268JCWW008(1)

0468JCWW180(1)

0268JCWW007(1)

0268JCWW005(1)

0268JCWW004(1)

0268JCWW003(1)

0268JC(1)

75510(1)

22315(1)

ELR-17231(1)

36809(1)

40808(1)

0468JCWW119(1)

2681JC(1)

4682JCWW119(1)

26859JC(1)

4682JCWW114(1)

4682JCWW112(1)

4682JCWW008(1)

4682JCWW007(1)

4682JCWW005(1)

4682JCWW004(1)

4682JCWW003(1)

4682JC(1)

2687JC(1)

2685JC(1)

26858JC(1)

2681JCWW003(1)

26857JC(1)

2682JC(1)

2681JCWW180(1)

2681JCWW119(1)

2681JCWW114(1)

2681JCWW112(1)

2681JCWW008(1)

2681JCWW007(1)

2681JCWW005(1)

2681JCWW004(1)

6402BL(1)

 
Country of Origin

United States(67)

China(28)

Mexico(4)

Taiwan(4)

 
Width

48"(33)

20"(11)

39"(10)

24"(10)

60"(4)

36"(3)

4"(2)

18"(2)

16.5"(2)

7"(2)

1.5"(2)

4.3"(1)

14.5"(1)

14.3"(1)

19"(1)

6.5"(1)

1.8"(1)

17"(1)

22"(1)

14.8"(1)

 
Material

Steel Hook(9)

Steel(7)

Wood(6)

Metal Hook(4)

Plastic(3)

Acrylic(3)

Birch Plywood(3)

Medium Density Fiberboard (MDF)(3)

Aluminum Base(3)

Metal(2)

Wood Tip(2)

Wooden Tip(2)

Aluminum(2)

Steel Frame(2)

Plastic Hanger(2)

Baltic Birch Plywood(2)

Wire(2)

Solid Wood(1)

Brass Hook(1)

Metal Base(1)

Birch(1)

Metal Wire(1)

 
Limited Warranty

Lifetime(85)

5 Year(4)

90 Day(3)

 
Weight (Approximate)

152 lb(18)

80 lb(9)

122 lb(9)

149 lb(9)

160 lb(2)

8 oz(2)

33 lb(1)

1.76 lb(1)

2 lb(1)

1 lb(1)

51 lb(1)

86 lb(1)

64 lb(1)

147 lb(1)

62 lb(1)

141 lb(1)

150 lb(1)

59 lb(1)

123 lb(1)

105 lb(1)

6.56 oz(1)

18 lb(1)

 
Length

18"(1)

 
Style

Contemporary/Modern(2)

 
Placement

Wall(5)

Wall Mountable(3)

Freestanding(1)

Surface(1)

Floor(1)

 
Total Number of Compartments

5(21)

2(14)

4(10)

10(2)

8(1)

 
Weight Capacity

10 lb (4.54 kg)(4)

3 lb (1.36 kg)(1)

1 lb (453.6 g)(1)

5 lb (2.27 kg)(1)

8 oz (226.8 g)(1)

40 lb (18.14 kg)(1)

30 lb (13.61 kg)(1)

60 lb (27.22 kg)(1)

 
Number of Tiers

4(3)

 
Total Number of Hooks

2(7)

4(6)

3(4)

6(3)

1(2)

14(1)

28(1)

9(1)

8(1)

 
Product Type

Storage Rack(66)

Hook(12)

Hook Panel(11)

Tree Hook Stand(8)

Garment Rack(4)

Hanger(2)

 
Packaged Quantity

1 Each(89)

1 / Each(5)

24 / Pack(2)

20 / Pack(2)

2 / Pack(1)

8 / Each(1)

12 / Set(1)

28 / Pack(1)

 
Assembly Required

Yes(67)

No(36)

 
Product Model

4166(1)

4205SL(1)

4256BL(1)

 
Product Line

Partition Additions(2)

Neat-n-Trim(2)

Mode(1)

 
Finishing

UV Acrylic(5)

Powder Coated(5)

Brushed Nickel(2)

Chrome(1)

Walnut(1)

 
Package Type

OEM(1)

 
Item Capacity

4 x Coat(1)

 
Hook Size

1"(2)

7"(1)

3"(1)