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

Big D Industries(18)

Arm & Hammer(18)

Glade(14)

BRIGHT Air(13)

Boardwalk(11)

Chase Products(8)

Nature's Air(8)

Diversey(8)

AbilityOne(7)

Mrs. Meyer's(6)

Renuzit(5)

Misty(5)

Scott(4)

Claire(4)

Georgia Pacific Professional(3)

OdoBan(3)

Dymon(3)

Coastwide Professional(2)

Natural Magic(2)

LYSOL Neutra Air(1)

Citrus II(1)

Theochem Laboratories(1)

 
Application

Odor Control(165)

Automatic Odor Control(81)

Air Freshener(15)

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)

Carpet; Rugs(2)

Carpet;Upholstery(2)

Room Spray(1)

Washroom(1)

Odor Control/Disinfectant on Hard Surfaces(1)

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

Fabric(1)

Restrooms(1)

Carpet; Dumpsters; Drains; Floors(1)

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

Indoors(1)

Fire Odor Control(1)

Carpet;Rugs(1)

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

EFCABA1-F-000I012M(4)

TC 401219, 401278, 401442, 401758(4)

Air Wick Freshmatic Ultra Dispensers(4)

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

Glade Automatic Dispenser(3)

TC 401218, 401375(3)

Nature's Air NA2(2)

Scott 92621, 92620(2)

Febreze PLUG(2)

TC TCell Microtrans Odor Neutralizer(2)

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

TC TCell Passive Dispensers(1)

Boardwalk Metered Dispenser BWK908(1)

Rubbermaid Commercial 1957531, 1957532, 1957533, 1972664(1)

Air Wick 97290, 92944, 93554(1)

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

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

Febreze Plug(1)

Georgia Pacific Professional 56755, 56765(1)

Chase Products 4385189(1)

Febreze 22714(1)

 
Physical Form

Liquid(173)

Solid(41)

Gel(28)

Powder(20)

Aerosol(18)

Spray(7)

Oil(6)

Gel Beads(5)

Foam(3)

Canister(1)

 
Volume Capacity

8.8 oz(27)

10 oz(23)

7 oz(22)

1 gal(17)

5.89 oz(16)

6.6 oz(14)

32 oz(12)

2 oz(12)

14 oz(11)

5.3 oz(10)

0.67 oz(9)

6.2 oz(7)

8 oz(6)

48 mL(6)

4.8 oz(4)

1.62 oz(3)

16 oz(3)

2.63 oz(3)

5 oz(3)

0.87 oz(2)

8.3 oz(2)

6.25 oz(2)

1/2 lb(2)

64 oz(2)

15 oz(2)

17.6 oz(1)

42.5 oz(1)

1 qt(1)

7.5 mL(1)

1.5 L(1)

24 mL(1)

1.6 oz(1)

12 oz(1)

10.5 oz(1)

 
Country of Origin

US(259)

TH(11)

MY(10)

CN(6)

HU(6)

CA(5)

TR(4)

MX(1)

 
Color(s)

White(18)

Clear(9)

Blue(7)

Orange(7)

Pink(6)

Purple(4)

Colorless(2)

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)

Jar(2)

Spray Bottle(2)

Cartridge(2)

Bottle(1)

Bucket(1)

Canister(1)

Stick Up(1)

Sachet Pouch(1)

 
Capacity (Volume)

32 oz(3)

5.3 oz(3)

7 oz(2)

6.6 oz(2)

6 oz(1)

10 oz(1)

12.5 oz(1)

5 gal(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)

Lemon(8)

Fresh Linen(8)

Cucumber Melon(8)

Cherry(7)

Cotton Blossom(6)

Gain Original(6)

Lavender(6)

Original(6)

Linen & Sky(5)

Fresh Waters(5)

Hawaiian Aloha(5)

Spiced Apple(5)

Clean Linen(4)

Hawaiian Breeze(4)

Spring & Renewal(4)

Mountain Air(4)

Lavender & Almond Blossom(4)

Ocean Breeze(4)

Cool & Clean(4)

Island Nectar & Pineapple(3)

Country Garden(3)

Lemon Verbena(3)

Eucalyptus(3)

Apple Cinnamon Medley(3)

Linen Fresh(3)

Coconut Vanilla(2)

Mountain Peaks(2)

Orchard Fields(2)

Floral(2)

Kiwi Grapefruit(2)

Morning Lavender(2)

Spa Minerals(2)

Apple(2)

Summer Sunshine(2)

Tutti-Frutti(2)

Ocean(2)

Mandarin Orange(2)

Light Fresh(2)

Heavy Duty Crisp Clean(2)

Lavender/Chamomile(2)

Mediterranean Lavender(2)

Dutch Apple & Spice(2)

Lovely Lavender(2)

Clean N' Fresh(2)

Mint(2)

Lavender Lemonade(2)

Caribbean Waters(2)

Mandarin Orange & Fresh Lemon(2)

Lavender & Fresh Linen(2)

Spring Flowers(2)

Baby Powder(2)

Clean and Fresh(2)

Light Scent(2)

Paradise Retreat(2)

Summer Delights(2)

Crisp Clean(1)

Lavender & Chamomile(1)

Gain Moonlight Breeze(1)

Downy April Fresh(1)

Sparkling Citrus(1)

Lemon Peel(1)

Tropical Breeze(1)

Peony & Jasmine(1)

Elegance(1)

Blue Splash(1)

Summer Sorbet(1)

Aqua Waves(1)

Joyful Citrus and Daisies(1)

Exotic Tropical Blossoms(1)

Cashmere Woods(1)

Lavender & Vanilla(1)

Piña Colada(1)

Vanilla(1)

Cinnamon(1)

Wildwood Fig(1)

Scentillating Citrus(1)

Mango Blossom(1)

Coastal Breeze(1)

Island Fresh(1)

Powder Mist(1)

Pina Colada(1)

Mulberry(1)

Tropic Breeze(1)

Lemongrass Citronella(1)

Island Mist(1)

Citrus Sunrise(1)

Cinnamon Sunset(1)

Apple Harvest(1)

Orange Sun(1)

Sweet Lavender & Violet(1)

Zesty Lemon & Lime(1)

Sunburst(1)

Lemon Drop(1)

Snuggle SuperFresh(1)

Forever Raspberry(1)

After the Rain(1)

Alpine Mist(1)

Cherry Jubilee(1)

Powder Fresh(1)

Sea Spray(1)

Lavender and Aloe(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)

Sugar & Spice(1)

Sunscape Mango(1)

Exotic Garden(1)

Summer Breeze(1)

Citronella(1)

Sun Ripened Raspberry(1)

Springtime(1)

Bouquet(1)

Cherry Almond(1)

Tuscan Garden(1)

Citrus Blast(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