Hoggs of Fife
Hoggs of Fife is the long established supplier of high performance footwear and clothing for the country professional. FIfe Country is the trading division of Hoggs of Fife which has always striven to provide value for money products, fit for purpose in the country environment. The range is comprehensive, from caps to cords, socks to shirts and waterproofs to waders. Here we present a wide selection of the most popular Hoggs of Fife products. For safety footwear and protective clothing, please refer to the separate Hoggs Professional section.
SELECT product_id, code, stylename, category1_id, image_main, is_newproduct, price_pound, saleprice_pound, new_color, is_on_offer, prod_url, other_colours_html, is_new_improved FROM tbl_product WHERE isavailable='y' AND brand_id=31 ORDER BY stylename