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

Currently Filtered by

Category

Squeegees

Refine Search
  GO
Brand

Unger(55)

Boardwalk(2)

Rubbermaid Commercial(1)

Magnolia Brush(1)

Impact(1)

Country of Origin

CN(28)

DE(18)

US(14)

For Use With

Unger AL14T(8)

Unger AL140(5)

Opti-Loc Extension Poles (UNGEX250 or UNGED550), both sold separately.(3)

Unger ProAluminum Knock Down Handle(2)

Unger ErgoTec Handle; Unger Pro-Squeegee Handle(2)

Unger Golden Clip Handle;Unger GoldenPRO Handle;ErgoTec SwivelLoc Handle 0 Degree(2)

Unger ES300, GC300, GS300, NE300, PR300(1)

Unger Poles(1)

Unger ES350, GC350, GS350, NE350, PR350(1)

Unger ES450, GC450, GS450, NE450, PR440(1)

Unger ErgoTec Squeegees(1)

Unger Pro Stainless Steel Window Squeegees(1)

Unger ES400, GC400, GS400, NE400, PR400(1)

Aluminum handle UNG-AL14A (sold separately).(1)

Any tapered handle (not included).(1)

Unger GC30, GC45(1)

Rubbermaid Commercial 2018788; Rubbermaid Commercial 2018789; Rubbermaid Commercial 2018823(1)

Unger Pro Stainless Steel Handle;Unger ErgoTec Handle;Unger ErgoTec XL Handle;Unger ErgoTec SwivelLoc Handle 0 Degree;Unger ErgoTec SwivelLoc Handle 30 Degree(1)

AL14A(1)

All Unger Tools(1)

Blade Material

Rubber(30)

Foam Rubber(8)

Stainless Steel/Rubber(2)

Stainless Steel(2)

Aluminum(2)

Rubber; Synthetic Sponge(2)

Neoprene(2)

Rubber;Sponge(1)

Natural Foam;Rubber(1)

Moss Rubber(1)

Blade Width

18"(13)

22"(7)

12"(7)

14"(6)

30"(5)

10"(4)

24"(4)

16"(3)

36"(3)

8"(2)

13.125"(1)

6"(1)

Blade Color

Black(38)

Green(5)

Green/Black(4)

Silver(3)

White(3)

Silver/Black(2)

Black/Red(1)

Red(1)

Silver/Black|C0C0C0(1)

Handle Material

Stainless Steel(8)

Aluminum(6)

Brass(5)

Galvanized Steel(5)

Nylon(4)

Plastic(3)

Zinc Alloy(1)

Metal(1)

Rubber(1)

Cast Zinc(1)

Handle Type

Straight(21)

Grip(4)

Extendable(2)

Contoured(1)

Open Socket(1)

Handle Length

4"(5)

3"(4)

4 1/2"(3)

61"(2)

5 1/2"(1)

56"(1)

8 ft(1)

6"(1)

24"(1)

12"(1)

21"(1)

2" Socket(1)

16"(1)

18"(1)

Special Features

Straight(15)

Straight Handle(2)

Squeegee Handle(1)

Curved(1)

Straight-With black neoprene rubber.(1)

Curved-With black neoprene rubber.(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved

Powered by SITS Erp