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

 Phenix Hydra 8x Braid 175 Yards, Moss Green Hover to Zoom

phenix

Phenix Hydra 8X Braid 175 Yards, Moss Green

 Item# HX8175-10G

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

$18.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] 10 lb N STK 0 25642 Phenix Hydra 8X Braid 175 Yards, Moss Green [empty string] 469585 [empty string] HX8175-10G 469597 [empty string] HX8175-10G 1
2 [empty string] [empty string] 15 lb N STK 0 25643 Phenix Hydra 8X Braid 175 Yards, Moss Green [empty string] 469586 [empty string] HX8175-15G 469598 [empty string] HX8175-10G 2
3 [empty string] [empty string] 20 lb N STK 0 25644 Phenix Hydra 8X Braid 175 Yards, Moss Green [empty string] 469587 [empty string] HX8175-20G 469599 [empty string] HX8175-10G 3
4 [empty string] [empty string] 30 lb N STK 0 25645 Phenix Hydra 8X Braid 175 Yards, Moss Green [empty string] 469588 [empty string] HX8175-30G 469600 [empty string] HX8175-10G 4
5 [empty string] [empty string] 40 lb N STK 0 25646 Phenix Hydra 8X Braid 175 Yards, Moss Green [empty string] 469589 [empty string] HX8175-40G 469601 [empty string] HX8175-10G 5
6 [empty string] [empty string] 55 lb N STK 0 25647 Phenix Hydra 8X Braid 175 Yards, Moss Green [empty string] 469590 [empty string] HX8175-55G 469602 [empty string] HX8175-10G 6
7 [empty string] [empty string] 65 lb N STK 0 25648 Phenix Hydra 8X Braid 175 Yards, Moss Green [empty string] 469591 [empty string] HX8175-65G 469603 [empty string] HX8175-10G 7
8 [empty string] [empty string] 80 lb N STK 0 25649 Phenix Hydra 8X Braid 175 Yards, Moss Green [empty string] 469592 [empty string] HX8175-80G 469604 [empty string] HX8175-10G 8
CACHED false
EXECUTIONTIME 31
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,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 = 'HX8175-10G' AND (upper(f.web_text) = 'PHENIX' or upper(f.orig_text) = 'PHENIX' or upper(a.brand) = 'PHENIX') 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
8 DOA
2

Introducing the NEW Phenix Hydra 8X solid braid. Hydra 8X fishing braid brings you the toughest yet thinnest diameter fishing braid the industry has ever seen. Offering zero stretches for increased sensitivity, superior knot strength, water-proofing, and UV resistance. Phenix also use colorfast dye for better color retention compared to other braids. Hydra 8X multi-color braid is designed with 25′ color markings switching between high-visibility orange and yellow.


Features:

 

  • UV Resistant
  • Extremely Strong
  • Superior knot strength
  • Zero stretches for increased sensitivity
  • Toughest yet thinnest diameter fishing braid the industry has ever seen
 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


8 Styles Available

Phenix Hydra 8X Braid 175 Yards, Moss Green 10 lb 10 lb $18.99
Phenix Hydra 8X Braid 175 Yards, Moss Green 15 lb 15 lb $18.99
Phenix Hydra 8X Braid 175 Yards, Moss Green 20 lb 20 lb $18.99
Phenix Hydra 8X Braid 175 Yards, Moss Green 30 lb 30 lb $18.99
Phenix Hydra 8X Braid 175 Yards, Moss Green 40 lb 40 lb $18.99
Phenix Hydra 8X Braid 175 Yards, Moss Green 55 lb 55 lb $18.99
Phenix Hydra 8X Braid 175 Yards, Moss Green 65 lb 65 lb $18.99
Phenix Hydra 8X Braid 175 Yards, Moss Green 80 lb 80 lb $18.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.