facebook
 
 
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','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 '%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

Bright Air(43)

Air Wick(39)

TimeMist(28)

Febreze(26)

Rubbermaid Commercial(21)

Impact Products(12)

Glade(9)

Genuine Joe(9)

Citrus Magic(8)

RMC(8)

ActiveAire(7)

MISTY(5)

Renuzit(4)

Dial(4)

SNUGGLE(2)

Reckitt Benckiser(2)

PURELL®(2)

Lysol(2)

Georgia-Pacific(1)

 
Color

Clear(58)

White(35)

Blue(20)

Orange(20)

Purple(9)

Green(8)

Red(6)

Multicolor(6)

Blue/White(5)

Yellow(5)

Lavender(4)

Translucent(3)

Translucent Green(2)

Blue/Green(2)

Light Blue(2)

Clear Blue(2)

Black(2)

White/Green(2)

Lemon(2)

Light Yellow(2)

Off White(2)

Tan(2)

White/Red(2)

White/Aqua(1)

Salmon(1)

Pink(1)

Sunscape(1)

Aqua(1)

Citrus(1)

 
Recycled

No(224)

Yes(5)

 
Manufacturer Part Number

92944(1)

91112CT(1)

92944CT(1)

93045(1)

96531(1)

93045CT(1)

91112(1)

91110CT(1)

91101CT(1)

91101(1)

91109(1)

91109CT(1)

91110(1)

96532(1)

96533(1)

11963286CT(1)

11963286(1)

11963386(1)

11963386CT(1)

11963486CT(1)

11963486(1)

11963086CT(1)

11963086(1)

97290(1)

96534(1)

97290CT(1)

98552CT(1)

98554CT(1)

91099CT(1)

91099(1)

77002(1)

05762CT(1)

77002CT(1)

77961(1)

78283(1)

77961CT(1)

05762(1)

97810CT(1)

97799CT(1)

97799(1)

97805(1)

97805CT(1)

97810(1)

78283CT(1)

78473(1)

82680(1)

82314CT(1)

82680CT(1)

85595(1)

85595CT(1)

82314(1)

79831(1)

79553(1)

78473CT(1)

79553CT(1)

79717(1)

79717CT(1)

1957521(1)

1957522(1)

1042757(1)

1042756CT(1)

1042771(1)

1042771CT(1)

1042781CT(1)

1042781(1)

1042756(1)

1042727CT(1)

1042686CT(1)

1042686(1)

1042690(1)

1042690CT(1)

1042727(1)

1042786(1)

1042786CT(1)

1048493(1)

1047606(1)

1048493CT(1)

1048495(1)

1048495CT(1)

1045311CT(1)

1045311(1)

1042810CT(1)

1042810(1)

1042818(1)

1042818CT(1)

1045310(1)

1042639(1)

699158CT(1)

402112(1)

3486092(1)

402112CT(1)

402113(1)

402369(1)

402113CT(1)

3485952(1)

3485951(1)

1957524(1)

1957523(1)

1957525(1)

1957526(1)

3485950(1)

402369CT(1)

402408(1)

682263(1)

682262CT(1)

682263CT(1)

682277(1)

682277CT(1)

682262(1)

315104CT(1)

402470CT(1)

402470(1)

402472(1)

402472CT(1)

315104(1)

97794CT(1)

97794(1)

900255CT(1)

900255(1)

900256(1)

900256CT(1)

900426(1)

900288(1)

900254CT(1)

900254(1)

900229(1)

900228CT(1)

900229CT(1)

900248(1)

900248CT(1)

900426CT(1)

900436(1)

900440CT(1)

900440(1)

900441(1)

900441CT(1)

03659(1)

900439CT(1)

900439(1)

900437(1)

900436CT(1)

900437CT(1)

900438(1)

900438CT(1)

900228(1)

900134CT(1)

616472149CT(1)

616472149(1)

616472495(1)

618372831(1)

900013(1)

618372831CT(1)

612172147CT(1)

612172147(1)

1001870(1)

1001842(1)

1039375(1)

1039394(1)

612172146(1)

900013CT(1)

900014(1)

900114CT(1)

900114(1)

900115(1)

900115CT(1)

900134(1)

900090CT(1)

900090(1)

900021(1)

900014CT(1)

900021CT(1)

900022(1)

900022CT(1)

03659CT(1)

03663(1)

325VCT(1)

325V(1)

74901(1)

74901CT(1)

74902CT(1)

74902(1)

325OCT(1)

325O(1)

325L(1)

325BCT(1)

325LCT(1)

325M(1)

325MCT(1)

93306(1)

93306CT(1)

96257(1)

96256CT(1)

96257CT(1)

96260(1)

96260CT(1)

96256(1)

96255CT(1)

93326CT(1)

93326(1)

96254(1)

96254CT(1)

96255(1)

325B(1)

325ACT(1)

85162(1)

85161(1)

85163(1)

85164(1)

99661(1)

99660(1)

35001CT(1)

35001(1)

03674(1)

03663CT(1)

03674CT(1)

35000(1)

35000CT(1)

99662(1)

99663(1)

48290(1)

48255(1)

48291(1)

48295(1)

325A(1)

48254(1)

48253(1)

5457-04(1)

99664(1)

9652K1(1)

48251(1)

48252(1)

1001744(1)

 
Country of Origin

United States(137)

China(30)

Mexico(20)

Malaysia(16)

United Arab Emirates(13)

Hungary(6)

Thailand(5)

 
Weight (Approximate)

10.08 oz(7)

8.80 oz(7)

1 lb(4)

14.40 oz(2)

6 oz(1)

 
Scent

Lavender(14)

Citrus(11)

Linen & Sky(8)

Cinnamon(7)

Chamomile(7)

Summer Delights(6)

Papaya(6)

Freshwater(6)

Hawaiian Aloha(6)

Hawaiian Blossom(6)

Ocean Breeze(5)

Fresh Linen(5)

Apple Cinnamon(4)

Meadow Breeze(4)

Paradise Retreat(4)

Lemon(4)

Cucumber Melon(4)

Spa(4)

Morning Dew Scent(4)

Mango(4)

Spring & Renewal(4)

Cool(4)

Pineapple(4)

Fresh Citrus(4)

Macintosh Apple(4)

Clean(4)

Mandarin Orange(3)

Sweet Melon(3)

Sweet Almond Blossom(3)

Linen Fresh(3)

Coconut(3)

Island Nectar(3)

White Florals(3)

Subtle Vanilla(3)

Cool Clean(3)

Fresh Orange(2)

Apple Cinnamon Medley(2)

Clean Linen(2)

Sea Mist(2)

Alpine Sping(2)

Mountain Peaks(2)

Crisp Clean(2)

Gain Original(2)

Hawaiian Breeze(2)

Tang(2)

Cherry(2)

Turquoise Oasis(2)

Mango Blossom(2)

Tropical Flowers(2)

Cotton Berry(2)

Tropical Sunrise(2)

Super Fresh(2)

Glee(2)

Refreshing Citrus(2)

Vanilla Bean(2)

After the Rain(2)

Snuggle SuperFresh Original(2)

Apple(2)

Citrus Orchard(2)

Fresh Lemon(2)

Citrus Burst(2)

Dutch Apple & Spice(2)

Desert Bloom(2)

Wildwood Fig(2)

Sweet Lavender & Violet(2)

Calm Water(2)

Country Garden(2)

Fresh Lavender(2)

Fresh-N-Clean(2)

Apple Zing(2)

Mulberry Mist(2)

Orange Zest(2)

Pina Colada(2)

Baby Powder(2)

Sunscape(2)

Voodoo Berry(2)

Caribbean Waters(2)

Bamboo(1)

Lavender Mint(1)

Clear Spring(1)

Green Tea(1)

Lavender Lemonade(1)

Splash Blue(1)

Blue Splash(1)

Gentle Breeze(1)

Lavender Zest(1)

Fresh Cotton(1)

Lavender Field(1)

Breezy Linen(1)

Pacific Meadow(1)

Coastal Breeze(1)

Citrus Grove(1)

Cucumber(1)

Nectar(1)

Peach(1)

Lime(1)

Violet(1)

Cool + Clean(1)

Pure Linen(1)

Fresh(1)

Natural(1)

Fresh Water Breeze(1)

Spring Blossom(1)

Citrus Zest(1)

Spring(1)

Lavender & Almond Blossoms(1)

Lemon Idol(1)

Fresh Petals & Peach(1)

Topical Citrus Blend(1)

Sun-bleached Driftwood(1)

Salty Sea(1)

Warm Breezes(1)

Marine(1)

 
Recommended Use

Kill Germs(1)

 
Volume Capacity

40.6 fl oz (1200 mL)(1)

 
Composition

Ethyl Alcohol(1)

 
Freshener/Sanitizer Type

Spray(51)

Aerosol(42)

Oil(35)

Gel(18)

Liquid(15)

Solid(4)

Beads(2)

 
Effective Duration

60 Day(49)

30 Day(49)

45 Day(39)

180 Day(4)

90 Day(2)

50 Day(2)

6 Week(2)

 
Freshener/Sanitizer Weight

6.17 oz(12)

8 oz(9)

7 oz(8)

0.67 oz(7)

14 oz(4)

10 oz(4)

2.50 oz(3)

15.20 oz(1)

 
Freshener/Sanitizer Volume

6.6 fl oz (0.2 quart)(16)

8.8 fl oz (0.3 quart)(12)

7 fl oz (0.2 quart)(9)

10 fl oz (0.3 quart)(8)

6.2 fl oz (0.2 quart)(7)

5.3 fl oz (0.2 quart)(7)

8.5 fl oz (0.3 quart)(6)

4 fl oz (0.1 quart)(6)

0.7 fl oz (0 quart)(6)

13.8 fl oz (0.4 quart)(6)

14 fl oz (0.4 quart)(6)

6.4 fl oz (0.2 quart)(5)

1.9 fl oz (0.1 quart)(4)

8 fl oz (0.3 quart)(3)

1.3 fl oz (0 quart)(2)

0.9 fl oz (0 quart)(2)

12.8 fl oz (0.4 quart)(2)

2.5 fl oz (0.1 quart)(2)

0.2 fl oz (0 quart)(2)

25 fl oz (0.8 quart)(2)

6 fl oz (0.2 quart)(1)

7.5 fl oz (0.2 quart)(1)

13 fl oz (0.4 quart)(1)

6.5 fl oz (0.2 quart)(1)

1.6 fl oz (0.1 quart)(1)

32 fl oz (1 quart)(1)

 
Coverage Volume

6000 ft³(43)

3000 ft³(8)

450 ft³(2)

 
Product Type

Air Freshener Refill(109)

Air Freshener(109)

Deodorizer(8)

Air Freshener Kit(4)

Sanitizing Refill(1)

Sanitizer Kit(1)

 
Packaged Quantity

1 Each(63)

12 / Carton(62)

6 / Carton(57)

2 / Pack(20)

1 / Each(10)

4 / Carton(7)

12 / Dozen(4)

1 Kit(2)

16 / Carton(2)

3 / Pack(2)

12 / Pack(1)

1 / Pack(1)

8 / Carton(1)

 
Assembly Required

No(228)

Yes(2)

 
Product Model

402498(1)

MB 3000(1)

402369(1)

402113(1)

402112(1)

 
Product Line

Air(16)

TCell(10)

Scented Oil(9)

Super Odor Eliminator(9)

Life Scents(8)

Freshmatic(6)

Scent Gems(5)

Microburst(5)

V.I.Poo(4)

smallSPACES(4)

Renuzit(4)

Max(3)

Premium(3)

Simply Refreshed(2)

PlugIns(2)

Essential(2)

PLUG(2)

Fresh Picked(1)

Snuggle(1)

ActiveAire(1)