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

TimeMist(19)

Rubbermaid Commercial(19)

BRIGHT Air(14)

Renuzit(12)

Febreze(10)

Arm & Hammer(9)

Glade(5)

Misty(5)

LYSOL NEUTRA AIR FRESHMATIC(4)

LYSOL Neutra Air(3)

Georgia Pacific Professional(3)

Scott(2)

OdoBan(2)

Dymon(1)

Professional Air Wick(1)

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

Automatic Odor Control(58)

Air Freshener(3)

Refrigerators(2)

Fabric(2)

Odor Control; Cleaning(1)

Carpet;Rugs(1)

Carpet; Rugs(1)

Carpet;Upholstery(1)

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

 
Physical Form

Liquid(89)

Gel(13)

Solid(13)

Powder(7)

Gel Beads(4)

Spray(4)

Oil(3)

Aerosol(2)

 
Freshener/Sanitizer Type

Aerosol(4)

 
Freshener/Sanitizer Volume

5.5 fl oz (0.2 quart)(4)

 
Manufacturer Part Number

1001744(1)

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

96719(1)

96717(1)

4012581(1)

85595(1)

79831(1)

79831CT(1)

82093CT(1)

82314(1)

82314CT(1)

82680(1)

85823CT(1)

96534(1)

91099(1)

91101(1)

93045(1)

96531(1)

96532(1)

96533(1)

4012571(1)

401260A(1)

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

401504(1)

402470(1)

4015471(1)

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

79830CT(1)

79553(1)

1001842(1)

900286CT(1)

03663CT(1)

03663(1)

03661CT(1)

03659CT(1)

03659(1)

3320094170CT(1)

3320094170(1)

3320084116CT(1)

3320084113CT(1)

3320084113(1)

3320084104(1)

3320084011(1)

33200-01961(1)

3320001710(1)

900258(1)

03667CT(1)

900090CT(1)

1015013(1)

1039375(1)

1039394(1)

900013CT(1)

900014(1)

900014CT(1)

900114CT(1)

900248(1)

900133(1)

900133CT(1)

900228(1)

900228CT(1)

900229(1)

900229CT(1)

03667(1)

03674(1)

79196(1)

96257(1)

78283CT(1)

78283(1)

77961CT(1)

77961(1)

77002(1)

76940CT(1)

76938CT(1)

06732(1)

05762CT(1)

97810(1)

97805(1)

97799(1)

97794(1)

96260(1)

96256(1)

35000(1)

48291(1)

35000CT(1)

35001(1)

35001CT(1)

94355110(1)

48255(1)

48290(1)

33632(1)

96255(1)

12373(1)

91067(1)

911062-G4(1)

927062-QC12(1)

74902(1)

96254(1)

1048495(1)

 
Country of Origin

US(102)

TH(10)

HU(8)

MY(7)

CN(6)

United States(4)

CA(1)

VN(1)

 
Color(s)

White(7)

Clear(5)

Opaque White(4)

Blue(3)

Pink(3)

Orange(2)

Yellow(2)

Red(2)

Purple(2)

Orange/White(1)

Aqua(1)

Orchid(1)

Light Blue(1)

Lime(1)

White/Gray/Blue(1)

White/Gray/Orange(1)

White/Gray(1)

 
Packing Type

Aerosol(73)

Jar(14)

Cone(12)

Bottle(8)

Box(5)

Cartridge(5)

Spray Bottle(5)

TCell Refill(5)

Kit(2)

Can(2)

Unit(1)

Bag(1)

Pack(1)

Stick Up(1)

 
Capacity (Volume)

5.89 oz(18)

7 oz(17)

6.6 oz(11)

14 oz(10)

10 oz(9)

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

Unscented(5)

Citrus(5)

Ocean Breeze(4)

Apple Cinnamon Medley(3)

Mandarin Orange(3)

Cool & Clean(3)

Island Nectar & Pineapple(3)

Linen Fresh(3)

Fresh Linen(3)

Fresh Waters(3)

Meadows & Rain(2)

Spring & Renewal(2)

Linen & Sky(2)

Hawaiian Aloha(2)

Lavender & Chamomile(2)

Lemon Peel(2)

Lavender/Chamomile(2)

Fresh(2)

Mango(2)

Tropical Flowers(2)

Lavender & Almond Blossom(2)

Cucumber Melon(2)

Clean N' Fresh(2)

Bamboo and Green Tea(2)

Eucalyptus(2)

NEUTRA AIR Fresh(2)

White Peach & Citrus(2)

Forever Raspberry(2)

Lavender & Fresh Linen(2)

Original(2)

Light Fresh(2)

After the Rain(2)

Light Scent(2)

Lovely Lavender(2)

Citrus Sunburst(2)

Country Garden(1)

Lavender; Vanilla(1)

Mountain Peaks(1)

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

Wildwood Fig(1)

Blue Splash(1)

Mango Blossom(1)

Mandarin Orange & Fresh Lemon(1)

Tropical Sunrise(1)

Super Fresh(1)

Hawaiian Breeze(1)

Clean Linen(1)

Alpine Mist(1)

Clear Springs(1)

Lavender Lemonade(1)

Lavender Zest(1)

Cinnamon(1)

Cotton Berry/Refreshing Citrus(1)

Baby Powder(1)

Piņa Colada(1)

Bayberry(1)

Voodoo Berry(1)

Caribbean Waters(1)

Dutch Apple & Spice(1)

Neutral(1)

Zesty Lemon & Lime(1)

Sea Mist/Ocean Breeze(1)

Crisp Breeze(1)

Coastal Breeze(1)

Cherry Almond(1)

Heavy Duty Crisp Clean(1)

Blissful Apple & Cinnamon(1)

Gain Original(1)

Clean Breeze(1)

Revitalizing Fresh Breeze(1)

Energizing Citrus Zest(1)

Vanilla, Apricot Blossom & Almond(1)

Rejuvenating Morning Linen(1)

Summer Breeze(1)

Paradise Retreat(1)

Alpine Springs/Mountain Peaks(1)

Summer Delights(1)

Lemon Idol(1)

Lavender Superstar(1)

Rosy Starlet(1)

Fruity Pin-Up(1)

Lavender(1)

Sunset Cotton(1)

Wild Raspberry & Pomegranate(1)

Cool Citrus(1)

Sunscape Mango(1)

Fresh Water Breeze(1)

Gentle Breeze/Linen Fresh(1)

Desert Bloom(1)

 
Capacity (Weight)

42.6 oz(3)

5.5 oz(1)

13.5 lbs(1)

16 oz(1)

1 lb(1)

2.1 oz(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved