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)

RMC(8)

Citrus Magic(8)

ActiveAire(7)

MISTY(5)

Dial(4)

Renuzit(4)

PURELL®(2)

Lysol(2)

Reckitt Benckiser(2)

SNUGGLE(2)

Georgia-Pacific(1)

 
Color

Clear(58)

White(35)

Orange(20)

Blue(20)

Purple(9)

Green(8)

Red(6)

Multicolor(6)

Blue/White(5)

Yellow(5)

Lavender(4)

Translucent(3)

Tan(2)

Light Blue(2)

Translucent Green(2)

Clear Blue(2)

White/Green(2)

Light Yellow(2)

White/Red(2)

Off White(2)

Black(2)

Lemon(2)

Blue/Green(2)

Salmon(1)

Citrus(1)

Aqua(1)

Sunscape(1)

Pink(1)

White/Aqua(1)

 
Recycled

No(224)

Yes(5)

 
Manufacturer Part Number

1001744(1)

96532(1)

91109(1)

91109CT(1)

91110(1)

91110CT(1)

91112(1)

91112CT(1)

92944(1)

92944CT(1)

93045(1)

93045CT(1)

96531(1)

96533(1)

91101(1)

96534(1)

97290(1)

97290CT(1)

98552CT(1)

98554CT(1)

11963086(1)

11963086CT(1)

11963286(1)

11963286CT(1)

11963386(1)

11963386CT(1)

11963486(1)

91101CT(1)

91099CT(1)

1957521(1)

78283CT(1)

97805(1)

97805CT(1)

97810(1)

97810CT(1)

05762(1)

05762CT(1)

77002(1)

77002CT(1)

77961(1)

77961CT(1)

78283(1)

78473(1)

91099(1)

78473CT(1)

79553(1)

79553CT(1)

79717(1)

79717CT(1)

79831(1)

82314(1)

82314CT(1)

82680(1)

82680CT(1)

85595(1)

85595CT(1)

11963486CT(1)

1957522(1)

97799(1)

1042781CT(1)

1042686CT(1)

1042690(1)

1042690CT(1)

1042727(1)

1042727CT(1)

1042756(1)

1042756CT(1)

1042757(1)

1042771(1)

1042771CT(1)

1042781(1)

1042786(1)

1042639(1)

1042786CT(1)

1042810(1)

1042810CT(1)

1042818(1)

1042818CT(1)

1045310(1)

1045311(1)

1045311CT(1)

1047606(1)

1048493(1)

1048493CT(1)

1048495(1)

1042686(1)

699158CT(1)

1957523(1)

402369(1)

1957524(1)

1957525(1)

1957526(1)

3485950(1)

3485951(1)

3485952(1)

3486092(1)

402112(1)

402112CT(1)

402113(1)

402113CT(1)

402369CT(1)

682277CT(1)

402408(1)

402470(1)

402470CT(1)

402472(1)

402472CT(1)

315104(1)

315104CT(1)

682262(1)

682262CT(1)

682263(1)

682263CT(1)

682277(1)

97799CT(1)

97794CT(1)

1001842(1)

900426(1)

900229(1)

900229CT(1)

900248(1)

900248CT(1)

900254(1)

900254CT(1)

900255(1)

900255CT(1)

900256(1)

900256CT(1)

900288(1)

900426CT(1)

900228(1)

900436(1)

900436CT(1)

900437(1)

900437CT(1)

900438(1)

900438CT(1)

900439(1)

900439CT(1)

900440(1)

900440CT(1)

900441(1)

900441CT(1)

900228CT(1)

900134CT(1)

03659CT(1)

900013(1)

1001870(1)

1039375(1)

1039394(1)

612172146(1)

612172147(1)

612172147CT(1)

616472149(1)

616472149CT(1)

616472495(1)

618372831(1)

618372831CT(1)

900013CT(1)

900134(1)

900014(1)

900014CT(1)

900021(1)

900021CT(1)

900022(1)

900022CT(1)

900090(1)

900090CT(1)

900114(1)

900114CT(1)

900115(1)

900115CT(1)

03659(1)

03663(1)

97794(1)

93306(1)

325LCT(1)

325M(1)

325MCT(1)

325O(1)

325OCT(1)

325V(1)

325VCT(1)

74901(1)

74901CT(1)

74902(1)

74902CT(1)

93306CT(1)

325BCT(1)

93326(1)

93326CT(1)

96254(1)

96254CT(1)

96255(1)

96255CT(1)

96256(1)

96256CT(1)

96257(1)

96257CT(1)

96260(1)

96260CT(1)

325L(1)

325B(1)

03663CT(1)

99662(1)

03674(1)

03674CT(1)

35000(1)

35000CT(1)

35001(1)

35001CT(1)

85161(1)

85162(1)

85163(1)

85164(1)

99660(1)

99661(1)

99663(1)

325ACT(1)

99664(1)

5457-04(1)

9652K1(1)

48251(1)

48252(1)

48253(1)

48254(1)

48255(1)

48290(1)

48291(1)

48295(1)

325A(1)

1048495CT(1)

 
Country of Origin

United States(137)

China(30)

Mexico(20)

Malaysia(16)

United Arab Emirates(13)

Hungary(6)

Thailand(5)

 
Weight (Approximate)

8.80 oz(7)

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

Freshwater(6)

Hawaiian Aloha(6)

Hawaiian Blossom(6)

Papaya(6)

Ocean Breeze(5)

Fresh Linen(5)

Apple Cinnamon(4)

Cucumber Melon(4)

Lemon(4)

Morning Dew Scent(4)

Paradise Retreat(4)

Mango(4)

Meadow Breeze(4)

Spring & Renewal(4)

Spa(4)

Macintosh Apple(4)

Fresh Citrus(4)

Clean(4)

Pineapple(4)

Cool(4)

White Florals(3)

Mandarin Orange(3)

Cool Clean(3)

Sweet Almond Blossom(3)

Sweet Melon(3)

Linen Fresh(3)

Island Nectar(3)

Coconut(3)

Subtle Vanilla(3)

Mountain Peaks(2)

Turquoise Oasis(2)

Cherry(2)

Tropical Flowers(2)

Glee(2)

Tang(2)

Fresh Orange(2)

Refreshing Citrus(2)

Alpine Sping(2)

Pina Colada(2)

Wildwood Fig(2)

Dutch Apple & Spice(2)

Country Garden(2)

Fresh-N-Clean(2)

Caribbean Waters(2)

Voodoo Berry(2)

Baby Powder(2)

Sea Mist(2)

Clean Linen(2)

Hawaiian Breeze(2)

Super Fresh(2)

Tropical Sunrise(2)

Mango Blossom(2)

Cotton Berry(2)

Apple Cinnamon Medley(2)

Desert Bloom(2)

Sunscape(2)

Fresh Lavender(2)

Calm Water(2)

Sweet Lavender & Violet(2)

Snuggle SuperFresh Original(2)

After the Rain(2)

Apple Zing(2)

Apple(2)

Citrus Orchard(2)

Mulberry Mist(2)

Citrus Burst(2)

Orange Zest(2)

Vanilla Bean(2)

Fresh Lemon(2)

Crisp Clean(2)

Gain Original(2)

Blue Splash(1)

Splash Blue(1)

Clear Spring(1)

Violet(1)

Cool + Clean(1)

Lavender Lemonade(1)

Cucumber(1)

Lime(1)

Nectar(1)

Green Tea(1)

Bamboo(1)

Peach(1)

Gentle Breeze(1)

Pure Linen(1)

Citrus Grove(1)

Fresh Water Breeze(1)

Spring(1)

Fresh Petals & Peach(1)

Sun-bleached Driftwood(1)

Salty Sea(1)

Warm Breezes(1)

Lemon Idol(1)

Coastal Breeze(1)

Lavender & Almond Blossoms(1)

Pacific Meadow(1)

Lavender Field(1)

Breezy Linen(1)

Natural(1)

Spring Blossom(1)

Citrus Zest(1)

Lavender Zest(1)

Marine(1)

Lavender Mint(1)

Fresh(1)

Fresh Cotton(1)

Topical Citrus Blend(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)

6 Week(2)

50 Day(2)

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

5.3 fl oz (0.2 quart)(7)

6.2 fl oz (0.2 quart)(7)

14 fl oz (0.4 quart)(6)

0.7 fl oz (0 quart)(6)

4 fl oz (0.1 quart)(6)

13.8 fl oz (0.4 quart)(6)

8.5 fl oz (0.3 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)

12.8 fl oz (0.4 quart)(2)

25 fl oz (0.8 quart)(2)

0.9 fl oz (0 quart)(2)

2.5 fl oz (0.1 quart)(2)

0.2 fl oz (0 quart)(2)

6 fl oz (0.2 quart)(1)

1.6 fl oz (0.1 quart)(1)

6.5 fl oz (0.2 quart)(1)

13 fl oz (0.4 quart)(1)

32 fl oz (1 quart)(1)

7.5 fl oz (0.2 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)

3 / Pack(2)

16 / Carton(2)

1 Kit(2)

1 / Pack(1)

8 / Carton(1)

12 / Pack(1)

 
Assembly Required

No(228)

Yes(2)

 
Product Model

402112(1)

402113(1)

402369(1)

MB 3000(1)

402498(1)

 
Product Line

Air(16)

TCell(10)

Scented Oil(9)

Super Odor Eliminator(9)

Life Scents(8)

Freshmatic(6)

Scent Gems(5)

Microburst(5)

Renuzit(4)

smallSPACES(4)

V.I.Poo(4)

Max(3)

Premium(3)

Simply Refreshed(2)

PLUG(2)

Essential(2)

PlugIns(2)

Fresh Picked(1)

ActiveAire(1)

Snuggle(1)