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

Currently Filtered by

Category

Air Fresheners Odor Eliminators

Refine Search

  GO
 
Brand

TimeMist(69)

Air Wick(68)

Febreze(63)

BRIGHT Air(61)

Rubbermaid Commercial(52)

Fresh Products(34)

Big D Industries(22)

Boardwalk(22)

Arm & Hammer(21)

Renuzit(20)

OdoBan(18)

Glade(16)

Misty(14)

Diversey(12)

Nature's Air(10)

Clorox(8)

PAK-IT(6)

LYSOL Neutra Air(6)

Zep Commercial(5)

San Jamar(4)

Natural Magic(4)

Georgia Pacific Professional(4)

Scott(4)

LYSOL NEUTRA AIR FRESHMATIC(3)

Dymon(3)

Professional Air Wick(2)

Suma(1)

Zep Professional(1)

Franklin Cleaning Technology(1)

WD-40(1)

 
Height

8.063"(2)

 
Color(s)

Clear(31)

Blue(25)

White(19)

Orange(18)

Pink(12)

Red(10)

Purple(9)

Green(7)

Yellow(4)

White/Gray/Blue(4)

Sandy(2)

Orange/White(2)

Light Blue(2)

White/Blue(2)

Lime(2)

Lavender(2)

Orchid(2)

White/Gray(1)

Teal(1)

White/Gray/Orange(1)

Opaque White(1)

Beige(1)

Red/Orange(1)

Aqua(1)

White/Gray/Purple(1)

 
Depth

3.625"(2)

 
Packing Type

Aerosol(204)

Bottle(64)

Jar(40)

Box(36)

Spray Bottle(28)

Cartridge(23)

Refill(20)

Cone(18)

Diffuser(16)

Can(13)

Pack(12)

Spray Can(11)

TCell Refill(9)

Cup(8)

Cassette(6)

Liquid Packet(6)

Clip(6)

Pail(5)

Stick Up(4)

Continuous Spray(4)

Shaker Bottle(2)

Fragrance Cup(2)

Dispenser(2)

Tub(2)

Unit(2)

Starter Kit(1)

Kit(1)

Shaker Can(1)

Bucket(1)

Refill Pad(1)

Container(1)

Bag(1)

Canister(1)

Pouch(1)

 
Manufacturer Part Number

85823CT(1)

85825CT(1)

85826CT(1)

85823(1)

85723(1)

85595(1)

85595PK(1)

91099(1)

91099EA(1)

93045(1)

96534(1)

96717(1)

91112(1)

91110(1)

91101(1)

91101EA(1)

85257EA(1)

85257(1)

79831(1)

79831CT(1)

80095CT(1)

79830CT(1)

79717CT(1)

79553(1)

79553EA(1)

80420CT(1)

82093CT(1)

82680PK(1)

85175CT(1)

82680(1)

82314CT(1)

82291(1)

82314(1)

96717EA(1)

96718EA(1)

98864EA(1)

1957521CT(1)

1957522CT(1)

98864(1)

98577KT(1)

98576KT(1)

98577(1)

1957523CT(1)

1957524CT(1)

3485950(1)

3485951(1)

3485952(1)

3485949(1)

1957528CT(1)

1957525CT(1)

1957526CT(1)

98576(1)

98555EA(1)

98000(1)

98000EA(1)

98551(1)

97053EA(1)

97053(1)

96719EA(1)

96720(1)

98551EA(1)

98552(1)

98554EA(1)

98555(1)

98554(1)

98553EA(1)

98552EA(1)

98553(1)

79196EA(1)

79196(1)

97588(1)

97588EA(1)

97589(1)

97583(1)

96264EA(1)

96260EA(1)

96264(1)

97589EA(1)

97590(1)

97596EA(1)

97794(1)

97794PK(1)

97596(1)

97591EA(1)

97590EA(1)

97591(1)

96260(1)

96257EA(1)

94734CT(1)

94734PK(1)

96252(1)

94731CT(1)

94728CT(1)

90188EA(1)

90189(1)

96252EA(1)

96254(1)

96256EA(1)

96257(1)

96256(1)

96255EA(1)

96254EA(1)

96255(1)

97799(1)

97799PK(1)

76940CT(1)

76940EA(1)

77002(1)

76938EA(1)

76938CT(1)

75819(1)

75819EA(1)

77002EA(1)

77961(1)

78297CT(1)

78473CT(1)

78297(1)

78283CT(1)

77961CT(1)

78283(1)

06732EA(1)

06732(1)

98388(1)

98388EA(1)

98390(1)

97810PK(1)

97810(1)

97805(1)

97805PK(1)

98390EA(1)

98391(1)

05762EA(1)

05768(1)

05762CT(1)

98393EA(1)

98391EA(1)

98393(1)

400573(1)

400696(1)

1042757EA(1)

1042771(1)

1042771EA(1)

1042757(1)

1042756EA(1)

1042746(1)

1042756(1)

1042781(1)

1042781EA(1)

1042810EA(1)

1042818(1)

1042818EA(1)

1042810(1)

1042798(1)

1042786(1)

1042786EA(1)

1042737(1)

1042727EA(1)

1042690(1)

1042690EA(1)

1042694(1)

1042686EA(1)

1042686(1)

1042677(1)

1042677EA(1)

1042694EA(1)

1042700(1)

1042720(1)

1042727(1)

1042712EA(1)

1042712(1)

1042705(1)

1042705EA(1)

1042824(1)

1042824EA(1)

TMTF32PK(1)

280300(1)

4119D(1)

TMFBKIT14(1)

TMFB32PK(1)

1049548(1)

1049713(1)

4119DEA(1)

4121D(1)

ZUOCC128EA(1)

ZUSOE16(1)

ZUSOE16CT(1)

ZUAIR32EA(1)

ZUAIR32CT(1)

4121DEA(1)

R36101CT(1)

1049547(1)

1048495(1)

1044935(1)

1044935EA(1)

1047605(1)

1044024(1)

1043978(1)

1043744(1)

1043747(1)

1047605CT(1)

1047606(1)

1048493(1)

1048494(1)

1048328(1)

1047941(1)

1047606CT(1)

1047940(1)

1042657(1)

1042649(1)

402112(1)

402113(1)

402369(1)

402110(1)

402093(1)

401690(1)

401693CT(1)

402408(1)

402470(1)

9C83-01(1)

9C84-01(1)

9C85-01(1)

516000(1)

5159(1)

402472(1)

5158(1)

401689(1)

4015471(1)

4012461(1)

4012471(1)

4012481(1)

4012451(1)

4012441(1)

4009831(1)

4009851(1)

4012551(1)

4012561(1)

401504(1)

4015061(1)

401260A(1)

4012591(1)

4012571(1)

4012581(1)

9C87-01(1)

9C94-01(1)

697248EA(1)

699158(1)

699158EA(1)

697248(1)

686452KT(1)

682277EA(1)

686452(1)

1042415CT(1)

1042419CT(1)

1042637(1)

1042639(1)

1042430EA(1)

1042430(1)

1042421(1)

1042421EA(1)

682277(1)

682263EA(1)

RW107801227(1)

RW107801228(1)

RW107801231(1)

FG402472(1)

FG402113(1)

9C97-01(1)

FG402112(1)

RW107801232(1)

616415(1)

682262EA(1)

682263(1)

682262(1)

616419EA(1)

616415EA(1)

616419(1)

90188CT(1)

84220EA(1)

900346PK(1)

900426EA(1)

900436(1)

900346(1)

900345PK(1)

900288EA(1)

900345(1)

900436EA(1)

900437(1)

900439EA(1)

900440(1)

900440EA(1)

900439(1)

900438EA(1)

900437EA(1)

900438(1)

900288CT(1)

900286EA(1)

900258(1)

900258EA(1)

900269(1)

900256PK(1)

900256(1)

900255(1)

900255PK(1)

900269PK(1)

900270(1)

900272PK(1)

900286CT(1)

900272(1)

900271PK(1)

900270PK(1)

900271(1)

900441(1)

900441EA(1)

W24(1)

33200-00007(1)

3320000514CT(1)

W16(1)

G20(1)

CURVESAP(1)

CURVESAPCT(1)

3320000514EA(1)

33200-01140(1)

3320011535(1)

3320011535EA(1)

3320011536(1)

33200-01961(1)

3320001710EA(1)

3320001140EA(1)

3320001710(1)

CURVEMANCT(1)

CURVEMAN(1)

902(1)

903(1)

904(1)

901(1)

900(1)

4824(1)

4824EA(1)

905(1)

906(1)

CURVECME(1)

CURVECMECT(1)

CURVECBLCT(1)

CURVECBL(1)

909(1)

910(1)

900254EA(1)

900254(1)

202(1)

241(1)

337(1)

178(1)

1618(1)

1500(1)

1504(1)

341(1)

344(1)

464(1)

472(1)

500(1)

463(1)

462(1)

358(1)

451(1)

150(1)

1358(1)

1001870(1)

1015013(1)

1020755(1)

1001868(1)

1001844(1)

1001840(1)

1001842(1)

1021970(1)

1037236(1)

1045309(1)

1045310(1)

1039402(1)

1039394(1)

1037236EA(1)

1039375(1)

504(1)

5618(1)

900115EA(1)

900133(1)

900133CT(1)

900115CT(1)

900114EA(1)

900090EA(1)

900114CT(1)

900134CT(1)

900134EA(1)

900248(1)

900248EA(1)

900229CT(1)

900229(1)

900228(1)

900228CT(1)

900090CT(1)

900022CT(1)

5853202240CT(1)

5853203400CT(1)

586320002240(1)

585320003400(1)

585320002240(1)

604(1)

608(1)

586320003400(1)

900013CT(1)

900021CT(1)

900022(1)

900021(1)

900014CT(1)

900013EA(1)

900014(1)

3320011536EA(1)

3320084011(1)

EF12 CIT(1)

EF12 MAN(1)

EF12 SAP(1)

EF12 CBL(1)

EA36SAP(1)

EA36CT30(1)

EA36MG30(1)

PP004I004I20(1)

48250(1)

33632(1)

70220(1)

12370(1)

33601(1)

48290(1)

48251(1)

48255(1)

EA36 CME(1)

EA36CB(1)

1WBLE(1)

1-WB-MG(1)

1-WB-TU(1)

1-WB-CHCT(1)

1-BWB-MG(1)

1-BWB-CM-F(1)

1BWBCT(1)

2REFCHERRY(1)

2REFCITRUS(1)

2REFSRRASP(1)

CITRO12(1)

2REFSPRING(1)

2REFSPAPPLE(1)

2REFCUMELON(1)

2REFMANGO(1)

12373(1)

91067(1)

33032CT(1)

33032EA(1)

36551(1)

03259EA(1)

03259CT(1)

911762G4EA(1)

927062-QC12(1)

74593(1)

74593EA(1)

74903(1)

74903EA(1)

84220(1)

74902EA(1)

74902(1)

74901(1)

74901EA(1)

911762G4(1)

9117625G(1)

91010114A12(1)

91010114AEA(1)

910162-QC12(1)

910062-QC12(1)

91000114AEA(1)

91072(1)

91000114A12(1)

91070114A12(1)

91070114AEA(1)

911162-5G(1)

911162-G4(1)

911062G4EA(1)

911062-G4(1)

910762QC12(1)

911062-5G(1)

12-32WB-TU(1)

12-32WB-MG(1)

1012EA(1)

1013(1)

10132CT(1)

101-2(1)

1011EA(1)

1011DP(1)

1011DPEA(1)

10132EA(1)

1013EA(1)

03663(1)

03663CT(1)

03667(1)

03661CT(1)

03661(1)

01704(1)

02216CT(1)

101-1(1)

31716EA(1)

3320084116(1)

3320084116CT(1)

3320094170(1)

3320084113CT(1)

3320084113(1)

3320084011CT(1)

3320084104(1)

3320094170CT(1)

31708(1)

31711EA(1)

31716(1)

31711(1)

31710EA(1)

31708EA(1)

31710(1)

03667CT(1)

03674(1)

94291110(1)

94355110(1)

94496154(1)

94266359(1)

93165353(1)

100924937(1)

100949179(1)

K600493CT(1)

12-14-00BO(1)

1232WBHMF(1)

12-32WB-LECT(1)

12-32WB-CH(1)

12-32BWB-MG(1)

12-32BWB-CMF(1)

1232BWBCT(1)

100910595(1)

100898962(1)

05362EA(1)

06585(1)

06585EA(1)

05362CT(1)

05359EA(1)

03674EA(1)

05359CT(1)

35000(1)

35000CT(1)

100871126(1)

100888677(1)

04439(1)

04437(1)

35001(1)

35001CT(1)

1001744(1)

 
Country of Origin

US(424)

CN(50)

TH(20)

HU(19)

MY(19)

MX(19)

CA(4)

 
Width

3.688"(2)

 
Material(s)

Plastic(3)

 
Capacity (Volume)

0.67 oz(39)

6.6 oz(31)

5.3 oz(31)

6.17 oz(31)

7 oz(29)

32 oz(28)

1 gal(24)

14 oz(23)

10 oz(22)

2 oz(17)

2.5 oz(15)

8.8 oz(14)

3 oz(12)

8 oz(11)

27 oz(11)

6 oz(9)

2 x 8.8 oz(8)

300 mL(8)

13.8 oz(8)

24 mL(7)

4 oz(6)

0.87 oz(6)

0.35 oz(6)

7.5 oz(5)

16 oz(5)

5.5 oz(5)

1.62 oz(5)

2 ml(4)

5 gal(4)

5 oz(4)

48 ml(4)

48 mL(4)

128 oz(4)

6.2 oz(4)

4.8 oz(4)

5.5 ml(3)

0.77 oz(3)

10.5 oz(3)

1.7 oz(2)

64 oz(2)

1/2 lb(2)

15 oz(2)

22 oz(2)

16.9 oz(2)

2 mL(2)

14.6 oz(2)

1 oz(2)

20 oz(2)

67.6 oz(1)

12 oz(1)

9 oz(1)

13 oz(1)

1.5 L(1)

1 Quart(1)

1.9 oz(1)

42.5 oz(1)

5.25 oz(1)

 
Scent

Mango(23)

Citrus(17)

Fresh(15)

Fresh Linen(14)

Neutral(11)

Unscented(10)

Cool & Clean(10)

Cucumber Melon(10)

Original(9)

Lemon(9)

Gain Original(9)

Clean Air Scent(8)

Lavender & Chamomile(8)

Hawaiian Aloha(8)

Cherry(8)

Ocean Breeze(7)

Apple Cinnamon Medley(7)

Eucalyptus(7)

Linen & Sky(7)

Bamboo Rain(6)

Fresh Waters(6)

Hawaiian Blossoms & Papaya(6)

Spring & Renewal(6)

Sweet Lavender & Violet(5)

Mandarin Orange(5)

Mountain Air(5)

Lavender(5)

Fresh Clean(5)

Meadow Breeze(4)

Citrus Burst(4)

Meadows & Rain(4)

Cotton Blossom(4)

Lavender & Almond Blossom(4)

Spiced Apple(4)

Clean Linen(4)

Fresh Breeze(4)

Clean N' Fresh(4)

Island Nectar & Pineapple(4)

Hawaiian Breeze(4)

Mandarin Orange & Fresh Lemon(4)

Orchid(4)

Autumn Fresh(4)

Linen Fresh(3)

Country Garden(3)

Mountain Peaks(3)

Cinnamon Spice(3)

Summer Delights(3)

Lemon Peel(3)

Tropical Flowers(3)

Sparkling Citrus(3)

Paradise Retreat(3)

Country Delight(3)

Heavy Duty Crisp Clean(2)

Mediterranean Lavender(2)

Tide Original(2)

Clean Breeze(2)

Energizing Citrus Zest(2)

Lavender/Chamomile(2)

Revitalizing Fresh Breeze(2)

Rejuvenating Morning Linen(2)

Hawaii Exotic Papaya & Hibiscus Flower(2)

NEUTRA AIR Fresh(2)

Crisp Breeze(2)

Orchard Fields(2)

Caribbean Waters(2)

Lavender Lemonade(2)

Voodoo Berry(2)

Spring Flowers(2)

Bayberry(2)

Dutch Apple & Spice(2)

French Kiss(2)

Crisp & Clean(2)

Scentillating Citrus(2)

Bamboo and Green Tea(2)

Pomegranate Grapefruit(2)

Acapulco Splash(2)

Green Apple(2)

Piņa Colada(2)

Blue Splash(2)

Tropical Sunrise(2)

Peony & Jasmine(2)

Fresh Water Breeze(2)

Cinnamon & Crisp Apple(2)

Citrus Breeze(2)

Lemon Lime(2)

Cinnamon(2)

Baby Powder(2)

Clear Springs(2)

Lavender; Vanilla(2)

Super Fresh(2)

Purple Lavender(2)

Downy April Fresh(2)

Light Fresh(2)

Fragrance Free(2)

Light Scent(2)

Superberry(2)

Lavender & Fresh Linen(2)

Mint(2)

Vanilla, Apricot Blossom & Almond(2)

Blissful Apple & Cinnamon(2)

Alpine Mist(2)

Forever Raspberry(2)

After the Rain(2)

Macintosh Apple & Cinnamon(2)

Calm Waters & Spa(2)

Fresh Water(2)

Linen & Spring Breeze(2)

Cherry Blossom & Magnolia(2)

Midnight Woods & Vanilla(2)

Wild Raspberry & Pomegranate(2)

Cool Citrus(2)

Macintosh Apples & Cinnamon(2)

White Peach & Citrus(2)

Fresh Petals & Peach(2)

Zesty Lemon & Lime(2)

Island Mist(2)

Pure Ocean Breeze(2)

Clean & Fresh(2)

Floral(2)

Pure White Pear & Lavender(2)

Tutti-Frutti(2)

Coastal Breeze(2)

Apple(2)

Summer Breeze(2)

Citrus Sunburst(2)

Lovely Lavender(2)

Snappy Apple(1)

Fresh Scent(1)

Citrus; Linen; Mango(1)

Mango Smoothie(1)

Xtreme Citrus(1)

Assorted(1)

Cinna Fresh(1)

Mango Burst(1)

Pleasant(1)

Lavender Bouquet(1)

Pacific Glacier(1)

Tropic Wave(1)

Pure Linen(1)

Desert Bloom(1)

Seaside Breeze(1)

Vanilla(1)

Potpourri(1)

Fresh Apple(1)

Lavender Zest(1)

Raspberry Acai Splash(1)

Passion Violet(1)

Sunburst(1)

Wildwood Fig(1)

Very Cherry(1)

Clean and Fresh(1)

Citrus Slice(1)

Spring Rain(1)

Lemon Drop(1)

Cinnamon Sunset(1)

Tropical(1)

Tuscan Garden(1)

Cherry Almond(1)

Bouquet(1)

Fresh Floral(1)

White Lilac(1)

Blue Sky, Linen & Pear(1)

Sunset Cotton(1)

Fruity Pin-Up(1)

Hawai'i Exotic Papaya and Hibiscus Flower(1)

Herbal Mint(1)

Vanilla Indulgence(1)

Sugar & Spice(1)

Summer Fresh(1)

Midnight Storm(1)

Ocean(1)

Sunscape Mango(1)

Clean Splash(1)

Springtime(1)

Sun Ripened Raspberry(1)

Citronella(1)

Fresh Lavender(1)

Spring Blossoms(1)

Wakening Spring(1)

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

Citrus Sunrise(1)

Cherry Thunder(1)

Powder Mist(1)

Mango Blossom(1)

Country Linen(1)

Spring Garden(1)

Apple Harvest(1)

Vanilla Bean(1)

Vanilla Royale(1)

Lavender Mint(1)

Marine Fresh(1)

Mango Blast(1)

Citrus Zest(1)

Decadence(1)

Gentle Breeze/Linen Fresh(1)

Cotton Berry/Refreshing Citrus(1)

Sea Mist/Ocean Breeze(1)

Alpine Springs/Mountain Peaks(1)

Exotic Garden(1)

 
Capacity (Weight)

8 oz(6)

2.89 oz(5)

42.6 oz(4)

2.1 oz(4)

16 oz(4)

30 oz(4)

14 oz(4)

1.25 oz(3)

2 lbs(2)

0.1 oz(2)

2.5 oz(2)

5.5 oz(2)

.89(1)

12 oz(1)

0.07 oz(1)

2 oz(1)

1 lb(1)

24 oz(1)

20 lbs(1)

25 lbs(1)

30 lbs(1)

13 1/2 lbs(1)

0.67 oz(1)

16 lb(1)

10 oz(1)

15 oz(1)

 
 
 

© 2019-2020 Desert West Office Supply, All Rights Reserved