Shimano Curado Casting Rod
$169.99 to $189.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 = 'CDC72HA' 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|
Shimano redesigned the Curado series of casting rods with power and versatility for the tournament angler. Now featuring Shimano's Hi-Power X technology that utilizes diagonally-wrapped carbon tape forming "X" shapes on the rod blank's outermost layer, the Curado series provides anglers with rods showcasing increased strength and improved casting performance. The Curado series of rods now feature Shimano CI4+ reel seats for increased sensitivity and reduced weight. The combination of Fuji tangle-free K guides with FazLite inserts is the ideal guide train for reducing line tangles and providing anglers the option to fish with monofilament, fluorocarbon or PowerPro braided fishing line. Shimano built the Curado series of casting rods for tournament anglers with powers and actions to fulfill the spectrum of techniques one may face when a check is on the line.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$179.99 to $199.99
$134.99 $119.99 to $129.99
$109.99 to $119.99