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

Safco(18)

Lorell(6)

Quartet(5)

Command(4)

Advantus(3)

Fellowes(3)

Alba(1)

Artistic(1)

Deflecto(1)

3M(1)

Onyx(1)

 
Color

Black(14)

Silver(9)

White(4)

Hook(3)

Black Hanger(2)

Charcoal(2)

Gray(2)

Charcoal Gray(2)

Slate Gray(1)

Brass(1)

Black Hook(1)

Gray Hook(1)

Walnut(1)

Black Powder Coat(1)

Chrome(1)

Black Base(1)

Cherry(1)

 
Recycled

No(40)

Yes(1)

 
Height

70"(4)

61.5"(3)

2"(3)

7"(3)

8.5"(2)

6.5"(2)

5.5"(2)

68"(2)

17"(1)

63.4"(1)

3.9"(1)

4.5"(1)

6"(1)

3"(1)

6.1"(1)

67"(1)

68.4"(1)

5"(1)

72.8"(1)

 
Depth

3"(3)

1.8"(2)

2.8"(2)

3.8"(2)

21"(2)

4.3"(2)

2.6"(2)

0.7"(1)

2.5"(1)

4.1"(1)

5.1"(1)

20"(1)

0.9"(1)

14.5"(1)

16.5"(1)

 
Diameter

15"(1)

 
Manufacturer Part Number

PMCINMET(1)

4191NC(1)

4160(1)

4161(1)

4162(1)

4163BL(1)

4163CR(1)

4166(1)

4167(1)

4168BL(1)

4200(1)

20225(1)

4201(1)

4202(1)

4214BL(1)

4229BL(1)

4255CH(1)

4256BL(1)

4257CH(1)

6401BL(1)

20314(1)

20224(1)

1309(1)

01065(1)

40804(1)

40807(1)

40808(1)

36809(1)

22315(1)

7501101(1)

75510(1)

01064(1)

02587(1)

2015M(1)

02872(1)

69880(1)

80665(1)

17001MPES(1)

17002MPES(1)

17003MPES(1)

17067MPES(1)

3PH15M5ES(1)

2013(1)

6402BL(1)

 
Country of Origin

China(35)

Mexico(4)

Taiwan(3)

United States(2)

 
Width

36"(3)

1.5"(3)

18"(2)

48"(2)

4"(2)

21"(2)

8.5"(1)

16.5"(1)

4.3"(1)

14.5"(1)

12"(1)

18.1"(1)

6.5"(1)

1.8"(1)

19"(1)

17"(1)

1.6"(1)

7"(1)

14.8"(1)

 
Material

Steel(11)

Steel Hook(7)

Plastic(4)

Aluminum(4)

Metal(3)

Aluminum Base(3)

Wood(3)

Metal Hook(2)

Wire(2)

Plastic Hanger(2)

Wooden Tip(2)

Wood Tip(1)

Metal Base(1)

Brass Hook(1)

Solid Wood(1)

Brass(1)

Metal Wire(1)

Cast Aluminum(1)

Steel Frame(1)

 
Limited Warranty

Lifetime(18)

90 Day(3)

5 Year(3)

5 Year Lifetime(3)

3 Year(1)

1 Year(1)

 
Weight (Approximate)

8 oz(2)

8.50 lb(2)

1 lb(2)

3.84 oz(1)

6.56 oz(1)

17 lb(1)

2 lb(1)

18 lb(1)

 
Length

18"(1)

 
Style

Contemporary/Modern(2)

 
Placement

Freestanding(1)

Surface(1)

 
Weight Capacity

10 lb (4.54 kg)(4)

80 lb (36.29 kg)(3)

15 lb (6.80 kg)(2)

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)

20 lb (9.07 kg)(1)

30 lb (13.61 kg)(1)

60 lb (27.22 kg)(1)

 
Mount Type

Wall(7)

Surface(2)

 
Total Number of Hooks

2(9)

4(5)

1(4)

3(4)

6(3)

8(3)

14(1)

28(1)

9(1)

 
Product Type

Hook(17)

Tree Hook Stand(10)

Hook Panel(10)

Hanger(4)

Garment Rack(3)

 
Packaged Quantity

1 Each(35)

20 / Pack(2)

1 / Each(1)

2 / Pack(1)

24 Pack(1)

12 Set(1)

24 / Pack(1)

28 / Pack(1)

5 Each(1)

 
Assembly Required

No(27)

Yes(17)

 
Product Model

4163(2)

4166(1)

4191(1)

4256BL(1)

 
Product Line

Partition Additions(3)

CLAW(1)

Mode(1)

 
Finishing

Powder Coated(5)

Metal(1)

Chrome(1)

Walnut(1)

 
Hook Size

1"(3)

3"(2)

2.50"(2)

7"(1)

4.38"(1)

5.38"(1)