Kitchen Restaurant Supply - Commercial refrigeration ice machines freezers deli cases Ice machines refrigeration and restaurant equipment.

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

Beverage Air Product Categories
Undercounter Refrigerators	Sandwich Prep
Work Tops	Work Top
Pizza Prep	Reach Ins
Reach In	Glass Door
School Milk	Beer Cooler
Draft Beer Dispenser	Refrigerated Equipment Stand
Glass Froster	Open Display
All Products

Click a product below for complete details

Beverage Air Bottle Cooler
Beverage Air DW49-B

Bottle Cooler, flat top, 50" L, 26-1/2" D, (2) sliding doors, deep well design, black vinyl exterior, galvanized interior, s/s top, self-contained refrigeration system, 1/3 hp

variables - struct

ABSOLUTESITEDIR

C:\Inetpub\wwwroot\kitchen\www\

ACCESSORIESON

Right

ADMINEMAIL

salesinfo@kitchenrestaurantsupply.com

Variable HIDDENPRICE is undefined.

StackTrace

TagContext

variables - array

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

CFQUERY.EXECUTIONTIME

CFSTOREDPROC

variables - struct
ExecutionTime	0

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/

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	Bar Equipment	No	Beer Cooler	97	0	DW49-B	Yes	DEEP & SHALLOW WELL HORIZONTAL COOLERS,restaurant supply,foodservice equipment,foodservice supply,restaurant supplies, Beverage Air, commercial equipment, bar cooler, beer cooler, deep well cooler, beer refrigerator, beer box, bar equipment	29	Beverage Air	0.0000	BEV0458pdf4.pdf	[empty string]	Bottle Cooler, flat top, 50" L, 26-1/2" D, (2) sliding doors, deep well design, black vinyl exterior, galvanized interior, s/s top, self-contained refrigeration system, 1/3 hp	The DW49-B holds a net capacity of 13.3 cubic feet and is 50" wide. It can hold 23.75 cases of 12oz. cans or 17.50 cases of 12oz. bottles. The exteriors include attractive, wear-resistant vinyl on steel in black finish. It has a bottle cap opener and catcher as a standard feature. It has easy glide, stainless steel lids and stainless steel counter top with integral glass stops. <br><br>The <b>Beverage Air Horizontal Cooler DW49-B</b> would be a good choice. <br><br> Standard Features:<br> <ul> <li>Standard interior metal is galvanized steel.</li> <li>Adjustable dividers included are epoxy coated steel wire.</li> <li>Lid locks are optionally available.</li> <li>Forced air refrigeration hold products between 32°F and 38°F. </li> <li>8’ long cord and plug set included.</li> </ul> <br><br>See PDF for more information.	801	BevAirDW49-B.jpg	BevAirDW49-B.jpg	Beverage Air Bottle Cooler	99999	1287.0000	[empty string]	1234.5600	2	259.00
2	0	Bar Equipment	No	Beer Cooler	97	0	DW64-B	Yes	DEEP & SHALLOW WELL HORIZONTAL COOLERS,restaurant supply,foodservice equipment,foodservice supply,restaurant supplies, Beverage Air, commercial equipment, bar cooler, beer cooler, deep well cooler, beer refrigerator, beer box, bar equipment	29	Beverage Air	0.0000	BEV0458pdf11.pdf	[empty string]	Bottle Cooler, flat top, 65" L, 26-1/2" D, (2) sliding doors, deep well design, black vinyl exterior, galvanized interior, s/s top, self-contained refrigeration system, 1/3 hp	The DW64-B holds a net capacity of 18.5 cubic feet and is 65" wide. This model holds 34.75 cases of 12oz. cans or 25.25 cases of 12oz. bottles. The exteriors include attractive, wear-resistant vinyl on steel in black finish. The bottle cap opener and catcher are standard. It has easy glide, stainless steel lids and stainless steel counter top with integral glass stops. <br><br>The <b>Beverage Air Horizontal Cooler DW64-B </b> would be a good choice. <br><br> Standard Features:<br> <ul> <li>Standard interior metal is galvanized steel.</li> <li>Adjustable dividers included are epoxy coated steel wire.</li> <li>Lid locks are optionally available.</li> <li>Forced air refrigeration hold products between 32°F and 38°F.</li> <li>8’ long cord and plug set included.</li> </ul> <br><br>See PDF for more information.	802	BevAirDW64-B.jpg	BevAirDW64-B.jpg	Beverage Air Bottle Cooler	99999	1428.0000	[empty string]	1234.5600	2	296.00
3	0	Bar Equipment	No	Beer Cooler	97	0	DW79-B	Yes	DEEP & SHALLOW WELL HORIZONTAL COOLERS,restaurant supply,foodservice equipment,foodservice supply,restaurant supplies, Beverage Air, commercial equipment, bar cooler, beer cooler, deep well cooler, beer refrigerator, beer box, bar equipment	29	Beverage Air	0.0000	BEV0458pdf12.pdf	[empty string]	Bottle Cooler, flat top, 80" L, 26-1/2" D, (3) sliding doors, deep well design, 3-sliding doors, black vinyl exterior, galvanized interior, s/s top, self-contained refrigeration system, 1/2 hp, ENERGY STAR®	The DW79-B model holds a net capacity of 23.2 cubic feet and is 80" wide. It holds 45.75 cases of 12oz. cans or 32.00 cases of 12oz. bottles. The exteriors include attractive, wear-resistant vinyl on steel in black finish. It comes with a standard bottle cap opener and catcher. It has easy glide, stainless steel lids and stainless steel counter top with integral glass stops. <br><br>The <b>Beverage Air Horizontal Cooler DW79-B </b> would be a good choice. <br><br> Standard Features:<br> <ul> <li>Standard interior metal is galvanized steel.</li> <li>Adjustable dividers included are epoxy coated steel wire.</li> <li>Lid locks are optionally available.</li> <li>Forced air refrigeration hold products between 32°F and 38°F.</li> <li>8’ long cord and plug set included.</li> </ul> <br><br>See PDF for more information.	803	BevAirDW79-B.jpg	BevAirDW79-B.jpg	Beverage Air Bottle Cooler	99999	1868.0000	[empty string]	1234.5600	2	379.00
4	0	Bar Equipment	No	Beer Cooler	97	0	DW94-B	Yes	DEEP & SHALLOW WELL HORIZONTAL COOLERS,restaurant supply,foodservice equipment,foodservice supply,restaurant supplies, Beverage Air, commercial equipment, bar cooler, beer cooler, deep well cooler, beer refrigerator, beer box, bar equipment	29	Beverage Air	0.0000	BEV0458pdf13.pdf	[empty string]	Bottle Cooler, flat top, 95" L, 26-1/2" D, (4) sliding doors, deep well design, black vinyl exterior, galvanized interior, s/s top, self-contained refrigeration system, 1/2 hp, ENERGY STAR®	The model DW94-B holds a net capacity of 28.5 cubic feet and is 95" wide. It has a capacity of 55.75 cases of 12oz. cans or 39.00 cases of 12oz. bottles. The exteriors include attractive, wear-resistant vinyl on steel in black finish. A standard feature is a bottle cap opener and catcher. It has easy glide, stainless steel lids and stainless steel counter top with integral glass stops. <br><br>The <b>Beverage Air Horizontal Cooler DW94-B</b> would be a good choice. <br><br> Standard Features:<br> <ul> <li>Standard interior metal is galvanized steel.</li> <li>Lid locks are optionally available..</li> <li>Adjustable dividers included are epoxy coated steel wire.</li> <li>Forced air refrigeration hold products between 32°F and 38°F.</li> <li>8’ long cord and plug set included.</li> </ul> <br><br>See PDF for more information.	804	BevAirDW94-B.jpg	BevAirDW94-B.jpg	Beverage Air Bottle Cooler	99999	1978.0000	[empty string]	1234.5600	2	425.00
5	0	Bar Equipment	No	Beer Cooler	97	0	BB58-1-B	Yes	Beverage Air,restaurant supply,foodservice equipment,foodservice supply,restaurant supplies, back bar refrigerator, beer cooler, refrigerated bar cooler, cooler, bar equipment	29	Beverage Air	0.0000	BEV0330pdf4.pdf	[empty string]	Refrigerated Backbar Storage Cabinet, 2-section, 37-1/4" H, left-mounted self-contained refrig w/storage above, (2) solid doors, black exterior finish, s/s top, with s/s floors & galvanized interior walls, (4) epoxy coated steel shelves, 1/3 hp, ENERGY STAR®	Back bar storage cabinets come in basic, self contained models up to 95" wide. The overall height is 37 1/4" from face of door to back of cabinet. The handles project 1 3/4". The solid doors are standard, self closing with magnetic gaskets for positive seal. Reinforced stainless steel doorsills and flooring for lasting service. It uses 134A refrigerant, which is CFC free for compliance with environmental concerns. <br><br>The <b>Beverage-Air Refrigerated Barback Storage Cabinet BB58-1</b> would be a good choice. <br><br> Standard Features:<br> <ul> <li>Number of Shelves - 4</li> <li>Number of Kegs - 2</li> <li>Net Capacity cubic ft. 23.7</li> <li>Net Capacity 671 liters</li> <li>Length overall 59"</li> </ul> <br><br>See PDF for more information.	805	BevAirBB58-1-B.jpg	BevAirBB58-1-B.jpg	Beverage Air Refrigerated Backbar	99999	1828.0000	[empty string]	1234.5600	2	315.00
6	0	Bar Equipment	No	Beer Cooler	97	0	BB58G-1-B	Yes	Beverage Air,restaurant supply,foodservice equipment,foodservice supply,restaurant supplies, back bar refrigerator, beer cooler, refrigerated bar cooler, cooler, bar equipment	29	Beverage Air	0.0000	BEV0332pdf3.pdf	[empty string]	Refrigerated Backbar Storage Cabinet, 2-section, 37-1/4" H, left-mounted self-contained refrig, (2) glass doors, black exterior finish, s/s top, with s/s floors & galvanized interior walls, (4) epoxy coated steel shelves, 1/3 hp	[empty string]	806	BevAirBB58G-1-B.bmp	BevAirBB58G-1-B.bmp	Beverage Air Refrigerated Backbar	99999	2039.0000	[empty string]	1234.5600	2	315.00
7	0	Bar Equipment	No	Beer Cooler	97	0	BB68-1-B	Yes	Beverage Air,restaurant supply,foodservice equipment,foodservice supply,restaurant supplies, back bar refrigerator, beer cooler, refrigerated bar cooler, cooler, bar equipment	29	Beverage Air	0.0000	BEV0330pdf11.pdf	[empty string]	Refrigerated Backbar Storage Cabinet, 2-section, 37-1/4" H, left-mounted self-contained refrig w/storage above, (2) solid doors, black exterior finish, s/s top, with s/s floors & galvanized walls, (4) epoxy coated steel shelves, 1/3 hp, ENERGY STAR®	The Beverage Air Refrigerated Backbar Storage Cabinet has 2-sections and is 37-1/4' H. It is a left-mounted self-contained storage with 2-solid doors, black exterior finish and a stainless steel top. For easy cleaning it has stainless steel floors and galvanized walls. For storage, it has 4- epoxy coated steel shelves. It is Energy Star Rated. <br><br>The <b>Beverage Air Solid Door Back Bar Cooler BB68-1</b> would be a good choice. <br><br> Standard Features:<br> <ul> <li>Self-closing doors</li> <li>Built-in locks</li> <li>Black steel exterior</li> <li>Stainless steel floor and door breakers</li> <li>Accommodates 3 straight wall beer kegs</li> </ul> <br><br>See PDF for more information.	807	BevAirBB68-1-B.jpg	BevAirBB68-1-B.jpg	Beverage Air Refrigerated Backbar	99999	1918.0000	[empty string]	1234.5600	2	372.00
8	0	Bar Equipment	No	Beer Cooler	97	0	BB68G-1-B	Yes	Beverage Air,restaurant supply,foodservice equipment,foodservice supply,restaurant supplies, back bar refrigerator, beer cooler, refrigerated bar cooler, cooler, bar equipment	29	Beverage Air	0.0000	BEV0332pdf4.pdf	[empty string]	Refrigerated Backbar Storage Cabinet, 2-section, 37-1/4" H, right-mounted self-contained refrig, (2) glass doors, black exterior finish, s/s top, with s/s floors & galvanized interior walls, (4) epoxy coated steel shelves, 1/3 hp	[empty string]	808	BevAirBB68G-1-B.jpg	BevAirBB68G-1-B.jpg	Beverage Air Refrigerated Backbar	99999	2209.0000	[empty string]	1234.5600	2	372.00
9	0	Bar Equipment	No	Beer Cooler	97	0	BB78-1-B	Yes	Beverage Air,restaurant supply,foodservice equipment,foodservice supply,restaurant supplies, back bar refrigerator, beer cooler, refrigerated bar cooler, cooler, bar equipment	29	Beverage Air	0.0000	BEV0330pdf12.pdf	[empty string]	Refrigerated Backbar Storage Cabinet, 3-section, 37-1/4" H, left-mounted self-contained refrig w/storage above, (3) solid doors, black exterior finish, s/s top, with s/s floors & galvanized interior walls, (6) epoxy coated steel shelves, 1/3 hp, ENERGY STAR®	This Beverage Air Refrigerated Backbar Storage Cabinet has 3-sections. It comes with a 37-1/4' H, left-mounted self-contained storage area. To make cleaning quick, it has a stainless steel top, floors and galvanized interior walls. This model has 6-epoxy coated steel shelves. It is Energy Star Rated. <br><br>The <b>Beverage Air Refrigerated Backbar BB78-1-B</b> would be a good choice. <br><br> Standard Features:<br> <ul> <li>Width (in): 79 </li> <li>Door Type: Solid Door</li> <li>Doors/Drawers: 3 Swing</li> <li>Construction: Black Front & Sides</li> <li>Accommodates 4 straight wall beer kegs</li> </ul> <br><br>See PDF for more information.	809	BevAirBB78-1-B.jpg	BevAirBB78-1-B.jpg	Beverage Air Refrigerated Backbar	99999	2258.0000	[empty string]	1234.5600	2	405.00
10	0	Bar Equipment	No	Beer Cooler	97	0	BB78G-1-B	Yes	Beverage Air,restaurant supply,foodservice equipment,foodservice supply,restaurant supplies, back bar refrigerator, beer cooler, refrigerated bar cooler, cooler, bar equipment	29	Beverage Air	0.0000	BEV0332pdf5.pdf	[empty string]	Refrigerated Backbar Storage Cabinet, 3-section, 37-1/4" H, right-mounted self-contained refrig, (3) glass doors, black exterior finish, s/s top, with s/s floors & galvanized interior walls, (6) epoxy coated steel shelves, 1/3 hp	[empty string]	810	BevAirBB78G-1-B.jpg	BevAirBB78G-1-B.jpg	Beverage Air Refrigerated Backbar	99999	2575.0000	[empty string]	1234.5600	2	405.00

salesinfo@kitchenrestaurantsupply.com

variables - struct
AID	[empty string]
BID	[empty string]
CID	[empty string]

SHIPFROMZIP

36609

SHOWA

Beverage Air Undercounter Refrigerators Sandwich Prep Work Tops Work Top Pizza Prep Reach Ins Reach In Glass Door School Milk Beer Cooler Draft Beer Dispenser Refrigerated Equipment Stand Glass Froster Open Display

SHOWC

Beverage Air Bar Equipment Beer Cooler

SITETITLE

Kitchen and Restaurant Supply

C:\Inetpub\wwwroot\kitchen\www\

TIMEOUTTIME

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	Undercounter Refrigerators	65
2	Sandwich Prep	68
3	Work Tops	72
4	Work Top	73
5	Pizza Prep	74
6	Reach Ins	88
7	Reach In	90
8	Glass Door	93
9	School Milk	95
10	Beer Cooler	97
11	Draft Beer Dispenser	98
12	Refrigerated Equipment Stand	99
13	Glass Froster	100
14	Open Display	129

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