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

TimeMist(19)

Rubbermaid Commercial(18)

BRIGHT Air(14)

Febreze(12)

Renuzit(11)

Misty(7)

Glade(5)

Georgia Pacific Professional(5)

LYSOL NEUTRA AIR FRESHMATIC(4)

LYSOL Neutra Air(3)

OdoBan(2)

Diversey(1)

Dymon(1)

Scott(1)

 
Color

Clear(3)

 
Recycled

No(3)

 
Packaged Quantity

1 Each(3)

 
Assembly Required

No(3)

 
Warranty

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

 
Special Features

Twin Refill Pack(3)

Starter Kit-Includes one base unit and one scent cartridge.(2)

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

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

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

 
Application

Odor Control(62)

Automatic Odor Control(58)

Air Freshener(3)

Fabric(2)

Carpet;Upholstery(1)

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

 
Physical Form

Liquid(88)

Gel(15)

Solid(11)

Gel Beads(4)

Spray(4)

Oil(3)

Aerosol(2)

 
Freshener/Sanitizer Type

Aerosol(3)

 
Freshener/Sanitizer Volume

5.5 fl oz (0.2 quart)(3)

 
Manufacturer Part Number

98554(1)

98576(1)

3485949(1)

98552(1)

98000(1)

96720(1)

97053(1)

3485950(1)

3485951(1)

4012571(1)

4012581(1)

4012551(1)

4012441(1)

3485952(1)

4009831(1)

96719(1)

96718(1)

82680(1)

85595(1)

82314CT(1)

82314(1)

79831(1)

79831CT(1)

91099(1)

91101(1)

96534(1)

96717(1)

96533(1)

96532(1)

93045(1)

96531(1)

401504(1)

4015471(1)

1042756(1)

1042757(1)

1042771(1)

1042727(1)

1042705(1)

1042686(1)

1042690(1)

1042781(1)

1042786(1)

1048493(1)

1048495(1)

1047606CT(1)

1047606(1)

1042810(1)

1042818(1)

1042677(1)

1042639(1)

402408(1)

402470(1)

402369(1)

402113(1)

402093(1)

402112(1)

402472(1)

682262(1)

1042421(1)

1042637(1)

699158(1)

697248(1)

682263(1)

682277(1)

79830CT(1)

79830(1)

03659(1)

03659CT(1)

03663(1)

900286CT(1)

900258(1)

900229CT(1)

900248(1)

03663CT(1)

03667(1)

35001(1)

35001CT(1)

35000CT(1)

35000(1)

03667CT(1)

03674(1)

900229(1)

900228CT(1)

1039394(1)

1039402(1)

1039375(1)

1015013(1)

1001842(1)

1001870(1)

900013CT(1)

900014(1)

900133CT(1)

900228(1)

900133(1)

900114CT(1)

900014CT(1)

900090CT(1)

94355110(1)

48250(1)

05762CT(1)

76938CT(1)

97810(1)

97805(1)

97794(1)

97799(1)

76940CT(1)

77002(1)

79196(1)

79553(1)

78283CT(1)

78283(1)

77961(1)

77961CT(1)

96260(1)

96257(1)

33632(1)

91067(1)

48291(1)

48290(1)

48251(1)

48255(1)

911062-G4(1)

927062-QC12(1)

96255(1)

96256(1)

96254(1)

90189(1)

74902(1)

90188CT(1)

1001744(1)

 
Country of Origin

US(96)

TH(9)

HU(7)

CN(6)

MY(6)

United States(3)

MX(1)

CA(1)

VN(1)

 
Color(s)

Clear(6)

Blue(4)

Opaque White(4)

White(4)

Pink(3)

Orange(3)

Yellow(2)

Red(2)

Purple(2)

White/Gray/Orange(1)

White/Gray(1)

White/Gray/Blue(1)

Orchid(1)

Lime(1)

Aqua(1)

 
Packing Type

Aerosol(72)

Jar(14)

Cone(11)

Cartridge(8)

Bottle(7)

Spray Bottle(5)

TCell Refill(5)

Can(2)

Kit(2)

Pack(1)

 
Capacity (Volume)

5.89 oz(17)

7 oz(14)

6.6 oz(11)

10 oz(10)

14 oz(10)

5.3 oz(7)

3 oz(5)

8.8 oz(5)

1.9 oz(4)

13.8 oz(4)

2 oz(4)

2 x 8.8 oz(4)

48 ml(4)

32 oz(3)

0.67 oz(3)

6 oz(3)

8 oz(2)

1 gal(2)

5.5 mL(2)

1.62 oz(2)

7.5 oz(2)

6.17 oz(1)

0.87 oz(1)

5 oz(1)

5.5 oz(1)

 
Scent

Citrus(5)

Ocean Breeze(4)

Hawaiian Aloha(3)

Linen Fresh(3)

Apple Cinnamon Medley(3)

Fresh Linen(3)

Island Nectar & Pineapple(3)

Mandarin Orange(3)

Linen & Sky(3)

Cool & Clean(3)

Cucumber Melon(2)

Lavender & Chamomile(2)

Spring & Renewal(2)

Tropical Flowers(2)

Lavender & Fresh Linen(2)

White Peach & Citrus(2)

Clean N' Fresh(2)

Alpine Mist(2)

Lemon Peel(2)

NEUTRA AIR Fresh(2)

Fresh(2)

Fresh Waters(2)

Lavender/Chamomile(2)

Eucalyptus(2)

Meadows & Rain(2)

Unscented(2)

Citrus Sunburst(2)

Forever Raspberry(2)

After the Rain(2)

Lavender & Almond Blossom(2)

Lovely Lavender(2)

Bamboo and Green Tea(2)

Sunscape Mango(2)

Coastal Breeze(2)

Wildwood Fig(1)

Mountain Peaks(1)

Desert Bloom(1)

Hawaiian Breeze(1)

Blue Splash(1)

Mango Blossom(1)

Clean Linen(1)

Tropical Sunrise(1)

Super Fresh(1)

Cinnamon(1)

Caribbean Waters(1)

Voodoo Berry(1)

Lavender Lemonade(1)

Country Garden(1)

Mango(1)

Bayberry(1)

Cotton Berry/Refreshing Citrus(1)

Clear Springs(1)

Dutch Apple & Spice(1)

Baby Powder(1)

Piņa Colada(1)

Lavender; Vanilla(1)

Paradise Retreat(1)

Cherry Almond(1)

Blissful Apple & Cinnamon(1)

Neutral(1)

Heavy Duty Crisp Clean(1)

Gain Original(1)

Wild Raspberry & Pomegranate(1)

Cool Citrus(1)

Summer Breeze(1)

Spring Rain(1)

Lavender Zest(1)

Mandarin Orange & Fresh Lemon(1)

Zesty Lemon & Lime(1)

Revitalizing Fresh Breeze(1)

Energizing Citrus Zest(1)

Sunset Cotton(1)

Lavender(1)

Fresh Water Breeze(1)

Gentle Breeze/Linen Fresh(1)

Alpine Springs/Mountain Peaks(1)

Fruity Pin-Up(1)

Rosy Starlet(1)

Rejuvenating Morning Linen(1)

Summer Delights(1)

Lemon Idol(1)

Lavender Superstar(1)

Sea Mist/Ocean Breeze(1)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved