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

Currently Filtered by

Category

Sprayers Hoses And Nozzles

Refine Search

  GO
 
Brand

TOLCO(4)

Boardwalk(2)

Coastwide Professional(2)

Diversey(2)

Impact(2)

SC Johnson Professional(2)

Clorox(1)

Genuine Joe(1)

3M(1)

Solo Inc.(1)

Unger(1)

 
Packaged Quantity

1 Each(1)

24 / Carton(1)

 
Compatibility

Clorox TurboPro Disinfectant Cleaner(1)

 
For Use With

SC Johnson Professional TruShot 2.0 Concentrate Cartridges(2)

PDC(2)

Coastwide Professional Concentrated Cleaning Products for the ExpressMix System(1)

Coastwide Professional ExpressMix Chemicals(1)

Common Garden Hoses(1)

Diversey 3481057, 3719563, 3481049(1)

Standard Gallon Containers(1)

5-gal Pails; Standard Gallon Containers(1)

3M Twist ’n Fill System Chemical Concentrates(1)

Standard Faucet(1)

 
Country of Origin

US(14)

TW(2)

United States(1)

CN(1)

Korea(1)

 
Height

4.1"(1)

 
Width

14.3"(1)

 
Depth

10.8"(1)

 
Color(s)

White(5)

Gray(3)

Clear/Green(2)

Translucent White/Black(2)

White/Gold(1)

Gray/Natural(1)

Clear/White(1)

 
Material(s)

Plastic(6)

High-Density Polyethylene (HDPE)(4)

PVC(2)

ABS Plastic; Brass; Steel(1)

PVC/Rubber(1)

 
Hose Length

6 ft(3)

10.75"(2)

3.75"; 36"(1)

5 ft(1)

48"(1)

32"(1)

28"(1)

30"(1)

 
Sprayer/Hose/Nozzle Type

Tank Sprayer(4)

Dispense System/Hose(3)

Sprayer(3)

Water Hose(2)

Dispenser Pump(2)

Hose/Nozzle Kit(1)

Sprayer Kit(1)

Hose(1)

 
Sprayer/Nozzle Type

Adjustable(4)

Quick Connect(2)

Pump(2)

Trigger(2)

Measure Nozzle(1)

Plastic Foaming Nozzle(1)

Switch(1)

0.4 gpm Brass 80 Flat Fan Nozzle; Adjustable Plastic Nozzle; Hollow Cone Nozzle; Jet Stream Nozzle(1)

 
Tank Capacity

1.06 quart(1)

 
Nozzle/Sprayer Settings

Adjustable Fine Mist to Stream(4)

On/Off(2)

(4) Spray-Dilution Product Selections; (4) Mop-Bucket-Dilution Product Selections(1)

 
Connection Type

(4) Screw-Cap Pick-Up Hoses (Concentrate); (1) Tap Hose (Water-Line)(1)

Brass Fittings(1)

Screw Cap(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved