Californian Tri-Helix 7'6" Medium Heavy Spinning Rod
|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) ) 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 = 'CTX767MH-SPN' AND (upper(f.web_text) = 'CALIFORNIAN' or upper(f.orig_text) = 'CALIFORNIAN' or upper(a.brand) = 'CALIFORNIAN') 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|
Californian Tri-Helix Composite Rods By Phenix
Phenix has been at the forefront of rod innovation in Southern California over the last few years and is amongst the top selling rod brands in America. These rods will be the perfect opportunity for our customers to own and fish a Phenix Rod without the hefty price tag. All of these rods are being made in the same factory as their in-line rods, using the same highly advanced materials.
The “Tri-Helix” is the method (layering of materials on the mandrels) and materials in which they are constructed and the “Composite” means constructed of Graphite, Glass, and Proprietary materials. These are not 100% graphite or 100% glass rods. These rods were constructed to be extremely durable yet lightweight with a tremendous amount of pulling power. The actions were designed to take advantage of Braided/Spectra lines and minimize the impact felt by the angler while fighting fish using these types of lines.
All the rod components are Phenix proprietary components that are used on some of their own factory rods. There are 10 models: 8 conventional with reel seats 7, 7’ 6”, and 8’, 1 spinning 7’ 6”, and 2- 9’ deck hand style rods (no reel seat). All of these models are based off of Phenix’s best-selling rods in their current lines. All rods feature small diamond heat shrink handles.
The warranty on these rods is the same as our current Californian-E series rods. It is a lifetime warranty with a 50% of retail replacement charge.
Medium Heavy Action
Line Rating: 15-40
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$179.99 to $199.99
$119.97 to $199.99
$169.99 to $189.99
$29.97 to $84.99
$49.99 to $59.99
$109.99 to $119.99
$274.99 to $374.99
$109.99 to $129.99