Okuma Tesoro Star Drag Reel
$299.99 to $319.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 = 'TSR-5S' AND (upper(f.web_text) = 'OKUMA' or upper(f.orig_text) = 'OKUMA' or upper(a.brand) = 'OKUMA') 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|
The Tesoro star drag reels were designed with the latest technology and insight from the leading fishermen in the industry. The Tesoro features 6061-T6 machined aluminum frame, side plates, and spool as well as our MSS: Mechanical Stabilizing System for a zero flex platform keeping all key components aligned, and running smoothly. With its 17-4 grade, self lubricating, stainless steel helical cut gearing, and multi-disc Carbonite drag system bathed in Cal’s drag grease, this reel runs silent and smooth.
The Tesoro star drag reels packs its strength and technology into 5, 10 and 12 size reels. All three sizes contain five total corrosion resistant bearings that are bathed in TSI oil for the ultimate in free spool. The Carbonite drag system puts out a fish stopping 22lbs of drag. Both sizes of the Tesoro feature a high speed 6.2:1 gear ratio.
The key features on the Tesoro star drag reel include the CRC: Corrosion-Resistant Coating process to help defend against any corrosion build up. The Tesoro features an aluminum swept handle that reduces wobble while cranking and an ergo grip soft touch handle knob for all day cranking.
- High Speed 6.2:1 gear ratio
- 6061-T6 machined aluminum frame, sideplate and spool
- 17-4 grade stainless steel helical cut gearing
- Multi-disc Carbonite drag system with Cal’s drag grease
- CRC: Corrosion-Resistant Coating Process
- Swept aluminum star for increased ergonomics
- Anodized aluminum swept handle reduces wobble while cranking
- 4BB+1RB corrosion resistant bearings, spool bearing with TSI oil
- Ergo grip handle knob with anodized aluminum handle arm
- Dual anti-reverse (mechanical and roller bearing)
- XL Gearing: Drop down gear box
- Quick-Set ant-reverse bearing allows for zero back play in handle
- MSS: Mechanical Stabilizing System for increased durability
- Self-lubricating gear system, all models
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$419.99 to $579.99
$189.99 to $259.99
$84.97 to $129.99
$79.99 to $84.99
$499.99 to $699.99
$239.99 to $339.99
$129.99 to $149.99