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

Currently Filtered by

Category

Air Freshener Dispensers

Refine Search

  GO
Brand

Rubbermaid Commercial(21)

TimeMist(13)

Air Wick(9)

Fresh Products(6)

Diversey(4)

Georgia Pacific Professional(3)

Renuzit(2)

Febreze(2)

Nature's Air(2)

Scott(2)

Boardwalk(2)

Clorox(1)

Chase Products(1)

AbilityOne(1)

HOSPECO(1)

OdoBan(1)

Height

7.5"(5)

8"(4)

7.76"(4)

8.75"(4)

8.25"(4)

4"(4)

3.75"(3)

9"(3)

4.09"(2)

5"(2)

9.5"(2)

6.6"(2)

8.6"(2)

9.25"(2)

3.63"(2)

7.25"(2)

5.9"(1)

5.4"(1)

5.75"(1)

7 3/4"(1)

8.63"(1)

5.25"(1)

10.5"(1)

1.5"(1)

6"(1)

4.75"(1)

5.7"(1)

3"(1)

5.34"(1)

10 3/4"(1)

8.5"(1)

6.83"(1)

7"(1)

Color(s)

White(46)

Black(8)

Chrome(2)

Off White(2)

Silver(2)

Gray Pearl/White(1)

Black; Chrome(1)

Black/White(1)

Off-White(1)

Brushed Chrome(1)

Gray(1)

Green/White|008000(1)

Yellow(1)

White/Gray(1)

Smoke(1)

Width

4.75"(14)

3.75"(8)

3.25"(8)

3.38"(8)

3.33"(8)

2.5"(6)

2.75"(6)

3"(6)

3.4"(6)

2.8"(4)

3.5"(4)

6"(4)

4"(4)

5"(4)

10.63"(4)

3.9"(4)

4.09"(4)

2.88"(2)

2.25"(2)

4.5"(2)

2.9"(2)

3 1/2"(2)

2 4/5"(2)

6.1"(2)

8.45"(2)

5.34"(2)

3.22"(2)

1.75"(2)

11"(2)

3.6"(2)

Depth

3"(7)

3.25"(4)

5"(4)

3.53"(4)

3.5"(4)

6"(3)

3.13"(3)

2.88"(2)

4.33"(2)

4.1"(2)

2.36"(2)

4.5"(2)

1"(2)

3.56"(2)

3.4"(2)

2.75"(2)

3,4"(1)

3 5/8"(1)

3.2"(1)

5.2"(1)

2.06"(1)

2.9"(1)

2.4"(1)

1.6"(1)

4.75"(1)

9.25"(1)

10.6"(1)

4.06"(1)

3.75"(1)

2.69"(1)

3.63"(1)

2 2/5"(1)

2.5"(1)

Packing Type

Aerosol(4)

Cartridge(2)

Kit(1)

Country of Origin

US(26)

CN(14)

TW(12)

MY(10)

VN(7)

CA(1)

MX(1)

Material(s)

Plastic(59)

Metal(2)

Plastic/Metal(1)

Metal; Plastic(1)

For Use With

Febreze 74901EA; Febreze 74902; Febreze 74902EA; Febreze 74903; Febreze 74903EA; Febreze PGC 74901(2)

Renuzit 03659, 03663, 03667, 00062, 03674, 03661(2)

Rubbermaid Commercial 4012441; 4012451; 4012461; 4012471; 4012491(1)

Refill WTB-304060 Series(1)

TimeMist 1042705, 1044024, 1042756, 1042700, 1042786(1)

TC Tcell Refills 1836256, 1836257, 1836258, FG402110, FG402111, FG402112, FG402187, FG402113, FG402369, FG402470, FG402472, FG402473, FG402498, FG750905, FG750537, FG750907, FG402236(1)

Microburst 3000 Refills(1)

Diversey Good Sense 04808(1)

oufresh Refills(1)

Georgia Pacific Professional 48290, 48291, 48292, 48293, 48294, 48295(1)

Tcell Refills(1)

Capacity (Volume)

5.89 oz(3)

0.67 oz(2)

6.17 oz(1)

5.3 oz(1)

Scent

Summer Delights(4)

Tuscan Garden(1)

Fresh(1)

Cinnamon Sunset(1)

Application

Automatic Odor Control(7)

Physical Form

Liquid(7)

Special Features

Microburst 3000 Dispenser(4)

Includes Tropical Flowers Refill-Fill your home with the bright scent of tropical flowers using this convenient included aerosol.(4)

Summer Delights Scent-White flowers--melon-vanilla.(3)

Micro Dispenser(3)

TCellT 2.0(2)

Microburst 3000 LCD(2)

Microburst 9000 Economizer(1)

Uses AA Batteries-Operates six months on 2 AA batteries, one year on 4 AA batteries (not included).(1)

Microburst 3000 Economizer(1)

LED-Features adjustable spray intervals from 5 to 25 minutes and service intervals of 30, 45, or 60 days.(1)

115 VAC Req.(1)

Summer Delights Scent(1)

Microburst 9000 LCD(1)

Brain Dispenser-Mounts by doorway, with a blinking red LED reminder and an audible reminders to let employees know when to change the refills for all in-stall units.(1)

LCD-Features adjustable spray intervals of 7, 14, or 28 minutes; 12/24 hours per day; or 5, 6, or 7 days per week.(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved