California's #1 Hunting, Shooting & Fishing Headquarters Since 1971 0 View Cart CART My Account

 Rat- L- Trap 1/2oz Hover to Zoom

bill lewis

Rat-L-Trap 1/2oz

 Item# RT25B

rating 1.0rating 2.0rating  3.0rating 4.0rating 5.0 0 Reviews

$8.39

Out Of Stock

query
RESULTSET
query
  ATTR1ID ATTR2ID CAPACITY NON_INVT OF8 OVERALLQOH PICTURE_ID REALNAME SCALEID SKU_ID SKU_OF7 STYLE STYLE_ID USEPACKAGE WEBSTYLE WEBSTYLE_SORT
1 [empty string] [empty string] Chrome Blue Back N STK 0 11499 Rat-L-Trap 1/2oz [empty string] 1601 [empty string] RT25B 1601 [empty string] RT25B 0
2 [empty string] [empty string] Lectric Silver N STK 0 11500 Rat-L-Trap 1/2oz [empty string] 1602 [empty string] RTL1 1602 [empty string] RT25B 0
CACHED false
EXECUTIONTIME 32
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 = 'RT25B' AND (upper(f.web_text) = 'BILL LEWIS' or upper(f.orig_text) = 'BILL LEWIS' or upper(a.brand) = 'BILL LEWIS') 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
SQLPARAMETERS
array
1 OBS
2 RS
3 SM
4 DNR
5 DNRFD
6 CSN
7 SPDNR
2

Lipless crankbaits are well known and justly famous for their ability to cover a lot of water quickly and to produce fish. Rattletrap is one the best known lipless crankbaits. Loud, flashy attention getters, Rattletraps can be fished in a variety of situations from shallow to deep and everything in between.

Normally fished in a cast-and-crank shallow water situation, they are also effective when allowed to sink to the bottom and burned over deep structure back to the boat. With this method, just position the boat on the uphill side of a point or underwater hump and throw out as far as you can. Let the bait sink to the bottom and start the retrieve up the slope, banging into rocks and other obstructions along the way. The Rattletrap is best known for ripping through shallow grass beds and surprising bad tempered bass waiting in ambush. These baits will get pounded by hungry fish however you choose to fish them.

 Warning - Cancer and reproductive harm WARNING 
Cancer and Reproductive Harm

 www.P65Warnings.ca.gov

No reviews have been written for this product.
Be the first one!  – Write a Review


2 Styles Available

Rat-L-Trap 1/2oz Chrome Blue Back Chrome Blue Back $8.39
Rat-L-Trap 1/2oz Lectric Silver Lectric Silver $8.39

arrow to add to cart button Add to Wish List

We Also Recommend Next Prev

x

We use cookies to improve your browsing experience. By continuing to browse our website you agree to our use of cookies. To learn more about how we use cookies, please review our privacy policy  click here.