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

Air Wick(31)

Rubbermaid Commercial(20)

TimeMist(19)

BRIGHT Air(14)

Renuzit(12)

Febreze(10)

Misty(6)

Arm & Hammer(5)

Georgia Pacific Professional(5)

Glade(5)

LYSOL NEUTRA AIR FRESHMATIC(4)

LYSOL Neutra Air(3)

Diversey(2)

OdoBan(2)

Dymon(1)

Scott(1)

 
Color

Clear(4)

 
Recycled

No(4)

 
Packaged Quantity

1 Each(3)

1 / Each(1)

 
Assembly Required

No(4)

 
Warranty

Manufacturer's limited one-year warranty.(4)

 
Special Features

Twin Refill Pack(4)

Heavy Duty Strength-2X the tough odor-eliminating power.(1)

Paradise Retreat Scent-Coconut, almond blossom and cherry notes.(1)

Summer Delights Scent-Florals, sweet melon and vanilla notes.(1)

 
Application

Odor Control(69)

Automatic Odor Control(58)

Air Freshener(3)

Carpet;Upholstery(2)

Fabric(2)

Carpet; Rugs(1)

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

 
For Use With

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

TC 401219, 401278, 401442, 401758(4)

Georgia Pacific Professional 56755, 56765(3)

Air Wick RAC92944; RAC79782; RAC84178; RAC84179(3)

TC 400570, 400868, 400979, 401196, 401375(3)

Georgia Pacific Professional 56804(2)

Air Wick Freshmatic Ultra Dispensers(2)

RAC97290,RAC92944,RAC93554(2)

RAC98576; RAC98576EA; RAC98577; RAC98577EA(2)

TC 401218, 401375(2)

TC TCell Microtrans Odor Neutralizer(2)

TimeMist 32-0142TM01B, 32-0142XX01B, 32-1111TM, 32-1131TM, 32-1131WBY, 32-1131XX, 32-1141TM, 32-1141XX00(2)

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

 
Physical Form

Liquid(89)

Gel(15)

Solid(15)

Gel Beads(4)

Spray(4)

Oil(4)

Powder(3)

Aerosol(2)

 
Freshener/Sanitizer Type

Aerosol(4)

 
Freshener/Sanitizer Volume

5.5 fl oz (0.2 quart)(4)

 
Manufacturer Part Number

1001744(1)

96719(1)

4012571(1)

4012551(1)

4012441(1)

4009831(1)

3485952(1)

3485951(1)

3485950(1)

3485949(1)

98576(1)

98554(1)

98552(1)

98000(1)

97053(1)

96720(1)

96718(1)

401260A(1)

85825(1)

82314(1)

82314CT(1)

82680(1)

85595(1)

85823(1)

85823CT(1)

91099(1)

96717(1)

91101(1)

93045(1)

96531(1)

96532(1)

96533(1)

96534(1)

4012581(1)

401504(1)

79831CT(1)

1042677(1)

1048493(1)

1047606CT(1)

1047606(1)

1042818(1)

1042810(1)

1042786(1)

1042781(1)

1042771(1)

1042757(1)

1042756(1)

1042727(1)

1042705(1)

1042690(1)

1042686(1)

1042639(1)

4015471(1)

402470(1)

402093(1)

402110(1)

402112(1)

402113(1)

402369(1)

402408(1)

402472(1)

1042637(1)

682262(1)

682263(1)

682277(1)

697248(1)

699158(1)

1042421(1)

82093CT(1)

79831(1)

1001842(1)

900258(1)

03674(1)

03667CT(1)

03667(1)

03663CT(1)

03663(1)

03661CT(1)

03659CT(1)

03659(1)

3320094170CT(1)

3320094170(1)

3320084116CT(1)

3320084113CT(1)

3320084104(1)

900286CT(1)

900248(1)

35000CT(1)

900014CT(1)

1001870(1)

1015013(1)

1039375(1)

1039394(1)

900013CT(1)

900014(1)

900090CT(1)

900229CT(1)

900114CT(1)

900133(1)

900133CT(1)

900228(1)

900228CT(1)

900229(1)

35000(1)

35001(1)

79830CT(1)

77002(1)

97799(1)

97805(1)

97810(1)

05762CT(1)

76938CT(1)

76940CT(1)

77961(1)

96260(1)

77961CT(1)

78283(1)

78283CT(1)

79196(1)

79553(1)

79830(1)

97794(1)

96257(1)

35001CT(1)

48291(1)

94291110(1)

94355110(1)

48250(1)

48251(1)

48255(1)

48290(1)

33632(1)

96256(1)

91067(1)

911062-G4(1)

927062-QC12(1)

74902(1)

96254(1)

96255(1)

1048495(1)

 
Country of Origin

US(96)

TH(14)

HU(10)

MY(7)

CN(6)

United States(4)

CA(2)

VN(1)

 
Color(s)

White(6)

Clear(5)

Blue(4)

Opaque White(4)

Orange(3)

Pink(3)

Purple(2)

Light Blue(2)

Yellow(2)

Red(2)

Aqua(1)

Orange/White(1)

Orchid(1)

Lavender(1)

Lime(1)

White/Gray/Purple(1)

White/Gray/Blue(1)

White/Gray/Orange(1)

White/Gray(1)

 
Packing Type

Aerosol(74)

Jar(14)

Cone(12)

Bottle(8)

Cartridge(6)

TCell Refill(6)

Spray Bottle(5)

Box(3)

Stick Up(3)

Kit(2)

Can(2)

Pack(1)

 
Capacity (Volume)

5.89 oz(18)

7 oz(17)

6.6 oz(11)

10 oz(10)

14 oz(10)

5.3 oz(7)

3 oz(5)

48 ml(5)

8.8 oz(5)

2 oz(5)

1.9 oz(4)

13.8 oz(4)

2 x 8.8 oz(4)

6 oz(3)

1 gal(3)

0.67 oz(3)

32 oz(3)

8 oz(2)

1.62 oz(2)

7.5 oz(2)

0.87 oz(1)

6.17 oz(1)

 
Scent

Citrus(5)

Ocean Breeze(4)

Fresh Linen(3)

Fresh Waters(3)

Fresh(3)

Mandarin Orange(3)

Linen Fresh(3)

Cool & Clean(3)

Island Nectar & Pineapple(3)

Unscented(3)

Lavender & Chamomile(3)

Apple Cinnamon Medley(3)

Morning & Dew(2)

Spring & Renewal(2)

Linen & Sky(2)

Hawaiian Aloha(2)

Lemon Peel(2)

Lavender/Chamomile(2)

NEUTRA AIR Fresh(2)

Tropical Flowers(2)

Lavender & Almond Blossom(2)

Cucumber Melon(2)

Clean N' Fresh(2)

Bamboo and Green Tea(2)

Eucalyptus(2)

Crisp Breeze(2)

Sunscape Mango(2)

White Peach & Citrus(2)

Lavender & Fresh Linen(2)

Light Fresh(2)

Forever Raspberry(2)

After the Rain(2)

Citrus Sunburst(2)

Lovely Lavender(2)

Coastal Breeze(2)

Mandarin Orange & Fresh Lemon(1)

Wakening Spring(1)

Lavender; Vanilla(1)

Blue Splash(1)

Mango Blossom(1)

Alpine Mist(1)

Tropical Sunrise(1)

Super Fresh(1)

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

Hawaiian Breeze(1)

Clean Linen(1)

Baby Powder(1)

Clear Springs(1)

Lavender Zest(1)

Cinnamon(1)

Piņa Colada(1)

Bayberry(1)

Voodoo Berry(1)

Caribbean Waters(1)

Lavender Lemonade(1)

Country Garden(1)

Mango(1)

Dutch Apple & Spice(1)

Summer Breeze(1)

Wildwood Fig(1)

Mountain Peaks(1)

Gentle Breeze/Linen Fresh(1)

Cotton Berry/Refreshing Citrus(1)

Wild Raspberry & Pomegranate(1)

Neutral(1)

Cherry Almond(1)

Blissful Apple & Cinnamon(1)

Heavy Duty Crisp Clean(1)

Gain Original(1)

Revitalizing Fresh Breeze(1)

Energizing Citrus Zest(1)

Vanilla, Apricot Blossom & Almond(1)

Original(1)

Rejuvenating Morning Linen(1)

Light Scent(1)

Spring Rain(1)

Sea Mist/Ocean Breeze(1)

Paradise Retreat(1)

Summer Delights(1)

Lemon Idol(1)

Lavender Superstar(1)

Rosy Starlet(1)

Fruity Pin-Up(1)

Lavender(1)

Sunset Cotton(1)

Cool Citrus(1)

Zesty Lemon & Lime(1)

Fresh Water Breeze(1)

Alpine Springs/Mountain Peaks(1)

Desert Bloom(1)

 
Capacity (Weight)

2.1 oz(3)

42.6 oz(2)

1 lb(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved