Californian Inshore Special Casting
$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 = 'ctx76mh' 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 Inshore Special 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-Fiber X-Fusion design makes for an extremely light yet durable rod blank with an amazing amount of power. These rods were built to our unique specifications to maximize performance and strength to cover a myriad of lures types and techniques.
All the rod components are Phenix proprietary components that are used on some of their own factory rods. The special K guides on our rods help reduce troublesome spectra wraps when fishing in windy conditions.
There are 9 models: 7 Trigger casting models with reel seats 7’6” to 9ft and 2 spinning Models 7’6” and 8ft. All of these models are based off of Phenix’s best-selling rods in their current lines. All rods feature High Density Eva Foam grips.
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.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$119.97 to $199.99
$169.99 to $189.99
$234.99 to $304.99
$199.99 to $219.99
$79.99 to $94.99
$139.99 to $149.99
$109.97 to $299.99