Daiwa Regal LT
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,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 = 'RGLT1000D' 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 Regal LT is the latest manifestation in Daiwa’s storied Regal Line. The redesigned reel embraces the LT Concept of light and tough. The True Carbon Frame reduces weight and size yet is as rigid as conventional materials. The reel weight has been reduced from 7.9 ounces to 6.7 oz. in the 1000 series and 10.6 oz. to 7.6 oz. in the 3000 series. The Air Rotor System improves balance and rotation and reduces rotor weight by 15 percent.
Reel performance is silky smooth with 9 ball bearings and 1 roller bearing. Few reels in this price range have 9 ball bearings. The Machined Aluminum handle is swept back and the knob is oversized and ergonomically designed. Available in 1000 to 3000 series sizes the Daiwa Regal LT is a versatile line of workhorse reels, designed to put anglers of all skill levels in the high tech world of spinning reels. If you want to experienced the best of Daiwa engineering at a smart price, look for the new, reengineered Regal LT spinning reel.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$639.99 to $659.99
$549.99 to $699.99
$249.99 to $339.99
$199.99 to $259.99
$99.99 to $109.99