Seeker Rods MGC Series Casting
$194.99 to $229.99
Out Of Stock
|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 = 'STL7020C' AND (upper(f.web_text) = 'SEEKER RODS' or upper(f.orig_text) = 'SEEKER RODS' or upper(a.brand) = 'SEEKER RODS') 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|
MGC Series: On A Mission
The MGC Series is a series of rods introduced to the world last year under a different name (Stealth). The MGC represents the latest in combining composites and resins. These blanks are light in weight, thin wall and fast in taper. These finished rods replaced the American Serires. The MGC is the Seeker entry level rod at a great price. Truth be told, the MGC blanks are nearly equivalent to our flagship series the Super Seeker in construction and materials. However, by utilitizing different tooling, Randy Penny was able to develop a lighter weight blank that will also allow for great actions and the recoil power that Seeker fans have come to expect.
The MGC series is the most unique series in the entire Seeker product line as it crosses over from performance to value. Each rod is equipped with light weight EVA foam grips, graphite reel seats, and ful 316 Stainless Steel guide frames and duraline ceramic rings. At a great value, these rods pack a punch.
If you are gearing up for any trip from twilight to 5 days, all you need is the MGC series in your hands to tackle anything swimming up and down the coast.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$49.99 to $54.99
$159.99 to $169.99
$159.99 to $179.99