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

Currently Filtered by

Category

Air Freshener Dispensers

Refine Search

  GO
 
Brand

Rubbermaid Commercial(8)

TimeMist(4)

Air Wick(3)

Georgia Pacific Professional(2)

Febreze(1)

 
Color

White(1)

 
Recycled

No(1)

 
Packaged Quantity

1 Each(1)

 
Assembly Required

No(1)

 
Limited Warranty

Lifetime(1)

 
Warranty

Manufacturer's limited one-year warranty.(3)

Manufacturer’s limited one-year warranty.(1)

 
Special Features

Microburst 3000 Dispenser(3)

TCellT 2.0(2)

Micro Dispenser(1)

Uses AA Batteries-Operates six months on 2 AA batteries, one year on 4 AA batteries (not included).(1)

Includes Tropical Flowers Refill-Fill your home with the bright scent of tropical flowers using this convenient included aerosol.(1)

Summer Delights Scent-White flowers--melon-vanilla.(1)

 
Application

Automatic Odor Control(1)

 
Physical Form

Liquid(1)

 
Manufacturer Part Number

1957532(1)

1957531(1)

1955230(1)

1957533(1)

1047717(1)

1047824(1)

1047811(1)

1047809(1)

1955229(1)

1955228(1)

78046(1)

76985(1)

56765(1)

92944(1)

97290(1)

1793547(1)

1793546(1)

56755(1)

 
Country of Origin

US(6)

MY(4)

TW(3)

VN(2)

CN(1)

Malaysia(1)

MX(1)

 
Height

8"(3)

4.09"(2)

8.25"(2)

3.75"(2)

9.5"(1)

7.5"(1)

4.1"(1)

5.25"(1)

4"(1)

3.63"(1)

7.76"(1)

5.9"(1)

 
Width

4.75"(3)

4.09"(2)

10.63"(2)

3.75"(1)

3.4"(1)

3.5"(1)

3.38"(1)

2.4"(1)

1.75"(1)

2.9"(1)

2.75"(1)

2.5"(1)

3.33"(1)

 
Depth

5"(3)

2.36"(2)

3"(2)

2.88"(2)

3.4"(1)

3.5"(1)

3.25"(1)

2.5"(1)

2.69"(1)

3.53"(1)

2.75"(1)

 
Color(s)

White(6)

Black(6)

Chrome(2)

Off White(1)

Gray(1)

White/Gray(1)

 
Material(s)

Plastic(16)

 
Packing Type

Aerosol(1)

 
Capacity (Volume)

5.89 oz(1)

 
Scent

Summer Delights(1)

 
Placement

Wall Mountable(1)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved