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(47)

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(177)

Bottle(47)

Box(28)

Jar(24)

Cartridge(17)

Cone(16)

Cup(10)

Can(8)

Spray Bottle(8)

TCell Refill(7)

Cassette(5)

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)

 
Manufacturer Part Number

1001744(1)

98554(1)

1957521CT(1)

98577KT(1)

98577(1)

98576KT(1)

98576(1)

98555EA(1)

98555(1)

98554EA(1)

98553EA(1)

1957523CT(1)

98553(1)

98552EA(1)

98552(1)

98551EA(1)

98551(1)

98000EA(1)

98000(1)

97053EA(1)

97053(1)

1957522CT(1)

1957524CT(1)

96533(1)

4012451(1)

401260A(1)

4012591(1)

4012581(1)

4012571(1)

4012561(1)

4012551(1)

4012481(1)

4012471(1)

4012461(1)

4012441(1)

1957526CT(1)

4009851(1)

4009831(1)

400696(1)

400573(1)

3485952(1)

3485951(1)

3485950(1)

3485949(1)

1957528CT(1)

96534(1)

96532(1)

4015471(1)

76940CT(1)

79196(1)

78283CT(1)

78283(1)

77961CT(1)

77961(1)

77002EA(1)

77002(1)

76940EA(1)

76938EA(1)

79553(1)

76938CT(1)

75819EA(1)

75819(1)

06732EA(1)

06732(1)

05762EA(1)

05762CT(1)

97810PK(1)

97810(1)

79196EA(1)

79553EA(1)

96531(1)

85595PK(1)

93045(1)

91101EA(1)

91101(1)

91099EA(1)

91099(1)

85826CT(1)

85825CT(1)

85823CT(1)

85823(1)

85595(1)

79830CT(1)

85257EA(1)

85257(1)

82680PK(1)

82680(1)

82314CT(1)

82314(1)

82093CT(1)

79831CT(1)

79831(1)

401504(1)

401689(1)

97805(1)

1042757EA(1)

1042810(1)

1042798(1)

1042786EA(1)

1042786(1)

1042781EA(1)

1042781(1)

1042771EA(1)

1042771(1)

1042757(1)

1042818(1)

1042756EA(1)

1042756(1)

1042746(1)

1042737(1)

1042727EA(1)

1042727(1)

1042720(1)

1042712EA(1)

1042712(1)

1042810EA(1)

1042818EA(1)

1042705(1)

1047606CT(1)

4121DEA(1)

4121D(1)

4119DEA(1)

4119D(1)

280300(1)

1048495(1)

1048494(1)

1048493(1)

1047941(1)

1047606(1)

1042824(1)

1047605CT(1)

1047605(1)

1044935EA(1)

1044935(1)

1044024(1)

1043978(1)

1043747(1)

1043744(1)

1042824EA(1)

1042705EA(1)

1042700(1)

401690(1)

5159(1)

682262(1)

FG402113(1)

9C97-01(1)

9C94-01(1)

9C85-01(1)

9C84-01(1)

9C83-01(1)

516000(1)

5158(1)

682263(1)

402472(1)

402470(1)

402408(1)

402369(1)

402113(1)

402112(1)

402110(1)

402093(1)

401693CT(1)

682262EA(1)

682263EA(1)

1042694EA(1)

1042639(1)

1042694(1)

1042690EA(1)

1042690(1)

1042686EA(1)

1042686(1)

1042677EA(1)

1042677(1)

1042657(1)

1042649(1)

1042637(1)

682277(1)

1042430EA(1)

1042430(1)

1042421EA(1)

1042421(1)

1042419CT(1)

1042415CT(1)

697248EA(1)

697248(1)

682277EA(1)

97805PK(1)

97799PK(1)

1001842(1)

910(1)

3320001140EA(1)

33200-01140(1)

3320000514EA(1)

3320000514CT(1)

33200-00007(1)

W24(1)

W16(1)

G20(1)

909(1)

3320001710EA(1)

906(1)

905(1)

904(1)

903(1)

902(1)

901(1)

900(1)

900286EA(1)

900286CT(1)

3320001710(1)

33200-01961(1)

900258(1)

3320094170(1)

1013EA(1)

1013(1)

1012EA(1)

101-2(1)

1011EA(1)

1011DPEA(1)

1011DP(1)

101-1(1)

3320094170CT(1)

3320084116CT(1)

3320011535(1)

3320084116(1)

3320084113CT(1)

3320084113(1)

3320084104(1)

3320084011CT(1)

3320084011(1)

3320011536EA(1)

3320011536(1)

3320011535EA(1)

900258EA(1)

900248EA(1)

03661CT(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)

900248(1)

900090CT(1)

900229CT(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)

03661(1)

03663(1)

97799(1)

91072(1)

927062-QC12(1)

927062G4(1)

911062G4EA(1)

911062-G4(1)

91070114AEA(1)

91070114A12(1)

91000114AEA(1)

91000114A12(1)

91067(1)

36551(1)

12373(1)

12370(1)

33632(1)

33601(1)

48291(1)

48290(1)

48281(1)

48255(1)

48254(1)

970262-G4(1)

84220EA(1)

48252(1)

96256(1)

97794PK(1)

97794(1)

96264EA(1)

96264(1)

96260EA(1)

96260(1)

96257EA(1)

96257(1)

96256EA(1)

96255EA(1)

90188CT(1)

96255(1)

96254EA(1)

96254(1)

96252EA(1)

96252(1)

94734PK(1)

94734CT(1)

94731CT(1)

94728CT(1)

48253(1)

48251(1)

03663CT(1)

35001(1)

12-32BWB-MG(1)

12-32BWB-CMF(1)

12-14-00BO(1)

94355110(1)

93165353(1)

100949179(1)

04439(1)

04437(1)

35001CT(1)

35000CT(1)

12-32WB-CM-F(1)

35000(1)

05362EA(1)

05362CT(1)

05359EA(1)

05359CT(1)

03674EA(1)

03674(1)

03667CT(1)

03667(1)

12-32WB-CH(1)

1232WBHMF(1)

48250(1)

2REFCUMELON(1)

EF12 SAP(1)

EF12 MAN(1)

EF12 CIT(1)

EF12 CBL(1)

CITRO12(1)

2REFSRRASP(1)

2REFSPRING(1)

2REFSPAPPLE(1)

2REFMANGO(1)

2REFCITRUS(1)

12-32WB-LECT(1)

2REFCHERRY(1)

1-WB-TU(1)

1-WB-MG(1)

1WBLE(1)

1-WB-CHCT(1)

1-BWB-MG(1)

1-BWB-CM-F(1)

12-32WB-TU(1)

12-32WB-MG(1)

R36101CT(1)

 
Country of Origin

US(291)

HU(22)

TH(19)

CN(16)

MY(16)

MX(5)

United States(4)

CA(2)

VN(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)

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

TC TCell Microtrans Odor Neutralizer(2)

Nature's Air NA2(2)

Scott 92621, 92620(2)

Georgia Pacific Professional 56804(2)

TC 1793534, 1793535, 1793536, FG401375(1)

Microburst 3000(1)

Rubbermaid Commercial 5114(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)

24 mL(6)

6 oz(6)

7.5 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)

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(8)

Hawaiian Aloha(7)

Fresh Linen(7)

Cherry(7)

Ocean Breeze(6)

Eucalyptus(6)

Apple Cinnamon Medley(6)

Original(6)

Fresh(6)

Fresh Breeze(5)

Mandarin Orange(5)

Gain Original(5)

Fresh Waters(5)

Lavender & Chamomile(5)

Cool & Clean(4)

Island Nectar & Pineapple(4)

Autumn Fresh(4)

Mountain Air(4)

Lavender & Almond Blossom(4)

Spring & Renewal(4)

Linen & Sky(4)

Clean N' Fresh(4)

Cinnamon Spice(3)

Linen Fresh(3)

Mountain Peaks(3)

Lemon Peel(3)

Country Garden(3)

Lavender; Vanilla(2)

Revitalizing Fresh Breeze(2)

Crisp Breeze(2)

Hawaii Exotic Papaya & Hibiscus Flower(2)

NEUTRA AIR Fresh(2)

Rejuvenating Morning Linen(2)

Lavender/Chamomile(2)

Dutch Apple & Spice(2)

Clean Breeze(2)

French Kiss(2)

Summer Delights(2)

Acapulco Splash(2)

Mediterranean Lavender(2)

Pomegranate Grapefruit(2)

Heavy Duty Crisp Clean(2)

Bamboo and Green Tea(2)

Scentillating Citrus(2)

Paradise Retreat(2)

Lavender Lemonade(2)

Tropical Flowers(2)

Piņa Colada(2)

Hawaiian Breeze(2)

Cinnamon(2)

Baby Powder(2)

Lemon Lime(2)

Citrus Breeze(2)

Country Delight(2)

Orchard Fields(2)

Green Apple(2)

Clean Linen(2)

Bayberry(2)

Peony & Jasmine(2)

Fresh Water Breeze(2)

Cinnamon & Crisp Apple(2)

Spring Flowers(2)

Voodoo Berry(2)

Caribbean Waters(2)

Super Fresh(2)

Energizing Citrus Zest(2)

Morning & Dew(2)

Island Mist(2)

Citrus Sunburst(2)

Pure White Pear & Lavender(2)

Pure Ocean Breeze(2)

Blissful Apple & Cinnamon(2)

After the Rain(2)

Vanilla, Apricot Blossom & Almond(2)

Light Fresh(2)

Light Scent(2)

Wild Raspberry & Pomegranate(2)

Apple(2)

Cool Citrus(2)

Zesty Lemon & Lime(2)

White Peach & Citrus(2)

Lavender & Fresh Linen(2)

Mandarin Orange & Fresh Lemon(2)

Mint(2)

Clean & Fresh(2)

Summer Breeze(2)

Lovely Lavender(2)

Forever Raspberry(2)

Tutti-Frutti(2)

Coastal Breeze(2)

Sunscape Mango(2)

Bamboo Rain(2)

Tuscan Garden(1)

Sunscape(1)

Citrus Sunrise(1)

Cinnamon Sunset(1)

Powder Mist(1)

Apple Harvest(1)

Exotic Garden(1)

Bouquet(1)

Lavender(1)

Passion Violet(1)

Snappy Apple(1)

Vanilla(1)

Breezy Linen(1)

Pacific Meadow(1)

Summer Fresh(1)

Vanilla Bean(1)

Citrus Slice(1)

Very Cherry(1)

Assorted(1)

Raspberry Acai Splash(1)

Ocean(1)

Alpine Mist(1)

Spring Rain(1)

Clean and Fresh(1)

Wildwood Fig(1)

Seaside Breeze(1)

Desert Bloom(1)

Fresh Scent(1)

Fresh Clean(1)

Cherry Thunder(1)

Cherry Almond(1)

Fruity Pin-Up(1)

Lemon Idol(1)

Rosy Starlet(1)

Spring Blossoms(1)

Citrus Zest(1)

Mango Blast(1)

Lavender Mint(1)

Decadence(1)

Gentle Breeze/Linen Fresh(1)

Alpine Springs/Mountain Peaks(1)

Sea Mist/Ocean Breeze(1)

Cotton Berry/Refreshing Citrus(1)

Vanilla Royale(1)

Lavender Superstar(1)

Spiced Apple(1)

Cotton Blossom(1)

Springtime(1)

Midnight Storm(1)

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

Wakening Spring(1)

Blue Splash(1)

Mango Blossom(1)

Tropical Sunrise(1)

Spring Garden(1)

Country Linen(1)

Sparkling Citrus(1)

Fresh Apple(1)

Sun Ripened Raspberry(1)

Herbal Mint(1)

Citronella(1)

 
Capacity (Weight)

14 oz(4)

16 oz(4)

2.1 oz(4)

42.6 oz(4)

30 oz(4)

2 lbs(2)

5.5 oz(2)

1.25 oz(2)

0.1 oz(2)

30 lbs(1)

13.5 lbs(1)

24 oz(1)

1 lb(1)

20 lbs(1)

12 oz(1)

2.5 oz(1)

0.07 oz(1)

10 oz(1)

 
Recommended Use

Bacteria Remover(1)

Odor Remover(1)

Urine Remover(1)

Soil Remover(1)

 
Cleaner Volume

1 gal (128 fl oz)(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)