Californian CBX Casting Bass Rod
$109.99 to $129.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 = 'cbx-c71ml' 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|
CBX Series Bass Rods
Utilizing IM-8 36TX Helix Carbon Construction, our revolutionary bass rods deliver unmatched sensitivity and unparalleled power for incredible performance. The 45 degree Helix carbon construction provide for a lightweight yet durable rod. Our specially designed reel seats (straight grip on spinning rods) provides a feel similar to Tennessee Handles, without the hassle of locking rings or taping. Our 70+ high elastic eva handles provide a solid grip while providing increased sensitivity throughout the grip. Our special K Type guides help reduce troublesome spectra wraps while the SIC inserts provide strength and sensitivity.
With 4 spinning and 8 casting models, they are sure to cover all of your bass fishing needs from drop shotting to Swimbait fishing.
The warranty on these rods is the same as our current Californian 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
$199.99 to $219.99
$109.97 to $299.99
$79.99 to $89.99
$109.99 to $119.99
$289.99 to $324.99
$29.99 to $39.99
$119.99 to $129.99