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

Currently Filtered by

Category

Key Boxes And Cabinets

Refine Search

  GO
 
Brand

Green Mountain Coffee(57)

Starbucks(36)

Folgers(32)

Peet's Coffee & Tea(13)

The Original Donut Shop(12)

1850(11)

Dunkin Donuts(10)

Eight O'Clock(8)

McCafe(8)

New England Coffee(8)

Caribou Coffee(8)

Maxwell House(8)

Tully's Coffee(8)

Café Bustelo(8)

PapaNicholas Coffee(7)

Java One(7)

Nescafé(7)

Seattle's Best(7)

Community Coffee(6)

Barista Prima Coffeehouse(6)

La Colombe(6)

Lavazza(6)

Snack Box Pros(6)

Day to Day Coffee(5)

HIGH Brew Coffee(5)

RISE Brewing Co.(4)

Gloria Jean's(4)

Café Escapes(4)

Distant Lands Coffee(3)

BLK & Bold(3)

Monster(3)

Kahlúa(2)

Tim Hortons(2)

National Coffee Roasters(2)

Gevalia(2)

Intelligentsia(2)

ALTERRA(2)

Newman's Own Organics(2)

Laughing Man Coffee Company(2)

CALIFIA FARMS(2)

Emeril's(2)

Krispy Kreme Doughnuts(1)

KITULife(1)

Starbucks By NESPRESSO(1)

Cinnabon(1)

revv(1)

Hills Bros.(1)

Nestle(1)

Chock full o'Nuts(1)

EVO Bean Coffee(1)

Yuban(1)

 
Packaged Quantity

6 / Carton(1)

 
For Use With

Keurig K-Cup System(155)

Commercial Coffee Brewers(21)

Single Cup Brewers(7)

Drip Coffee Brewers(5)

FLAVIA Hot Beverage Brewers(4)

Standard Coffee Brewers(4)

Commercial Coffee Brewers; Standard Coffee Brewers(3)

NESCAFE Bean-to-Cup Specialty Coffee Makers: Total Barista 30, Ultimate Barista 50(3)

B-40; B-60; B-70; B-100(3)

Grinder; Coffee Brewer(3)

Pod Brewers(2)

Select Flavia Freshpack Pod Machines(2)

Coffee Brewer(1)

Standard and Commercial Coffee Makers(1)

Original-Line Nespresso Machines(1)

Any traditional coffee maker(1)

In-Room Lodging Standard 4-Cup Brewers(1)

FLAVIA Machines only(1)

 
Flavor

French Roast(18)

Breakfast Blend(18)

Classic Roast(12)

House Blend(11)

French Vanilla(9)

Espresso(9)

Original(8)

Assorted(8)

Caffe Verona(8)

Regular(8)

Pike Place Roast(8)

Hazelnut(7)

Original Blend(6)

Mocha(6)

Veranda Blend(5)

Italian Roast(5)

Hazelnut Creme(5)

Pumpkin Spice(5)

Black Silk(5)

Vanilla(4)

Donut Shop Regular(4)

Major Dickason's Blend(4)

Black Gold(4)

Caramel(3)

Colombia(3)

Dark Magic(3)

Portside Blend(3)

Vermont Country Blend(3)

Nantucket Blend(3)

100% Colombian(3)

Dark Roast(3)

Lake & Lodge(2)

Holiday Blend(2)

Single Origin Colombian Select(2)

Colombian(2)

Mahogany(2)

Our Blend(2)

Caramel Vanilla Cream(2)

Island Coconut(2)

Southern Pecan(2)

Wild Mountain Blueberry(2)

Premium Roast(2)

Caribou Blend(2)

Daybreak Morning Blend(2)

Big Easy Bold(2)

Kahlúa Original(2)

Café Domingo Blend(2)

Sumatran(2)

Pier 70 Blend(2)

Cinnamon Sugar Cookie(2)

Hawaiian Blend(2)

Chicory(2)

Organic Sumatran Extra Bold(2)

Butter Toffee(2)

Medium Roast(2)

Lantern Glow(2)

Expedition Blend(2)

Trailblazer(2)

Traditional Roast(2)

Colombian Supremo(2)

Special Blend(2)

Special Roast(2)

6th Avenue Bistro(2)

Double Black Diamond Extra Bold(2)

Dark Magic Extra Bold(2)

Café Special(2)

Eye Opener(1)

French Dark Roast(1)

Sumatra Blend(1)

Intenso(1)

Dark and Bold(1)

Dark and Intense(1)

Brazilian Bold(1)

Gold Selection(1)

Classico 100% Arabica(1)

Triple Shot(1)

Nitro Extra Bold(1)

Vanilla Latte(1)

Sumatra Mandheling(1)

Creamy Cappuccino(1)

Black and Bold(1)

Arabica(1)

Colombian Blend(1)

Clasico(1)

Oat Milk Vanilla(1)

Salted Caramel(1)

Blonde Espresso Roast(1)

Mean Bean(1)

Loca Moca(1)

Dark Royal(1)

Premium Roast Decaf(1)

Oat Milk Mocha(1)

Mexican Vanilla(1)

Oat Milk(1)

Original Black(1)

Colombia Luminosa(1)

Honduran(1)

Special House Blend(1)

Hawaiian Islands Blend(1)

Kona Blend(1)

Dark Chocolate Mocha(1)

Cinnamon Roll(1)

Double Expresso(1)

Classic(1)

Columbian(1)

Gentle On Your Stomach(1)

NO SURRENDER(1)

Cafe Vanilla(1)

Turtle Love(1)

Regular Extra Bold(1)

Buttery Caramel(1)

Caramel Hideaway(1)

Lively Colombian(1)

Donut Shop Blend(1)

Rise & GRND(1)

Toasty Hazelnut(1)

Extra Bold Breakfast Blend(1)

Coconut Mocha(1)

Dark Italian Espresso(1)

Pioneer Blend(1)

Peppermint Bark(1)

XX Expresso(1)

Snickers(1)

Signature Blend(1)

Dunkin Original; Polar Peppermint(1)

Gourmet Supreme(1)

Pike Place(1)

Blonde Espresso Roast; Colombia; Espresso Roast; Pikes Place(1)

Original Roast(1)

Cookie Dough(1)

Maple Pecan(1)

Blueberry Muffin(1)

Cappuccino(1)

Ethiopian Supreme(1)

Dukale's Blend(1)

Colombia Huila(1)

Sumatra Reserve(1)

Costa Rica Paraiso(1)

Mocha Noir(1)

 
Volume Capacity

9 oz(6)

8 oz(5)

7 oz(4)

15 oz(3)

10 oz(2)

13.7 oz(2)

9.5 oz(2)

10.5 oz(2)

12 oz(1)

 
Flavor/Blend

French Vanilla(1)

 
Coffee Weight

32 oz(1)

 
Country of Origin

US(323)

CA(16)

IT(5)

BR(1)

 
Quantity

1 each(1)

 
Packing Type

Bag(2)

K-Cup(2)

Flavia Freshpack(1)

 
Capacity (Weight)

2.5 oz(22)

1 lb(13)

12 oz(12)

0.3 oz(9)

1.5 oz(9)

2.2 oz(9)

2 oz(6)

1.4 oz(5)

2.2 lb(5)

0.4 oz(4)

4.25 lb(4)

2.1 oz(3)

0.35 oz(3)

18 oz(3)

2 lb(3)

2.25 oz(3)

0.9 oz(3)

22.6 oz(3)

30.5 oz(2)

0.32 oz(2)

1.75 oz(2)

0.06 oz(2)

28 oz(2)

0.8 oz(2)

2.7 oz(2)

0.34 oz(2)

25.9 oz(2)

1.2 oz(2)

30.6 oz(2)

0.11 oz(1)

0.44 oz(1)

32 oz(1)

8 oz(1)

0.1 oz(1)

0.25 oz(1)

1.1 oz(1)

36 oz(1)

1.05 oz(1)

7 g(1)

27 oz(1)

0.6 oz(1)

3.12 lb(1)

3 lb(1)

11 oz (Polar Peppermint); 12 oz (Original)(1)

1.25 oz(1)

0.38 oz(1)

16 oz(1)

29 oz(1)

30 oz(1)

0.33 oz(1)

0.41 oz(1)

31 oz(1)

 
Beverage Type

Coffee(307)

Coffee Drink(26)

Instant Coffee(4)

Coffee; Hot Cocoa(3)

Latte(2)

Coffee, Instant(1)

Coffee, Whole Bean(1)

 
Roast Type

Medium(103)

Dark(94)

Light(48)

Extra Dark(1)

Dark Roast(1)

Medium; Dark(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved