Okuma PCH Custom Casting Series Rod
$119.97 to $289.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 = 'PCH-C-701M' AND (upper(f.web_text) = 'OKUMA' or upper(f.orig_text) = 'OKUMA' or upper(a.brand) = 'OKUMA') 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|
The PCH Custom Series Rods were designed with the latest technology and insight from leading fishermen around the country. The backbone to the PCH Custom Rods is the patented blank construction process dubbed Unidirectional Fiber Reinforcement. Owned by an Okuma engineer, the patented process blends unidirectional fiber over 24-ton carbon in the extended tip section of the rod to increase lifting strength and power by as much as 400%. This technology provides for the ultimate in strength without sacrificing sensitivity so that you can feel even the lightest of bites.
The component system on the PCH Custom Rods are all top notch featuring Fuji K-guides with Alconite inserts on the Medium, Medium Heavy, and Heavy models, as well as ALPS HXH guides with Zirconium inserts on the Extra Heavy models. All models also feature ALPS CAH reel seats. The 7-foot and 7-foot 6-inch models feature tapered TPE fore and rear grips and the 8-foot models feature tapered shrink tube for durability and comfort. All PCH Custom Rods also have an ALPS non-skid rubber butt cap to reduce deck slide.
- Extremely light weight and responsive 24-ton carbon rod blanks
- UFR-II: Ultimate Flex Reinforcement rod tip technology
- 3K-woven carbon outer blank wrap improves hoop strength
- M, MH and H models feature Fuji K-guides with Alconite inserts
- XH models feature ALPS HXN guides with Zirconium inserts
- All models feature machined aluminum ALPS CAH reel seats
- 7' and 7'6"rods feature tapered TPE fore and rear grips
- 8'rods featured tapered shrink tube for durability and comfort
- All PCH models feature ALPS non-skid rubber butt caps
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$69.99 to $74.99
$54.99 to $64.99
$159.99 to $179.99
$289.99 to $324.99
$29.97 to $84.99