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)

OdoBan(2)

Diversey(1)

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)

Fabric(2)

Carpet; Rugs(1)

Carpet;Upholstery(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(88)

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)

97794(1)

79830(1)

79553(1)

79196(1)

78283CT(1)

78283(1)

77961CT(1)

77961(1)

77002(1)

76940CT(1)

76938CT(1)

05762CT(1)

97810(1)

97805(1)

97799(1)

96260(1)

35001CT(1)

33632(1)

94355110(1)

48250(1)

48251(1)

48255(1)

48290(1)

48291(1)

91067(1)

96257(1)

911062-G4(1)

927062-QC12(1)

74902(1)

96254(1)

96255(1)

96256(1)

1048495(1)

 
Country of Origin

US(96)

TH(14)

HU(10)

MY(7)

CN(6)

United States(4)

CA(1)

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

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)

2 oz(5)

48 ml(5)

8.8 oz(5)

3 oz(5)

1.9 oz(4)

2 x 8.8 oz(4)

13.8 oz(4)

32 oz(3)

0.67 oz(3)

6 oz(3)

7.5 oz(2)

1 gal(2)

1.62 oz(2)

8 oz(2)

0.87 oz(1)

6.17 oz(1)

 
Scent

Citrus(5)

Ocean Breeze(4)

Fresh Linen(3)

Apple Cinnamon Medley(3)

Mandarin Orange(3)

Linen Fresh(3)

Cool & Clean(3)

Island Nectar & Pineapple(3)

Lavender & Chamomile(3)

Unscented(3)

Fresh Waters(3)

Morning & Dew(2)

Spring & Renewal(2)

Linen & Sky(2)

Hawaiian Aloha(2)

Lavender/Chamomile(2)

Lemon Peel(2)

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

After the Rain(2)

Coastal Breeze(2)

Lovely Lavender(2)

Citrus Sunburst(2)

Lavender & Fresh Linen(2)

White Peach & Citrus(2)

Forever Raspberry(2)

Light Fresh(2)

Hawaiian Breeze(1)

Super Fresh(1)

Tropical Sunrise(1)

Blue Splash(1)

Alpine Mist(1)

Mango Blossom(1)

Lavender; Vanilla(1)

Wakening Spring(1)

Mandarin Orange & Fresh Lemon(1)

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

Clean Linen(1)

Piņa Colada(1)

Clear Springs(1)

Lavender Zest(1)

Cinnamon(1)

Baby Powder(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)

Spring Rain(1)

Cherry Almond(1)

Heavy Duty Crisp Clean(1)

Blissful Apple & Cinnamon(1)

Gain Original(1)

Revitalizing Fresh Breeze(1)

Energizing Citrus Zest(1)

Vanilla, Apricot Blossom & Almond(1)

Rejuvenating Morning Linen(1)

Original(1)

Light Scent(1)

Wild Raspberry & Pomegranate(1)

Paradise Retreat(1)

Sea Mist/Ocean Breeze(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)

Neutral(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