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

We're sorry, there were no matches for "Armoires" on our site.

Search Tips

Please try searching for different keywords that describe the item you're looking for.

  • Descriptive Keyword(s) - example: "Copy Paper Letter"
  • Product Name (full or partial) - example: "Boise Fireworx Copy Paper"
  • Stock Number (full or partial) - example: "UNV21200"
  • Manufacturer Name or Abbreviation - example: "HP"

Continue Shopping

  • Order by Item Number
  • Browse Our Products

Need Help? Contact us at 800-214-0028 or email Customer Service at [email protected].

 
Advantus Blank PVC ID Cards
Advantus 97034

FREE Shipping

Please login to Add Item in Favorites.
Tripp Lite 10-Device AC Desktop Charging Station with Surge Protection
Tripp Lite 1006

FREE Shipping

Please login to Add Item in Favorites.
Genuine Joe Lemon Scent Furniture Polish
Genuine Joe 10351

Please login to Add Item in Favorites.
Genuine Joe Value Plus Plunger
Genuine Joe 85130

FREE Shipping

Please login to Add Item in Favorites.
Trend Copy & Multipurpose Paper - Multicolor
Trend enterprises, Inc 11921

FREE Shipping

Please login to Add Item in Favorites.
DAC Height and Angle Adjustable Laptop Stand
DAC 195

FREE Shipping

Please login to Add Item in Favorites.
3M Ergonomic Vertical Notebook Computer Riser
3M 550

FREE Shipping

Please login to Add Item in Favorites.
Trend Copy & Multipurpose Paper - Multicolor
Trend enterprises, Inc 11920

FREE Shipping

Please login to Add Item in Favorites.
Impact Products Deluxe Professional Plunger
Impact 9205

FREE Shipping

Please login to Add Item in Favorites.
HON 10700 Series Bridge
HON 10770

FREE Shipping

Please login to Add Item in Favorites.
Tripp Lite USB-C Docking Station w/ USB-A , HDMI, VGA, mDP, Gbe, Memory Cards 3.5mm, USB C PD Charging 4K @ 30Hz
Tripp Lite 4421

FREE Shipping

Please login to Add Item in Favorites.
HON Metal Corner Sleeve
HON 51206

FREE Shipping

Please login to Add Item in Favorites.
Avery® Inkjet Postcard - White
Avery 8386

FREE Shipping

Please login to Add Item in Favorites.
Allsop TriTilt Adjustable Laptop / Tablet Stand for Ultrabook, Tablet, Notebook, iPad - (31660)
Allsop 31660

FREE Shipping

Please login to Add Item in Favorites.
HON 10700 Series Bridge
HON 10760

FREE Shipping

Please login to Add Item in Favorites.