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 '%AirFresheners' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('AirFresheners' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+AirFresheners' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"AirFresheners"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"AirFresheners"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"AirFresheners"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"AirFresheners"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+AirFresheners' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='AirFresheners',`category_4` ='AirFresheners') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'AirFresheners,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('AirFresheners', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Air Fresheners

Refine Search

  GO
 
Brand

Fresh Products(56)

Febreze(44)

Air Wick(23)

Glade(23)

TimeMist(20)

Arm & Hammer(19)

Big D Industries(18)

Rubbermaid Commercial(17)

Claire(13)

BRIGHT Air(11)

Boardwalk(10)

Chase Products(8)

Diversey(8)

Nature's Air(8)

AbilityOne(7)

Renuzit(6)

Misty(5)

Mrs. Meyer's(4)

Scott(4)

Georgia Pacific Professional(3)

OdoBan(3)

Dymon(3)

HLS Commercial(1)

Citrus II(1)

PAK-IT(1)

Theochem Laboratories(1)

 
Application

Odor Control(155)

Automatic Odor Control(86)

Air Freshener(28)

Room Spray(5)

Refrigerators(4)

Air Freshener; Odor Control(4)

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

Spray(4)

General Purpose(4)

Carpet; Curtains; Fabric(2)

Carpet;Upholstery(2)

Carpet; Rugs(2)

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

Hospitals; Hotels; Meeting Rooms; Motels; Nursing Homes; Offices; Public Buildings; Restaurants; Restrooms; Schools(2)

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

Fabric(1)

Carpet; Dumpsters; Drains; Floors(1)

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

Restrooms(1)

Cleaning; Odor Control(1)

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

Fire Odor Control(1)

Carpet(1)

Odor Control; Cleaning(1)

Carpet;Rugs(1)

 
For Use With

Fresh Products ourfreshE Dispenser(14)

ourfresh Dispenser 2.0(10)

Febreze PLUG(8)

Chase Products 4381000(6)

Boardwalk Metered Dispenser 908; Claire 7MADISP(5)

TC 401218, 401375(4)

TC 401219, 401278, 401442, 401758(4)

Air Wick Freshmatic Ultra Dispensers(4)

Glade 686452(4)

EFCABA1-F-000I012M(4)

Glade Automatic Dispenser(3)

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

Nature's Air NA2(2)

TC TCell Microtrans Odor Neutralizer(2)

Scott 92621, 92620(2)

BWK908EA(2)

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

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

Metered Air Freshener Dispensers: Boardwalk 908; Claire 7MADISP(2)

Boardwalk Metered Dispenser BWK908(1)

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

Febreze 22714(1)

Febreze Plug(1)

Georgia Pacific Professional 56755, 56765(1)

Fresh Products ourFresh 2.0 Dispenser(1)

Chase Products 4385189(1)

Glade Automatic Spray Holder Dispenser(1)

 
Physical Form

Liquid(187)

Solid(41)

Gel(26)

Aerosol(21)

Powder(20)

Oil(9)

Spray(7)

Foam(3)

Gel Beads(2)

Particulate(1)

 
Volume Capacity

7 oz(28)

8.8 oz(23)

7.1 oz(20)

10 oz(17)

1 gal(17)

5.89 oz(15)

0.67 oz(13)

2 oz(12)

32 oz(12)

14 oz(10)

6.2 oz(9)

0.87 oz(9)

2.63 oz(6)

8 oz(6)

8.3 oz(6)

48 mL(6)

11 oz(5)

5.3 oz(4)

4.8 oz(4)

16 oz(3)

1.62 oz(3)

5 oz(3)

64 oz(3)

0.25 oz(3)

15 oz(2)

6.25 oz(2)

1/2 lb(2)

17.6 oz(1)

7.5 mL(1)

42.5 oz(1)

0.35 oz(1)

1 qt(1)

84.5 oz(1)

5 gal(1)

1.5 L(1)

12 oz(1)

 
Country of Origin

US(276)

TH(12)

MY(8)

CA(6)

HU(6)

TR(4)

CN(3)

MX(2)

 
Color(s)

White(19)

Blue(8)

Clear(7)

Orange(7)

Colorless(6)

Purple(4)

Pink(3)

Red(3)

Light Blue(3)

Lime(2)

White/Blue(2)

Green(2)

White/Gray/Blue(2)

Beige(1)

Yellow(1)

Blue; White(1)

Assorted(1)

White/Green(1)

White/Gray/Orange(1)

 
Packing Type

Aerosol(9)

Spray Bottle(2)

Cartridge(2)

Bottle(1)

Stick Up(1)

 
Capacity (Volume)

32 oz(3)

7 oz(2)

5.3 oz(2)

6 oz(1)

8.8 oz(1)

6.17 oz(1)

13.8 oz(1)

20 oz(1)

 
Scent

Mango(16)

Unscented(12)

Neutral(12)

Linen & Sky(10)

Citrus(10)

Fresh Linen(9)

Gain Original(9)

Cucumber Melon(9)

Fresh(9)

Lemon(8)

Cherry(7)

Clean Linen(7)

Cotton Blossom(6)

Lavender(6)

Original(6)

Hawaiian Aloha(6)

Spiced Apple(5)

Fresh Waters(5)

Hawaiian Breeze(5)

Cool & Clean(5)

Country Garden(4)

Ocean(4)

Lavender & Almond Blossom(4)

Mountain Air(4)

Cashmere Woods(4)

Exotic Tropical Blossoms(3)

Linen Fresh(3)

Eucalyptus(3)

Mediterranean Lavender(3)

Spa Minerals(3)

Apple Cinnamon Medley(3)

Caribbean Waters(2)

Ocean Breeze(2)

Kiwi Grapefruit(2)

Coconut Vanilla(2)

Morning Lavender(2)

Summer Sunshine(2)

Clean N' Fresh(2)

Summer Delights(2)

Lavender Lemonade(2)

Downy April Fresh(2)

Lavender/Chamomile(2)

Spring Flowers(2)

Baby Powder(2)

Orchard Fields(2)

Mandarin Orange(2)

Lemon Verbena(2)

Aqua Waves(2)

Heavy Duty Crisp Clean(2)

Paradise Retreat(2)

Mountain Peaks(2)

Dutch Apple & Spice(2)

Tutti-Frutti(2)

Mint(2)

Mulberry(2)

Light Fresh(2)

Light Scent(2)

Zesty Lemon & Lime(2)

Lavender & Fresh Linen(2)

Tropic Breeze(2)

Mandarin Orange & Fresh Lemon(2)

Apple(2)

Lovely Lavender(2)

Linen Escape(1)

Alpine Mist(1)

After the Rain(1)

Forever Raspberry(1)

Lavender & Chamomile(1)

Sparkling Citrus(1)

Island Mist(1)

Clean and Fresh(1)

Citrus Sunrise(1)

Cinnamon Sunset(1)

Apple Harvest(1)

Powder Mist(1)

Cinnamon(1)

Blue Splash(1)

Mango Blossom(1)

Vanilla(1)

Superberry(1)

Sky & Sea Salt(1)

Sunburst(1)

Lemon Drop(1)

Lavender & Vanilla(1)

Springtime(1)

Crisp Clean(1)

Gain Moonlight Breeze(1)

Peach(1)

Sun Ripened Raspberry(1)

Bouquet(1)

Clean & Fresh(1)

Cherry Almond(1)

Summer Breeze(1)

Tuscan Garden(1)

Exotic Garden(1)

Coastal Breeze(1)

Sunscape Mango(1)

Sugar & Spice(1)

Summer Fresh(1)

Powder Fresh(1)

Green Apple(1)

Spring & Renewal(1)

Odor Neutralizer(1)

Citrus Burst(1)

Floral(1)

Orange Sun(1)

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

Gain(1)

Cherry Jubilee(1)

Mountain; Ocean; Rainforest(1)

Pina Colada(1)

Lemongrass Citronella(1)

Rain Forest(1)

Citrus Blast(1)

Island Fresh(1)

Lemon Peel(1)

 
Capacity (Weight)

2.54 oz(15)

0.16 lb(10)

42.6 oz(4)

16 oz(3)

12 oz(3)

5.5 oz(2)

14 oz(1)

26.5 lbs(1)

0.03 lb(1)

0.08 lbs(1)

1 lb(1)

25 lbs(1)

30 oz(1)

13.5 lbs(1)

2 lbs(1)

10.8 lbs(1)

10.8 lb(1)

24 oz(1)

20 lbs(1)

2.1 oz(1)

 
 
 
 

© 2025-2026 Regal Office Supplies, All Rights Reserved