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

Garland/US Range Product Categories
Convection Ovens	Ranges
All Products

Click a product below for complete details

GARLAND RANGE
Garland/US Range X36-6R

Restaurant Range, Gas, 36" wide, (6) 28,000 BTU open burners, (1) 26" oven w/aluminized top, back, sides & porcelain bottom, center pilots, s/s front, sides, plate rail, backguard and plate shelf, 6" chrome plated adjustable legs, 198,000 total BTU, NSF, Stove

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	Cooking Equipment	No	Ranges	127	0	X36-6R	Yes	stove, stoves,gas range,gas oven,restaurant range and oven,restaurant supplies,restaurant supply,foodservice equipment,foodservice supply	3	Garland/US Range	0.0000	GAR0979pdf.pdf	[empty string]	Restaurant Range, Gas, 36" wide, (6) 28,000 BTU open burners, (1) 26" oven w/aluminized top, back, sides & porcelain bottom, center pilots, s/s front, sides, plate rail, backguard and plate shelf, 6" chrome plated adjustable legs, 198,000 total BTU, NSF, Stove	The Garland X36-6R X-Series Gas Restaurant Range has a large work surface of 35-7/16in. x 27in. The durable stainless steel construction covers the front, sides, 4in. plate rail, backguard, and removable shelf. The X-Series is furnished with a heavy duty standard size oven that has a temperature range between Low and 500ºF. The 6 natural gas open burners each produce 30,000 BTU/hr. and the straight steel tube oven burner produces 33,000 BTU/hr. for a total of 213,000 BTU/hr. <br><br>The <b>Garland X36-6R X-Series 36in. Gas Restaurant Range with Oven</b> would be a good choice. <br><br> Standard Features: <ul> <li>Total 213,000 BTU/hr.(6 burners at 30,000 BTU/hr. and oven at 33,000 BTU/hr.)</li> <li>Includes ergonomic split cast iron top ring grates</li> <li>Natural Gas</li> <li>3/4in. pressure regulator</li> <li>Total Dimensions: 35-7/16in. W x 33-1/2in. D x 57in. H (height includes overshelf)</li> <li>Oven Dimensions: 13in. H x 22in. D x 26-1/4in. W</li> </ul> See PDF for more information.	674	GARUSRSX626.jpg	GARUSRSX626.jpg	GARLAND RANGE	153,222,221,226,224,223	0.0000	[empty string]	1234.5600	2	446.00
2	0	Cooking Equipment	No	Ranges	127	0	X24-4L	Yes	stoves, stove,space saver, range,gas oven,restaurant range and oven,restaurant, supplies,restaurant supply,foodservice equipment,foodservice supply	3	Garland/US Range	0.0000	GAR0939pdf.pdf	[empty string]	Restaurant Range, gas, 24" wide, (4) 28,000 BTU open burners, (1) 20-1/4" oven w/aluminized top, back, sides & porcelain bottom, center pilots, s/s front, sides & front plate rail, with s/s backguard & plate shelf, 6" chrome plated adjustable legs, 137,000 total BTU, NSF	The Garland X24-4L X-Series Gas Restaurant Range comes complete with 4 open burners and a space saving oven. It has a large work surface of 23-5/8in. x 27in. Each of the 4 open burners produces 30,000 BTU/hr. and the straight steel tube oven burner produces 25,000 BTU/hr. <br><br>The <b>Garland X24-4L X-Series 24in. Gas Restaurant Range with Space Saving Oven</b> would be a good choice. <br><br> Standard Features: <ul> <li>Space Saving Oven Dimensions: 13in. H x 26in. D x 20in. W</li> <li>Total Dimensions: 23-5/8in. W x 33-1/2in. D x 57in. H (height includes overshelf)</li> <li>Total 145,000 BTU/hr.(4 burners at 30,000 BTU/hr. and oven at 25,000 BTU/hr.)</li> <li>Stainless steel front, sides, 4in. plate rail, backguard, and removable shelf</li> <li>Includes ergonomic split cast iron top ring grates</li> <li>Natural Gas</li> <li>3/4in. pressure regulator</li> </ul> See PDF for more information.	675	GARUSRSX420.jpg	GARUSRSX420.jpg	Garland Range	153,222,221,226,224,223	0.0000	[empty string]	1234.5600	2	350.00
3	0	Cooking Equipment	No	Ranges	127	0	X60-10RR	Yes	stoves, stove,gas range,gas oven,restaurant range and oven,restaurant supplies,restaurant supply,foodservice equipment,foodservice supply	3	Garland/US Range	0.0000	GAR0965pdf1.pdf	[empty string]	Restaurant Range, Gas, 60" wide, (10) 28,000 BTU open burners, (2) 26" ovens w/aluminized top, back & sides w/porcelain bottom, center pilots, s/s front, sides & front plate rail, with s/s backguard & plate shelf, 6" chrome plated adjustable legs, 340,000 total BTU, NSF, Stove	The Garland X60-10RR X-Series Gas Restaurant Range has 10 natural gas open burners that each produce 30,000 BTU/hr. The X-Series is furnished with two heavy duty standard size ovens that produce 33,000 BTU/hr. each and have a temperature range between Low and 500ºF. It has a large work surface of 59-1/16in. x 27in. to offer today's high-volume kitchen significant cooking space. The durable stainless steel construction covers the front, sides, 4in. plate rail, backguard, and removable shelf. <br><br>The <b>Garland X60-10RR X-Series 60in. Gas Restaurant Range with Double Oven</b> would be a good choice. <br><br> Standard Features: <ul> <li>Total 366,000 BTU/hr.(10 burners at 30,000 BTU/hr. and 2 ovens at 33,000 BTU/hr.) </li> <li>Total Dimensions: 59-1/16in. W x 33-1/2in. D x 57in. H (height includes overshelf) </li> <li>Standard Size Oven Dimensions: 13in. H x 22in. D x 26-1/4in. W</li> <li>Includes ergonomic split cast iron top ring grates</li> <li>1in. pressure regulator</li> <li>Natural Gas</li> </ul> See PDF for more information.	676	GARUSRSX102626.jpg	GARUSRSX102626.jpg	GARLAND RANGE	153,222,221,226,224,223	0.0000	[empty string]	1234.5600	2	756.00
4	0	Cooking Equipment	No	Ranges	127	0	X60-6G24RR	Yes	stoves, stove,gas griddle range,gas range,gas oven,restaurant range and oven,restaurant supplies,restaurant supply,foodservice equipment,foodservice supply	3	Garland/US Range	0.0000	GAR0965pdf11.pdf	[empty string]	Restaurant Range, Gas, 60" wide, (6) 28,000 BTU open burners, 24" griddle w/5/8" thick grill plate, (2) 26" ovens w/aluminized top, back, sides & porcelain bottom, center pilots, s/s front, sides & front plate rail, with s/s backguard & plate shelf, 6" chrome plated adjustable legs, 268,000 total BTU, NSF, stove	The Garland X60-6G24RR X-Series Gas Restaurant Range includes 6 burners, 24in. griddle, and 2 ovens. The sizable work surface measures 59-1/16in. x 27in. to offer significant cooking space for high-volume kitchens. The X-Series is built strong with stainless steel construction covering the front, sides, 4in. plate rail, backguard, and removable shelf. <br><br>The <b>Garland X60-6G24RR X-Series 60in. Gas Restaurant Range with Griddle and Double Oven</b> would be a good choice. <br><br> Standard Features: <ul> <li>Natural Gas</li> <li>1in. pressure regulator</li> <li>Includes ergonomic split cast iron top ring grates</li> <li>Total 282,000 BTU/hr.(6 burners at 30,000 BTU/hr., 2 ovens at 33,000 BTU/hr., and two 12in. griddles at 18,000 BTU/hr.)</li> <li>Total Dimensions: 59-1/16in. W x 33-1/2in. D x 57in. H (height includes overshelf)</li> <li>Standard Size Oven Dimensions: 13in. H x 22in. D x 26-1/4in. W</li> </ul>See PDF for more information.	677	GARUSRPS-24G-6.jpg	GARUSRPS-24G-6.jpg	GARLAND RANGE	153,222,221,226,224,223	0.0000	[empty string]	1234.5600	2	793.00
5	0	Cooking Equipment	No	Ranges	127	0	X60-6R24RR	Yes	broiler griddle range,gas raised griddle range,gas range,gas oven,restaurant range and oven,restaurant supplies,restaurant supply,foodservice equipment,foodservice supply, stove	3	Garland/US Range	0.0000	GAR0965pdf12.pdf	[empty string]	Restaurant Range, gas, 60" wide, (6) 28,000 BTU open burners, 24" broiler/griddle, (2) 26" ovens w/porcelain bottom & aluminized top, back & sides, center pilots, s/s front, sides & front plate rail, with s/s backguard & plate shelf, 6" chrome plated adjustable legs, 270,000 total BTU, NSF, stove	The Garland X60-6R24RR X-Series Gas Restaurant Range includes 6 burners, 2 ovens, and a 24in. raised griddle broiler. The X-Series is resilient with stainless steel construction covering the front, sides, 4in. plate rail, backguard, and removable shelf. The sizable work surface measures 59-1/16in. x 27in. to offer significant cooking space for high-volume kitchens. <br><br>The <b>Garland X60-6R24RR X-Series 60in. Gas Restaurant Range with Raised Griddle Broiler and Double Oven</b> would be a good choice. <br><br> Standard Features: <ul> <li>Natural Gas</li> <li>1in. pressure regulator</li> <li>Includes ergonomic split cast iron top ring grates</li> <li>24in. raised broiler griddle has 3 cast iron burners each producing 14,500 BTU/hr.</li> <li>Total Dimensions: 59-1/16in. W x 33-1/2in. D x 57in. H (height includes overshelf) </li> <li>2 Standard Size Ovens with thermostat temperature range of Low to 500ºF</li> <li>Total BTU/hr.: 279,000 BTU/hr.</li> <li>Furnished with 6in. adjustable legs</li> </ul> See PDF for more information.	678	GARUSRSX24G626261.jpg	GARUSRSX24G626261.jpg	GARLAND RANGE	153,222,221,226,224,223	0.0000	[empty string]	1234.5600	2	855.00
6	0	Cooking Equipment	No	Ranges	127	0	SS686	Yes	stove, stove, electric restaurant range,electric restaurant oven,restaurant supplies,restaurant supply,foodservice equipment,foodservice supply	3	Garland/US Range	10135.0000	default.pdf	[empty string]	Sentry Series Range, 36" Restaurant, electric, 6 high performance sealed element burners, standard oven, with 10" high backguard, all s/s ext'r finish, 6" s/s legs, 19 kw (Garland), stove	The Garland SS686 Sentry Series Electric Restaurant Range has a stainless steel exterior. It contains one oven racks that can be positioned on 4 rack guides. This range uses a resilient electromechanical thermostat that ranges in temperatures between 150ºF and 550ºF. The 6 sealed-top elements protect against over heating if an element is left without a pan for 8 minutes. <br><br>The <b>Garland SS686 Sentry Series Electric Restaurant Range</b> would be a good choice. <br><br> Standard Features: <ul> <li>North American Model - Is not CE approved</li> <li>10in. stainless backguard</li> <li>6in. adjustable stainless legs</li> <li>Medium duty</li> <li>Specifications: 19Kw; 208V, single-phase, 90amps</li> <li>Outer Dimensions: 47in. H x 36in. W x 34-1/4in. D (with 6in. front rail)</li> <li>Interior Oven Dimensions: 13-1/2in. H x 26-1/4in. W x 22in. D</li> </ul> See PDF for more information.	823	GARUSRSS686.jpg	GARUSRSS686.jpg	Garland Range	219,217,220,218,153,222,221,226	0.0000	[empty string]	1234.5600	2	385.00
7	0	Cooking Equipment	No	Ranges	127	0	G36-6R	Yes	restaurant range,restaurant oven,restaurant cook top,cooktop,restaurant supplies,restaurant supply,foodservice equipment,foodservice supply,stove	3	Garland/US Range	0.0000	default.pdf	[empty string]	G36 Series Restaurant Range, gas, 36"W, (6) 33,000 BTU open burners, with cast iron top & ring grates, standard oven w/3 position rack guides w/oven rack, s/s front, sides, backguard, & high shelf, 6" s/s legs with adjustable feet, 236,000 BTU, Stove	The Garland G36-6R G-Series Gas Restaurant Range has stainless steel construction front, sides, plate rail, backguard, and overhead shelf. The large, easy-to-operate control knobs make cooking almost effortless. The high-efficiency standard porcelain oven fits standard full-size sheet pans side-by- side or front-to-back. The G-Series range comes with a 4-1/4in. grease trough to make clean-up a breeze. <br><br>The <b>Garland G36-6R G-Series 36in. Gas Restaurant Range</b> would be a good choice. <br><br> Standard Features: <ul> <li>5in. Front Rail</li> <li>Work Space Dimensions: 35-7/16in. W x 27in. D</li> <li>Overall Dimensions: 35-7/16in. W x 34-1/2in. D x 57in. H (with shelf and 6in. adjustable legs)</li> <li>6 Natural Gas 33,000 BTU/hr. open burners</li> <li>Interior Oven Dimensions: 13in.H x 26in. D x 26-1/4in. W</li> </ul> See PDF for more information.	865	G36-6R.jpg	G36-6R.jpg	Garland Range	153,222,221,226,224,223	0.0000	[empty string]	1234.5600	2	430.00
8	0	Cooking Equipment	No	Ranges	127	0	G60-10RR	Yes	stove,restaurant range,restaurant oven,restaurant cook top,cooktop,restaurant supplies,restaurant supply,foodservice equipment,foodservice supply	3	Garland/US Range	0.0000	GAR0957pdf.pdf	[empty string]	G60 Series Restaurant Range, gas, 60"W, (10) 33,000 BTU open burners, with cast iron top & ring grates, (2) standard ovens w/3 position rack guides w/oven rack each, s/s front, sides, plate rail, backguard, & high shelf, 6" s/s legs with adjustable feet, 406,000 BTU, stove	The Garland G60-10RR G-Series Gas Restaurant Range includes 2 standard size ovens. The sturdy stainless steel construction covers the front, sides, plate rail, backguard, and removable overhead shelf. The large, easy-to-operate control knobs make cooking almost effortless. <br><br>The <b>Garland G60-10RR G-Series 60in. Gas Restaurant Range with Double Oven</b> would be a good choice. <br><br> Standard Features: <ul> <li>5in. W Front Rail</li> <li>Work Space Dimensions: 59-1/16in. W x 27in. D</li> <li>Overall Dimensions: 59-1/16in. W x 34-1/2in. D x 57in. H (with shelf and 6in. adjustable legs)</li> <li>10 Natural Gas 33,000 BTU/hr. open burners</li> <li>(2) 13in.H x 26in. D x 26-1/4in. W ovens</li> </ul> See PDF for more information.	866	GARUSRX60-10RR.jpg	GARUSRX60-10RR.jpg	Garland Range	153,222,221,226,224,223	0.0000	[empty string]	1234.5600	2	726.00
9	0	Cooking Equipment	No	Ranges	127	0	G60-6R24RR	Yes	stove, restaurant range,restaurant oven,restaurant cook top,cooktop,restaurant supplies,restaurant supply,foodservice equipment,foodservice supply	3	Garland/US Range	0.0000	GAR0977pdf1.pdf	[empty string]	G60 Series Restaurant Range, gas, 60"W, (6) 33,000 BTU open burners, with cast iron top & ring grates, 24" raised griddle/broiler (std on right), (2) standard ovens w/3 position rack guides w/oven rack, s/s front, sides, plate rail, backguard, & high shelf, 6" s/s legs with adjustable feet, 317,500 BTU, stove	The Garland G60-6R24RR G-Series Gas Restaurant Range includes 2 standard size ovens and a 24in. raised griddle/broiler. The large, easy-to-operate control knobs make cooking almost effortless. The sturdy stainless steel construction covers the front, sides, plate rail, backguard, and removable overhead shelf. The 5/8in. thick steel griddle plate has a manual valve control. <br><br>The <b>Garland G60-6R24RR G-Series 60in. Gas Restaurant Range with Griddle and Double Oven</b> would be a good choice. <br><br> Standard Features: <ul> <li>Griddle: Right side; 5/8in. thickness; 24in. W x 23in. D work space</li> <li>Overall Work Space Dimensions: 59-1/16in. W x 27in. D</li> <li>Overall Dimensions: 59-1/16in. W x 34-1/2in. D x 57in. H (with shelf and 6in. adjustable legs)</li> <li>6 Natural Gas 33,000 BTU/hr. open burners</li> <li>(2) 13in.H x 26in. D x 26-1/4in. W ovens</li> <li>5in. W Front Rail</li> </ul> See PDF for more information.	867	GARUSRX60-6R24RR.jpg	GARUSRX60-6R24RR.jpg	Garland Range	153,222,221,226,224,223	0.0000	[empty string]	1234.5600	2	828.00
10	0	Cooking Equipment	No	Ranges	127	0	SS684	Yes	garland, range, cooking, restaurant, kitchen range, commercial range, stove	3	Garland/US Range	16251.0000	GAR1002pdf.pdf	[empty string]	Sentry Series Range, 60" Restaurant, electric, 10 high performance sealed element burners, two standard ovens, with 10" high backguard, all s/s ext'r finish, 6" s/s legs, 33 kw (Garland), stove	[empty string]	29845	GARUSRSS684.bmp	GARUSRSS684.bmp	Garland Range	99999	0.0000	[empty string]	1234.5600	2	630.00

salesinfo@kitchenrestaurantsupply.com

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

SHIPFROMZIP

36609

SHOWA

Garland/US Range Convection Ovens Ranges

SHOWC

Garland/US Range Cooking Equipment Ranges

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	Convection Ovens	62
2	Ranges	127

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