Shimano Stradic FL
$199.99 to $219.99
|SQL||SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,90,4) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = 'ST1000HGFL' AND (upper(f.web_text) = 'SHIMANO' or upper(f.orig_text) = 'SHIMANO' or upper(a.brand) = 'SHIMANO') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id|
Never satisfied with “good enough”, Shimano always finds another way to improve your fishing experience. Introducing the new Shimano Stradic, the product of CONTINUOUS EVOLUTION. Now with Shimano’s MicroModule Gear II you’ll experience a rotational smoothness and power transfer, never before achieved in a reel at this price point. Couple MicroModule Gear II with Silent Drive, which fine tunes internal components to the highest tolerances possible, and you’ll agree the new Stradic approaches flagship level performance. Plus, Shimano’s X-Protect water-repellent coating and specially designed, water channeling, labyrinth construction ensure a lifetime of top level performance by stopping water penetration in key areas without adding a heavy rotational feel. The C3000, 4000 and C5000 models come equipped with Shimano’s Cross Carbon Drag system, designed to endure and conquer the most blistering runs and the most powerful fish.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$299.99 to $319.99
$129.99 to $149.99
$249.99 to $339.99
$389.99 $179.97 to $349.99