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

 Daiwa North Coast Ss Spinning Rod Hover to Zoom

daiwa

Daiwa North Coast SS Spinning Rod

 Item# NC862MFS

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

$89.99 to $94.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] NC862MFS N STK 0 20040 Daiwa North Coast SS Spinning Rod [empty string] 483444 [empty string] NC862MFS 483466 [empty string] NC862MFS 1
2 [empty string] [empty string] NC862MHFS N STK 0 20041 Daiwa North Coast SS Spinning Rod [empty string] 483445 [empty string] NC862MHFS 483467 [empty string] NC862MFS 2
3 [empty string] [empty string] NC902MHFS N STK 0 20042 Daiwa North Coast SS Spinning Rod [empty string] 483446 [empty string] NC902MHFS 483468 [empty string] NC862MFS 3
CACHED false
EXECUTIONTIME 63
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 = 'NC862MFS' AND (upper(f.web_text) = 'DAIWA' or upper(f.orig_text) = 'DAIWA' or upper(a.brand) = 'DAIWA') 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
3

 The North Coast Salmon and Steelhead Side Drifting rods are designed and crafted for the acute demands of those pursuing these marvelous gamefish side drifting in rivers. With spinning rods specifically designed for serious trout, steelhead and salmon anglers.

The blanks are constructed from IM7 graphite a composite with a long illustrious history in high-end rod building. The handles are beautifully crafted from Natural Cork providing good looks and a sure grip. To the quality blank are added light weight yet durable Titanium Oxide Ring Guides, designed to pay out long casts while still sensitive to the bend of the rod. The rod tips are dipped in Fluorescent Orange Paint a great visual for strike detection.

 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


3 Styles Available

  Item Price Length Feet Line Weight (Lb.) LureWeight (Ounces) Pieces Stock Qty
NC862MFS $89.99 8 ft 6 in 6-12 lb 3/16-1/2 oz 2 0
NC862MHFS $89.99 8 ft 6 in 8-17 lb 3/8-1 oz 2 0
NC902MHFS $94.99 9 ft 8-17 lb 3/8-1 oz 2 0

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.