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

Currently Filtered by

Category

Clothes Racks

Refine Search

  GO
Brand

Safco(27)

Alba(16)

Quartet(7)

Tatco(2)

Alera(2)

Color

Tropic Sand(1)

Charcoal|36454F(1)

Height

6 3/4"(4)

70"(3)

7"(3)

61 1/2"(3)

2"(3)

5.25"(3)

5.5"(3)

6"(2)

72.75"(2)

75"(2)

61.5"(2)

69 1/3"(2)

70.5"(2)

73.67"(2)

23.67"(2)

69"(1)

70 1/2"(1)

69.33"(1)

54.5"(1)

40"(1)

68.9"(1)

67"(1)

66.25"(1)

69.3"(1)

70.8"(1)

67.5"(1)

19"(1)

25.5"(1)

68.5"(1)

Color(s)

Black(19)

Satin(3)

Brushed Nickel(3)

Mahogany(3)

Steel/Black(3)

Chrome(2)

Medium Oak(2)

Silver Steel/Wood(2)

Satin Metal(2)

Black/Silver(2)

Cream(1)

Brass/Black/White(1)

Silver(1)

Beech(1)

White(1)

Espresso Brown(1)

Chrome/Black(1)

Silver Gray(1)

Black Steel/Plastic(1)

Silver Steel/Black(1)

Chrome Metal(1)

Width

36"(10)

48"(10)

18"(8)

16"(6)

21"(6)

35 1/2"(4)

13.75"(4)

16.5"(4)

10.25"(4)

21 2/3"(4)

14"(4)

15"(4)

10"(2)

14.25"(2)

20 1/2"(2)

26.75"(2)

14.75"(2)

18 1/2"(2)

10.75"(2)

8.5"(2)

6.5"(2)

63.5"(2)

19.75"(2)

21.67"(2)

44.8"(2)

18.88"(2)

12"(2)

49"(2)

24"(2)

7"(2)

Depth

3"(4)

3 1/4"(4)

14"(4)

18 1/2"(4)

21"(3)

2.75"(3)

4.5"(3)

16"(2)

3.75"(2)

16.5"(2)

21.67"(2)

18.5"(2)

14.5"(2)

13.75"(2)

15"(2)

10.25"(2)

18"(2)

10"(1)

12"(1)

19.75"(1)

21.25"(1)

21 1/2"(1)

17 1/2"(1)

21 2/3"(1)

Country of Origin

CN(46)

VN(4)

TW(2)

China(1)

Taiwan(1)

Material(s)

Steel(23)

Metal(13)

Wood(7)

Steel; Wood(3)

Wood/Steel(1)

Plastic; Steel(1)

Chrome Steel; Plastic(1)

Plastic; Powder-Coated Steel(1)

Weight

0.75 lbs(4)

4 lbs(3)

7 lbs(2)

6 lbs(2)

11 lbs(2)

13 lbs(2)

10.5 lbs(2)

5 lbs(1)

7.5 lbs(1)

2 lbs(1)

6.61 ;bs(1)

20.75 lbs(1)

17.75 lbs(1)

Mounting

Stand Alone(33)

Wall(19)

Number of Hangers/Hooks

4 Hooks(4)

4 Ball-Tipped Double-Hooks(3)

10 Hooks(3)

2 Hooks(3)

3 Hooks(3)

5 Hooks(2)

8(2)

3 Double Hooks(2)

2 Double Hooks(2)

3 Hooks for Small Pocket Umbrellas(2)

12 Hooks(2)

5 Knobs(2)

6(2)

3(2)

5 Double Hooks(1)

12 Hangers(1)

8 Nail-Head Hooks(1)

6 Hooks(1)

3 Ball-Tipped Double-Hooks(1)

24 Hangers(1)

8 Knobs(1)

6 Hangers/6 Hooks(1)

2 Hooks; 3 Hangers(1)

10(1)

8 Hooks(1)

6 Hangers/4 Hooks/2 Knobs(1)

12(1)

9 Hooks(1)

18(1)

6 Double Hooks(1)

Base Diameter

14"(5)

21"(3)

13.75"(2)

16.5"(2)

12"(1)

10"(1)

20 1/2"(1)

20"(1)

21.67"(1)

21 1/2"(1)

21 2/3"(1)

15"(1)

Storage

Umbrella Holder(11)

Perforated Shelves; Top Shelf(4)

3 Shelves(2)

3 Umbrella Holders;Boot Shelf;Hat Shelf;Perforated Shelves(2)

Umbrella Bag Holder(1)

Wet Umbrella Bags(1)

Shelf(1)

3 Umbrella Holders; Boot Shelf; Hat Shelf; Perforated Shelves(1)

Rotating Head with Pegs for 10 Garments(1)

Rotating Pegs; Umbrella Holder(1)

Number of Knobs

8(7)

10(4)

4(3)

2(2)

6(2)

5(2)

0(1)

12(1)

3(1)

9(1)

Base/Leg Type

Weighted Rounded Base(5)

Round(3)

Crossed Base(2)

4 Casters (2 Locking)(2)

A-Frame(2)

Tripod(1)

Square(1)

4 Roller Casters(1)

Crossed base(1)

Weighted Base(1)

"X" With Bottom Water Receptacle(1)

Hook Material

Steel(14)

Wood(9)

Metal(8)

Plastic(8)

Aluminum; Steel(3)

Hanger Material

Wood(4)

Steel; Wood(2)

Steel(2)

Brass Plated Metal(1)

Metal(1)

Plastic; Steel(1)

Hanging Capacity

6 Garments(7)

12 Garments(6)

8 Garments(6)

4 Garments(5)

10 Garments(5)

12 Umbrellas(3)

2 Garments(2)

3 Garments(2)

40 Garments(2)

12 Garments; 3 Umbrellas; Boots; Hats(2)

5 Garments(2)

50 Garments(2)

8 Garments; Umbrella(1)

800 Bags(1)

1,000 Bags(1)

Holds up to 18 hangers; Hats(1)

9 Garments; 6 Umbrellas(1)

Holds up to 24 hangers; Hats(1)

8 Garments; 3 Umbrellas; Boots; Hats(1)

16 Garments(1)

Hook Finish

Black(10)

Chrome(5)

Satin Aluminum(3)

Brass(2)

Beech(2)

Mahogany(2)

Brass-Plated(1)

Silver(1)

Wood(1)

Plastic(1)

Brushed Aluminum(1)

Special Features

For use with TCO57010(2)

Without Umbrella Stand(2)

Double-Sided, Two-Shelf Rack-Top and bottom shelves for storing hats and cases.(1)

With Umbrella Stand--Bottom water receptacle.(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved