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','spl_call_for_price') 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

Fresh Products(56)

Febreze(34)

Air Wick(24)

TimeMist(23)

Rubbermaid Commercial(19)

Big D Industries(18)

Arm & Hammer(18)

Glade(14)

BRIGHT Air(11)

Boardwalk(11)

Chase Products(8)

Nature's Air(8)

Diversey(8)

AbilityOne(7)

Mrs. Meyer's(6)

Claire(6)

Renuzit(5)

Misty(5)

Scott(4)

Georgia Pacific Professional(3)

OdoBan(3)

Dymon(3)

Natural Magic(2)

LYSOL Neutra Air(1)

Coastwide Professional(1)

Citrus II(1)

Theochem Laboratories(1)

 
Application

Odor Control(163)

Automatic Odor Control(81)

Air Freshener(13)

Refrigerators(4)

Air Freshener; Odor Control(4)

Garbage Areas; Hotels; Locker Rooms; Nursing Homes; Public Restrooms; Restaurants; Smoking Areas(4)

Spray(4)

General Purpose(3)

Carpet; Curtains; Fabric(2)

Garbage Areas; Hotels; Restaurants; Locker Rooms; Nursing Homes; Public Restrooms; Smoking Areas(2)

Room Spray(2)

Carpet; Rugs(2)

Carpet;Upholstery(2)

Fire Odor Control(1)

Carpet;Rugs(1)

Indoors(1)

Cleaner; Degreaser; Deodorizer; General Purpose; Kitchen; Laundry; Pool(1)

Restrooms(1)

Carpet; Dumpsters; Drains; Floors(1)

Carpet(1)

Fabric(1)

Carpet; Concrete; Fabrics; Garbage Areas; Pavement; Restrooms; Tile; Trash Bins; Upholstery(1)

Odor Control/Disinfectant on Hard Surfaces(1)

Odor Control; Cleaning(1)

Baking; General Purpose; Kitchen; Laundry; Waste Receptacles(1)

 
For Use With

Fresh Products ourfreshE Dispenser(14)

ourfresh Dispenser 2.0(10)

Chase Products 4381000(6)

Glade 686452(4)

Air Wick Freshmatic Ultra Dispensers(4)

TC 401219, 401278, 401442, 401758(4)

EFCABA1-F-000I012M(4)

TC 401218, 401375(3)

Air Wick 98576, 98576EA, 98577, 98577EA(3)

Glade Automatic Dispenser(3)

Scott 92621, 92620(2)

Febreze PLUG(2)

TC TCell Microtrans Odor Neutralizer(2)

BWK908EA(2)

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

Nature's Air NA2(2)

TC TCell Passive Dispensers(1)

Boardwalk Metered Dispenser BWK908(1)

Air Wick 97290, 92944, 93554(1)

Air Wick 92944, 79782, 84178, 84179(1)

Febreze 22714(1)

Febreze Plug(1)

Georgia Pacific Professional 56755, 56765(1)

Chase Products 4385189(1)

Febreze 72792, 72792EA, 76985EA, 97558CT, 97558EA(1)

 
Physical Form

Liquid(175)

Solid(41)

Gel(28)

Powder(20)

Aerosol(18)

Spray(7)

Oil(5)

Foam(3)

Gel Beads(3)

 
Volume Capacity

8.8 oz(27)

7 oz(24)

10 oz(21)

1 gal(17)

5.89 oz(16)

2 oz(12)

6.6 oz(12)

32 oz(12)

14 oz(10)

5.3 oz(10)

0.67 oz(8)

6.2 oz(7)

8 oz(6)

48 mL(6)

4.8 oz(4)

1.62 oz(3)

5 oz(3)

16 oz(3)

2.63 oz(3)

8.3 oz(3)

0.87 oz(2)

7.1 oz(2)

6.25 oz(2)

64 oz(2)

1/2 lb(2)

15 oz(2)

1.6 oz(1)

1 qt(1)

12 oz(1)

7.5 mL(1)

5 gal(1)

17.6 oz(1)

42.5 oz(1)

1.5 L(1)

10.5 oz(1)

 
Country of Origin

US(260)

TH(11)

MY(9)

HU(6)

CA(5)

CN(4)

TR(4)

MX(1)

 
Color(s)

White(18)

Clear(9)

Blue(7)

Orange(7)

Purple(4)

Pink(4)

Colorless(4)

White/Blue(2)

Green(2)

Red(2)

Light Blue(2)

White/Gray/Blue(2)

Lime(1)

Lavender(1)

Beige(1)

Yellow(1)

White/Green(1)

White/Gray/Orange(1)

 
Packing Type

Aerosol(13)

Spray Bottle(2)

Cartridge(2)

Bottle(1)

Jar(1)

Canister(1)

Stick Up(1)

Sachet Pouch(1)

 
Capacity (Volume)

5.3 oz(3)

32 oz(3)

7 oz(2)

6.6 oz(2)

6 oz(1)

14 oz(1)

12.5 oz(1)

12 oz(1)

8 oz(1)

6.17 oz(1)

13.8 oz(1)

20 oz(1)

 
Scent

Mango(15)

Neutral(12)

Citrus(11)

Fresh(9)

Unscented(9)

Cucumber Melon(8)

Lemon(8)

Original(7)

Fresh Linen(7)

Cherry(7)

Lavender(6)

Gain Original(6)

Cotton Blossom(6)

Linen & Sky(5)

Hawaiian Aloha(5)

Spiced Apple(5)

Fresh Waters(5)

Clean Linen(4)

Hawaiian Breeze(4)

Lavender & Almond Blossom(4)

Spring & Renewal(4)

Mountain Air(4)

Ocean Breeze(4)

Cool & Clean(4)

Apple Cinnamon Medley(3)

Lemon Verbena(3)

Eucalyptus(3)

Linen Fresh(3)

Country Garden(3)

Summer Sunshine(2)

Orchard Fields(2)

Tutti-Frutti(2)

Spa Minerals(2)

Mountain Peaks(2)

Mandarin Orange(2)

Lavender/Chamomile(2)

Morning Lavender(2)

Summer Delights(2)

Paradise Retreat(2)

Coconut Vanilla(2)

Floral(2)

Kiwi Grapefruit(2)

Citrus Blast(2)

Apple(2)

Caribbean Waters(2)

Mediterranean Lavender(2)

Dutch Apple & Spice(2)

Lovely Lavender(2)

Mint(2)

Clean N' Fresh(2)

Lavender Lemonade(2)

Mandarin Orange & Fresh Lemon(2)

Lavender & Fresh Linen(2)

Spring Flowers(2)

Heavy Duty Crisp Clean(2)

Baby Powder(2)

Clean and Fresh(2)

Cashmere Woods(2)

Light Scent(2)

Light Fresh(2)

Tropic Breeze(2)

Ocean(2)

Crisp Clean(1)

Gain Moonlight Breeze(1)

Downy April Fresh(1)

Lavender & Chamomile(1)

Lemon Peel(1)

Sparkling Citrus(1)

Tropical Breeze(1)

Peony & Jasmine(1)

Blue Splash(1)

Mango Blossom(1)

Aqua Waves(1)

Exotic Tropical Blossoms(1)

Lavender & Vanilla(1)

Piña Colada(1)

Vanilla(1)

Cinnamon(1)

Wildwood Fig(1)

Scentillating Citrus(1)

Summer Sorbet(1)

Coastal Breeze(1)

Island Fresh(1)

Apple Harvest(1)

Pina Colada(1)

Mulberry(1)

Lemongrass Citronella(1)

Island Mist(1)

Citrus Sunrise(1)

Cinnamon Sunset(1)

Powder Mist(1)

Sweet Lavender & Violet(1)

Orange Sun(1)

Zesty Lemon & Lime(1)

Island Nectar & Pineapple(1)

Sunburst(1)

Lemon Drop(1)

Forever Raspberry(1)

After the Rain(1)

Alpine Mist(1)

Cherry Jubilee(1)

Powder Fresh(1)

Sea Spray(1)

Sugar & Spice(1)

Linen and Sky(1)

Alpine Wildflower Cedar; Hinoki Ginger Water Lily; Mandarin Amber Lava(1)

Citrus Burst(1)

Odor Neutralizer(1)

Green Apple(1)

Peach(1)

Summer Fresh(1)

Lavender and Aloe(1)

Exotic Garden(1)

Sunscape Mango(1)

Summer Breeze(1)

Citronella(1)

Sun Ripened Raspberry(1)

Springtime(1)

Bouquet(1)

Cherry Almond(1)

Tuscan Garden(1)

Brushed Cotton(1)

 
Capacity (Weight)

2.54 oz(14)

0.16 lb(10)

42.6 oz(4)

12 oz(3)

14 oz(3)

16 oz(3)

5.5 oz(2)

0.05 lbs(2)

13.5 lbs(1)

30 oz(1)

1 lb(1)

25 lbs(1)

2 lbs(1)

0.08 lbs(1)

10.8 lb(1)

24 oz(1)

26.5 lbs(1)

20 lbs(1)

2.1 oz(1)

30 g(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved