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

 Shimano Teramar B Wc Inshore Casting Rod Hover to Zoom

shimano

Shimano Teramar B WC Inshore Casting Rod

 Item# TMC70HB

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

$109.97 to $209.99

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] TMC70MHB N DNR 1 11655 Shimano Teramar B WC Inshore Casting Rod [empty string] 415997 [empty string] TMC70MHB 416002 [empty string] TMC70HB 0
2 [empty string] [empty string] TMC76XHB N DNR 1 11656 Shimano Teramar B WC Inshore Casting Rod [empty string] 415998 [empty string] TMC76XHB 416003 [empty string] TMC70HB 0
3 [empty string] [empty string] TMC80HB N STK 0 11657 Shimano Teramar B WC Inshore Casting Rod [empty string] 415999 YES TMC80HB 416004 [empty string] TMC70HB 0
4 [empty string] [empty string] TMC80MB N STK 0 11658 Shimano Teramar B WC Inshore Casting Rod [empty string] 416000 YES TMC80MB 416005 [empty string] TMC70HB 0
5 [empty string] [empty string] TMC80MHB N STK 0 11659 Shimano Teramar B WC Inshore Casting Rod [empty string] 416001 YES TMC80MHB 416006 [empty string] TMC70HB 0
6 [empty string] [empty string] TMC86MHB N STK 0 11661 Shimano Teramar B WC Inshore Casting Rod [empty string] 416003 YES TMC86MHB 416008 [empty string] TMC70HB 0
7 [empty string] [empty string] TMCJ90HB N STK 0 11662 Shimano Teramar B WC Inshore Casting Rod [empty string] 416004 YES TMCJ90HB 416009 [empty string] TMC70HB 0
8 [empty string] [empty string] TMCX80MHB N STK 0 11666 Shimano Teramar B WC Inshore Casting Rod [empty string] 416008 YES TMCX80MHB 416013 [empty string] TMC70HB 0
CACHED false
EXECUTIONTIME 78
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 = 'TMC70HB' AND (upper(f.web_text) = 'SHIMANO' or upper(f.orig_text) = 'SHIMANO' or upper(a.brand) = 'SHIMANO') 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

Model Technique Length Power Action Mono Rating Power Pro Rating Grip Material
TMC70MHB 40lb Flyline 7' MH Moderate Fast 20-50 30-65 Black Diamond Shrink Tube
TMC70HB 50lb Flyline 7' H Moderate Fast 30-60 40-80 Black Diamond Shrink Tube
TMC76XHB 60lb Flyline 7'6" XH Moderate Fast 40-80 50-100 Black Diamond Shrink Tube
TMCX76XHB Dropper Loop 7'6" XH Extra Fast 40-80 50-100 Black Diamond Shrink Tube
TMC80MB 30lb Flyline 8' M Moderate Fast 15-40 20-50 Black Diamond Shrink Tube
TMC80MHB 40lb Flyline 8' MH Moderate Fast 20-50 30-65 Black Diamond Shrink Tube
TMC86HB 50lb Bobber/Leadhead 8'6" H Fast 30-60 40-80 Black Diamond Shrink Tube
TMCX76HB Swimbait 7'6" H Extra Fast 15-30 30-65 Cork Shaped
TMCX80MB Swimbait 8' M Extra Fast 10-20 20-40 Cork Shaped
TMCX80MHB Swimbait 8' MH Extra Fast 12-25 20-50 Cork Shaped
TMCX80HB Swimbait 8' H Extra Fast 15-30 30-65 Cork Shaped
TMCJ90HB Surface Iron 9' H Fast 25-40 30-65 Black Diamond Shrink Tube

 

 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

Shimano Teramar B WC Inshore Casting Rod TMC70MHB TMC70MHB $199.99
Shimano Teramar B WC Inshore Casting Rod TMC76XHB TMC76XHB $209.99
Shimano Teramar B WC Inshore Casting Rod TMC80HB TMC80HB $199.99
Shimano Teramar B WC Inshore Casting Rod TMC80MB TMC80MB $199.99
Shimano Teramar B WC Inshore Casting Rod TMC80MHB TMC80MHB $199.99
Shimano Teramar B WC Inshore Casting Rod TMC86MHB TMC86MHB $199.99
Shimano Teramar B WC Inshore Casting Rod TMCJ90HB TMCJ90HB $199.99
Shimano Teramar B WC Inshore Casting Rod TMCX80MHB TMCX80MHB $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.