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

Currently Filtered by

Category

Air Fresheners And Sanitizers

Refine Search

  GO
 
Brand

HON(21)

Safco(5)

 
Dimensions

24" Width(1)

 
For Use With

HON Coze Writing Desk Worksurfaces(3)

HON Between 42" Table Tops(2)

HON Between 30 to 36" Table Tops(2)

HON Arrange 42 to 48" Round Table Tops(2)

HON Arrange 30 to 36" Round Table Tops(2)

HON Mod Table Tops(2)

HON Mod 42" Table Tops(2)

HON Mod 48" Table Tops(2)

HON Mod 72" Table Tops(2)

Safco Precision Drafting Table Base(2)

HON Mod 96" Table Tops(1)

When creating mailroom system, use Mayline Kwik-File Mailflow-To-Go Mailroom Series products(1)

Safco 60" and 72" Precision Tabletop(1)

Safco E-Z Sort Sorting Tabletop, Module, Riser, Satellite Mail Station Base, 5 Additional Mail Trays(1)

 
Series Name

HON Coze Series(3)

 
Diameter

26"(1)

 
Country of Origin

US(22)

TW(2)

TH(1)

 
Base Material

Steel(3)

 
Overall Width

30"(3)

32.68"(2)

26.18"(2)

31.95"(2)

25.59"(2)

27.48"(2)

39.5"(2)

60"(2)

23.75"(1)

29.75"(1)

63.5"(1)

72"(1)

56.5"(1)

 
Overall Depth

30"(4)

31.95"(2)

2"(2)

27.48"(2)

23.23"(2)

37 1/2"(2)

25.59"(1)

29.23"(1)

30.5"(1)

 
Caster/Glide/Wheel

Glide(14)

Four Glides(4)

Four Height-Adjustable Glides(3)

 
Edge Detail Profile

Smooth(2)

3 mm PVC Protective Edge Banding; Rounded Corner(1)

 
Base Color

Silver(10)

Slate Teak(4)

Traditional Mahogany(3)

Gray(1)

Black(1)

 
Top Material

Laminate(3)

 
Top Thickness

1"(2)

 
Top Shape

Rectangular(2)

Square(1)

 
Base Type

X-Base(12)

Slab Base(3)

U-Leg(2)

(4) Legs(2)

(4) Posts(1)

 
Top Color

Green(2)

Pebble Gray(1)

 
Base/Leg Material

Aluminum(8)

Laminate(7)

Steel(3)

Industrial Grade Steel(1)

Heavy-Gauge Steel(1)

 
Pedestal Count

0(3)

 
Number of Drawers

0(3)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved