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

 Fishing Legend Large Orange Hook Remover Hover to Zoom

fishing legend

Fishing Legend Large Orange Hook Remover

 Item# HRL-2

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

$6.99

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
CACHED false
EXECUTIONTIME 47
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 = 'HRL-2' AND (upper(f.web_text) = 'FISHING LEGEND' or upper(f.orig_text) = 'FISHING LEGEND' or upper(a.brand) = 'FISHING LEGEND') 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
1


OUT WITH THE OLD

The red hook remover

1) Made outside of the USA

2) A three piece unit (often coming apart and leaving the ball in the fish)

3) Have to push and pull & twist to try to get the hook out (always killing the fish and leaving the fish and you bloody!!!)

4) Kids have unpleasant first time memories of fishing (Don’t want to go fishing ever again!!!)

5) Most fisherman end up cutting their line leaving hook in the fish! 

6) Most importantly they “JUST DON’T WORK”

 

IN WITH THE NEW

Introducing

The One and Only Hook Remover

 

Strong selling points

1) Made in the USA

2) A two piece unit (made of the highest grade plastic to last a life time)

3) Multi function custom metal clip

a) Clip the One and Only Hook Remover to your pocket

b) Turn clip to secure the One and Only Hook Remover to your line while putting your fish on the stringer. (Great feature for boats and float tubes to keep from losing in the water!!!)

c) Remove clip and clean slot of the One and Only Hook Remover (Great feature when using dough baits!)

4) Simply insert tight line in the One and Only Hook Remover slide down to hook! (the hook is out!)

5) Fast

6) Safe

7) Easy

8) Designed for quick catch and release (Keeps fish alive!!!)

9) Catch more fish!

10)  So simple even a kid can use them! (Great family memories!!!)

11) Use it on the shore, on your boat or your float tube.

12)  The One and Only Hook Remover

 “IT REALLY WORKS!”

 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


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.