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

Rubbermaid Commercial(51)

Febreze(31)

Fresh Products(27)

Arm & Hammer(21)

BRIGHT Air(20)

Renuzit(17)

Big D Industries(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)

Zep Professional(1)

WD-40(1)

Georgia-Pacific(1)

 
Color

Purple(1)

Aqua(1)

Salmon(1)

Blue(1)

 
Recycled

No(4)

 
Color(s)

White(18)

Clear(16)

Blue(11)

Pink(7)

Orange(7)

Opaque White(4)

White/Gray/Blue(4)

Red(4)

Yellow(3)

Light Blue(2)

Orange/White(2)

White/Blue(2)

Purple(2)

Orchid(2)

Lime(2)

White/Gray/Orange(1)

White/Gray(1)

Teal(1)

Lavender(1)

Aqua(1)

Green(1)

White/Gray/Purple(1)

 
Packing Type

Aerosol(182)

Bottle(48)

Box(28)

Jar(25)

Cartridge(20)

Cone(16)

Cup(10)

TCell Refill(9)

Can(8)

Spray Bottle(8)

Liquid Packet(6)

Cassette(6)

Clip(4)

Stick Up(4)

Tub(2)

Unit(2)

Shaker Bottle(2)

Dispenser(2)

Refill(1)

Canister(1)

Bag(1)

Pail(1)

Spray Can(1)

Kit(1)

 
Manufacturer Part Number

98555EA(1)

98576(1)

98555(1)

98554EA(1)

98554(1)

98576KT(1)

98577(1)

1957523CT(1)

1957522CT(1)

1957521CT(1)

98577KT(1)

98553EA(1)

98553(1)

97053EA(1)

97053(1)

96720(1)

96719EA(1)

98000(1)

98000EA(1)

98552EA(1)

98552(1)

98551EA(1)

98551(1)

1957524CT(1)

1957525CT(1)

4012551(1)

4012561(1)

4012481(1)

4012471(1)

4012461(1)

4012571(1)

4012581(1)

4015471(1)

401504(1)

401260A(1)

4012591(1)

4012451(1)

4012441(1)

3485950(1)

3485949(1)

1957528CT(1)

1957526CT(1)

3485951(1)

3485952(1)

4009851(1)

4009831(1)

400696(1)

400573(1)

96718EA(1)

96717EA(1)

78283(1)

78283CT(1)

77961CT(1)

77961(1)

77002EA(1)

79196(1)

79196EA(1)

79831(1)

79830CT(1)

79553EA(1)

79553(1)

77002(1)

76940EA(1)

06732(1)

05762EA(1)

05762CT(1)

97810PK(1)

06732EA(1)

75819(1)

76940CT(1)

76938EA(1)

76938CT(1)

75819EA(1)

79831CT(1)

82093CT(1)

91101EA(1)

91101(1)

91099EA(1)

91099(1)

93045(1)

96531(1)

96717(1)

96534(1)

96533(1)

96532(1)

85826CT(1)

85825CT(1)

82680PK(1)

82680(1)

82314CT(1)

82314(1)

85257(1)

85257EA(1)

85823CT(1)

85823(1)

85595PK(1)

85595(1)

401689(1)

401690(1)

1042781EA(1)

1042786(1)

1042781(1)

1042771EA(1)

1042771(1)

1042786EA(1)

1042798(1)

1042818EA(1)

1042818(1)

1042810EA(1)

1042810(1)

1042757EA(1)

1042757(1)

1042720(1)

1042712EA(1)

1042712(1)

1042705EA(1)

1042727(1)

1042727EA(1)

1042756EA(1)

1042756(1)

1042746(1)

1042737(1)

1042824(1)

1042824EA(1)

1048495(1)

1048494(1)

1048493(1)

1048328(1)

280300(1)

4119D(1)

R36101CT(1)

4121DEA(1)

4121D(1)

4119DEA(1)

1047941(1)

1047940(1)

1044024(1)

1043978(1)

1043747(1)

1043744(1)

1044935(1)

1044935EA(1)

1047606CT(1)

1047606(1)

1047605CT(1)

1047605(1)

1042705(1)

1042700(1)

9C87-01(1)

9C94-01(1)

9C85-01(1)

9C84-01(1)

9C83-01(1)

9C97-01(1)

FG402112(1)

682262EA(1)

682262(1)

FG402472(1)

FG402113(1)

516000(1)

5159(1)

402112(1)

402110(1)

402093(1)

401693CT(1)

402113(1)

402369(1)

5158(1)

402472(1)

402470(1)

402408(1)

682263(1)

682263EA(1)

1042677EA(1)

1042677(1)

1042657(1)

1042649(1)

1042686(1)

1042686EA(1)

1042694EA(1)

1042694(1)

1042690EA(1)

1042690(1)

1042639(1)

1042637(1)

697248EA(1)

697248(1)

682277EA(1)

682277(1)

1042415CT(1)

1042419CT(1)

1042430EA(1)

1042430(1)

1042421EA(1)

1042421(1)

97810(1)

97805PK(1)

33200-00007(1)

3320000514CT(1)

W24(1)

W16(1)

G20(1)

3320000514EA(1)

33200-01140(1)

33200-01961(1)

3320001710EA(1)

3320001710(1)

3320001140EA(1)

910(1)

909(1)

900(1)

900286EA(1)

900286CT(1)

900258EA(1)

901(1)

902(1)

906(1)

905(1)

904(1)

903(1)

3320011535(1)

3320011535EA(1)

101-2(1)

1011EA(1)

1011DPEA(1)

1011DP(1)

1012EA(1)

1013(1)

03661CT(1)

03661(1)

02216CT(1)

1013EA(1)

101-1(1)

3320094170CT(1)

3320084011CT(1)

3320084011(1)

3320011536EA(1)

3320011536(1)

3320084104(1)

3320084113(1)

3320094170(1)

3320084116CT(1)

3320084116(1)

3320084113CT(1)

900258(1)

900248EA(1)

202(1)

241(1)

1618(1)

1504(1)

1500(1)

337(1)

341(1)

504(1)

500(1)

358(1)

344(1)

150(1)

1358(1)

1001870(1)

1001868(1)

1001844(1)

1001842(1)

1015013(1)

1020755(1)

1045309(1)

1039394(1)

1037236EA(1)

1037236(1)

5618(1)

604(1)

900133(1)

900114EA(1)

900114CT(1)

900090EA(1)

900133CT(1)

900228(1)

900248(1)

900229CT(1)

900229(1)

900228CT(1)

900090CT(1)

900014CT(1)

5853202240CT(1)

585320003400(1)

585320002240(1)

608(1)

5853203400CT(1)

586320002240(1)

900014(1)

900013EA(1)

900013CT(1)

586320003400(1)

03663(1)

03663CT(1)

911062G4EA(1)

927062G4(1)

911062-G4(1)

91070114AEA(1)

91070114A12(1)

927062-QC12(1)

970262-G4(1)

90188EA(1)

90188CT(1)

84220EA(1)

36551(1)

91000114AEA(1)

91000114A12(1)

48291(1)

48290(1)

48281(1)

48255(1)

33601(1)

33632(1)

91072(1)

91067(1)

12373(1)

12370(1)

90189(1)

94728CT(1)

96264(1)

96260EA(1)

96260(1)

96257EA(1)

96264EA(1)

97794(1)

97805(1)

97799PK(1)

97799(1)

97794PK(1)

96257(1)

96256EA(1)

96252(1)

94734PK(1)

94734CT(1)

94731CT(1)

96252EA(1)

96254(1)

96256(1)

96255EA(1)

96255(1)

96254EA(1)

48254(1)

48253(1)

93165353(1)

94355110(1)

100949179(1)

04439(1)

04437(1)

12-14-00BO(1)

12-32BWB-CMF(1)

1232WBHMF(1)

12-32WB-CM-F(1)

12-32WB-CH(1)

12-32BWB-MG(1)

35001CT(1)

35001(1)

03674EA(1)

03674(1)

03667CT(1)

03667(1)

05359CT(1)

05359EA(1)

35000CT(1)

35000(1)

05362EA(1)

05362CT(1)

12-32WB-LECT(1)

12-32WB-MG(1)

EF12 CBL(1)

CITRO12(1)

2REFSRRASP(1)

2REFSPRING(1)

EF12 CIT(1)

EF12 MAN(1)

48252(1)

48251(1)

48250(1)

EF12 SAP(1)

2REFSPAPPLE(1)

2REFMANGO(1)

1-WB-CHCT(1)

1-BWB-MG(1)

1-BWB-CM-F(1)

12-32WB-TU(1)

1WBLE(1)

1-WB-MG(1)

2REFCUMELON(1)

2REFCITRUS(1)

2REFCHERRY(1)

1-WB-TU(1)

1001744(1)

 
Country of Origin

US(302)

HU(22)

TH(19)

MY(19)

CN(17)

MX(6)

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)

0.67 oz(14)

8.8 oz(14)

32 oz(13)

8 oz(10)

3 oz(10)

48 ml(8)

13.8 oz(8)

2 x 8.8 oz(8)

24 mL(7)

6 oz(6)

0.35 oz(6)

7.5 oz(5)

5.5 oz(5)

1.62 oz(5)

4.8 oz(4)

1.9 oz(4)

2 ml(4)

10.5 oz(3)

16 oz(3)

5 oz(3)

5.5 mL(3)

1 oz(2)

20 oz(2)

15 oz(2)

1/2 lb(2)

1 qt(2)

64 oz(2)

67.6 oz(1)

12 oz(1)

2.5 oz(1)

5 gal(1)

9 oz(1)

1.5 L(1)

16.9 oz(1)

5.25 oz(1)

 
Scent

Mango(17)

Citrus(13)

Neutral(10)

Unscented(8)

Lemon(8)

Hawaiian Aloha(8)

Cucumber Melon(8)

Cherry(7)

Fresh Linen(7)

Ocean Breeze(7)

Eucalyptus(6)

Fresh(6)

Original(6)

Apple Cinnamon Medley(6)

Fresh Breeze(5)

Mandarin Orange(5)

Fresh Waters(5)

Lavender & Chamomile(5)

Linen & Sky(5)

Gain Original(5)

Lavender & Almond Blossom(4)

Mountain Air(4)

Spring & Renewal(4)

Clean N' Fresh(4)

Autumn Fresh(4)

Cool & Clean(4)

Island Nectar & Pineapple(4)

Lemon Peel(3)

Tropical Flowers(3)

Mountain Peaks(3)

Cinnamon Spice(3)

Country Garden(3)

Linen Fresh(3)

Mediterranean Lavender(2)

Cinnamon & Crisp Apple(2)

Revitalizing Fresh Breeze(2)

Purple Lavender(2)

Crisp Breeze(2)

Rejuvenating Morning Linen(2)

Hawaii Exotic Papaya & Hibiscus Flower(2)

Paradise Retreat(2)

Clean Breeze(2)

Fresh Water Breeze(2)

Summer Delights(2)

Lavender/Chamomile(2)

NEUTRA AIR Fresh(2)

Lemon Lime(2)

Caribbean Waters(2)

Lavender Lemonade(2)

Voodoo Berry(2)

Spring Flowers(2)

Bayberry(2)

Dutch Apple & Spice(2)

French Kiss(2)

Scentillating Citrus(2)

Bamboo Rain(2)

Bamboo and Green Tea(2)

Pomegranate Grapefruit(2)

Acapulco Splash(2)

Green Apple(2)

Piņa Colada(2)

Tropical Sunrise(2)

Citrus Breeze(2)

Blue Splash(2)

Country Delight(2)

Orchard Fields(2)

Heavy Duty Crisp Clean(2)

Super Fresh(2)

Cinnamon(2)

Baby Powder(2)

Lavender; Vanilla(2)

Clean Linen(2)

Hawaiian Breeze(2)

Peony & Jasmine(2)

Energizing Citrus Zest(2)

After the Rain(2)

Vanilla, Apricot Blossom & Almond(2)

Light Fresh(2)

Light Scent(2)

Meadows & Rain(2)

Blissful Apple & Cinnamon(2)

Lovely Lavender(2)

Citrus Sunburst(2)

Pure White Pear & Lavender(2)

Pure Ocean Breeze(2)

Island Mist(2)

Wild Raspberry & Pomegranate(2)

Superberry(2)

Mint(2)

Clean & Fresh(2)

Summer Breeze(2)

Mandarin Orange & Fresh Lemon(2)

Lavender & Fresh Linen(2)

Cool Citrus(2)

Zesty Lemon & Lime(2)

White Peach & Citrus(2)

Apple(2)

Forever Raspberry(2)

Sunscape Mango(2)

Coastal Breeze(2)

Tutti-Frutti(2)

Lavender(1)

Sunscape(1)

Passion Violet(1)

Breezy Linen(1)

Pacific Meadow(1)

Vanilla(1)

Exotic Garden(1)

Cherry Thunder(1)

Vanilla Bean(1)

Citrus Sunrise(1)

Cinnamon Sunset(1)

Apple Harvest(1)

Powder Mist(1)

Summer Fresh(1)

Ocean(1)

Seaside Breeze(1)

Wildwood Fig(1)

Desert Bloom(1)

Fresh Scent(1)

Snappy Apple(1)

Midnight Storm(1)

Clean and Fresh(1)

Spring Rain(1)

Very Cherry(1)

Citrus Slice(1)

Assorted(1)

Raspberry Acai Splash(1)

Alpine Mist(1)

Fresh Clean(1)

Cotton Blossom(1)

Sparkling Citrus(1)

Gentle Breeze/Linen Fresh(1)

Decadence(1)

Lavender Mint(1)

Alpine Springs/Mountain Peaks(1)

Sea Mist/Ocean Breeze(1)

Vanilla Royale(1)

Cotton Berry/Refreshing Citrus(1)

Marine Fresh(1)

Mango Blast(1)

Cherry Almond(1)

Bouquet(1)

Tuscan Garden(1)

Sunset Cotton(1)

Citrus Zest(1)

Spring Blossoms(1)

Spiced Apple(1)

Fruity Pin-Up(1)

Country Linen(1)

Spring Garden(1)

Blue Sky, Linen & Pear(1)

Fresh Apple(1)

Herbal Mint(1)

Lavender Bouquet(1)

Sun Ripened Raspberry(1)

Mango Blossom(1)

Lavender Superstar(1)

Rosy Starlet(1)

Lemon Idol(1)

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

Springtime(1)

Wakening Spring(1)

Citronella(1)

 
Capacity (Weight)

2.1 oz(4)

30 oz(4)

14 oz(4)

16 oz(4)

42.6 oz(4)

1.25 oz(3)

0.1 oz(2)

5.5 oz(2)

2 lbs(2)

12 oz(1)

0.07 oz(1)

13.5 lbs(1)

20 lbs(1)

2.5 oz(1)

24 oz(1)

30 lbs(1)

10 oz(1)

1 lb(1)

 
Recommended Use

Soil Remover(1)

Urine Remover(1)

Odor Remover(1)

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

Multipurpose Cleaner(1)

Deodorizer(1)

 
Packaged Quantity

12 / Carton(3)

1 Each(1)

 
Assembly Required

No(4)

 
Product Line

Professional(1)

ActiveAire(1)

 
Compatibility

ActiveAire Freshener Dispenser(3)

 
Cleaner Type

Liquid(1)