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

Currently Filtered by

Category

Mounting Putty

Refine Search

  GO
 
Brand

PURELL®(2)

Staedtler(2)

Duck Brand(2)

VELCRO® Brand(1)

Velcro(1)

Lorell(1)

Elmer's(1)

MooreCo(1)

Scotch(1)

 
Color

White(7)

Black(2)

Silver(1)

 
Recycled

No(7)

 
Packaged Quantity

1 Each(6)

4 / Pack(2)

84 / Pack(1)

48 / Carton(1)

1 Pack(1)

 
Weight (Approximate)

2.12 oz(1)

3 oz(1)

1.98 oz(1)

2 oz(1)

29 lb(1)

 
Compatibility

Purell ES Dispenser Everywhere System(1)

Purell ES Everywhere System(1)

  • LCD TV
  • Plasma TV
  • Flat Panel TV
(1)

 
Special Features

Bars(1)

 
Durability

Stain Resistant(1)

 
Device Supported

Sanitizing Dispenser(2)

Cable(1)

Flat Panel Display(1)

 
Maximum Screen Size Supported

61"(1)

 
Quantity Per Container

4(1)

 
Manufacturer Part Number

99681(1)

860(1)

99683(1)

91396(1)

91404(1)

25991(1)

584008WHT(1)

PTY-2(1)

PTY2CT(1)

98620(1)

583008BLK(1)

66587(1)

 
Country of Origin

United States(6)

China(2)

Germany(2)

GB(1)

United Kingdom(1)

 
Height

21.3"(1)

 
Width

42"(1)

 
Depth

11.5"(1)

 
Maximum Load Capacity

220 lb(1)

 
Capacity (Volume)

2 oz(1)

 
Tape Length

0.50"(1)

 
Tape Width

0.50"(1)

2"(1)

 
Backing Material

Adhesive(1)

 
Container Type

Pack(1)

 
Dispenser Included

No(1)

 
For Use On

Adheres Paper to Clean Dry Surfaces(1)

 
 
 

© 2018-2019 Rhino Office Products, All Rights Reserved