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

Currently Filtered by

Category

Hangers Hooks

Refine Search

  GO
 
Brand

Command(47)

Safco(11)

Alba(11)

Quartet(3)

Universal(1)

Duck(1)

Adams Manufacturing(1)

 
Height

10 1/2"(4)

3"(4)

3.13"(4)

2 3/8"(4)

3.88"(3)

1.63"(3)

1 5/8"(3)

4.13"(3)

2.16"(3)

7 3/4"(3)

1 1/2"(2)

3 1/4"(2)

3 3/8"(2)

8 1/2"(2)

6.45"(2)

4"(2)

1 1/8"(2)

9 1/4"(1)

Small Picture Strip 2 1/8"; Large Picture Strip 3 5/8"; Small Clear 1 1/8"; Small Wire 1 5/8"; Medium Clear 2 3/8"; Large Clear 3 3/8"(1)

7 1/2"(1)

7 9/10"(1)

9 1/2"(1)

3.25"(1)

5"(1)

6"(1)

2 1/2"(1)

1/8"(1)

5 7/8"(1)

1 1/4"(1)

5 7/10"(1)

9 3/8"(1)

0.63"(1)

6.7"(1)

6 3/4"(1)

3 1/8"(1)

7 7/8"(1)

1 3/8"(1)

1.13"(1)

4 3/10"(1)

4 1/8"(1)

Small: 2.13"; Medium: 3.13"(1)

 
Depth

1"(8)

3/4"(5)

1.13"(4)

0.88"(3)

0.75"(3)

0.83"(3)

7/16"(3)

1 3/8"(3)

3 1/2"(3)

5/8"(2)

1 1/4"(2)

4 1/4"(2)

5 1/4"(2)

2.95"(2)

7/8"(1)

6"(1)

1.63"(1)

1 1/8"(1)

1/4"(1)

2 3/4"(1)

1.25"(1)

6 1/2"(1)

1 3/4"(1)

8"(1)

1.88"(1)

0.63"(1)

1/2"(1)

1.3"(1)

4 3/4"(1)

4 1/2"(1)

8 2/5"(1)

1 3/10"(1)

1.5"(1)

Small:.88"; Medium: 1.13"(1)

1 7/8"(1)

1 1/2"(1)

Small Clear 7/16"; Small Wire 3/4"; Medium Clear 1"; Large Clear 1 1/8"(1)

 
Manufacturer Part Number

17091CLRAWES(1)

17091CLR6ES(1)

17089S8ES(1)

17091CLRCABP(1)

17091CLRES(1)

17232ES(1)

17093CLRAWES(1)

17092CLRES(1)

17089Q8ES(1)

17086SAWES(1)

170812VPES(1)

17069S14NA(1)

17068ES(1)

17081BLKES(1)

17081CABPK(1)

17083ES(1)

17081ES(1)

FC12BNES(1)

FC13BNES(1)

4229BL(1)

4227BL(1)

4225BL(1)

4245CR(1)

4247BL(1)

08607(1)

4250WL(1)

4248BL(1)

4224BL(1)

4167(1)

2015M(1)

MR13SS(1)

MR12SSES(1)

20801(1)

85378(1)

4166(1)

4165(1)

17067MPES(1)

17067ES(1)

283788(1)

1900-99-3241(1)

PMV5(1)

170016ES(1)

17001ES(1)

17002MPES(1)

17001S37NA(1)

17001MPES(1)

PMV3(1)

PMS3P(1)

PMCINHANG12(1)

PMCIN6(1)

PM2PARTBO(1)

PMMAG(1)

PMMOUSPART(1)

PMPRO5M(1)

PMPRO3M(1)

170033ES(1)

17003ES(1)

17065S35NA(1)

17065CLRVPES(1)

17061BNES(1)

17065VPES(1)

17066ES(1)

17067CLRES(1)

17067CLR9ES(1)

170679ES(1)

17053BNES(1)

17051BNES(1)

17006CLR18ES(1)

17005ES(1)

17003MPES(1)

17006CLRES(1)

17017CLRAWES(1)

17034MB2ES(1)

17034BN2ES(1)

PM1PARTBO(1)

 
Country of Origin

CN(39)

MX(29)

TW(4)

US(3)

 
Width

0.88"(7)

1"(5)

17"(5)

7/8"(5)

3/4"(5)

1.13"(4)

0.75"(3)

1.25"(3)

1 1/2"(3)

1 3/4"(3)

1 1/8"(2)

1 1/4"(2)

24 1/8"(2)

1 1/5"(2)

1.5"(2)

5/8"(1)

1 3/8"(1)

4 1/4"(1)

18"(1)

16 3/4"(1)

4"(1)

Small Picture Strip 5/8"; Large Picture Strip 1/2"; Small Clear Hook 7/8"; Small Wire Hook 3/4"; Medium Clear Hook: 1"; Large Clear Hook: 1 3/8"(1)

1.63"(1)

Small: 1"; Medium: 1.13"(1)

3 4/5"(1)

18.11"(1)

15"(1)

3 1/8"(1)

16 4/5"(1)

29.92"(1)

6 3/4"(1)

4.3(1)

1.75"(1)

3.8"(1)

5/16"; 3/4"(1)

1 5/8"(1)

 
Weight

0.11 lbs(1)

1.98 lb(1)

1.32 lb(1)

 
Capacity (Weight)

3 lbs(11)

0.5 lb(8)

2 lb(6)

5 lbs(6)

1 lb(3)

3 lb(3)

4 lb(2)

0.25 lbs(2)

2 lbs(2)

45 lb(2)

22 lb(2)

Small: 1 lb; Medium: 3 lbs(1)

25 lb(1)

Picture Strips: 4-16 lbs; Small Hook: 05. lbs; Medium Hook: 2 lbs; Large Hook: 4 lbs(1)

5 lb(1)

0.5 lb; 3 lb; 5 lb(1)

11 lbs(1)

20 lb(1)

10 lb(1)

1.5 lb(1)

 
Mounting

Wall(29)

Adhesive(23)

Hanging(2)

Over-the-Panel(2)

Magnetic(2)

Over-the-Door/Over-the-Panel(1)

Over-the-Door(1)

Microsuction Synthetic Rubber(1)

Over The Door; Over The Panel(1)

Command Strips(1)

 
Number of Hangers/Hooks

1(20)

2(14)

6(7)

3(5)

8(4)

12(3)

14(2)

9(2)

24(2)

16(2)

50(1)

4(1)

10(1)

15 Hooks; 16 Picture Strips(1)

1 Double Coat Hook(1)

28(1)

7(1)

5(1)

37(1)

18(1)

35(1)

20(1)

3; 1(1)

 
Finish

Black(9)

Brushed Nickel(2)

Chrome(2)

Metallic Gray(2)

Powder Coat(1)

Walnut(1)

Satin Aluminum(1)

Matte(1)

Silver/Black(1)

Powder Coat; ABS(1)

 
Hook Material

Plastic(39)

Metal(15)

Steel(6)

Plastic/Metal(3)

Wood(2)

Wood; Steel(2)

Plastic; Plastic/Metal(1)

Metal;Foam;ABS(1)

 
Hanger/Hook Type

Hook(53)

Hanger(8)

Wire Hook(3)

Spring Clip(3)

Over The Panel, Double Hook(2)

Over The Panel(2)

Over The Door, Double Hook(1)

Hook; Wire Hook(1)

Over The Door(1)

Over The Panel, Single Hook(1)

 
Hook Color

White(21)

Clear(15)

Silver(9)

Black(8)

Brushed Nickel(4)

Brown/Silver(2)

Chrome(2)

Charcoal(1)

silver(1)

Slate(1)

Matte Black(1)

Black; Green(1)

 
Hanger Material

Plastic(44)

Metal(7)

Plastic/Metal(2)

Wood(1)

Steel(1)

Molded Plastic(1)

Metal; Plastic(1)

Wood;Steel(1)

 
Hook Base Material

Plastic(46)

Metal(5)

Steel(3)

Silver(1)

Aluminum(1)

Rubber(1)

Plastic/Metal(1)

 
Hanger Color

White(21)

Clear(14)

Brushed Nickel(8)

Black(7)

Metallic Gray(3)

Chrome(2)

Slate(2)

Walnut(1)

Matte Black(1)

Black;Silver(1)

Quartz(1)

 
 
 

© 2019-2020 BonTay, Inc., All Rights Reserved