Daiwa Crossfire LT
$29.99 to $39.99
Out Of Stock
|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 = 'cflt1000' 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|
Engineering of the new Crossfire was guided by the LT Concept of lighter, tougher reel designs utilizing state of the art composites. The new LT cuts as much as 20 percent of the reel weight from the old Crossfire design. A fact not lost on an angler who has put in a long day of fishing. The solid ABS Aluminum Spool resists flexing and distorting and is deep enough to hold plenty of line yardage. The heart of the reel is the cold forged and precision milled Digigears. The state of the art manufacturing process optimizies the meshing between the main and pinion gears. Daiwa’s innovative proprietary grease makes the Advanced Tournament Drag System (ATD) one of the smoothest on the market. The fit and finish is complete with a smart Machined Aluminum Handle that optimizes grip and provides positive torque to the main gear. With reel sizes ranging from 1000 to 5000 the new CROSSFIRE LT line is comfortable in freshwater or light saltwater.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$209.99 to $249.99
$189.97 to $259.99
$299.99 to $319.99
$99.99 to $109.99