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

Currently Filtered by

Category

Air Fresheners And Odor Eliminators

Refine Search

  GO
 
Brand

TimeMist(60)

Air Wick(52)

Rubbermaid Commercial(38)

Febreze(29)

Fresh Products(27)

Arm & Hammer(21)

BRIGHT Air(20)

Big D Industries(16)

Renuzit(16)

Boardwalk(12)

Misty(10)

OdoBan(9)

Glade(8)

Nature's Air(8)

Georgia Pacific Professional(6)

LYSOL Neutra Air(6)

Diversey(5)

Natural Magic(4)

Scott(4)

PAK-IT(4)

LYSOL NEUTRA AIR FRESHMATIC(3)

ActiveAire(2)

Professional Air Wick(2)

Dymon(2)

WD-40(1)

Georgia-Pacific(1)

Zep Professional(1)

 
Color

Blue(1)

Salmon(1)

Aqua(1)

Purple(1)

 
Recycled

No(4)

 
Color(s)

White(18)

Clear(11)

Blue(10)

Pink(7)

Orange(7)

Opaque White(4)

Red(3)

Yellow(3)

Orange/White(2)

White/Blue(2)

Orchid(2)

Lime(2)

Light Blue(2)

Purple(2)

White/Gray/Blue(2)

Aqua(1)

Green(1)

Lavender(1)

White/Gray/Purple(1)

White/Gray/Orange(1)

White/Gray(1)

 
Packing Type

Aerosol(176)

Bottle(47)

Box(28)

Jar(24)

Cone(16)

Cartridge(13)

Cup(10)

Can(8)

Spray Bottle(8)

TCell Refill(7)

Liquid Packet(4)

Clip(4)

Stick Up(4)

Dispenser(2)

Unit(2)

Tub(2)

Shaker Bottle(2)

Bag(1)

Spray Can(1)

Pail(1)

Canister(1)

Kit(1)

Cassette(1)

 
Manufacturer Part Number

1001744(1)

98551(1)

98555(1)

98554EA(1)

98554(1)

98553EA(1)

98553(1)

98552EA(1)

98552(1)

98551EA(1)

98000EA(1)

98576(1)

98000(1)

97053EA(1)

97053(1)

96534(1)

96533(1)

96532(1)

96531(1)

93045(1)

91101EA(1)

98555EA(1)

98576KT(1)

91099EA(1)

4012441(1)

4012581(1)

4012571(1)

4012561(1)

4012551(1)

4012481(1)

4012471(1)

4012461(1)

4012451(1)

4009851(1)

98577(1)

4009831(1)

400696(1)

3485952(1)

3485951(1)

3485950(1)

3485949(1)

1957523CT(1)

1957521CT(1)

98577KT(1)

91101(1)

91099(1)

401260A(1)

06732EA(1)

77002EA(1)

77002(1)

76940EA(1)

76940CT(1)

76938EA(1)

76938CT(1)

75819EA(1)

75819(1)

06732(1)

77961CT(1)

05762EA(1)

05762CT(1)

97810PK(1)

97810(1)

97805PK(1)

97805(1)

97799PK(1)

97799(1)

97794PK(1)

77961(1)

78283(1)

85826CT(1)

82680(1)

85825CT(1)

85823CT(1)

85823(1)

85595PK(1)

85595(1)

85257EA(1)

85257(1)

82680PK(1)

82314CT(1)

78283CT(1)

82314(1)

82093CT(1)

79831CT(1)

79831(1)

79830CT(1)

79553EA(1)

79553(1)

79196EA(1)

79196(1)

4012591(1)

401504(1)

96264EA(1)

1042771(1)

1042810EA(1)

1042810(1)

1042798(1)

1042786EA(1)

1042786(1)

1042781EA(1)

1042781(1)

1042771EA(1)

1042757EA(1)

1042818EA(1)

1042757(1)

1042756EA(1)

1042756(1)

1042746(1)

1042737(1)

1042727EA(1)

1042727(1)

1042720(1)

1042712EA(1)

1042818(1)

1042824(1)

1042705EA(1)

1047941(1)

4121DEA(1)

4121D(1)

4119DEA(1)

4119D(1)

280300(1)

1048495(1)

1048494(1)

1048493(1)

1047606CT(1)

1042824EA(1)

1047606(1)

1047605CT(1)

1047605(1)

1044935EA(1)

1044935(1)

1044024(1)

1043978(1)

1043747(1)

1043744(1)

1042712(1)

1042705(1)

4015471(1)

402472(1)

682263(1)

682262EA(1)

682262(1)

FG402113(1)

9C83-01(1)

516000(1)

5159(1)

5158(1)

402470(1)

682277(1)

402408(1)

402369(1)

402113(1)

402112(1)

402110(1)

402093(1)

401693CT(1)

401690(1)

401689(1)

682263EA(1)

682277EA(1)

1042700(1)

1042657(1)

1042694EA(1)

1042694(1)

1042690EA(1)

1042690(1)

1042686EA(1)

1042686(1)

1042677EA(1)

1042677(1)

1042649(1)

697248(1)

1042639(1)

1042637(1)

1042430EA(1)

1042430(1)

1042421EA(1)

1042421(1)

1042419CT(1)

1042415CT(1)

697248EA(1)

97794(1)

96264(1)

1001842(1)

909(1)

33200-01140(1)

3320000514EA(1)

3320000514CT(1)

33200-00007(1)

W24(1)

W16(1)

G20(1)

910(1)

906(1)

3320001710(1)

905(1)

904(1)

903(1)

902(1)

901(1)

900(1)

900286EA(1)

900286CT(1)

900258EA(1)

3320001140EA(1)

3320001710EA(1)

900248EA(1)

3320084116CT(1)

1012EA(1)

101-2(1)

1011EA(1)

1011DPEA(1)

1011DP(1)

101-1(1)

3320094170CT(1)

3320094170(1)

3320084116(1)

33200-01961(1)

3320084113CT(1)

3320084113(1)

3320084104(1)

3320084011CT(1)

3320084011(1)

3320011536EA(1)

3320011536(1)

3320011535EA(1)

3320011535(1)

900258(1)

900248(1)

1013EA(1)

150(1)

344(1)

341(1)

337(1)

241(1)

202(1)

1618(1)

1504(1)

1500(1)

1358(1)

500(1)

1045309(1)

1039394(1)

1037236EA(1)

1037236(1)

1020755(1)

1015013(1)

1001870(1)

1001868(1)

1001844(1)

358(1)

504(1)

900229CT(1)

900090CT(1)

900229(1)

900228CT(1)

900228(1)

900133CT(1)

900133(1)

900114EA(1)

900114CT(1)

900090EA(1)

900014CT(1)

5618(1)

900014(1)

900013EA(1)

900013CT(1)

5853203400CT(1)

5853202240CT(1)

585320003400(1)

585320002240(1)

608(1)

604(1)

1013(1)

03661(1)

96260EA(1)

33632(1)

91070114AEA(1)

91070114A12(1)

91000114AEA(1)

91000114A12(1)

91072(1)

91067(1)

12373(1)

12370(1)

33601(1)

911062G4EA(1)

48291(1)

48290(1)

48281(1)

48255(1)

48254(1)

48253(1)

48252(1)

48251(1)

48250(1)

911062-G4(1)

927062G4(1)

EF12 MAN(1)

96254(1)

96260(1)

96257EA(1)

96257(1)

96256EA(1)

96256(1)

96255EA(1)

96255(1)

96254EA(1)

96252EA(1)

927062-QC12(1)

96252(1)

94734PK(1)

94734CT(1)

94731CT(1)

94728CT(1)

90188CT(1)

84220EA(1)

36551(1)

970262-G4(1)

EF12 SAP(1)

EF12 CIT(1)

03661CT(1)

35000(1)

94355110(1)

93165353(1)

100949179(1)

04439(1)

04437(1)

35001CT(1)

35001(1)

35000CT(1)

05362EA(1)

12-32BWB-CMF(1)

05362CT(1)

05359EA(1)

05359CT(1)

03674EA(1)

03674(1)

03667CT(1)

03667(1)

03663CT(1)

03663(1)

12-14-00BO(1)

12-32BWB-MG(1)

EF12 CBL(1)

1-WB-TU(1)

CITRO12(1)

2REFSRRASP(1)

2REFSPRING(1)

2REFSPAPPLE(1)

2REFMANGO(1)

2REFCUMELON(1)

2REFCITRUS(1)

2REFCHERRY(1)

1-WB-MG(1)

12-32WB-CH(1)

1WBLE(1)

1-WB-CHCT(1)

1-BWB-MG(1)

1-BWB-CM-F(1)

12-32WB-TU(1)

12-32WB-MG(1)

12-32WB-LECT(1)

1232WBHMF(1)

12-32WB-CM-F(1)

R36101CT(1)

 
Country of Origin

US(281)

TH(27)

HU(22)

CN(12)

MY(12)

MX(5)

United States(4)

CA(2)

VN(1)

TW(1)

 
For Use With

RAC98576; RAC98576EA; RAC98577; RAC98577EA(10)

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

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

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

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

Air Wick Freshmatic Ultra Dispensers(4)

RAC97290,RAC92944,RAC93554(4)

EFCABA1-F-000I012M(4)

TC 401218, 401375(4)

TC 401219, 401278, 401442, 401758(4)

Georgia Pacific Professional 56755, 56765(3)

Rubbermaid Commercial 5137(3)

TC TCell Microtrans Odor Neutralizer(2)

Nature's Air NA2(2)

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

Scott 92621, 92620(2)

Georgia Pacific Professional 56804(2)

TC 1793534, 1793535, 1793536, FG401375(1)

Microburst 3000(1)

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

 
Capacity (Volume)

5.3 oz(33)

6.6 oz(29)

5.89 oz(25)

14 oz(21)

7 oz(20)

1 gal(18)

10 oz(18)

2 oz(16)

0.67 oz(14)

8.8 oz(14)

32 oz(13)

8 oz(10)

3 oz(10)

2 x 8.8 oz(8)

48 ml(8)

13.8 oz(8)

7.5 oz(5)

6 oz(5)

0.35 oz(4)

1.9 oz(4)

4.8 oz(4)

2 ml(4)

16 oz(3)

1.62 oz(3)

5 oz(3)

24 mL(2)

20 oz(2)

1/2 lb(2)

15 oz(2)

1 oz(2)

1 qt(2)

64 oz(2)

10.5 oz(1)

12 oz(1)

5.25 oz(1)

5.5 mL(1)

16.9 oz(1)

1.5 L(1)

2.5 oz(1)

5 gal(1)

67.6 oz(1)

 
Scent

Mango(16)

Citrus(12)

Neutral(10)

Unscented(8)

Lemon(8)

Cucumber Melon(7)

Fresh Linen(7)

Hawaiian Aloha(7)

Cherry(7)

Fresh(6)

Eucalyptus(6)

Apple Cinnamon Medley(6)

Original(6)

Fresh Waters(5)

Fresh Breeze(5)

Gain Original(5)

Lavender & Chamomile(5)

Mandarin Orange(5)

Ocean Breeze(5)

Island Nectar & Pineapple(4)

Cool & Clean(4)

Lavender & Almond Blossom(4)

Spring & Renewal(4)

Mountain Air(4)

Clean N' Fresh(4)

Autumn Fresh(4)

Linen & Sky(4)

Linen Fresh(3)

Mountain Peaks(3)

Country Garden(3)

Lemon Peel(3)

Bamboo Rain(2)

Lavender/Chamomile(2)

Paradise Retreat(2)

Piņa Colada(2)

Crisp Breeze(2)

Hawaii Exotic Papaya & Hibiscus Flower(2)

NEUTRA AIR Fresh(2)

Rejuvenating Morning Linen(2)

White Peach & Citrus(2)

Baby Powder(2)

Energizing Citrus Zest(2)

Revitalizing Fresh Breeze(2)

Green Apple(2)

Clean Breeze(2)

Zesty Lemon & Lime(2)

Mediterranean Lavender(2)

Heavy Duty Crisp Clean(2)

Summer Delights(2)

Cinnamon(2)

Wild Raspberry & Pomegranate(2)

Lavender; Vanilla(2)

Country Delight(2)

Orchard Fields(2)

Clean & Fresh(2)

Cinnamon Spice(2)

Super Fresh(2)

Hawaiian Breeze(2)

Clean Linen(2)

Peony & Jasmine(2)

Summer Breeze(2)

Fresh Water Breeze(2)

Cinnamon & Crisp Apple(2)

Mint(2)

Mandarin Orange & Fresh Lemon(2)

Lavender & Fresh Linen(2)

Tropical Flowers(2)

Island Mist(2)

Morning & Dew(2)

Cool Citrus(2)

Bayberry(2)

Vanilla, Apricot Blossom & Almond(2)

Citrus Sunburst(2)

Lovely Lavender(2)

Apple(2)

Blissful Apple & Cinnamon(2)

Forever Raspberry(2)

After the Rain(2)

Spring Flowers(2)

Bamboo and Green Tea(2)

Tutti-Frutti(2)

Pomegranate Grapefruit(2)

Acapulco Splash(2)

Pure White Pear & Lavender(2)

Pure Ocean Breeze(2)

Coastal Breeze(2)

Sunscape Mango(2)

Light Fresh(2)

French Kiss(2)

Dutch Apple & Spice(2)

Lavender Lemonade(2)

Caribbean Waters(2)

Light Scent(2)

Voodoo Berry(2)

Scentillating Citrus(2)

Fresh Apple(1)

Citrus Breeze(1)

Country Linen(1)

Fresh Scent(1)

Clean and Fresh(1)

Spring Rain(1)

Desert Bloom(1)

Seaside Breeze(1)

Wildwood Fig(1)

Raspberry Acai Splash(1)

Assorted(1)

Very Cherry(1)

Citrus Slice(1)

Lemon Lime(1)

Vanilla(1)

Passion Violet(1)

Tropical Sunrise(1)

Spring Garden(1)

Vanilla Bean(1)

Mango Blossom(1)

Springtime(1)

Sunscape(1)

Pacific Meadow(1)

Breezy Linen(1)

Lavender(1)

Cotton Blossom(1)

Citronella(1)

Sun Ripened Raspberry(1)

Spiced Apple(1)

Ocean(1)

Herbal Mint(1)

Cinnamon Sunset(1)

Bouquet(1)

Cherry Almond(1)

Tuscan Garden(1)

Citrus Sunrise(1)

Cherry Thunder(1)

Summer Fresh(1)

Powder Mist(1)

Blue Splash(1)

Mango Blast(1)

Wakening Spring(1)

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

Alpine Mist(1)

Cotton Berry/Refreshing Citrus(1)

Sea Mist/Ocean Breeze(1)

Alpine Springs/Mountain Peaks(1)

Gentle Breeze/Linen Fresh(1)

Spring Blossoms(1)

Fresh Clean(1)

Rosy Starlet(1)

Lavender Superstar(1)

Lemon Idol(1)

Sparkling Citrus(1)

Snappy Apple(1)

Exotic Garden(1)

Midnight Storm(1)

Apple Harvest(1)

Fruity Pin-Up(1)

 
Capacity (Weight)

16 oz(4)

30 oz(4)

42.6 oz(4)

2.1 oz(4)

14 oz(4)

2 lbs(2)

5.5 oz(2)

10 oz(1)

2.5 oz(1)

20 lbs(1)

24 oz(1)

30 lbs(1)

13.5 lbs(1)

1 lb(1)

12 oz(1)

0.07 oz(1)

 
Recommended Use

Bacteria Remover(1)

Odor Remover(1)

Urine Remover(1)

Soil Remover(1)

 
Cleaner Volume

128 fl oz (4 quart)(1)

 
Cleaner Form

Ready-To-Use(1)

 
Effective Duration

30 Day(3)

 
Product Type

Air Freshener Refill(2)

Deodorizer(1)

Multipurpose Cleaner(1)

 
Packaged Quantity

12 / Carton(3)

1 Each(1)

 
Assembly Required

No(4)

 
Product Line

ActiveAire(1)

Professional(1)

 
Compatibility

ActiveAire Freshener Dispenser(3)

 
Cleaner Type

Liquid(1)