Chef Hats

Find the Largest selection of Chef Hats Available in Different Sizes and Colors

SMALLWARES
> Restaurant Apparel
> Chef Hats and Caps
> Chef Hats

VENDORS
	Alegacy Foodservice Products Grp	(2)
	Chef Revival	(19)
	Chef Works	(29)
	Crown Brands	(1)
	Matfer	(2)
	Mercer Culinary	(5)
	Royal Industries	(8)
	Winco	(10)

PRICES
	$ 3 - $ 11	(25)
	$ 11 - $ 16	(27)
	$ 16 - $ 200	(24)

Search Results: 76 Products

Sort:

SELECT p_model, p_title as p_titlang, p_title, p_descrip as p_descrip, p_sell, p_sellBy, p_listPrc, p_mapPrc, prc_bustSite, prc_bustCart, sp_price, v_id, v_name , (MATCH (p_title) AGAINST ('+Chef +Hat' IN BOOLEAN MODE) ) * p_relevance as relev FROM products JOIN pricing ON p_prc_id = prc_id JOIN vendor ON prc_v_id = v_id JOIN prod_cat ON pc_p_id = p_id JOIN category ON pc_c_id = c_id LEFT JOIN ship_prod ON sp_p_id = p_id LEFT JOIN media ON p_id = m_p_id AND m_type = 'Image' WHERE p_sell <> 0 and p_relevance >= 0 and c_left >= (SELECT c_left FROM category WHERE c_id = 3276) AND c_right <= (SELECT c_right FROM category WHERE c_id = 3276) order by relev desc, p_model LIMIT 72, 24