Daiwa Lexa TW 400
|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 = 'LX-TW400P-P' 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|
The battle tested Lexa line has been upgraded and reintroduced- the all new Lexa TW has arrived.
Complete with the features that have made the Lexa a staple in markets across the country, now paired with our industry leading T-Wing System (TWS) for a lightweight, heavy duty bait casting reel in a class of it's own.
The reels feature a stainless steel Pinion Gear with a high grade brass gear, aluminum frame and side plate, and a swept Power handle with a custom EVA handle knob for maximum power and torque.
The Lexa has become a staple in the industry across many different fisheries, but the addition of our T-Wing System (TWS) will take your saltwater fishing to the next level.
Lasting 12 times longer than standard stainless steel bearings Daiwa’s corrosion resistant ball bearings feature specially treated stainless steel, and a protective shield on the bearing race that seals out sand, fine grit, salt crystals and other abrasives. The result is a longer lasting bearing that’s protected from the corrosive elements that destroy traditional bearings.
Delivered enhanced angler comfort and contact, EVA knobs provide optimum contact in wet conditions.
Daiwa’s revolutionary T-Wing System addresses the issue of traditional line guide/level wind systems constricting line flow by delivering a T-shaped line guide that is larger, wider and less restrictive. TWS allows line to exit freely from the spool with minimal line angle and minimal friction, thereby reducing line noise and backlash, and delivering more accurate and longer casts.
A system that combines ultra smooth low inertia with ultimate fish stopping power. UTD combines advanced carbon washers, alloy and stainless steel drag plates with specially designed grease for ultra-smooth performance.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$219.99 to $349.99
$349.97 to $419.99
$19.99 to $24.99
$89.99 to $99.99