ZMan Bait Binderz Doublewide
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 = 'BINDER-2' AND (upper(f.web_text) = 'ZMAN' or upper(f.orig_text) = 'ZMAN' or upper(a.brand) = 'ZMAN') 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|
A perfect grab-and-go storage solution for Z-Man enthusiasts, the Bait BinderZ Doublewide stores up to 20 standard size bags of ElaZtech baits side-by-side. Small, medium, and large inside clear pockets allow for generous storage of jigheads and terminal tackle along with other accessories like leader spools and small tools. The Bait BinderZ Doublewide is built with no zippers that can rust, corrode, or foul and instead used hook-and-loop closures and plastic snaps designed for quick, easy access on the water!
- 18" wide X 10" tall
- Side-by-side binder orientation designed to fit pre-punched holes in standard size ElaZtech® bait bags and holds up to 20 packs of Z-Man softbaits
- Clear plastic pockets sized to hold a variety of jigheads, terminal tackle, leader spools, and tools
- Secures with plastic clips and hook-and-loop closures, so contains no zippers that will rust or foul
- Built-in handle with slip-free plastic grip
*Contents not included
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$5.49 to $8.99
$349.99 to $399.99