The name Fife has been around for over 125 years, originally set up in 1888 as a working boot brand, for shepherds and farmers. Today we use the Fife Country name where we have sourced a product to meet a specific need which our customers have. We use outstanding fabrics, often sourced locally in Scotland, such as lambswool or Harris Tweed, and create timeless, hardwearing, practical garments at reasonable prices. Fife Country offers a diverse range of town and country clothing and footwear, for men and women, ideal for outdoor activities, work or leisure.
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=24 ORDER BY stylename