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') 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(62)

Air Wick(54)

Rubbermaid Commercial(48)

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)

PAK-IT(6)

LYSOL Neutra Air(6)

Diversey(5)

Natural Magic(4)

Scott(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(13)

Blue(10)

Orange(7)

Pink(7)

Red(4)

Opaque White(4)

Yellow(3)

Orchid(2)

White/Blue(2)

Orange/White(2)

Lime(2)

Light Blue(2)

Purple(2)

White/Gray/Blue(2)

Teal(1)

Aqua(1)

Green(1)

Lavender(1)

White/Gray/Purple(1)

White/Gray/Orange(1)

White/Gray(1)

 
Packing Type

Aerosol(179)

Bottle(48)

Box(28)

Jar(24)

Cartridge(18)

Cone(16)

Cup(10)

Spray Bottle(8)

Can(8)

TCell Refill(7)

Liquid Packet(6)

Cassette(5)

Stick Up(4)

Clip(4)

Tub(2)

Unit(2)

Dispenser(2)

Shaker Bottle(2)

Canister(1)

Spray Can(1)

Bag(1)

Kit(1)

Pail(1)

Refill(1)

 
Manufacturer Part Number

1001744(1)

98554(1)

1957522CT(1)

1957521CT(1)

98577KT(1)

98577(1)

98576KT(1)

98576(1)

98555EA(1)

98555(1)

98554EA(1)

98553EA(1)

1957524CT(1)

98553(1)

98552EA(1)

98552(1)

98551EA(1)

98551(1)

98000EA(1)

98000(1)

97053EA(1)

97053(1)

1957523CT(1)

1957525CT(1)

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

96718EA(1)

96534(1)

4015471(1)

76940EA(1)

79553(1)

79196EA(1)

79196(1)

78283CT(1)

78283(1)

77961CT(1)

77961(1)

77002EA(1)

77002(1)

76940CT(1)

79830CT(1)

76938EA(1)

76938CT(1)

75819EA(1)

75819(1)

06732EA(1)

06732(1)

05762EA(1)

05762CT(1)

97810PK(1)

79553EA(1)

79831(1)

96533(1)

85823CT(1)

96532(1)

96531(1)

93045(1)

91101EA(1)

91101(1)

91099EA(1)

91099(1)

85826CT(1)

85825CT(1)

85823(1)

79831CT(1)

85595PK(1)

85595(1)

85257EA(1)

85257(1)

82680PK(1)

82680(1)

82314CT(1)

82314(1)

82093CT(1)

401504(1)

401689(1)

97805PK(1)

1042771(1)

1042818(1)

1042810EA(1)

1042810(1)

1042798(1)

1042786EA(1)

1042786(1)

1042781EA(1)

1042781(1)

1042771EA(1)

1042757EA(1)

1042824(1)

1042757(1)

1042756EA(1)

1042756(1)

1042746(1)

1042737(1)

1042727EA(1)

1042727(1)

1042720(1)

1042712EA(1)

1042818EA(1)

1042824EA(1)

1042705EA(1)

1047941(1)

4121DEA(1)

4121D(1)

4119DEA(1)

4119D(1)

280300(1)

1048495(1)

1048494(1)

1048493(1)

1048328(1)

1047940(1)

1043744(1)

1047606CT(1)

1047606(1)

1047605CT(1)

1047605(1)

1044935EA(1)

1044935(1)

1044024(1)

1043978(1)

1043747(1)

1042712(1)

1042705(1)

401690(1)

5159(1)

682262EA(1)

682262(1)

FG402113(1)

9C97-01(1)

9C94-01(1)

9C85-01(1)

9C84-01(1)

9C83-01(1)

516000(1)

5158(1)

682263EA(1)

402472(1)

402470(1)

402408(1)

402369(1)

402113(1)

402112(1)

402110(1)

402093(1)

401693CT(1)

682263(1)

682277(1)

1042700(1)

1042649(1)

1042694EA(1)

1042694(1)

1042690EA(1)

1042690(1)

1042686EA(1)

1042686(1)

1042677EA(1)

1042677(1)

1042657(1)

1042639(1)

682277EA(1)

1042637(1)

1042430EA(1)

1042430(1)

1042421EA(1)

1042421(1)

1042419CT(1)

1042415CT(1)

697248EA(1)

697248(1)

97810(1)

97805(1)

1001842(1)

909(1)

3320001140EA(1)

33200-01140(1)

3320000514EA(1)

3320000514CT(1)

33200-00007(1)

W24(1)

W16(1)

G20(1)

910(1)

906(1)

3320001710EA(1)

905(1)

904(1)

903(1)

902(1)

901(1)

900(1)

900286EA(1)

900286CT(1)

900258EA(1)

3320001710(1)

33200-01961(1)

900248EA(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)

900258(1)

900248(1)

03661CT(1)

150(1)

358(1)

344(1)

341(1)

337(1)

241(1)

202(1)

1618(1)

1504(1)

1500(1)

1358(1)

504(1)

1045309(1)

1039394(1)

1037236EA(1)

1037236(1)

1020755(1)

1015013(1)

1001870(1)

1001868(1)

1001844(1)

500(1)

5618(1)

900229CT(1)

900014CT(1)

900229(1)

900228CT(1)

900228(1)

900133CT(1)

900133(1)

900114EA(1)

900114CT(1)

900090EA(1)

900090CT(1)

900014(1)

604(1)

900013EA(1)

900013CT(1)

586320003400(1)

586320002240(1)

5853203400CT(1)

5853202240CT(1)

585320003400(1)

585320002240(1)

608(1)

03661(1)

03663(1)

97799PK(1)

91072(1)

970262-G4(1)

927062-QC12(1)

927062G4(1)

911062G4EA(1)

911062-G4(1)

91070114AEA(1)

91070114A12(1)

91000114AEA(1)

91000114A12(1)

91067(1)

84220EA(1)

12373(1)

12370(1)

33632(1)

33601(1)

48291(1)

48290(1)

48281(1)

48255(1)

48254(1)

36551(1)

90188CT(1)

48252(1)

96256EA(1)

97799(1)

97794PK(1)

97794(1)

96264EA(1)

96264(1)

96260EA(1)

96260(1)

96257EA(1)

96257(1)

96256(1)

94728CT(1)

96255EA(1)

96255(1)

96254EA(1)

96254(1)

96252EA(1)

96252(1)

94734PK(1)

94734CT(1)

94731CT(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(297)

HU(22)

TH(19)

MY(17)

CN(16)

MX(5)

United States(4)

CA(2)

VN(1)

 
Capacity (Volume)

5.3 oz(32)

6.6 oz(30)

5.89 oz(25)

14 oz(21)

7 oz(20)

10 oz(18)

1 gal(18)

2 oz(16)

8.8 oz(14)

0.67 oz(14)

32 oz(13)

3 oz(10)

8 oz(10)

48 ml(8)

2 x 8.8 oz(8)

13.8 oz(8)

24 mL(7)

0.35 oz(6)

6 oz(6)

7.5 oz(5)

1.9 oz(4)

2 ml(4)

4.8 oz(4)

1.62 oz(3)

10.5 oz(3)

16 oz(3)

5 oz(3)

15 oz(2)

1 qt(2)

1 oz(2)

64 oz(2)

5.5 oz(2)

1/2 lb(2)

20 oz(2)

5 gal(1)

16.9 oz(1)

5.25 oz(1)

2.5 oz(1)

5.5 mL(1)

1.5 L(1)

12 oz(1)

67.6 oz(1)

 
Scent

Mango(17)

Citrus(13)

Neutral(10)

Unscented(8)

Lemon(8)

Cucumber Melon(8)

Cherry(7)

Hawaiian Aloha(7)

Fresh Linen(7)

Ocean Breeze(6)

Eucalyptus(6)

Original(6)

Fresh(6)

Apple Cinnamon Medley(6)

Gain Original(5)

Lavender & Chamomile(5)

Fresh Breeze(5)

Fresh Waters(5)

Mandarin Orange(5)

Cool & Clean(4)

Island Nectar & Pineapple(4)

Autumn Fresh(4)

Linen & Sky(4)

Spring & Renewal(4)

Mountain Air(4)

Clean N' Fresh(4)

Lavender & Almond Blossom(4)

Cinnamon Spice(3)

Linen Fresh(3)

Mountain Peaks(3)

Country Garden(3)

Lemon Peel(3)

Bamboo Rain(2)

Island Mist(2)

Orchard Fields(2)

Clean & Fresh(2)

Mint(2)

Peony & Jasmine(2)

Fresh Water Breeze(2)

Cinnamon & Crisp Apple(2)

Superberry(2)

Mandarin Orange & Fresh Lemon(2)

Tropical Flowers(2)

Citrus Breeze(2)

Summer Delights(2)

Paradise Retreat(2)

Crisp Breeze(2)

Hawaii Exotic Papaya & Hibiscus Flower(2)

NEUTRA AIR Fresh(2)

Rejuvenating Morning Linen(2)

Lavender/Chamomile(2)

Energizing Citrus Zest(2)

Country Delight(2)

Lemon Lime(2)

White Peach & Citrus(2)

Voodoo Berry(2)

Scentillating Citrus(2)

Bamboo and Green Tea(2)

Pomegranate Grapefruit(2)

Acapulco Splash(2)

French Kiss(2)

Dutch Apple & Spice(2)

Lavender Lemonade(2)

Caribbean Waters(2)

Spring Flowers(2)

Super Fresh(2)

Bayberry(2)

Green Apple(2)

Piņa Colada(2)

Baby Powder(2)

Cinnamon(2)

Summer Breeze(2)

Lavender; Vanilla(2)

Clean Linen(2)

Hawaiian Breeze(2)

Revitalizing Fresh Breeze(2)

Lavender & Fresh Linen(2)

Clean Breeze(2)

Vanilla, Apricot Blossom & Almond(2)

Zesty Lemon & Lime(2)

Tutti-Frutti(2)

Coastal Breeze(2)

Sunscape Mango(2)

Apple(2)

Lovely Lavender(2)

Citrus Sunburst(2)

Pure White Pear & Lavender(2)

Pure Ocean Breeze(2)

Forever Raspberry(2)

After the Rain(2)

Blissful Apple & Cinnamon(2)

Light Fresh(2)

Wild Raspberry & Pomegranate(2)

Mediterranean Lavender(2)

Heavy Duty Crisp Clean(2)

Cool Citrus(2)

Meadows & Rain(2)

Light Scent(2)

Spring Rain(1)

Sun Ripened Raspberry(1)

Fresh Apple(1)

Raspberry Acai Splash(1)

Springtime(1)

Spiced Apple(1)

Assorted(1)

Cherry Thunder(1)

Very Cherry(1)

Herbal Mint(1)

Cinnamon Sunset(1)

Bouquet(1)

Clean and Fresh(1)

Cherry Almond(1)

Tuscan Garden(1)

Citrus Sunrise(1)

Citrus Slice(1)

Fresh Scent(1)

Desert Bloom(1)

Passion Violet(1)

Seaside Breeze(1)

Vanilla(1)

Spring Garden(1)

Wildwood Fig(1)

Country Linen(1)

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

Tropical Sunrise(1)

Rosy Starlet(1)

Summer Fresh(1)

Ocean(1)

Powder Mist(1)

Sunset Cotton(1)

Purple Lavender(1)

Fruity Pin-Up(1)

Lavender Superstar(1)

Pacific Meadow(1)

Lemon Idol(1)

Fresh Clean(1)

Apple Harvest(1)

Sparkling Citrus(1)

Midnight Storm(1)

Exotic Garden(1)

Snappy Apple(1)

Sunscape(1)

Breezy Linen(1)

Mango Blossom(1)

Sea Mist/Ocean Breeze(1)

Blue Splash(1)

Wakening Spring(1)

Citronella(1)

Cotton Blossom(1)

Alpine Mist(1)

Vanilla Royale(1)

Cotton Berry/Refreshing Citrus(1)

Alpine Springs/Mountain Peaks(1)

Lavender(1)

Gentle Breeze/Linen Fresh(1)

Decadence(1)

Lavender Mint(1)

Marine Fresh(1)

Mango Blast(1)

Citrus Zest(1)

Spring Blossoms(1)

Vanilla Bean(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)