Daiwa Proteus Spinning Rod
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 = 'PTB80HFS' AND (upper(f.web_text) = 'DAIWA' or upper(f.orig_text) = 'DAIWA' or upper(a.brand) = 'DAIWA') 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|
Destined to create sport fishing memories, the redesigned Proteus Boat Rods. Beautiful in appearance and rugged in performance and build, the series was created for the avid inshore and offshore fisherman on both coasts. With a variety of actions to choose from. the line of advanced fishing rods is well-suited for boat fisherman both coastal and offshore. The HVF Carbon Constructed blank is light yet powerfully strong for taming a plethora of saltwater adversaries. The carbon-based rods are lighter and stronger than traditional rod building materials.
The Braiding X Tape reinforces the blank preventing twisting and distortion when loaded up. It also adds a striking appearance to the blank. Fuji FazLite Tangle Free K-Guides are state of the art, light, diminutive, yet strong. Tough, smooth inserts insure long accurate casts.
The Ultra Durable EVA Grip provides a solid, infallible, connection to the rod. With 8 spinning models and 11 casting models, the Proteus line has a rod to suit your technique specific needs. Each rod is rated for monofilament and braided lines. If you are rigging your boat with tackle to subdue saltwater's toughest gamefish, consider the quality, performance and value of Daiwa's Proteus Boat Rods, you won't be disappointed.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$54.99 to $64.99
$79.99 to $94.99
$89.99 to $94.99
$69.99 to $79.99
$119.97 to $199.99
$234.99 to $304.99