Bar Equipment

 Cooking Equipment

 Dishwashing

 Freezers

 Ice Machines

 Prep Equipment

 Refrigerated Merchandiser

 Refrigerators

 Shelving/Storage

 Small Appliances

 Smallwares

 Stainless Steel

 True Commercial Refrigeration

 Walk Ins

 Warming/Merchandising




Scotsman Product Categories
Bargain Sale Ice Machines Counter Height
200 lbs - 500 lbs 600 lbs - 1000 lbs
1200 lbs - 2000 lbs Ice Storage Bins
Ice Maker/Ice Dispensers Accessories
All Products

Click a product below for complete details

Scotsman Hotel Cube Dispenser HD22B-1H
Scotsman Hotel Cube Dispenser
Scotsman HD22B-1H

Hotel Cube Ice Dispenser with Push Button operation, 120 lbs. of bin storage with 322 lbs of ice production within 24 hours. Stainless steel exterior. 115/60/1. Three year parts and labor warranty. 22" wide x 33 1/2" deep x 82 1/4" high with legs. Price includes model #C0322MA-1B ice machine.

variables - struct
ABSOLUTESITEDIR C:\Inetpub\wwwroot\kitchen\www\
ACCESSORIESON Right
ADMINEMAIL salesinfo@kitchenrestaurantsupply.com
AIMOD No
CERTLINK [empty string]
CFCATCH
variables - struct
Detail [empty string]
ErrNumber 0
Message Variable HIDDENPRICE is undefined.
StackTrace coldfusion.runtime.UndefinedVariableException: Variable HIDDENPRICE is undefined. at coldfusion.runtime.CfJspPage._get(CfJspPage.java:377) at coldfusion.runtime.CfJspPage._get(CfJspPage.java:339) at coldfusion.runtime.CfJspPage._autoscalarize(CfJspPage.java:1447) at cfmanufacturers2ecfm1163638810.runPage(C:\Inetpub\wwwroot\kitchen\www\store\manufacturers.cfm:99) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
variables - array
1
variables - struct
COLUMN 0
ID ??
LINE 99
RAW_TRACE at cfmanufacturers2ecfm1163638810.runPage(C:\Inetpub\wwwroot\kitchen\www\store\manufacturers.cfm:99)
TEMPLATE C:\Inetpub\wwwroot\kitchen\www\store\manufacturers.cfm
TYPE CFML
Type Expression
name HIDDENPRICE
CFQUERY.EXECUTIONTIME 0
CFSTOREDPROC
variables - struct
ExecutionTime 16
CODAMOUNT 7.00
COLLOOPER 5
COUPONAFTER 0
COUPONBEFORE 0
DATASRC kitchenrest
DBPASS [empty string]
DBUSER [empty string]
DODESCRIPTION Commercial restaurant supply, refrigerators, ice machines, freezers, deli cases and coolers by True, Manitowoc, Delfield, Traulsen and Scotsman.
DOKEYWORDS commercial, restaurant supply, refrigerators, ice machines, freezers, deli cases, ice, machine, commercial, ice machine, refrigeration, industrial, restaurant, supply, coolers, bars, chiller, refrigerator, ice machine, supply, factory, company, kitchen, restaurant, ice, machine, True, Manitowoc, Delfield, Traulsen, Scotsman, parts, supplies, sanitizer, series, compressor, nugget, filter, tvks, tmc, equipment, wholesale
DOMAINNAME http://www.kitchenrestaurantsupply.com/
ECOUPON No
FORMATTEDTIMEOUT 0.0729166666667
GETPRODUCTS
variables - query
  AICAT B_CATEGORYNAME CHARGETOSHIP C_CATEGORYNAME C_ID EMAILQUOTE INVENTORYNUMBER ISTAXABLE KEYWORDS MFG_ID MFG_NAME MSRP PDF PRODUCTDESCRIPTIONLONG PRODUCTDESCRIPTIONSHORT PRODUCTHTML PRODUCTID PRODUCTIMAGELG PRODUCTIMAGESM PRODUCTNAME PRODUCTOPTIONS PRODUCTPRICE REVIEW SALEPRICE SITE WEIGHT
1 0 Ice Machines No Ice Maker/Ice Dispensers 107 0 HD22B-1H Yes Scotsman HD22B,Hotel Ice dispenser,Cube Dispenser,restaurant supplies, restaurant supply,foodservice equipment, foodservice supply, hotel dispenser, Scotsman, Scotsman ice machine, restaurant supply, commercial equipment, cubed ice, cuber, ice dispenser 18 Scotsman 0.0000 default.pdf Scotsman ice machine CO322MA air cooled, dice cube comes with this dispenser. Hotel Cube Ice Dispenser with Push Button operation, 120 lbs. of bin storage with 322 lbs of ice production within 24 hours. Stainless steel exterior. 115/60/1. Three year parts and labor warranty. 22" wide x 33 1/2" deep x 82 1/4" high with legs. Price includes model #C0322MA-1B ice machine. The reliability of the new iceValet will keep your guests supplied with ice always, so you can pay attention to their other needs. Because it is so reliable, it will be like adding another member to your staff. The 22” wide unit offers storage up to 120 lbs. The unit features a new and improved sink depth of 7.75” that will accommodate virtually every sized hotel ice bucket. <br><br> The <b>Scotsman HD22B Hotel Cube Ice Dispenser</b> would be a good choice. <br><br> Standard Features:<br> <br>• Stores up to 120 lb. of cube ice <br>• Easy push chute for easy ice dispensing <br>• Removable top panel allows access to the bin for simple cleaning <br>• Improved sink depth that will accommodate almost every size hotel ice bucket <br>• Equipped with an 11ft. power cord <br> <br> See PDF for more information. 55 30HD356.jpg 30HD356.jpg Scotsman Hotel Cube Dispenser 99999 3979.0000 [empty string] 1234.5600 3 199.00
2 0 Ice Machines No Ice Maker/Ice Dispensers 107 0 HD30B-1H Yes Scotsman HD30B-1H,Hotel Ice dispenser,Cube Dispenser,restaurant supplies, restaurant supply,foodservice equipment, foodservice supply, hotel dispenser, Scotsman, Scotsman ice machine, restaurant supply, commercial equipment, cubed ice, cuber, ice dispenser 18 Scotsman 9990.0000 default.pdf This ice dispenser comes with a Scotsman model CO330MA, air cooled, dice cube ice maker. Hotel Cube Ice Dispenser with 180 lbs. of ice storage with 330 lbs of ice production within 24 hours.Stainless steel exterior. 115/60/1. Three year parts and labor warranty. 30" wide x 33 1/2" deep x 82 1/4" high height. Price includes model #C0330MA-1B ice machine. The reliability of the new iceValet will keep your guests supplied with ice always, so you can pay attention to their other needs. Because it is so reliable, it will be like adding another member to your staff. The 30” unit stores up to 180 lbs. The unit features a new and improved sink depth of 7.75” that will accommodate virtually every sized hotel ice bucket. Plus, the 30” wide model is available with optional coin/token mechanism or water filler. <br><br> The <b>Scotsman HD30 Hotel Cube Ice Dispenser</b> would be a good choice. <br><br> Standard Features:<br> <br>• Stores up to 180 lb. of cube ice <br>• Equipped with an 11 ft. power cord <br>• Easy push chute for simple ice dispensing <br>• Stylish design in a stainless steel cabinet <br>• Removable top panel allows access to the bin for easy cleaning <br>• Improved sink depth that will accommodate almost every size hotel ice bucket <br> <br> See PDF for more information. 57 30HD3561.jpg 30HD3561.jpg Scotsman Hotel Cube Dispenser 102,103,138,118 4259.0000 [empty string] 1234.5600 3 220.00
3 0 Ice Machines No Ice Maker/Ice Dispensers 107 0 ID150B-1A Yes Scotsman ID150B,Ice Only Dispenser,Ice Dispenser,restaurant supplies, restaurant supply,foodservice equipment, foodservice supply, Scotsman, cubed ice dispenser, convenience store ice dispenser, fountain drink dispenser, Coke dispenser 18 Scotsman 4845.0000 default.pdf Must use a #KBT42 Bin Top when using a 22" wide cube machine located in the accessory section.          Ice Only Dispenser, cup activated with 150 lbs. of ice storage in stainless steel exterior. 115/60/1. Two year parts - one year labor warranty. This counter top ice dispenser, dispenses all ice forms reliably, including Nugget ice. Insulated, heavy-duty drip tray prevents condensation. Heavy-duty agitator reduces ice jams and bridging. <br><br>The <b>Scotsman ID150B Ice Only Dispenser</b> would be a good choice. <br><br> Standard Features:<br> <br>• Heavy duty agitator motor for long life <br>• Greater dispensable ice for periods of peak demand <br>• All components accessible <br>• Storage capacity from 150 to 250 lbs <br>• 2 years parts on all components 1 year labor on all components <br> <br> See PDF for more information. 58 ID2001.jpg ID2001.jpg Scotsman Ice Only Counter Top Dispenser 99999 2059.0000 [empty string] 1234.5600 3 150.00
4 0 Ice Machines No Ice Maker/Ice Dispensers 107 0 ID200B-1A Yes Scotsman ID150B,Ice Only Dispenser,Ice Dispenser,restaurant supplies, restaurant supply,foodservice equipment, foodservice supply, Scotsman, cubed ice dispenser, convenience store ice dispenser, fountain drink dispenser, Coke dispenser 18 Scotsman 5802.0000 SCO0186pdf4.pdf  This unit needs a #KBT44 bin top adapter to fit 30" wide cubed ice machines.           Ice Only Counter Dispenser, cup activated with 200 lbs. of ice storage in stainless steel exterior. 115/60/1. Two year parts - one year labor warranty. 30" wide x 30" deep x 35 5/8" high. This counter top ice dispenser, dispenses all ice forms reliably, including Nugget ice. Insulated, heavy-duty drip tray prevents condensation. Heavy-duty agitator reduces ice jams and bridging. <br><br>The <b>Scotsman ID200B Ice Only Dispenser</b> would be a good choice. <br><br> Standard Features:<br> <br>• Heavy duty agitator motor for long life <br>• Greater dispensable ice for periods of peak demand <br>• All components accessible <br>• Storage capacity from 150 to 250 lbs <br>• 2 years parts on all components 1 year labor on all components <br> <br> See PDF for more information. 59 ID200.jpg ID200.jpg Scotsman Ice Only Counter Top Dispenser 99999 2449.0000 [empty string] 1234.5600 3 250.00
5 0 Ice Machines No Ice Maker/Ice Dispensers 107 0 ID250B-1A Yes Scotsman ID250B-1A,Ice Only Dispenser,Ice Dispenser,restaurant supplies, restaurant supply,foodservice equipment, foodservice supply, Scotsman, cubed ice dispenser, convenience store ice dispenser, fountain drink dispenser, Coke dispenser 18 Scotsman 6963.0000 SCO0186pdf5.pdf Must use a #KBT43 Bin Top for a 22" wide cube machine or #KBT44 for use with a 30" wide cube machine located in the accessory section.          Ice Only Counter Top Dispenser, cup activated with 250 lbs. ice storage in stainless steel exterior. 115/60/1. Two year parts and one year labor warranty. 30" wide x 30" deep x 39 5/8" high. This counter top ice dispenser, dispenses all ice forms reliably, including Nugget ice. Insulated, heavy-duty drip tray prevents condensation. Heavy-duty agitator reduces ice jams and bridging. <br><br>The <b>Scotsman ID250B Ice Only Dispenser</b> would be a good choice. <br><br> Standard Features:<br> <br>• Heavy duty agitator motor for long life <br>• Greater dispensable ice for periods of peak demand <br>• All components accessible <br>• Storage capacity from 150 to 250 lbs <br>• 2 years parts on all components 1 year labor on all components <br> <br> See PDF for more information. 60 ID250.jpg ID250.jpg Scotsman Ice Only Counter Top Dispenser 99999 2939.0000 [empty string] 1234.5600 3 300.00
6 0 Ice Machines No Ice Maker/Ice Dispensers 107 0 MDT2C12A-1A Yes Scotsman MDT2C12,Cubelet Ice Maker/Dispenser.Ice Maker.Ice dispender,Ice Maker/Dispenser,Cublet Ice Maker,Cublet Ice Dispenser,restaurant supplies, restaurant, countertop ice maker, counter top icemaker supply,foodservice equipment, foodservice supply 18 Scotsman 0.0000 default.pdf           Cubelet Ice Machine/Dispenser wtih 273 lbs. of ice production and 12 lbs. of bin storage. Stainless steel exterior. Gravity Drain. 115/60/1. Two year parts and labor/five year compressor warranty. 15 9/32" wide x 26 7/64" deep x 34 13/32" high. The Cubelet Ice Maker/Dispenser is an extremely quiet operation, ideal for hospital floors, cafeterias and offices.The sleek, high tech design with durable plastic front and top panels. Up to 198 lbs. of ice production in 24 hour bin storage capacity of 12 lbs. of ice.<br><br>The <b>Scotsman MDT2C12 Cubelet Ice Maker/Dispense</b> would be a good choice. <br><br> Standard Features:<br><br> • Plastic chute, easily removed for cleaning<br> • Touch free actuation provides convenient one hand operation <br> • Flexible utility location <br> • Air Cooled<br> • Makes cubelet ice, which is a harder, slow melting ice form that allows for more reliable and easier dispensing <br> 28 MDT2C12.jpg MDT2C12.jpg Scotsman Touch Free IceMaker/Dispenser 99999 3071.0000 [empty string] 1234.5600 3 141.00
7 0 Ice Machines No Ice Maker/Ice Dispensers 107 0 MDT3F12A-1H Yes Scotsman MDT3F12A,Flaked Ice Maker/Dispenser,Flaked Ice Maker,Flaked Ice Dispenser,Ice Maker,Ice Dispenser,restaurant supplies, restaurant supply,foodservice, countertop icemaker, counter top ice maker equipment, foodservice supply 18 Scotsman 0.0000 default.pdf           Flaker IceMaker/Dispenser with 390 lbs. of ice production and 12 lbs. of storage. Stainless steel exterior. Gravity Drain. 115/60/1. Two year parts and labor/five year compressor warranty. 14" wide x 23 3/4" deep x 34 5/16" high. The Flaked Ice Maker/Dispenser has 25% less fan noise, ideal for hospitals floors, offices, and the quietest hallways. The sleek European design has attractive rounded corners and informative instruction labels. Up to 392 lbs of ice production in 24 hours bin storage capacity of 12 lbs of ice.<br><br>The <b>MDT3F12A Flaked Ice Maker/Dispenser</b> would be a good choice. <br><br> Standard Features:<br><br> • Improved dispending with easier access and room for most containers <br> • Touch free actuation provides convenient one hand operations <br> • Flexible utility location <br> • Makes and dispenses flaked ice <br> • Select ice only or ice and water at the touch of a switch, conveniently located on the front panel 29 MDT3F12.jpg MDT3F12.jpg Scotsman Touch Free IceMaker/Dispenser 99999 2749.0000 [empty string] 1234.5600 1 155.00
8 0 Ice Machines No Ice Maker/Ice Dispensers 107 0 MDT4F12A-1H Yes Scotsman MDT4F12A,Flaked Ice Maker/Dispenser,Flaked Ice Maker,Flaked Ice Dispenser,Ice Maker,Ice Dispenser,restaurant supplies, restaurant supply,foodservice, countertop icemaker, counter top ice maker equipment, foodservice supply 18 Scotsman 0.0000 default.pdf           Flake IceMaker/Dispenser with 450 lbs. of ice production and 12 lbs. of storage. Stainless steel exterior. 115/60/1. Two year parts and labor/five year compressor warranty. 14" wide x 23 3/4" deep x 34 5/16" high. The Flaked Ice Maker/Dispenser has 25% less fan noise, ideal for hospitals floors, offices, and the quietest hallways. The sleek European design has attractive rounded corners and informative instruction labels. Up to 453 lbs of ice production in 24 hours bin storage capacity of 12 lbs of ice.<br><br>The <b>MDT4F12A Flaked Ice Maker/Dispenser</b> would be a good choice. <br><br> Standard Features:<br><br> • Improved dispending with easier access and room for most containers <br> • Touch free actuation provides convenient one hand operations <br> • Flexible utility location <br> • Makes and dispenses flaked ice <br> • Select ice only or ice and water at the touch of a switch, conveniently located on the front panel 30 MDT3F121.jpg MDT3F121.jpg Scotsman Touch Free IceMaker/Dispenser 99999 3017.0000 [empty string] 1234.5600 3 155.00
9 0 Ice Machines No Ice Maker/Ice Dispensers 107 0 MDT5N25A-1J Yes Scotsman MDT5N25,Nugget Ice Maker/Dispenser,Ice Maker,Ice Dispenser,Nugget Ice Maker,Nugget Ice Dispenser,restaurant supplies, restaurant supply,foodservice, countertop icemaker, counter top ice maker equipment, foodservice supply 18 Scotsman 0.0000 default.pdf          Nugget IceMaker/Dispenser with 523 lbs. of ice production and 26 lbs. of bin storage. Stainless steel exterior. 115/60/1. Two year parts and labor/five year compressor warranty. 26" wide x 22 1/2" deep x 41" high. The Nugget Ice Maker/Dispenser has 25% less fan noise, ideal for hospitals floors, offices, and the quietest hallways. The sleek European design has attractive rounded corners and informative instruction labels. Up to 523 lbs of ice production in 24 hours bin storage capacity of 26 lbs of ice.<br><br>The <b>MDT5N25 Nugget Ice Maker/Dispenser</b> would be a good choice. <br><br> Standard Features:<br><br> • Improved dispending with easier access and room for most containers <br> • Touch free actuation provides convenient one hand operations <br> • Flexible utility location <br> • Makes and dispenses nugget ice <br> • Select ice only or ice and water at the touch of a switch, conveniently located on the front panel 31 MDT5N25.jpg MDT5N25.jpg Scotsman Touch Free IceMaker/Dispenser 99999 3971.0000 [empty string] 1234.5600 3 260.00
10 0 Ice Machines No Ice Maker/Ice Dispensers 107 0 MDT5N40A-1J Yes Scotsman MDT5N40,Nugget Ice Maker/Dispenser,Ice Maker,Ice Dispenser,Nugget Ice Maker,Nugget Ice Dispenser,restaurant supplies, restaurant supply,foodservice, countertop icemaker, counter top ice maker equipment, foodservice supply 18 Scotsman 0.0000 default.pdf           Nugget IceMaker/Dispenser with 523 lbs. of ice production and 40 lbs. of bin storage. Stainless steel exterior. 115/60/1. Two year parts and labor/five year compressor warranty. 26" wide x 22 1/2" deep x 48 1/2" high. The Nugget Ice Maker/Dispenser has 25% less fan noise, ideal for hospitals floors, offices, and the quietest hallways. The sleek European design has attractive rounded corners and informative instruction labels. Up to 523 lbs of ice production in 24 hours bin storage capacity of 26 lbs of ice.<br><br>The <b>MDT5N40 Nugget Ice Maker/Dispenser</b> would be a good choice. <br><br> Standard Features:<br><br> • Improved dispending with easier access and room for most containers <br> • Touch free actuation provides convenient one hand operations <br> • Flexible utility location <br> • Makes and dispenses nugget ice <br> • Select ice only or ice and water at the touch of a switch, conveniently located on the front panel 32 MDT5N40.jpg MDT5N40.jpg Scotsman Touch Free IceMaker/Dispenser 102,103 4379.0000 [empty string] 1234.5600 3 280.00
11 0 Ice Machines No Ice Maker/Ice Dispensers 107 0 MDT6N90A-1J Yes Scotsman MDT6N90A-1J, Scotsman ice dispener, Scotsman, icemaker, nugget ice, nugget ice dispenser, food service, commercial equipment, restaurant supply, food service equipment 18 Scotsman 0.0000 default.pdf           Nugget IceMaker/Dispenser with 720 lbs. of ice production and 90 lbs. of bin storage. Stainless steel exterior. 115/60/1. Two year parts and labor/five year compressor. 35 3/16" wide x 29 1/4" deep x 45 3/4" high. [empty string] 33 MDT6N90.jpg MDT6N90.jpg Scotsman Touch Free IceMaker/Dispenser 102,103 5839.0000 [empty string] 1234.5600 3 350.00
HANDLING 1.00
I variables
LASTBCAT [empty string]
LOGINPASS icebox
LOGINUSER icemachine
LOOPER 0
MAILSERVER mail.onlinecorp.com
MFGSTRING [empty string]
ORDEREMAIL salesinfo@kitchenrestaurantsupply.com
PNKEY Scotsman
SECURE Yes
SESSION
variables - struct
AID [empty string]
BID [empty string]
CID [empty string]
SHIPFROMZIP 36609
SHOWA Scotsman Bargain Sale Ice Machines Counter Height Ice Storage Bins Ice Maker/Ice Dispensers Accessories
SHOWC Scotsman Ice Machines Ice Maker/Ice Dispensers
SITETITLE Kitchen and Restaurant Supply
SMALLIMAGESIZE 105
SMTPPORT 25
STOREDIRECTORY store
TABLEBG White
TAX .1
TAXSTATE AL
THISBID 29
THISDIRECTORY C:\Inetpub\wwwroot\kitchen\www\
TIMEOUTTIME 45
getbsi
variables - query
  C_CATEGORYNAME C_ID EXPR1
1 Bargain Sale Food Warming Equipment 9068 2
2 Bargain Sale Furniture 9280 1
3 Bargain Sale Hot Food Displays 49 1
4 Bargain Sale Ice Machines 44 1
5 Bargain Sale Merchandisers 9072 1
6 Bargain Sale Refrigerated Equipment 42 2
7 Bargain Sale Shelves 41 3
8 Bargain Sale Sinks 9071 4
9 Bargain Sale Smallwares 9281 2
10 Bargain Sale Stainless Dish Tables/Accessories 47 5
11 Bargain Sale Work Tables 9073 1
12 Blender 9304 1
13 Food Processor 9305 1
getcats
variables - query
  C_CATEGORYNAME C_ID
1 Bargain Sale Ice Machines 44
2 Counter Height 102
3 200 lbs - 500 lbs 103
4 600 lbs - 1000 lbs 104
5 1200 lbs - 2000 lbs 105
6 Ice Storage Bins 106
7 Ice Maker/Ice Dispensers 107
8 Accessories 108
getleft
variables - query
  B_CATEGORYNAME B_ID C_CATEGORYNAME C_ID
1 Bar Equipment 39 Bar Blender 186
2 Bar Equipment 39 Bar Sink 9060
3 Bar Equipment 39 Beer Cooler 97
4 Bar Equipment 39 Draft Beer Dispenser 98
5 Bar Equipment 39 Ice/Cocktail Station 9061
6 Bar Equipment 39 Speed Rail 9062
7 Cooking Equipment 20 Braising Pans 126
8 Cooking Equipment 20 Charbroilers 53
9 Cooking Equipment 20 Combi Oven 9282
10 Cooking Equipment 20 Connection Hoses 130
11 Cooking Equipment 20 Convection Ovens 62
12 Cooking Equipment 20 Conveyor Oven 85
13 Cooking Equipment 20 Fryers 128
14 Cooking Equipment 20 Griddle 77
15 Cooking Equipment 20 Hot Plate 78
16 Cooking Equipment 20 Kettles 54
17 Cooking Equipment 20 Microwaves 64
18 Cooking Equipment 20 Ranges 127
19 Cooking Equipment 20 Rice Cooker 9283
20 Cooking Equipment 20 Steamers 71
21 Dishwashing 28 Dish Washers 61
22 Freezers 34 Chest Type 9284
23 Freezers 34 Reach In 90
24 Freezers 34 Undercounter freezer 66
25 Freezers 34 Work Top 73
26 Ice Machines 27 1200 lbs - 2000 lbs 105
27 Ice Machines 27 200 lbs - 500 lbs 103
28 Ice Machines 27 600 lbs - 1000 lbs 104
29 Ice Machines 27 Accessories 108
30 Ice Machines 27 Counter Height 102
31 Ice Machines 27 Ice Maker/Ice Dispensers 107
32 Ice Machines 27 Ice Storage Bins 106
33 Prep Equipment 26 Food Blender 185
34 Prep Equipment 26 Food Cutter 60
35 Prep Equipment 26 Food Processors 59
36 Prep Equipment 26 Hand Mixer 184
37 Prep Equipment 26 Meat Grinders & Tenderizers 57
38 Prep Equipment 26 Meat Saws 9303
39 Prep Equipment 26 Mixers 55
40 Prep Equipment 26 Slicers 58
41 Refrigerated Merchandiser 38 Deli Cases 94
42 Refrigerated Merchandiser 38 Floral Merchandiser 110
43 Refrigerated Merchandiser 38 Frozen Food/Ice Cream 119
44 Refrigerated Merchandiser 38 Glass Door 93
45 Refrigerated Merchandiser 38 Ice Bag Merchandiser 109
46 Refrigerated Merchandiser 38 Ice Cream Dipping Display 120
47 Refrigerated Merchandiser 38 Open Display 129
48 Refrigerated Merchandiser 38 School Milk 95
49 Refrigerated Merchandiser 38 Sushi Case 131
50 Refrigerators 33 Blast Chillers 69
51 Refrigerators 33 Glass Froster 100
52 Refrigerators 33 Pizza Prep 74
53 Refrigerators 33 Reach Ins 88
54 Refrigerators 33 Refrigerated Equipment Stand 99
55 Refrigerators 33 Sandwich Prep 68
56 Refrigerators 33 Undercounter Refrigerators 65
57 Refrigerators 33 Work Tops 72
58 Shelving/Storage 44 Post 9064
59 Shelving/Storage 44 Shelf 9063
60 Shelving/Storage 44 Wall Mount Bracket 9065
61 Small Appliances 37 Condiment Station 82
62 Small Appliances 37 Frozen Drink Mixer 188
63 Small Appliances 37 Hot Doggers 79
64 Small Appliances 37 Juicer 187
65 Small Appliances 37 Oyster Shucker 9301
66 Small Appliances 37 Pizza Display 84
67 Small Appliances 37 Popcorn Poppers 81
68 Small Appliances 37 Scales 9043
69 Small Appliances 37 Toasters 83
70 Small Appliances 37 Waffle Maker 9306
71 Smallwares 43 Bar Supplies 158
72 Smallwares 43 Brushes 174
73 Smallwares 43 Can Openers 9295
74 Smallwares 43 Catering Equipment 166
75 Smallwares 43 Cookware 9302
76 Smallwares 43 Cutlery 9296
77 Smallwares 43 Cutting Boards 9300
78 Smallwares 43 Dinnerware 9075
79 Smallwares 43 Displayware 168
80 Smallwares 43 Drinkware 9128
81 Smallwares 43 Fast Food Supply 160
82 Smallwares 43 Food Bars & Accessories 159
83 Smallwares 43 Food/Steam Table Pans 9288
84 Smallwares 43 Foodservice Trays 163
85 Smallwares 43 Ice Scoop 9299
86 Smallwares 43 Janitorial 180
87 Smallwares 43 Kitchen Utencils 161
88 Smallwares 43 Order/Ticket Holders 9289
89 Smallwares 43 Pitchers 9286
90 Smallwares 43 Silverware 9294
91 Smallwares 43 Storage & Handling 154
92 Smallwares 43 Tabletop Accessories 157
93 Smallwares 43 Tongs 9292
94 Smallwares 43 Trash Cans 9285
95 Smallwares 43 Turners 9293
96 Smallwares 43 Warewashing 164
97 Stainless Steel 30 Accessories 125
98 Stainless Steel 30 Can Racks 112
99 Stainless Steel 30 Dunnage Racks 111
100 Stainless Steel 30 Equipment Stands 124
101 Stainless Steel 30 Hand Sinks 114
102 Stainless Steel 30 Mixer Stand 123
103 Stainless Steel 30 Pan Racks 113
104 Stainless Steel 30 Pot Racks 122
105 Stainless Steel 30 Sink Accessories 121
106 Stainless Steel 30 Sinks 118
107 Stainless Steel 30 Wall Shelf 116
108 Stainless Steel 30 Work Tables 117
109 True Commercial Refrigeration 11 Deli Cases 32
110 True Commercial Refrigeration 11 Refrigerators 4
111 True Commercial Refrigeration 11 Under Bar Refrigeration 33
112 Walk Ins 41 Combo Cooler/Freezer 135
113 Walk Ins 41 Cooler 133
114 Walk Ins 41 Freezer 134
115 Warming/Merchandising 29 Countertop Warmer 87
116 Warming/Merchandising 29 Drawer Warmers 86
117 Warming/Merchandising 29 Heated Pump Warmer 80
118 Warming/Merchandising 29 Heated Reach Ins 92
119 Warming/Merchandising 29 Hot Food Table 91
getmfgs
variables - query
  MFG_ID MFG_NAME
1 9 Advance/Tabco
2 2562 Amana
3 26 APW/WYOTT
4 5737 Arctic Air
5 28 Berkel
6 29 Beverage Air
7 38 brand
8 5739 Browne-Halco
9 5747 Cambro
10 39 Carlisle
11 2 Cleveland
12 14 Delfield
13 5746 Dexter
14 33 Dormont Hoses
15 5751 Edlund
16 5745 Fleetwood
17 10 Frymaster/Dean
18 3 Garland/US Range
19 2560 Globe
20 6 Groen
21 5742 Hamilton
22 13 Hatco
23 15 Hobart
24 34 Hoshizaki
25 5743 Ice-O-Matic
26 30 Jackson
27 5728 Krowne Metal
28 31 Lincoln Ovens
29 17 Manitowoc
30 8 Masterbilt
31 5738 Meiko
32 20 Metal Master Eagle Group
33 4 Metro
34 36 Nemco
35 5727 Other
36 2561 Panasonic
37 7 Randell
38 44 Robot Coupe
39 5744 San Jamar
40 18 Scotsman
41 5736 Select Stainless
42 42 Sparta
43 5750 Spill-Stop Mfg. LLC
44 37 Star
45 5749 Tablecraft
46 16 Traulsen
47 5741 TriStar
48 19 True Ref.
49 2563 Turbo Air
50 11 Varimixer
51 45 Vita Mix
52 5730 Vollrath
53 21 Vulcan
54 35 Waring