California's #1 Hunting, Shooting & Fishing Headquarters Since 1971 0 View Cart CART My Account

 Californian Inshore Special Casting Hover to Zoom

californian

Californian Inshore Special Casting

 Item# CTX76MH

rating 1.0rating 2.0rating  3.0rating 4.0rating 5.0 0 Reviews

$169.99 to $189.99

Out Of Stock

query
RESULTSET
query
  ATTR1ID ATTR2ID CAPACITY NON_INVT OF8 OVERALLQOH PICTURE_ID REALNAME SCALEID SKU_ID SKU_OF7 STYLE STYLE_ID USEPACKAGE WEBSTYLE WEBSTYLE_SORT
1 [empty string] [empty string] CTX76MH N STK 0 14123 Californian Inshore Special Casting [empty string] 469344 YES CTX76MH 469356 [empty string] ctx76mh 1
2 [empty string] [empty string] CTX76H N STK 0 14124 Californian Inshore Special Casting [empty string] 469346 YES CTX76H 469358 [empty string] ctx76mh 2
3 [empty string] [empty string] CTX80MH N STK 0 14126 Californian Inshore Special Casting [empty string] 469348 YES CTX80MH 469360 [empty string] ctx76mh 4
4 [empty string] [empty string] CTX80H N STK 0 14127 Californian Inshore Special Casting [empty string] 469349 YES CTX80H 469361 [empty string] ctx76mh 5
5 [empty string] [empty string] CTX90MH N STK 0 14128 Californian Inshore Special Casting [empty string] 469351 YES CTX90MH 469363 [empty string] ctx76mh 6
6 [empty string] [empty string] CTX90H N STK 0 14129 Californian Inshore Special Casting [empty string] 469352 YES CTX90H 469364 [empty string] ctx76mh 7
CACHED false
EXECUTIONTIME 47
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 = '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
SQLPARAMETERS
array
1 OBS
2 RS
3 SM
4 DNR
5 DNRFD
6 CSN
7 SPDNR
2

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.

Model Length Power Lbs Test Handle
 CTX76MH  7'6"  Medium Heavy  12-30LB  Split
 CTX76H  7'6"  Heavy  15-40LB  Solid
 CTX80ML  8'  Medium Light  10-25LB  Split
 CTX80MH  8'  Medium Heavy  12-30LB  Split
 CTX80H  8'  Heavy  15-40LB  Solid
 CTX90MH  9'  Medium Heavy  12-30LB  Solid
 CTX90H  9'  Heavy  15-40LB  Solid

 

 Warning - Cancer and reproductive harm WARNING 
Cancer and Reproductive Harm

 www.P65Warnings.ca.gov

No reviews have been written for this product.
Be the first one!  – Write a Review


6 Styles Available

Californian Inshore Special Casting CTX76MH CTX76MH $169.99
Californian Inshore Special Casting CTX76H CTX76H $169.99
Californian Inshore Special Casting CTX80MH CTX80MH $179.99
Californian Inshore Special Casting CTX80H CTX80H $179.99
Californian Inshore Special Casting CTX90MH CTX90MH $189.99
Californian Inshore Special Casting CTX90H CTX90H $189.99

arrow to add to cart button Add to Wish List

We Also Recommend Next Prev

x

We use cookies to improve your browsing experience. By continuing to browse our website you agree to our use of cookies. To learn more about how we use cookies, please review our privacy policy  click here.