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_19` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` WHERE (`category_name` LIKE "Air Fresheners/Odor Eliminators") 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_cost`=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 MATCH(`desc_short`) AGAINST ('AirFreshenersOdorEliminator' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+AirFreshenersOdorEliminator' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"AirFreshenersOdorEliminator"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"AirFreshenersOdorEliminator"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"AirFreshenersOdorEliminator"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"AirFreshenersOdorEliminator"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+AirFreshenersOdorEliminator' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='AirFreshenersOdorEliminator',`category_4` ='AirFreshenersOdorEliminator') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'AirFreshenersOdorEliminator,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('AirFreshenersOdorEliminator', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

AIR FRESHENERS/ODOR ELIMINATORS


Search Again >>


Refine Search

  GO
Brand

Air Wick(70)

TimeMist(62)

BRIGHT Air(44)

Fresh Products(29)

Renuzit(28)

Febreze(28)

Rubbermaid Commercial(24)

Boardwalk(20)

Arm & Hammer(20)

Big D Industries(18)

Nature's Air(10)

OdoBan(9)

Misty(7)

LYSOL Neutra Air(6)

Georgia Pacific Professional(6)

Glade(5)

San Jamar(5)

Natural Magic(4)

Gonzo(4)

LYSOL NEUTRA AIR FRESHMATIC(4)

Dymon(2)

Scott(2)

Professional Air Wick(2)

Diversey(1)

Franklin Cleaning Technology(1)

WD-40(1)

Color(s)

Clear(27)

White(17)

Blue(13)

Pink(11)

Purple(11)

Red(9)

Orange(8)

Opaque White(4)

Green(4)

Orange/White(3)

Yellow(3)

Black(2)

Orchid(2)

Lime(2)

White/Blue(2)

Pink/White(1)

Salmon(1)

Red/Orange(1)

Aqua(1)

Purple/White(1)

Packing Type

Aerosol(153)

Jar(38)

Box(33)

Refill(32)

Bottle(29)

Spray Bottle(25)

Cartridge(24)

Cone(16)

Diffuser(10)

Cup(6)

Pack(6)

Cassette(5)

Bag(5)

Dispenser(4)

Continuous Spray(4)

Glass Sphere(3)

Fragrance Cup(2)

Aerosol Kit(2)

Kit(2)

Tub(2)

Shaker Bottle(2)

Pail(2)

Unit(2)

Aerosol Can(1)

Aerosol Refill(1)

Canister(1)

Shaker Can(1)

Block(1)

Manufacturer Part Number

91099(1)

91099EA(1)

89330EA(1)

89329EA(1)

89328EA(1)

91101(1)

91101EA(1)

91110EA(1)

91110(1)

91104EA(1)

91104(1)

85595PK(1)

85595(1)

82314(1)

82314CT(1)

82291EA(1)

82291(1)

81262CT(1)

82680(1)

82680PK(1)

85257EA(1)

85257(1)

85175CT(1)

85175(1)

91112(1)

91112EA(1)

96717(1)

96717EA(1)

96534(1)

96533(1)

96532(1)

96718(1)

96718EA(1)

96720EA(1)

96720(1)

96719EA(1)

96719(1)

96531(1)

95207(1)

92944EA(1)

93554(1)

92944(1)

91115EA(1)

91115(1)

93554EA(1)

95202(1)

95206(1)

95205(1)

95204(1)

95203(1)

81262(1)

80978(1)

97565CT(1)

97567CT(1)

94614EA(1)

94614CT(1)

90189EA(1)

97569CT(1)

97570CT(1)

06732EA(1)

06732(1)

05762EA(1)

05762CT(1)

90189(1)

90188EA(1)

69757(1)

69757PK(1)

47804CT(1)

45541EA(1)

45541(1)

84220(1)

84220EA(1)

90188CT(1)

88971CT(1)

85837CT(1)

84221CT(1)

75819(1)

75819EA(1)

79830(1)

79830CT(1)

79717CT(1)

79717(1)

79553EA(1)

79831(1)

79831CT(1)

80420CT(1)

80420(1)

80095CT(1)

80095(1)

79553(1)

79196EA(1)

76940EA(1)

77002(1)

76940CT(1)

76938EA(1)

76938CT(1)

77002EA(1)

77961(1)

79196(1)

78473CT(1)

78473(1)

77961CT(1)

1957521CT(1)

1957522CT(1)

1042781(1)

1042781EA(1)

1042771EA(1)

1042771(1)

1042757EA(1)

1042786(1)

1042786EA(1)

1042818(1)

1042810EA(1)

1042810(1)

1042798(1)

1042757(1)

1042756EA(1)

1042705(1)

1042705EA(1)

1042700(1)

1042694(1)

1042690EA(1)

1042712(1)

1042712EA(1)

1042756(1)

1042727EA(1)

1042727(1)

1042720(1)

1042818EA(1)

1042824(1)

1012D(1)

1012DEA(1)

280300(1)

1047606CT(1)

1047606(1)

1013D(1)

1013DEA(1)

4121DEA(1)

4121D(1)

4119DEA(1)

4119D(1)

1047605CT(1)

1047605(1)

1043708(1)

1043744(1)

1043698(1)

1043690(1)

1042824EA(1)

1043747(1)

1043978(1)

1047357(1)

1047356(1)

1047355(1)

1044024(1)

1042690(1)

1042686EA(1)

402408(1)

9C83-01(1)

4015471(1)

401504(1)

4012581(1)

9C84-01(1)

9C85-01(1)

RW107801228(1)

RW107801227(1)

9C97-01(1)

9C87-01(1)

4012571(1)

4012561(1)

3485949(1)

3485950(1)

1957525CT(1)

1957524CT(1)

1957523CT(1)

3485951(1)

3485952(1)

4012551(1)

4009851(1)

4009831(1)

400573(1)

RW107801230(1)

RW107801231(1)

1042453EA(1)

1042637(1)

1042453(1)

1042447EA(1)

1042447(1)

1042639(1)

1042649(1)

1042686(1)

1042677EA(1)

1042677(1)

1042657(1)

1042443EA(1)

1042443(1)

682263(1)

682262EA(1)

682262(1)

RW107801232(1)

682263EA(1)

1042415CT(1)

1042439EA(1)

1042439(1)

1042436(1)

1042419CT(1)

45540EA(1)

45540(1)

900288CT(1)

900288EA(1)

900286EA(1)

900286CT(1)

900272PK(1)

900(1)

901(1)

905(1)

904(1)

903(1)

902(1)

900272(1)

900271PK(1)

900256PK(1)

900257CT(1)

900256(1)

900255PK(1)

900255(1)

900257EA(1)

900269(1)

900271(1)

900270PK(1)

900270(1)

900269PK(1)

906(1)

909(1)

3320001710(1)

3320001710EA(1)

33200-01140(1)

3320000514EA(1)

3320000514CT(1)

33200-01961(1)

3320011535(1)

3320084011(1)

3320011536EA(1)

3320011536(1)

3320011535EA(1)

33200-00007(1)

W24(1)

CURVECME(1)

CURVECMECT(1)

CURVECBLCT(1)

CURVECBL(1)

910(1)

CURVEMAN(1)

CURVEMANCT(1)

W16(1)

G20(1)

CURVESAPCT(1)

CURVESAP(1)

900254EA(1)

900254(1)

337(1)

341(1)

316(1)

241(1)

202(1)

344(1)

358(1)

604(1)

5618(1)

504(1)

500(1)

1618(1)

1614(1)

1001870(1)

1015013(1)

1001868(1)

1001844(1)

1001842(1)

1020755(1)

1045309(1)

1504(1)

1500(1)

150(1)

1358(1)

608(1)

900013CT(1)

900134CT(1)

900134EA(1)

900133CT(1)

900133(1)

900115EA(1)

900228(1)

900228CT(1)

900248EA(1)

900248(1)

900229CT(1)

900229(1)

900115CT(1)

900114EA(1)

900021(1)

900014CT(1)

900014(1)

900013EA(1)

900021CT(1)

900022(1)

900114CT(1)

900090EA(1)

900090CT(1)

900022CT(1)

3320084011CT(1)

3320084104(1)

CITRO12(1)

EA36CB(1)

2REFSPRING(1)

2REFSPAPPLE(1)

2REFMANGO(1)

EA36 CME(1)

EA36CT30(1)

OTTOCLBR(1)

FSB5F(1)

EA36SAP(1)

EA36MG30(1)

2REFGRAPPLE(1)

2REFCUMELON(1)

1-BWB-CM-F(1)

1-BWB-MG(1)

12-32WB-TU(1)

12-32WB-MG(1)

12-32WB-LECT(1)

1-WB-CHCT(1)

1WBLE(1)

2REFCITRUS(1)

2REFCHERRY(1)

1-WB-TU(1)

1-WB-MG(1)

OTTOCUMEL(1)

48250(1)

911062-G4(1)

911162-5G(1)

91070114AEA(1)

91070114A12(1)

910162-QC12(1)

03259CT(1)

03259EA(1)

36551(1)

33032EA(1)

33032CT(1)

19761CT(1)

91000114AEA(1)

91000114A12(1)

48254(1)

48255(1)

48253(1)

48252(1)

48251(1)

33601(1)

33632(1)

745A62-24Z12(1)

745A62-24Z(1)

91072(1)

91067(1)

12-32WB-CM-F(1)

12-32WB-CH(1)

01704(1)

01704EA(1)

1013EA(1)

10132EA(1)

10132CT(1)

02201EA(1)

02202CT(1)

02222CT(1)

02221EA(1)

02216CT(1)

02215EA(1)

1013(1)

1012EA(1)

3320084116CT(1)

3320094170(1)

3320084116(1)

3320084113CT(1)

3320084113(1)

3320094170CT(1)

101-1(1)

101-2(1)

1011EA(1)

1011DPEA(1)

1011DP(1)

03659(1)

03659CT(1)

35001CT(1)

36043(1)

35001(1)

35000CT(1)

35000(1)

36043EA(1)

04437(1)

12-32BWB-MG(1)

12-14-00BO(1)

K600493CT(1)

100874875(1)

05362EA(1)

05362CT(1)

03663CT(1)

03663(1)

03661CT(1)

03661(1)

03667(1)

03667CT(1)

05359EA(1)

05359CT(1)

03674EA(1)

03674(1)

1001744(1)

Country of Origin

US(321)

CN(36)

MX(26)

TH(12)

PL(6)

MY(6)

HU(4)

CA(1)

Capacity (Volume)

6.6 oz(35)

0.67 oz(34)

6.17 oz(25)

2 oz(23)

7 oz(22)

2.5 oz(19)

14 oz(19)

1 gal(18)

10 oz(16)

32 oz(14)

5.3 oz(11)

8 oz(10)

3 oz(9)

5.5 oz(8)

27 oz(7)

5.5 ml(6)

7.4 oz(6)

9 oz(6)

6 oz(6)

24 mL(5)

7.5 oz(5)

13.8 oz(5)

13 oz(4)

0.87 oz(4)

16.9 oz(4)

9.7 oz(4)

36 mL(3)

5 oz(3)

1.85 oz(3)

64 oz(2)

1/2 lb(2)

22 oz(2)

5 gal(2)

16 oz(2)

15 oz(2)

48 mL(2)

20 oz(1)

1.85 oz(1)

12 oz(1)

1 qt(1)

Scent

Mango(15)

Cucumber Melon(10)

Neutral(10)

Citrus(10)

Lemon(9)

Unscented(8)

Fresh(8)

Original(7)

Cherry(7)

Lavender & Chamomile(7)

Fresh Waters(6)

Linen & Sky(6)

Fragrance Free(6)

Hawaiian Blossoms & Papaya(6)

Snuggle Fresh Linen(6)

Clean N' Fresh(6)

Summer Delights(6)

Country Garden(5)

Sweet Lavender Days(5)

Apple Cinnamon Medley(5)

Fresh Clean(5)

Paradise Retreat(5)

Ocean Breeze(5)

Fresh Lavender(4)

Spiced Apple(4)

Sweet Lavender & Violet(4)

Cool & Clean(4)

Island Nectar & Pineapple(4)

Mountain Air(4)

Cotton Blossom(3)

Magnolia & Cherry Blossom(3)

Lemon Peel(3)

Clean Breeze(3)

Eucalyptus(3)

Meadows & Rain(3)

Lavender(3)

Hawaiian Aloha(3)

Calm Waters & Spa(2)

White Peach & Citrus(2)

Bayberry(2)

Revitalizing Fresh Breeze(2)

Energizing Citrus Zest(2)

Rejuvenating Morning Linen(2)

Lavender/Chamomile(2)

Macintosh Apple & Cinnamon(2)

Spring Flowers(2)

Tide Original(2)

Lavender Lemonade(2)

Cool and Clean(2)

Fresh Linen(2)

Macintosh Apples & Cinnamon(2)

Caribbean Waters(2)

Fresh Petals & Peach(2)

Voodoo Berry(2)

NEUTRA AIR Fresh(2)

Lavender & Fresh Linen(2)

Purple Lavender(2)

Cinnamon Spice(2)

Super Fresh(2)

Sunset Cotton(2)

Tropical Flowers(2)

Linen Fresh(2)

Mountain Peaks(2)

Mandarin Orange(2)

Hawaiian Breeze(2)

Summer Breeze(2)

Cold Stone Creamery Vanilla Bean(2)

Baby Powder(2)

Piņa Colada(2)

Mandarin Orange & Fresh Lemon(2)

Hawai'i Exotic Papaya and Hibiscus Flower(2)

Mint(2)

Hawaii Exotic Papaya & Hibiscus Flower(2)

Linen & Spring Breeze(2)

Zesty Lemon & Lime(2)

Sparkling Rain(2)

Blue Sky Breeze(2)

Aromatherapy Serenity(2)

Simply Vanilla(2)

After the Rain(2)

Pure Ocean Breeze(2)

Blissful Apples & Cinnamon(2)

Forever Raspberry(2)

Wild Raspberry & Pomegranate(2)

Pomegranate Grapefruit(2)

Bamboo and Green Tea(2)

Scentillating Citrus(2)

Bamboo Rain(2)

Island Mist(2)

Fresh Breeze(2)

Light Fresh(2)

Light Scent(2)

Pure White Pear & Lavender(2)

Original Scent(2)

French Kiss(2)

Green Apple(2)

Citrus Sunburst(2)

Midnight Woods & Vanilla(2)

Cherry Blossom & Magnolia(2)

Tutti-Frutti(2)

Dutch Apple & Spice(2)

Pure Breeze(2)

Meadow Breeze(2)

Citrus Twist(1)

Sundried Linen(1)

Cotton Berry/Refreshing Citrus(1)

Fresh Scent(1)

Orchard Fields(1)

Vanilla Royale(1)

Pacific Glacier(1)

Fresh Apple(1)

Citrus Breeze(1)

Lavender Bouquet(1)

Mango Burst(1)

Very Cherry(1)

Citrus Slice(1)

Lemon Lime(1)

Assorted(1)

Raspberry Acai Splash(1)

Cinnamon(1)

Snappy Apple(1)

Pure Linen(1)

Citrus Blossom(1)

Mango Smoothie(1)

Tropical Splash(1)

Passion Violet(1)

Tropic Wave(1)

Hawai'i Exotic Papaya & Hibiscus Flower(1)

Breezy Linen(1)

Sunscape(1)

Coastal Breeze(1)

Black Cherry(1)

Pacific Meadow(1)

Ocean(1)

Clean Splash(1)

Downy April Fresh(1)

Gain Original(1)

Spring & Renewal(1)

Citronella(1)

Springtime(1)

Powder Mist(1)

Cinnamon Sunset(1)

Citrus Sunrise(1)

Cherry Thunder(1)

Apple Harvest(1)

Exotic Garden(1)

Bouquet(1)

Floral(1)

Clean Linen(1)

Heavy Duty Crisp Clean(1)

Allergen Reducer Clean Splash(1)

Spring Blossoms(1)

Spring Rain(1)

Fruity Pin-Up(1)

Rosy Starlet(1)

Citrus Zest(1)

Mango Blast(1)

Alpine Springs/Mountain Peaks(1)

Gentle Breeze/Linen Fresh(1)

Marine Fresh(1)

Lavender Superstar(1)

Lemon Idol(1)

Lavender Lace(1)

Vanilla Bean(1)

Vanilla(1)

Apple Cinnamon Medley(R)(1)

Clean & Fresh(1)

First Day of Spring(1)

Fresh Sparkling Waterfall(1)

Sunny Morning Linen(1)

Seaside Escape(1)

Sea Mist/Ocean Breeze(1)

Capacity (Weight)

2.89 oz(5)

16 oz(4)

14 oz(4)

30 oz(4)

42.6 oz(4)

24 oz(3)

1.25 oz(3)

32 oz(2)

8 oz(2)

5.5 oz(2)

2.5 oz(2)

0.07 oz(1)

0.1 oz(1)

5 lbs.(1)

12 oz(1)

30 lbs(1)

13 1/2 lbs(1)

1 lb(1)

15 oz(1)

2 lbs(1)

20 lbs(1)

Price Range

$0-$499.99(412)

$500-$999.99(1)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Carriage Paper Products, All Rights Reserved