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

Currently Filtered by

Category

Air Fresheners Odor Eliminators

Refine Search

  GO
Brand

Air Wick(78)

TimeMist(69)

Febreze(69)

BRIGHT Air(61)

Rubbermaid Commercial(55)

Fresh Products(54)

Boardwalk(24)

Big D Industries(23)

OdoBan(22)

Arm & Hammer(21)

Renuzit(20)

Glade(16)

Misty(15)

Diversey(15)

Nature's Air(10)

Chase Products(8)

Clorox(8)

Mrs. Meyer's(8)

Georgia Pacific Professional(7)

PAK-IT(6)

AbilityOne(6)

LYSOL Neutra Air(6)

Scott(5)

Natural Magic(4)

LYSOL NEUTRA AIR FRESHMATIC(4)

San Jamar(4)

Zep Commercial(4)

Dymon(3)

Theochem Laboratories(2)

Professional Air Wick(2)

Franklin Cleaning Technology(2)

Zep Professional(2)

Zep Commercial®(1)

Suma(1)

Kess(1)

WD-40(1)

Color(s)

Clear(31)

Blue(26)

Orange(20)

White(20)

Pink(12)

Purple(10)

Red(10)

Green(7)

White/Blue(4)

Yellow(4)

White/Gray/Blue(3)

Lavender(3)

Light Blue(2)

Orange/White(2)

Orchid(2)

Lime(2)

Clear|FFFFFF(2)

Opaque White(1)

White/Gray/Orange(1)

White/Gray(1)

White/Gray/Purple(1)

Aqua(1)

Beige(1)

Teal(1)

Red/Orange(1)

Blue|0000FF(1)

Green|008000(1)

Yellow|FFFF00(1)

White/Orange(1)

Packing Type

Aerosol(229)

Bottle(69)

Refill(43)

Jar(41)

Box(38)

Spray Bottle(33)

Cartridge(31)

Can(29)

Cone(18)

Diffuser(16)

Pack(12)

Cup(10)

TCell Refill(8)

Clip(7)

Pail(6)

Stick Up(6)

Cassette(6)

Liquid Packet(6)

Non-Aerosol Spray(4)

Sachet Pouch(4)

Shaker Bottle(3)

Kit(2)

Tub(2)

Dispenser(2)

Unit(2)

Bag(1)

Bucket(1)

Spray Can(1)

Starter Kit(1)

Refill Pad(1)

Canister(1)

Pouch(1)

Drum(1)

Container(1)

Shaker Can(1)

Country of Origin

US(474)

CN(56)

MX(30)

TH(29)

HU(21)

MY(19)

CA(4)

VN(2)

TW(1)

AF(1)

For Use With

RAC98576; RAC98576EA; RAC98577; RAC98577EA(10)

BRIGHT Air 900080(8)

ourfresh Dispenser(6)

Chase Products 4381000(6)

Febreze 72792; Febreze 72792EA; Febreze 76985EA; Febreze 97558CT; Febreze 97558EA(6)

Air Wick RAC92944; RAC79782; RAC84178; RAC84179(5)

EFCABA1-F-000I012M(5)

San Jamar WP107801202(4)

Air Wick Freshmatic Ultra Dispensers(4)

TimeMist 32-0142TM01B, 32-0142XX01B, 32-1111TM, 32-1131TM, 32-1131WBY, 32-1131XX, 32-1141TM, 32-1141XX00(4)

Air Wick 78046,78047,78048(4)

TC TCell 1793546, 1793547, 1793548, FG402430, 1793543, 1793544, 1793545, FG500551, FG500552(4)

TC 401218, 401375(4)

TC 400570, 400868, 400979, 401196, 401375(4)

TC 401219, 401278, 401442, 401758(4)

RAC97290,RAC92944,RAC93554(4)

BRIGHT Air BRI900254EA and BRI900254(4)

Rubbermaid Commercial 5137(3)

Georgia Pacific Professional 56755, 56765(3)

1044155(3)

RAC78046(3)

BRIGHT Air BRI900255EA; BRI900255; BRI900256EA; BRI900256(2)

616415; 616419(2)

Scott 92621, 92620(2)

SJN686452(2)

Nature's Air NA2(2)

TC TCell Microtrans Odor Neutralizer(2)

Georgia Pacific Professional 56804(2)

Air Wick 92944; Air Wick 93554; Air Wick 97290(2)

Rubbermaid Commercial 1957531; 1957532; 1957533; 1972664(2)

686452(2)

1047824; 1047825(1)

TimeMist 1044155(1)

Chase Products 4385189(1)

WTB-1041TM1;WTB33-1121TM;WTB32-1111TM;WTB32-0141TM01B;WTB32-014TM03B2(1)

D100910595(1)

MY-F-006I036M-54(1)

MY-F-006I036M-72(1)

MY-F-006I036M-89(1)

Rubbermaid Commercial FG400695(1)

MY-F-006I036M-78(1)

Microburst 3000(1)

Microburst 9000(1)

TC 1793534, 1793535, 1793536, FG401375(1)

Capacity (Volume)

0.67 oz(48)

7 oz(38)

5.3 oz(33)

32 oz(33)

1 gal(31)

10 oz(30)

6.6 oz(29)

5.89 oz(29)

14 oz(24)

2 oz(17)

8 oz(17)

8.8 oz(16)

2.5 oz(15)

3 oz(13)

27 oz(10)

6 oz(9)

13.8 oz(8)

2 x 8.8 oz(8)

48 ml(8)

2 ml(7)

24 mL(7)

4 oz(6)

6.2 oz(6)

0.87 oz(6)

0.35 oz(6)

128 oz(5)

4.8 oz(5)

7.5 oz(5)

5 gal(5)

20 oz(4)

5 oz(4)

6.17 oz(4)

16 oz(4)

1.62 oz(4)

5.5 ml(3)

5.5 oz(3)

300 ml(3)

0.77 oz(3)

0.25 mL(3)

6.25 oz(3)

15 oz(3)

1.7 oz(3)

64 oz(2)

22 oz(2)

1/2 lb(2)

1 oz(2)

10.5 oz(2)

16.9 oz(2)

5.25 oz(2)

1 qt(2)

14.6 oz(2)

12 oz(1)

42.5 oz(1)

1.6 oz(1)

67.6 oz(1)

55 gal(1)

13 oz(1)

1.9 oz(1)

12.5 oz(1)

5.5 mL(1)

9 oz(1)

5.3oz(1)

1.5 L(1)

Scent

Mango(25)

Fresh(17)

Citrus(17)

Fresh Linen(16)

Cucumber Melon(13)

Neutral(13)

Lemon(11)

Unscented(10)

Eucalyptus(10)

Gain Original(10)

Cool & Clean(10)

Lavender & Chamomile(10)

Linen & Sky(9)

Fresh Waters(9)

Apple Cinnamon Medley(9)

Hawaiian Aloha(9)

Lavender(9)

Clean Air Scent(8)

Cherry(8)

Original(7)

Floral(7)

Cotton Blossom(7)

Ocean Breeze(7)

Light Scent(6)

Mountain Air(6)

Spring & Renewal(6)

Hawaiian Blossoms & Papaya(6)

Clean Linen(6)

Citrus Burst(5)

Linen Fresh(5)

Fresh Clean(5)

Spiced Apple(5)

Sweet Lavender & Violet(5)

Country Garden(5)

Mandarin Orange(5)

Island Nectar & Pineapple(4)

Green Apple(4)

Clean N' Fresh(4)

Autumn Fresh(4)

Lavender & Almond Blossom(4)

Hawaiian Breeze(4)

Mandarin Orange & Fresh Lemon(4)

Morning & Dew(4)

Paradise Retreat(4)

Summer Delights(4)

Sparkling Citrus(4)

Fresh Breeze(4)

Meadow Breeze(4)

Mountain Peaks(3)

Lemon Verbena(3)

Coastal Breeze(3)

Cinnamon Spice(3)

Alpine Mist(3)

Tropical Flowers(3)

Heavy Duty Crisp Clean(3)

Lemon Peel(3)

Orchid(3)

Country Delight(3)

Clean & Fresh(2)

Lavender; Vanilla(2)

Cinnamon(2)

Baby Powder(2)

Piña Colada(2)

Orchard Fields(2)

Tea Lily(2)

Sunscape Mango(2)

Clear Springs(2)

Seaside Breeze(2)

Super Fresh(2)

Mediterranean Lavender(2)

Lavender/Chamomile(2)

Energizing Citrus Zest(2)

Revitalizing Fresh Breeze(2)

Clean Breeze(2)

Rejuvenating Morning Linen(2)

NEUTRA AIR Fresh(2)

Crisp Breeze(2)

Hawaii Exotic Papaya & Hibiscus Flower(2)

Hawai'i Exotic Papaya and Hibiscus Flower(2)

Cinnamon & Crisp Apple(2)

Bayberry(2)

Peony & Jasmine(2)

Lemon Lime(2)

Tropical Sunrise(2)

Citrus Breeze(2)

Downy April Fresh(2)

Summer Breeze(2)

Fresh Water Breeze(2)

Tide Original(2)

Fresh Water(2)

Spring Flowers(2)

Wild Raspberry & Pomegranate(2)

Exotic Garden(2)

Midnight Woods & Vanilla(2)

Cherry Blossom & Magnolia(2)

Linen & Spring Breeze(2)

Crisp & Clean(2)

Clean and Fresh(2)

Acapulco Splash(2)

Pomegranate Grapefruit(2)

Bamboo and Green Tea(2)

Light Fresh(2)

Cool Citrus(2)

Macintosh Apples & Cinnamon(2)

Superberry(2)

Lavender & Fresh Linen(2)

Scentillating Citrus(2)

Bamboo Rain(2)

Pleasant(2)

Macintosh Apple & Cinnamon(2)

Mint(2)

Zesty Lemon & Lime(2)

Fresh Petals & Peach(2)

White Peach & Citrus(2)

Calm Waters & Spa(2)

Fragrance Free(2)

Island Mist(2)

Lovely Lavender(2)

Apple(2)

Citrus Sunburst(2)

Snuggle SuperFresh(2)

Pure Ocean Breeze(2)

French Kiss(2)

Dutch Apple & Spice(2)

Tutti-Frutti(2)

Voodoo Berry(2)

Caribbean Waters(2)

Lavender Lemonade(2)

Blissful Apple & Cinnamon(2)

Pure White Pear & Lavender(2)

After the Rain(2)

Vanilla, Apricot Blossom & Almond(2)

Forever Raspberry(2)

Passion Violet(1)

Raspberry Acai Splash(1)

Assorted(1)

Tropic Wave(1)

Citrus Slice(1)

Mango Blossom(1)

Blue Splash(1)

Variety Pack(1)

Vanilla(1)

Linen Fresh; Orchard Fields; Mountain Peaks; Country Delight; Ocean Breeze(1)

Wildwood Fig(1)

Wakening Spring(1)

Pacific Glacier(1)

Vanilla Royale(1)

Fresh Apple(1)

Fresh Scent(1)

Citrus; Linen; Mango(1)

Mango Smoothie(1)

Xtreme Citrus(1)

Citrus Breeze, Orchard Harvest, Spring Garden(1)

Mango Burst(1)

Very Cherry(1)

Spring Garden(1)

Desert Bloom(1)

Country Linen(1)

Geranium(1)

Lavender Bouquet(1)

Basil(1)

Pure Linen(1)

Spring Rain(1)

Tuscan Garden(1)

Cherry Almond(1)

Tropical(1)

Green Apple and Fresh(1)

Blue Sky Breeze(1)

Fresh Floral(1)

Spring Bouquet(1)

Bouquet(1)

Sun Ripened Raspberry(1)

Citronella(1)

Springtime(1)

Lavendar(1)

Herbal Mint(1)

Fresh Lavender(1)

Powder Fresh(1)

Powder Mist(1)

Cinnamon Sunset(1)

Apple Harvest(1)

Sunburst(1)

Lemon Drop(1)

Potpourri(1)

Citrus Sunrise(1)

Cherry Thunder(1)

Cherry Jubilee(1)

Orange Sun(1)

Pina Colada(1)

Mulberry(1)

Vanilla Bean(1)

Honeysuckle(1)

Coconut Vanilla(1)

Spring Blossoms(1)

Citrus Zest(1)

Sunset Cotton(1)

Purple Lavender(1)

Cinna Fresh(1)

Fruity Pin-Up(1)

Mango Blast(1)

Marine Fresh(1)

Alpine Springs/Mountain Peaks(1)

Sea Mist/Ocean Breeze(1)

Gentle Breeze/Linen Fresh(1)

Decadence(1)

Lavender Mint(1)

Snappy Apple(1)

Vanilla Indulgence(1)

Natural(1)

Summer Fresh(1)

Sugar & Spice(1)

Sunscape(1)

Alpine Forest(1)

Kiwi Grapefruit(1)

Ocean(1)

Peach(1)

Lavender Zest(1)

Midnight Storm(1)

Sea Spray(1)

Bamboo(1)

Odor Neutralizer(1)

Cotton Berry/Refreshing Citrus(1)

Capacity (Weight)

44.12 g(8)

0.16 lb(6)

8 oz(6)

2.1 oz(6)

0.03 lbs(5)

2.89 oz(5)

.61 oz(5)

14 oz(5)

42.6 oz(4)

0.05 lbs(4)

30 oz(4)

16 oz(4)

1.25 oz(3)

12 oz(2)

2 lbs(2)

5.5 oz(2)

0.1 oz(2)

0.08 lbs(1)

0.07 oz(1)

5.25 oz(1)

16 lb(1)

24 oz(1)

20 lbs(1)

2.5 oz(1)

25 lbs(1)

30 lbs(1)

13.5 lbs(1)

0.67 oz(1)

1.19 lbs(1)

10 oz(1)

1 lb(1)

15 oz(1)

Application

Odor Control(331)

Automatic Odor Control(191)

Air Freshener(18)

Fabric(15)

Sanitizing and Deodorizing Fabrics(10)

Washroom(7)

General Purpose(6)

Air Freshener; Odor Control(5)

Carpet; Fabric; Hard Non-Porous Surfaces(4)

Spray(4)

Entry Way; Kitchen; Offices; Restrooms(4)

Carpet(4)

Refrigerators(4)

Carpet; Rugs(2)

Disinfectant/Cleaner(2)

Carpet; Concrete; Fabrics; Garbage Areas; Pavement; Restrooms; Tile; Trash Bins; Upholstery(2)

Carpet; Curtains; Fabric(2)

Cars; Furniture; Clothes; Shoes; Air(2)

Carpet;Upholstery(2)

Appliances; Cabinets; Bathtubs; Chairs; Counters; Doorknobs; Floors; Fixtures; Toilets; Tile(1)

Car Odor Control(1)

Carpet; Fabric(1)

General Purpose; Washroom(1)

Carpet; Dumpsters; Drains; Floors(1)

Carpet;Rugs(1)

Odor Control; Cleaning(1)

Fire Odor Control(1)

Indoors(1)

Restrooms(1)

Drains; Grease Traps(1)

Carpet;Trash Can(1)

Disinfectant/Sanitizer(1)

Physical Form

Liquid(403)

Solid(66)

Gel(63)

Aerosol(25)

Powder(23)

Oil(20)

Spray(19)

Canister(7)

Gel Beads(5)

Foam(4)

Pellets(1)

Beads(1)

Special Features

Twin Refill Pack(7)

For SPRAYScentsT 1000 Dispenser(6)

Summer Delights Scent-Florals, sweet melon and vanilla notes.(4)

Two per Pack(4)

Renuzit Sensitive ScentsT-Bring home the refreshing power of Renuzit with light, gentle fragrances that are great for sensitive noses.(4)

20 PAK-Its per Jar(3)

Starter Kit(3)

100 PAK-Its per Tub(3)

Paradise Retreat Scent-Coconut, almond blossom and cherry notes.(3)

Starter Kit-Includes one mist nozzle with spray can.(2)

Free-100% perfume-free; Dermatologist tested.(2)

Extra Strength-Eliminates tough odors in fabrics, provides lasting freshness.(2)

Lasts Four to Six Weeks(2)

Green(2)

Blue(2)

Clear(2)

Red(2)

Heavy Duty Strength-2X the tough odor-eliminating power.(2)

Includes One D-Cell Battery(2)

Stater Kit-Includes (1) Automatic Spray Unit; (1) Spray Refill; (2) AA Batteries.(1)

4 Stater Kits-Each kit includes (1) Automatic Spray Unit; (1) Spray Refill; (2) AA Batteries.(1)

9000 Series(1)

Paradise Retreat Scent-Coconut, almond blossom and cherry notes(1)

5X Concentrate Refill-1 Gallon Concentrate makes 5 Gallons of Fabric Refresher when diluted.(1)

Last Up To Three Months(1)

Clay Base(1)

Lasts up to Three Months(1)

Recommended Dilution: Misting - (1:10), Floor/Carpet Maintenance - (1:64)(1)

Starter Kit-Includes one base unit and one scent cartridge.(1)

Handheld(1)

Refill(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved