facebook
 
 
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_name` IN ('Air Dusters','CD/DVD Cleaner/Maintenance','Computer Cloths/Wipes & Dusters','Computer Dust Covers','Computer Vacuum Cleaners & Accessories','Drive Cleaners','Electronic Cleaners/Anti-Static Sprays','Tool Kits','Air Duster Refills','Cleaning Kits','Cleaning Sheets')) 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_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 '%CleaningandMaintenance' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('CleaningandMaintenance' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+CleaningandMaintenance' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"CleaningandMaintenance"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"CleaningandMaintenance"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"CleaningandMaintenance"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"CleaningandMaintenance"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+CleaningandMaintenance' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='CleaningandMaintenance',`category_4` ='CleaningandMaintenance') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'CleaningandMaintenance,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('CleaningandMaintenance', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Cleaning And Maintenance

Refine Search

  GO
 
Brand

Read Right(9)

Falcon(7)

Business Source(6)

Dust-Off(4)

Weiman(3)

Rubbermaid Commercial(3)

Genuine Joe(2)

Advantus(2)

Allsop(2)

Fellowes(2)

Bausch & Lomb(1)

Ettore(1)

Compucessory(1)

Brother(1)

Royal Sovereign(1)

Stanley(1)

Urnex(1)

 
Color

Gray(9)

Multi(8)

White(7)

Black(3)

Assorted(2)

Blue(1)

Green(1)

Clear(1)

 
Recycled

No(42)

 
Height

8"(2)

7.3"(1)

0.3"(1)

11.3"(1)

5"(1)

4"(1)

 
Depth

3"(1)

4.3"(1)

 
Manufacturer Part Number

4111100(1)

RR1245(1)

22555(1)

1928023(1)

1928756(1)

Q050000000(1)

RR1205(1)

RR1217(1)

RR1222(1)

RR1243(1)

RR1305(1)

99680(1)

RR15039(1)

RR15044(1)

RR15059(1)

RR3507(1)

RR3700(1)

RBC-CLN(1)

701354(1)

701354CT(1)

703457(1)

11963(1)

49106(1)

4111200(1)

2510(1)

8565(1)

92-680(1)

24302(1)

24305(1)

24306(1)

24308(1)

24309(1)

24310(1)

56268(1)

DE07521(1)

HCN2(1)

DE10521(1)

DE10522PW(1)

DE10526(1)

DPNXL(1)

DPNXL2(1)

DPS(1)

DPSJC(1)

DPSJMB(1)

DPSJMB2(1)

703457CT(1)

 
Country of Origin

United States(39)

China(4)

Taiwan(2)

Germany(1)

 
Width

6"(2)

3.5"(1)

2"(1)

8.5"(1)

2.1"(1)

8.3"(1)

 
Material

MicroFiber(3)

Polyurethane(1)

 
Limited Warranty

1 Year(3)

 
Weight (Approximate)

10 oz(5)

1.06 lb(2)

2.50 lb(1)

3.50 oz(1)

2.88 lb(1)

2.08 oz(1)

0.25 oz(1)

 
Length

6"(2)

78.7"(1)

0.1"(1)

1.5"(1)

 
Recommended Use

Dust Remover(11)

Dirt Remover(7)

Oil Remover(5)

Residue Remover(4)

Microbe Remover(2)

Soil Remover(2)

Limescale Remover(2)

Smudge Remover(1)

Spill Remover(1)

Fingerprint Remover(1)

Lint Remover(1)

 
Composition

Bleach(1)

 
Number of Pieces

55(1)

 
Cleaner Volume

2 fl oz(2)

8 fl oz(1)

 
Cleaner Weight

10 oz(9)

5 oz(1)

7 oz(1)

 
Quantity Per Container

160(1)

 
Product Type

Cleaning Kit(11)

Air Duster(11)

Cleaning Spray(7)

Cleaning Card(3)

Repair Kit(2)

Surface Cleaner(2)

Cleaning Pad(2)

Cleaning Swab(2)

Cleaning Ball(2)

Head Cleaner(1)

Service Kit(1)

Dust Cover(1)

Water Cooler Plumb Kit(1)

Cleaning Wipe(1)

 
Packaged Quantity

1 Each(17)

2 / Pack(5)

6 / Pack(3)

1 Kit(3)

1(2)

24 / Box(2)

25 / Box(2)

640 / Pack(1)

28 / Box(1)

80 / Box(1)

50 / Box(1)

10 / Pack(1)

15 / Pack(1)

5 / Box(1)

60 / Carton(1)

12 / Carton(1)

 
Assembly Required

No(43)

 
Product Model

BOS92680(1)

CK-1000(1)

DPNXL(1)

DPNXL2(1)

DPS(1)

DPSJC(1)

DPSJMB(1)

DPSJMB2(1)

 
Product Line

Dust-Off(6)

HYGEN(2)

Sight Savers(1)

Premium(1)

KeyKleen(1)

KleenSwab(1)

Office Duster(1)

 
Cleaner Type

Cloth(2)

 
Package Type

Box(1)

 
Container Type

Can(3)

Spray Bottle(1)

Tub(1)

Aerosol Spray Can(1)

 
Cleaner Size

8.90" Width x 11.90" Length(1)

7.20" Width x 10.80" Length(1)