E-Store

Query: SELECT DISTINCT `EstoreProduct`.`id`, `EstoreProduct`.*, `EstoreProductsCategory`.*, IFNULL(`EstoreProduct`.`active`, "") AS `active`, `EstoreProduct`.`id` FROM `estore_products` AS `EstoreProduct` LEFT JOIN `estore_brands` AS `EstoreBrand` ON (`EstoreProduct`.`brand_id` = `EstoreBrand`.`id`) LEFT JOIN `estore_products_categories` AS `EstoreProductsCategory` ON (`EstoreProductsCategory`.`product_id` = `EstoreProduct`.`id`) WHERE `EstoreProduct`.`id` != 181837 AND `EstoreProduct`.`user_id` = 340 AND `EstoreProductsCategory`.`category_id` = 19945 AND `EstoreProduct`.`title` Warning: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'C53S Signature Natural Bend Hooks ORDER BY `EstoreProduct`.`title` DESC LIMIT ' at line 1 in /home/pagetree/public_html/cake/libs/model/datasources/dbo_source.php on line 492

Query: SELECT DISTINCT `EstoreProduct`.`id`, `EstoreProduct`.*, `EstoreProductsCategory`.*, IFNULL(`EstoreProduct`.`active`, "") AS `active`, `EstoreProduct`.`id` FROM `estore_products` AS `EstoreProduct` LEFT JOIN `estore_brands` AS `EstoreBrand` ON (`EstoreProduct`.`brand_id` = `EstoreBrand`.`id`) LEFT JOIN `estore_products_categories` AS `EstoreProductsCategory` ON (`EstoreProductsCategory`.`product_id` = `EstoreProduct`.`id`) WHERE `EstoreProduct`.`id` != 181837 AND `EstoreProduct`.`user_id` = 340 AND `EstoreProductsCategory`.`category_id` = 19945 AND `EstoreProduct`.`title`>Mustad C53S Signature Natural Bend Hooks ORDER BY `EstoreProduct`.`title` ASC LIMIT 1
Warning: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'C53S Signature Natural Bend Hooks ORDER BY `EstoreProduct`.`title` ASC LIMIT 1' at line 1 in /home/pagetree/public_html/cake/libs/model/datasources/dbo_source.php on line 492

1. Fly Tying
2. Hooks
3. Mustad
4. Mustad C53S Signature Natural Bend Hooks

Mustad C53S Signature Natural Bend Hooks

$2.45

Attribute:

25 pack

Size: Please select Size 10 - $2.45 12 - $2.45 14 - $2.45 16 - $2.45 18 - $2.45 20 - $2.45 22 - $2.45 8 - $2.45

Quantity: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100

Ordering is temporarily down, please try again shortly

Details

3XL, standard wire, straight eyed, needle point, forged, curved nymph and terrestrial hook, with bronze finish. This hook has the correct attitude with a slow deep bend for terrestrials, stone flies and most curved nymphs patterns. Available in sizes 4 thru 22, 25 packs