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)

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

9C95-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(281)

TH(28)

HU(22)

CN(16)

MY(16)

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)

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)

Cucumber Melon(8)

Lemon(8)

Hawaiian Aloha(7)

Fresh Linen(7)

Cherry(7)

Eucalyptus(6)

Apple Cinnamon Medley(6)

Original(6)

Fresh(6)

Ocean Breeze(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)

French Kiss(2)

Hawaii Exotic Papaya & Hibiscus Flower(2)

NEUTRA AIR Fresh(2)

Rejuvenating Morning Linen(2)

Lavender/Chamomile(2)

Dutch Apple & Spice(2)

Revitalizing Fresh Breeze(2)

Acapulco Splash(2)

Clean Breeze(2)

Paradise Retreat(2)

Mediterranean Lavender(2)

Heavy Duty Crisp Clean(2)

Pomegranate Grapefruit(2)

Bamboo and Green Tea(2)

Scentillating Citrus(2)

Morning & Dew(2)

Crisp Breeze(2)

Tropical Flowers(2)

Summer Delights(2)

Green Apple(2)

Hawaiian Breeze(2)

Cinnamon(2)

Baby Powder(2)

Citrus Breeze(2)

Country Delight(2)

Orchard Fields(2)

Piņa Colada(2)

Bayberry(2)

Clean Linen(2)

Peony & Jasmine(2)

Fresh Water Breeze(2)

Cinnamon & Crisp Apple(2)

Spring Flowers(2)

Voodoo Berry(2)

Caribbean Waters(2)

Lavender Lemonade(2)

Super Fresh(2)

Energizing Citrus Zest(2)

Bamboo Rain(2)

Island Mist(2)

White Peach & Citrus(2)

Apple(2)

Lovely Lavender(2)

Citrus Sunburst(2)

Cool Citrus(2)

Wild Raspberry & Pomegranate(2)

Pure White Pear & Lavender(2)

Mandarin Orange & Fresh Lemon(2)

Pure Ocean Breeze(2)

Blissful Apple & Cinnamon(2)

Forever Raspberry(2)

After the Rain(2)

Light Scent(2)

Light Fresh(2)

Lavender & Fresh Linen(2)

Zesty Lemon & Lime(2)

Mint(2)

Clean & Fresh(2)

Summer Breeze(2)

Sunscape Mango(2)

Tutti-Frutti(2)

Coastal Breeze(2)

Vanilla, Apricot Blossom & Almond(2)

Passion Violet(1)

Citrus Slice(1)

Fresh Apple(1)

Wintermint(1)

Lemon Lime(1)

Fresh Scent(1)

Desert Bloom(1)

Seaside Breeze(1)

Wildwood Fig(1)

Clean and Fresh(1)

Spring Rain(1)

Vanilla Bean(1)

Assorted(1)

Cherry Thunder(1)

Citrus Sunrise(1)

Cinnamon Sunset(1)

Very Cherry(1)

Apple Harvest(1)

Exotic Garden(1)

Vanilla(1)

Alpine Mist(1)

Country Linen(1)

Raspberry Acai Splash(1)

Powder Mist(1)

Midnight Storm(1)

Spring Garden(1)

Citronella(1)

Lavender Superstar(1)

Lemon Idol(1)

Spiced Apple(1)

Sparkling Citrus(1)

Springtime(1)

Sun Ripened Raspberry(1)

Cotton Blossom(1)

Fruity Pin-Up(1)

Snappy Apple(1)

Lavender(1)

Breezy Linen(1)

Pacific Meadow(1)

Sunscape(1)

Summer Fresh(1)

Ocean(1)

Rosy Starlet(1)

Herbal Mint(1)

Tropical Sunrise(1)

Alpine Springs/Mountain Peaks(1)

Mango Blossom(1)

Blue Splash(1)

Wakening Spring(1)

Fresh Clean(1)

Vanilla Royale(1)

Cotton Berry/Refreshing Citrus(1)

Sea Mist/Ocean Breeze(1)

Gentle Breeze/Linen Fresh(1)

Bouquet(1)

Decadence(1)

Marine Fresh(1)

Mango Blast(1)

Citrus Zest(1)

Spring Blossoms(1)

Tuscan Garden(1)

Cherry Almond(1)

Linen Fresh; Orchard Fields; Mountain Peaks; Country Delight; Ocean Breeze(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)