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

Currently Filtered by

Category

Air Fresheners Sanitizers

Refine Search

  GO
 
Brand

Air Wick(62)

Bright Air(48)

TimeMist(41)

Glade(31)

Rubbermaid Commercial(28)

Febreze(24)

Impact Products(12)

Genuine Joe(11)

Renuzit(10)

RMC(10)

Lysol(9)

Dial(8)

ActiveAire(8)

Citrus Magic(7)

MISTY(7)

Fresh Products(7)

Reckitt Benckiser(5)

PURELL®(4)

Clorox(3)

Arm & Hammer(2)

Kimberly-Clark(2)

SNUGGLE(2)

Zep Commercial(2)

Dymon(2)

Johnson(1)

Big 3 Packaging(1)

SKILCRAFT(1)

Georgia-Pacific(1)

P&G(1)

 
Color

Clear(107)

White(50)

Blue(22)

Orange(22)

Purple(14)

Green(13)

Yellow(8)

Multicolor(8)

Red(7)

Blue/White(6)

Black(4)

White/Green(4)

Light Yellow(3)

Translucent(3)

Lavender(3)

White/Brown/Red(2)

Light Blue(2)

Translucent Green(2)

Tan(2)

Clear Blue(2)

Orchid(2)

Off White(2)

White/Red(2)

Lemon(2)

Blue/Green(2)

Assorted(1)

Sunscape(1)

Pink(1)

Beige(1)

Dark Red(1)

Salmon(1)

Aqua(1)

Citrus(1)

 
Recycled

No(325)

Yes(20)

 
Packaged Quantity

1 Each(101)

12 / Carton(94)

6 / Carton(71)

2 / Pack(25)

1 / Each(13)

4 / Carton(12)

8 / Carton(6)

12 / Dozen(4)

1 Kit(4)

10 / Pack(3)

12 / Box(3)

3 / Pack(3)

15 / Carton(2)

24 / Carton(2)

1 Pack(1)

6 / Box(1)

100 / Each(1)

1 / Pack(1)

1 Dozen(1)

 
Assembly Required

No(341)

Yes(2)

 
Weight (Approximate)

8.80 oz(11)

10.08 oz(7)

1 lb(4)

14.40 oz(2)

5.92 oz(2)

4.80 oz(2)

11.50 lb(1)

13.79 oz(1)

7.40 lb(1)

6 oz(1)

 
Compatibility

TimeMist Metered Fragrance Dispensers(19)

Air Wick Freshmatic Automatic Dispensers(11)

Rochester-Midland Oxy-Gen Air Care System Dispenser(7)

Impact Metered Aerosol Dispensers(6)

Air Wick Oil Warmers(6)

ActiveAire Freshener Dispenser(6)

Air Wick Freshmatic Ultra Automatic Sprayers(6)

Rubbermaid Microburst Duet Dispenser

(5)

Rubbermaid Commercial TCell 2.0(5)

Air Wick Scented Oil Warmer(4)

Febreze Oil Warmers(4)

Bright Air Glade and Air Wick Warmer Unit(4)

Glad Automatic Sprayers(4)

Glade PlugIns Scented Oil Warmers(4)

Rubbermaid TCell Dispenser(4)

TimeMist Metered Dispensers(3)

Air Wick Scented Oil Warmers(3)

Rochester-Midland Oxy-Gen 1962986 Air Care System Dispenser(3)

Georgia-Pacific ActiveAire Whole-Room Freshener Dispensers(3)

Air Wick scented Oil Warmers(3)

  • TimeMist 3000 Shot Micro Dispenser
  • TimeMist Micro Metered Dispensers
(2)

Rubbermaid Microburst LCD Dispensers (5137 and 5169)(2)

Glade PlugIns Scented Oil Warmer(2)

TimeMist 9000 Shot Dispensers(2)

  • TimeMist Fragrance Dispensers
  • Lite Mist Fragrance Dispensers
  • Encore Plus Fragrance Dispensers
(2)

  • VOC
  • NFPA Code 30B Storage Level 3
(2)

Air Wick Essential Mist Diffuser(2)

VOC(2)

  • TimeMist Continuous Fan Dispenser
  • Worldwind Fragrance Dispenser System
(2)

TimeMist 9000 Shot Micro Dispenser(1)

Bright Air, Glade and Air Wick Warmer Units(1)

TimeMist full-sized Metered Fragrance Dispensers(1)

Skilcraft Zep Meter Mist Dispensers:

  • 3000
  • 3000 Plus
(1)

Rubbermaid Microburst 3000 Dispensers:

  • 401442
  • 1793532
  • 1793533
  • 1793531
(1)

Rubbermaid Commercial TCell 2.0 Fan Dispenser:

  • 1957531
  • 1957532
  • 1957533
  • 1972664
  • 1972662
  • 1972663
(1)

Airwick Freshmatic Dispenser(1)

Air Wick i-Motion Freshmatic Ultra Automatic Spray System

(1)

Airwick Freshmatic Dispensers(1)

Air Wick Freshmatic Dispenser

(1)

Rubbermaid Commercial Microburst 9000 Dispensers(1)

Air Wick Freshmatic Dispensers(1)

Air Wick Dispensers:

  • Freshmatic Ultra
  • Ultra Odor Detect
(1)

Rubbermaid T-Cell Dispenser(1)

  • Rubbermaid Commercial Microburst 3000 LCD Dispenser
  • Rubbermaid Commercial Microburst 3000 Economizer Dispenser
(1)

Rubbermaid 9C90 Fan System

(1)

 
Recycled Content

25%(20)

 
Recommended Use

Kill Germs(2)

 
Volume Capacity

40.6 fl oz (1200 mL)(1)

12 fl oz (354.9 mL)(1)

 
Composition

Ethyl Alcohol(2)

 
Freshener/Sanitizer Type

Spray(74)

Aerosol(71)

Oil(54)

Liquid(17)

Gel(16)

Beads(8)

Stick(6)

Solid(6)

 
Additional Information

Color: Clear(1)

  • Leaves a clean and pleasant fragrance
  • Sanitizing spray eliminates tough odors such as smoke, food, mold, mildew, bathroom and pet odors
(1)

 
Effective Duration

30 Day(82)

60 Day(74)

45 Day(44)

180 Day(5)

90 Day(4)

50 Day(2)

6 Week(2)

6 Month(1)

 
Freshener/Sanitizer Weight

6.17 oz(13)

7 oz(10)

8 oz(9)

10 oz(9)

0.67 oz(7)

14 oz(6)

2.50 oz(3)

1.05 oz(2)

16 oz(1)

5.30 oz(1)

15.20 oz(1)

 
Freshener/Sanitizer Volume

6.6 fl oz (0.2 quart)(19)

6.2 fl oz (0.2 quart)(17)

7 fl oz (0.2 quart)(14)

8.8 fl oz (0.3 quart)(12)

10 fl oz (0.3 quart)(11)

0.7 fl oz (0 quart)(10)

14 fl oz (0.4 quart)(10)

5.3 fl oz (0.2 quart)(10)

8 fl oz (0.3 quart)(9)

5.5 fl oz (0.2 quart)(8)

8.5 fl oz (0.3 quart)(6)

13.8 fl oz (0.4 quart)(6)

9 fl oz (0.3 quart)(6)

32 fl oz (1 quart)(5)

6.4 fl oz (0.2 quart)(5)

12.4 fl oz (0.4 quart)(4)

1.9 fl oz (0.1 quart)(4)

0.2 fl oz (0 quart)(3)

4 fl oz (0.1 quart)(3)

2.5 fl oz (0.1 quart)(3)

0.9 fl oz (0 quart)(2)

3 fl oz (0.1 quart)(2)

1.3 fl oz (0 quart)(2)

7.5 fl oz (0.2 quart)(2)

20 fl oz (0.6 quart)(2)

12.8 fl oz (0.4 quart)(2)

16 fl oz (0.5 quart)(1)

256 fl oz (8 quart)(1)

7.3 fl oz (0.2 quart)(1)

6 fl oz (0.2 quart)(1)

6.5 fl oz (0.2 quart)(1)

13 fl oz (0.4 quart)(1)

2 fl oz (0.1 quart)(1)

1.6 fl oz (0.1 quart)(1)

 
Coverage Volume

6000 ft(50)

3000 ft(10)

450 ft(2)

 
Manufacturer Part Number

98552(1)

98000CT(1)

98000(1)

97290CT(1)

98554(1)

98576(1)

11963186(1)

11963086CT(1)

11963086(1)

97290(1)

97053CT(1)

96719CT(1)

96719(1)

96718CT(1)

96718(1)

96720(1)

96720CT(1)

97053(1)

97052CT(1)

97052(1)

11963186CT(1)

11963286(1)

3485952(1)

3485951(1)

3485950(1)

3485949(1)

3486092(1)

4012471(1)

402112CT(1)

402112(1)

4012551(1)

1957526(1)

1957525(1)

11963486(1)

11963386CT(1)

11963386(1)

11963286CT(1)

11963486CT(1)

1957521(1)

1957524(1)

1957523(1)

1957522(1)

96717CT(1)

96717(1)

82314CT(1)

82314(1)

82093CT(1)

82093(1)

82680(1)

82680CT(1)

85595(1)

85175CT(1)

85175(1)

80420CT(1)

80420(1)

79717(1)

79553CT(1)

79553(1)

79196CT(1)

79717CT(1)

79831(1)

80095CT(1)

80095(1)

79831CT(1)

85595CT(1)

85823(1)

93045(1)

92944CT(1)

92944(1)

91112CT(1)

93045CT(1)

96531(1)

96534(1)

96533(1)

96532(1)

91112(1)

91110CT(1)

91099CT(1)

91099(1)

85825(1)

85823CT(1)

91101(1)

91101CT(1)

91110(1)

91109CT(1)

91109(1)

402113(1)

402113CT(1)

1042756(1)

1042727CT(1)

1042727(1)

1042705CT(1)

1042756CT(1)

1042757(1)

1042781(1)

1042771CT(1)

1042771(1)

1042705(1)

1042690CT(1)

1042649(1)

1042639(1)

1042637(1)

1042421CT(1)

1042677(1)

1042677CT(1)

1042690(1)

1042686CT(1)

1042686(1)

1042781CT(1)

1042786(1)

1048493(1)

1047606CT(1)

1047606(1)

1045311CT(1)

1048493CT(1)

1048495(1)

ZUSOE16CT(1)

ZUSOE16(1)

1048495CT(1)

1045311(1)

1045310(1)

1042810CT(1)

1042810(1)

1042798(1)

1042786CT(1)

1042818(1)

1042818CT(1)

1044935CT(1)

1044935(1)

1043978(1)

1042421(1)

699158(1)

301971CT(1)

301971(1)

301970CT(1)

301970(1)

305869(1)

305869CT(1)

306041(1)

306038CT(1)

306038(1)

9C94010000(1)

5139CT(1)

402470(1)

402408(1)

402369CT(1)

402369(1)

402470CT(1)

402472(1)

5138000000CT(1)

5138000000(1)

402472CT(1)

306041CT(1)

306043(1)

682263(1)

682262CT(1)

682262(1)

649053CT(1)

682263CT(1)

682277(1)

697248CT(1)

697248(1)

682277CT(1)

649053(1)

649030CT(1)

313206(1)

312865(1)

312864(1)

306043CT(1)

630125(1)

630125CT(1)

649030(1)

643259CT(1)

643259(1)

79196(1)

78473CT(1)

900438CT(1)

900438(1)

900437CT(1)

900437(1)

900439(1)

900440(1)

AR33200941CT(1)

AR3320094170(1)

900441(1)

900436CT(1)

900436(1)

900270CT(1)

900270(1)

900258CT(1)

900258(1)

900286(1)

900286CT(1)

900426(1)

900288CT(1)

900288(1)

31710(1)

31711(1)

03674CT(1)

03674(1)

03667CT(1)

03667(1)

22151(1)

22151CT(1)

35001(1)

35000CT(1)

35000(1)

03663CT(1)

03663(1)

02221(1)

02201CT(1)

02201(1)

31711CT(1)

02221CT(1)

03659(1)

03661CT(1)

03661(1)

03659CT(1)

900256CT(1)

900256(1)

900013(1)

618372831CT(1)

618372831(1)

616472149CT(1)

900013CT(1)

900014(1)

900021CT(1)

900021(1)

900014CT(1)

616472149(1)

616471663(1)

1039375(1)

1015013(1)

1001870(1)

1001842(1)

1039394(1)

1039402(1)

612172147CT(1)

612172147(1)

58531004(1)

900022(1)

900022CT(1)

900248(1)

900229CT(1)

900229(1)

900228CT(1)

900248CT(1)

900254(1)

900255CT(1)

900255(1)

900254CT(1)

900228(1)

900134CT(1)

900114CT(1)

900114(1)

900090CT(1)

900090(1)

900115(1)

900115CT(1)

900134(1)

900133CT(1)

900133(1)

35001CT(1)

EA36SAP(1)

96255CT(1)

96255(1)

96254CT(1)

96254(1)

96256(1)

96256CT(1)

96260(1)

96257CT(1)

96257(1)

90189(1)

90188CT(1)

6840014598263(1)

91072(1)

91067(1)

70220CT(1)

74901(1)

74901CT(1)

90188(1)

74902CT(1)

74902(1)

96260CT(1)

97794(1)

77002CT(1)

77002(1)

76940CT(1)

76940(1)

77961(1)

77961CT(1)

78473(1)

78283CT(1)

78283(1)

76938CT(1)

76938(1)

97805(1)

97799CT(1)

97799(1)

97794CT(1)

97805CT(1)

97810(1)

05762CT(1)

05762(1)

97810CT(1)

70220(1)

325VCT(1)

99662(1)

99661(1)

99660(1)

85164(1)

99663(1)

99664(1)

9120K1EC(1)

5457-04(1)

369112(1)

85163(1)

85162(1)

RC30CBL(1)

EF12CME(1)

EBC72MAN(1)

EBC72CME(1)

RC30CME(1)

RC30MAN(1)

85161(1)

10356CT(1)

10356(1)

9652K1(1)

48250(1)

325LCT(1)

325L(1)

325BCT(1)

325B(1)

325M(1)

325MCT(1)

325V(1)

325OCT(1)

325O(1)

325ACT(1)

325A(1)

48253(1)

48252(1)

48251(1)

48254(1)

48255(1)

48295(1)

48291(1)

48290(1)

1001744(1)

 
Country of Origin

United States(228)

China(33)

Mexico(31)

Malaysia(18)

United Arab Emirates(15)

Thailand(9)

Hungary(8)

Canada(4)

Taiwan(2)

 
Scent

Lavender(24)

Citrus(20)

Hawaiian Breeze(10)

Clean Linen(10)

Ocean Breeze(10)

Cucumber Melon(9)

Chamomile(8)

Mango(7)

Freshwater(7)

Linen & Sky(7)

Cinnamon(7)

Tropical Flowers(6)

Hawaiian Blossom(6)

Papaya(6)

Summer Delights(6)

Fresh Linen(5)

Fresh(5)

Sweet Almond Blossom(5)

Fresh Citrus(5)

Sunset Cotton(4)

Vanilla(4)

Fresh Lavender(4)

Apple Cinnamon(4)

Meadows & Rain(4)

Apple Cinnamon Medley(4)

Paradise Retreat(4)

Lemon(4)

Spring & Renewal(4)

Linen Fresh(4)

Hawaiian Aloha(4)

Spa(4)

Mandarin Orange(4)

Cool(4)

Clean(4)

Macintosh Apple(4)

Pineapple(4)

Island Nectar(3)

White Florals(3)

Dutch Apple & Spice(3)

Country Garden(3)

Subtle Vanilla(3)

Sweet Melon(3)

Coconut(3)

Violet(3)

Meadow Breeze(3)

Tang(2)

Glee(2)

Bliss(2)

Gentle Breeze(2)

Mountain Peaks(2)

Sea Mist(2)

Alpine Sping(2)

Cherry(2)

Almond Scent Swirls(2)

Fresh Lemon(2)

Crisp Breeze(2)

Hibiscus Flower(2)

Pomegranate(2)

Wild Raspberry(2)

Refreshing Citrus(2)

Fresh Orange(2)

Hawaii Exotic Papaya(2)

Cotton Berry(2)

Cool Clean(2)

Fresh-N-Clean(2)

Caribbean Waters(2)

Acapulco Splash(2)

Green Tea(2)

Desert Bloom(2)

Wildwood Fig(2)

Bamboo(2)

Voodoo Berry(2)

Bayberry(2)

Spring Garden(2)

Tropical Sunrise(2)

Mango Blossom(2)

Lemon Lime(2)

Super Fresh(2)

Pina Colada(2)

Baby Powder(2)

Clean and Fresh(2)

White Lilac(2)

Turquoise Oasis(2)

Mulberry Mist(2)

White Peach(2)

Orange Zest(2)

Vanilla Bean(2)

Apricot Blossom(2)

Sugar & Spice(2)

Sunscape(2)

Coastal Breeze(2)

Raspberry(2)

After the Rain(2)

Apple(2)

Blue Sky Breeze(2)

Citrus Orchard(2)

Calm Water(2)

Apple Zing(2)

Sparkling Rain(2)

Gain Original(2)

Crisp Clean(2)

Revitalizing Fresh Breeze(2)

Snuggle SuperFresh Original(2)

Cool Fresh(2)

Clean Air(2)

Hawaiian(2)

Cucumber(1)

Sparkling Citrus(1)

Fresh Petals & Peach(1)

Powder Linen(1)

Toasty Pumpkin Spice(1)

Cozy Cider Sipping(1)

Icy Evergreen Forest(1)

Citrus Grove(1)

Clear Spring(1)

Peach(1)

Citrus Sparkle Zest(1)

French Kiss(1)

Lime(1)

Fresh Waters(1)

Morning Linen Scent(1)

Spring Flower(1)

Sweet Lavender & Violet(1)

Spring(1)

Nectar(1)

Lavender Lemonade(1)

Spiced Apple(1)

Cotton Blossom(1)

Fresh Cotton(1)

Cool + Clean(1)

Ocean(1)

Citrus Burst(1)

Natural(1)

Spring Blossom(1)

Fresh Water Breeze(1)

Lavender Zest(1)

Salty Sea(1)

Warm Breezes(1)

Lemon Idol(1)

Autumn Fresh(1)

Citrus Zest(1)

Marine(1)

Blue Splash(1)

Sun-bleached Driftwood(1)

Citrus Breeze(1)

Lavender Field(1)

Splash Blue(1)

Linen(1)

Lavender Mint(1)

Rejuvenating Morning Linen(1)

Pacific Meadow(1)

Breezy Linen(1)

Summer Breeze(1)

 
Dispenser Type

Pump Bottle(1)

 
 
 
 
 

© 2019-2020 Bayshore Office Products, Inc., All Rights Reserved