High Quality Hand-Crafted Lures that are Made in Minnesota in a variety of colors.
Discover the incredible selection of ice fishing gear at Maynards Tackle that will have you catching the limit on your next fishing trip.
products_description(string) => A unique kahle style hook that sets quick and holds'em. It's deadly on crappie and walleye and is easily seen on electronics. It's avaiable in 5 brilliant colors that attract fish day or night–even in stained or muddy water. Tip with minnow or grub.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
1(array)
products_image(string) => bc.jpg
products_name(string) => Barracuda
products_quantity(string) => 9580
products_id(string) => 10
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => <img src="includes/templates/westminster_new/images/nitelitelogo.gif" class="descriptionLogo" /></a>
An extra strong hook for those big fish. This lure is highly colorful with hand painted eyes on both sides. It is also available in our popular <span style="color: rgb(255, 0, 0); font-weight: bold;">Nite-Lite Glow</span> colors.
<b>
<p>Barracuda Size #2-3/16 oz.
<p>Barracuda Size #4-1/8 oz.
<p>Barracuda Size #6-1/24 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
2(array)
products_image(string) => BE_Yellow.jpg
products_name(string) => BIG EYE EASY-TIE GLOW JIGS
products_quantity(string) => 9866
products_id(string) => 68
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => Big Eye, Easy-Tie UV Glow Jig; there’s no place for ‘em to hide–not even in dark, murky waters. These outweigh anything on the market today: Easy tie means stronger, more resilient knots for better action and fewer snags. Plus, no holes to clean out and now, our UV Glow. Tip with your favorite artificial bait, minnow, leech or crawler.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
3(array)
products_image(string) => dgj.jpg
products_name(string) => Dakota Gold Jigs
products_quantity(string) => 9889
products_id(string) => 73
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => With it’s black pupil surrounded by our distintive Neon Lites, glow red eye set on a shimmering, 24 gold plated jig, this proven combination promises to deliver. All you need do is tip with your favorite live or artificial bait and prepare to catch your limit. Available in sizes #4, #6, #8 and #10.
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
4(array)
products_image(string) => df.jpg
products_name(string) => Dart Finky
products_quantity(string) => 9763
products_id(string) => 11
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The top side of the Dart Finky is two-toned with hand-painted eyes. It has a glow in the dark bottom and sits in the water horizontally.
<b>
<p>Dart Finky Size #8-1/24 oz.
<p>Dart Finky Size #10-1/50 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
5(array)
products_image(string) => ds.jpg
products_name(string) => Devils Stand-up
products_quantity(string) => 9892
products_id(string) => 12
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => These lures will always stand-up on the bottom of the lake for those fish that are waiting.<b>
<p>Devils Stand-up Size #6-1/24 oz.
<p>Devils Stand-up Size #8-1/24 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
6(array)
products_image(string) => dn.jpg
products_name(string) => Dragon Nymph
products_quantity(string) => 9615
products_id(string) => 13
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => <img src="includes/templates/westminster_new/images/nitelitelogo.gif" class="descriptionLogo"/></a>
The Dragon Nymph has a unique body with a two-tone paint on top. It has a glow in the dark bottom with gold metal flake for that extra flash. It is also available in our popular Nite-Lite Glow colors.
<b>
<p>Dragon Nymph Size #2-1/8 oz.
<p>Dragon Nymph Size #4-1/10 oz.
</b>
</p>
</a>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
7(array)
products_image(string) => ffglow_blue.jpg
products_name(string) => Fire Fry Glow Jigs
products_quantity(string) => 9927
products_id(string) => 69
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Fire Fry jig has a center-balance body for a horizontal presentation. This jig imitates tiny bait fish and dynamite for panfish, crappie and walleye. it's also easily seen on electronics. It's available in 5 brilliant NEON LITES colors and sizes #6, #8 and #10. Attract fish day or night–even in stained or muddy water.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
8(array)
products_image(string) => fe.jpg
products_name(string) => Fish-N-Eye
products_quantity(string) => 9442
products_id(string) => 14
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.5000
products_tax_class_id(string) => 1
products_description(string) => <img src="includes/templates/westminster_new/images/nitelitelogo.gif" class="descriptionLogo" /></a>The Fish-N-Eye has a glow in the dark back with two-tone painted front with gold metal flakes. It has an attention getting 3-D eye and also features a gold hook. It also is available in our 7 Nite-Lite Glow colors.
<b>
<p>Fish-N-Eye Size #4-1/4 oz.
<p>Fish-N-Eye Size #6-1/6 oz.
<p>Fish-N-Eye Size #8-1/12 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.5000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
listing_sql(string) => SELECT p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description,
IF(s.status = 1, s.specials_new_products_price, NULL) AS specials_new_products_price,
IF(s.status = 1, s.specials_new_products_price, p.products_price) AS final_price,
p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status
FROM products p
LEFT JOIN specials s ON s.products_id = p.products_id
LEFT JOIN products_description pd ON pd.products_id = p.products_id
AND pd.language_id = 1
LEFT JOIN products_to_categories p2c ON p2c.products_id = p.products_id
LEFT JOIN manufacturers m ON m.manufacturers_id = p.manufacturers_id
WHERE p.products_status = 1
AND p2c.categories_id = 7
ORDER BY p.products_sort_order, pd.products_name
metatags_keywords(string) => "fishing, tackle, ice, jigs, tungsten, panfish, bass, walleye, trout, northern pike, and muskie,Northwest Metro Tackle, original"
metatags_description(string) => Tungsten jigs, lead jigs, ice fishing jigs, summer fishing jigs,Going Crappie fishing,Quality fishing tackle, made in the usa.
order_by(string) => order by c.sort_order, cd.categories_name
categories_tab_query(string) => select c.sort_order, c.categories_id, cd.categories_name from categories c, categories_description cd
where c.categories_id=cd.categories_id and c.parent_id= '0' and cd.language_id='1' and c.categories_status='1' order by c.sort_order, cd.categories_name
categories_tab(object: queryFactoryResult)
0(array)
sort_order(string) => 0
categories_id(string) => 1
categories_name(string) => Tungsten Fishing Jigs
1(array)
sort_order(string) => 2
categories_id(string) => 7
categories_name(string) => Jigs
2(array)
sort_order(string) => 4
categories_id(string) => 15
categories_name(string) => Wonder Bread Series
3(array)
sort_order(string) => 10
categories_id(string) => 11
categories_name(string) => Jigging Spoons
4(array)
sort_order(string) => 12
categories_id(string) => 13
categories_name(string) => Kits
5(array)
sort_order(string) => 15
categories_id(string) => 8
categories_name(string) => Apparel & Accessories
6(array)
sort_order(string) => 20
categories_id(string) => 12
categories_name(string) => Gift Certificate
new_style(string) => category-top
categories_tab_current(string) => Gift Certificate
manufacturer_sidebox_query(string) => select distinct m.manufacturers_id, m.manufacturers_name
from manufacturers m
left join products p on m.manufacturers_id = p.manufacturers_id
where m.manufacturers_id = p.manufacturers_id and p.products_status= 1
order by manufacturers_name
manufacturer_sidebox(object: queryFactoryResult)
0(array)
manufacturers_id(string) => 1
manufacturers_name(string) => Maynards Tackle
1(array)
manufacturers_id(string) => 2
manufacturers_name(string) => Northwest Metro Tackle
current_categories_description(string) => High Quality Hand-Crafted Lures that are Made in Minnesota in a variety of colors.
<br />
Discover the incredible selection of ice fishing gear at Maynards Tackle that will have you catching the limit on your next fishing trip.
categories_description(string) => High Quality Hand-Crafted Lures that are Made in Minnesota in a variety of colors.
<br />
Discover the incredible selection of ice fishing gear at Maynards Tackle that will have you catching the limit on your next fishing trip.
categories_name(string) => Jigs
categories_image(string) => cat4.png
check_for_alpha(object: queryFactoryResult)
0(array)
products_image(string) => AA-blue.jpg
products_name(string) => Aqua Ant
products_quantity(string) => 9921
products_id(string) => 67
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => A unique kahle style hook that sets quick and holds'em. It's deadly on crappie and walleye and is easily seen on electronics. It's avaiable in 5 brilliant colors that attract fish day or night–even in stained or muddy water. Tip with minnow or grub.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
1(array)
products_image(string) => bc.jpg
products_name(string) => Barracuda
products_quantity(string) => 9580
products_id(string) => 10
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => <img src="includes/templates/westminster_new/images/nitelitelogo.gif" class="descriptionLogo" /></a>
An extra strong hook for those big fish. This lure is highly colorful with hand painted eyes on both sides. It is also available in our popular <span style="color: rgb(255, 0, 0); font-weight: bold;">Nite-Lite Glow</span> colors.
<b>
<p>Barracuda Size #2-3/16 oz.
<p>Barracuda Size #4-1/8 oz.
<p>Barracuda Size #6-1/24 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
2(array)
products_image(string) => BE_Yellow.jpg
products_name(string) => BIG EYE EASY-TIE GLOW JIGS
products_quantity(string) => 9866
products_id(string) => 68
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => Big Eye, Easy-Tie UV Glow Jig; there’s no place for ‘em to hide–not even in dark, murky waters. These outweigh anything on the market today: Easy tie means stronger, more resilient knots for better action and fewer snags. Plus, no holes to clean out and now, our UV Glow. Tip with your favorite artificial bait, minnow, leech or crawler.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
3(array)
products_image(string) => dgj.jpg
products_name(string) => Dakota Gold Jigs
products_quantity(string) => 9889
products_id(string) => 73
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => With it’s black pupil surrounded by our distintive Neon Lites, glow red eye set on a shimmering, 24 gold plated jig, this proven combination promises to deliver. All you need do is tip with your favorite live or artificial bait and prepare to catch your limit. Available in sizes #4, #6, #8 and #10.
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
4(array)
products_image(string) => df.jpg
products_name(string) => Dart Finky
products_quantity(string) => 9763
products_id(string) => 11
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The top side of the Dart Finky is two-toned with hand-painted eyes. It has a glow in the dark bottom and sits in the water horizontally.
<b>
<p>Dart Finky Size #8-1/24 oz.
<p>Dart Finky Size #10-1/50 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
5(array)
products_image(string) => ds.jpg
products_name(string) => Devils Stand-up
products_quantity(string) => 9892
products_id(string) => 12
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => These lures will always stand-up on the bottom of the lake for those fish that are waiting.<b>
<p>Devils Stand-up Size #6-1/24 oz.
<p>Devils Stand-up Size #8-1/24 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
6(array)
products_image(string) => dn.jpg
products_name(string) => Dragon Nymph
products_quantity(string) => 9615
products_id(string) => 13
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => <img src="includes/templates/westminster_new/images/nitelitelogo.gif" class="descriptionLogo"/></a>
The Dragon Nymph has a unique body with a two-tone paint on top. It has a glow in the dark bottom with gold metal flake for that extra flash. It is also available in our popular Nite-Lite Glow colors.
<b>
<p>Dragon Nymph Size #2-1/8 oz.
<p>Dragon Nymph Size #4-1/10 oz.
</b>
</p>
</a>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
7(array)
products_image(string) => ffglow_blue.jpg
products_name(string) => Fire Fry Glow Jigs
products_quantity(string) => 9927
products_id(string) => 69
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Fire Fry jig has a center-balance body for a horizontal presentation. This jig imitates tiny bait fish and dynamite for panfish, crappie and walleye. it's also easily seen on electronics. It's available in 5 brilliant NEON LITES colors and sizes #6, #8 and #10. Attract fish day or night–even in stained or muddy water.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
8(array)
products_image(string) => fe.jpg
products_name(string) => Fish-N-Eye
products_quantity(string) => 9442
products_id(string) => 14
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.5000
products_tax_class_id(string) => 1
products_description(string) => <img src="includes/templates/westminster_new/images/nitelitelogo.gif" class="descriptionLogo" /></a>The Fish-N-Eye has a glow in the dark back with two-tone painted front with gold metal flakes. It has an attention getting 3-D eye and also features a gold hook. It also is available in our 7 Nite-Lite Glow colors.
<b>
<p>Fish-N-Eye Size #4-1/4 oz.
<p>Fish-N-Eye Size #6-1/6 oz.
<p>Fish-N-Eye Size #8-1/12 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.5000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
9(array)
products_image(string) => ff.jpg
products_name(string) => Flat Fish
products_quantity(string) => 9732
products_id(string) => 15
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Flat Fish features glitter over a two-tone color with painted double eyes.
<b>
<p>Flat Fish Size #4-1/16 oz.
<p>Flat Fish Size #6-1/20 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
10(array)
products_image(string) => FT glow blue.jpg
products_name(string) => Flickertail Glow Jigs
products_quantity(string) => 9903
products_id(string) => 70
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => The Flickertail Jig is designed with a center-balance jig head for a horizontal presentation. It's painted with brilliant 5 brilliant NEON LITES super glow colors then tied with 'crystal-flash' tinsel that imitates tiny scales from baitfish–and drives fish wild! Available in sizes 1/16oz. #4, 1/32oz. #6 and 1/64oz. #8. For best results use camera flash or LED to excite jig, tip with minnow, waxworm or leech then cast in and around weeds of timber.
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
11(array)
products_image(string) => fb.jpg
products_name(string) => Flutter Bug
products_quantity(string) => 8729
products_id(string) => 16
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => This great little lure has 24 ct. gold blades attached to trigger strikes from those reluctant fish. It also has a glows in the dark bottom on all colors.
<b>
<p>Flutter Bug Size #6-1/20 oz.
<p>Flutter Bug Size #8-1/24 oz.
<p>Flutter Bug Size #10-1/28 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
12(array)
products_image(string) => RS-chrt-grn.jpg
products_name(string) => Glass Rat'lr Jigs
products_quantity(string) => 884
products_id(string) => 79
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.2000
products_tax_class_id(string) => 1
products_description(string) => The Glass Rat'lr Jig has a extra short shank, wide gap hook that provides a compact natural presentation for a "Deadly" hook set. It also has a venom glass rattle molded into the head which produces a loud enticing rattle "That triggers fish to strike." The Glass Rat'lr Jig is extremely effective in stained and muddy water. For best results, tip with minnow, leech or crawler.
specials_new_products_price(NULL) =>
final_price(string) => 1.2000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
13(array)
products_image(string) => gt.jpg
products_name(string) => Glo-Tear
products_quantity(string) => 9649
products_id(string) => 17
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Glo-Tear has an accent stripe across the color on the front and it has a glow in the dark back.
<b>
<p>Glo-Tear Size #6-1/50 oz.
<p>Glo-Tear Size #8-1/50 oz.
<p>Glo-Tear Size #10-1/64 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
14(array)
products_image(string) => wb.jpg
products_name(string) => Glow Bee
products_quantity(string) => 9593
products_id(string) => 18
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => This double body lure has a glow in the dark bottom with a splash of Fl.Red. The top is colored with gold glitter and accented with dots.
<b>
<p>Glow Bee Size #6-1/10 oz.
<p>Glow Bee Size #8-1/16 oz.
<p>Glow Bee Size #10-1/18 oz.
<p>Glow Bee Size #12-1/32 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
15(array)
products_image(string) => gb.jpg
products_name(string) => Glow Bug
products_quantity(string) => 9215
products_id(string) => 19
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => <img src="includes/templates/westminster_new/images/nitelitelogo.gif" class="descriptionLogo" /></a>
These tear drop shaped lures have double painted eyes with a glow in the dark back. Also available in our 7 popular Nite-Lite Glow colors.
<b>
<p>
<p>Glow Bug Size #2-1/8 oz.
<p>Glow Bug Size #4-1/8 oz.
<p>Glow Bug Size #6-1/16 oz.
<p>Glow Bug Size #8-1/28 oz.
<p>Glow Bug Size #10-1/32 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
16(array)
products_image(string) => gd.jpg
products_name(string) => Glow Dancer
products_quantity(string) => 9798
products_id(string) => 20
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.2500
products_tax_class_id(string) => 1
products_description(string) => <img src="includes/templates/westminster_new/images/nitelitelogo.gif" class="descriptionLogo" /></a>
The Glow Dancer is only about 1/10 oz. in weight. It sits in the water at about a 30 degree angle. It has a concave bottom that glows in the dark and falls through the water slowly. Has a darting action when jigged. It also comes in our popular <span style="color: rgb(255, 0, 0); font-weight: bold;">Nite-Lite Glow</span> colors.<p><strong><font size="+2" color="#FF0000">Now available in GOLD</font></strong></p>
<b>
<p>Glow Dancer Size #4-1/10 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.2500
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
17(array)
products_image(string) => gr.jpg
products_name(string) => Glow Rocker
products_quantity(string) => 8367
products_id(string) => 21
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => <img src="includes/templates/westminster_new/images/nitelitelogo.gif" class="descriptionLogo" /></a>
The Glow Rocker features a gold hook with two-tone colors and a glow in the dark back. It also comes in our <span style="color: rgb(255, 0, 0); font-weight: bold;">Nite-Lite Glow</span> colors.
<b>
<p>Glow Rocker Size #2-1/8 oz.
<p>Glow Rocker Size #4-1/24 oz.
<p>Glow Rocker Size #6-1/28 oz.
<p>Glow Rocker Size #8-1/64 oz.
<p>Glow Rocker Size #10-1/64 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
18(array)
products_image(string) => dr.jpg
products_name(string) => Gold Roc
products_quantity(string) => 9562
products_id(string) => 22
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => A "gold" plated lure that has some fish catching transparent color on one side and a double eye. The back side is gold plated.
<b>
<p>Gold Roc Size #2-1/8 oz.
<p>Gold Roc Size #4-1/24 oz.
<p>Gold Roc Size #6-1/28 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
19(array)
products_image(string) => Grubbie glow blue.jpg
products_name(string) => Grubby Glow Jigs
products_quantity(string) => 9886
products_id(string) => 72
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Grubby Jig is one of our most popular jigs, It's grub-shaped body resembles larva–and sends fish into a 'feeding frenzy'. Available in 5 brilliant NEON LITES colors in sizes #6, #8 and #10. Attract fish day or night–even in stained or muddy water. For best results use a camera flash to excite jig, then tip with minnow or waxworm.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
20(array)
products_image(string) => gp.jpg
products_name(string) => Guppee
products_quantity(string) => 9957
products_id(string) => 23
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Guppee is a two-toned lure with pearl on the bottom and various colors on the top. This lure has hand-painted eyes with a splash of Fl.Red color towards the eye of the hook.
<b>
<p>Guppee Size #8-1/16 oz.
<p>Guppee Size #10-1/20 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
21(array)
products_image(string) => hj.jpg
products_name(string) => Hydro Jig
products_quantity(string) => 7513
products_id(string) => 24
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.2500
products_tax_class_id(string) => 1
products_description(string) => <img src="includes/templates/westminster_new/images/nitelitelogo.gif" class="descriptionLogo" /></a>
<b><font size="+1" color="#ff0000">The Original Hydro Jig.</font></b> This is the jig head used by Professionals. This lure has a tournament grade superior hook. It is a Mustad ULTRA POINT®. It also has a bait keeper, if you choose to use plastic bait. The lure comes in 8 sizes to put the lure at the depth that is needed. It also comes in 12 colors. <font size="+1" color="#ff0000">NOW available in our Nite-Lite Fl.Red Glow</font>
<br />
Weight-oz. / Hook Size<p>
<p> 3/32       1
<p> 1/8        1/0
<p> 3/16       2/0
<p> 1/4        2/0
<p> 5/16       3/0
<p> 3/8        3/0
<p> 1/2        3/0
<p> 5/8        3/0</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.2500
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
22(array)
products_image(string) => jb.jpg
products_name(string) => Jig-A-Bit
products_quantity(string) => 8652
products_id(string) => 25
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Jig-A-Bit is an old time favorite. This lure has a wide gap hook and comes in both solid and two-tone colors. The Jig-A-Bit features a bronze hook.
<b>
<p>Jig-A-Bit Size #2-1/10 oz.
<p>Jig-A-Bit Size #4-1/10 oz.
<p>Jig-A-Bit Size #6-1/20 oz.
<p>Jig-A-Bit Size #8-1/20 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
23(array)
products_image(string) => lb.jpg
products_name(string) => Lady Bug
products_quantity(string) => 8691
products_id(string) => 26
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Lady Bug is finely detailed. It has a two-toned body with and hand-painted dots. All colors glow in the dark on the back side.
<b>
<p>Lady Bug Size #6-1/24 oz.
<p>Lady Bug Size #8-1/36 oz.
<p>Lady Bug Size #10-1/62 oz.
<p>Lady Bug Size #12-1/62 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
24(array)
products_image(string) => lt.jpg
products_name(string) => Lightning Bug
products_quantity(string) => 9381
products_id(string) => 27
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => <img src="includes/templates/westminster_new/images/nitelitelogo.gif" class="descriptionLogo" /></a>
The Lightning Bug is balanced to sit in the water at about a 45 degree angle. It features our two-toned paint with our natural glow color that glows in the dark.
It also comes in our "Nite-Lite" fluorescent glow colors.
<b>
<p>Lightning Bug Size #2-1/14 oz.
<p>Lightning Bug Size #4-1/16 oz.
<p>Lightning Bug Size #6-1/18 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
25(array)
products_image(string) => MG_glow blue.jpg
products_name(string) => MAXimum Gap Glow Jigs
products_quantity(string) => 9856
products_id(string) => 75
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => Since it’s introduction, the MAXimum Gap Glow Jig has become a fisherman’s standard. It’s piercing eyes and 6 brilliant NEO LITES colors in sizes 1/4oz., 1/8oz., 1/16oz. and 1/64oz. makes it a tackle-box favorite. The extra short shank and wide gap RED hook provides a compact, natural presentation for a deadly hook-set. Attract and catch fish day or night–even in stained or muddy water. For best results use a camera flash or LED to excite jig, then tip with a minnow, leech or crawler.
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
26(array)
products_image(string) => mg.jpg
products_name(string) => Moon Glow
products_quantity(string) => 6711
products_id(string) => 28
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => This popular jig glows in the dark on one side with color and gold flakes on the other side.
<b>
<p>Moon Glow Size #4-1/16 oz.
<p>Moon Glow Size #6-1/20 oz.
<p>Moon Glow Size #8-1/36 oz.
<p>Moon Glow Size #10-1/50 oz.
<p>Moon Glow Size #12-1/62 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
27(array)
products_image(string) => mj.jpg
products_name(string) => Mousie Jig
products_quantity(string) => 9718
products_id(string) => 29
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The solid color on the Mousie Jig is finely detailed with hand-painted eyes. The backside glows in the dark with gold flakes for that extra flash.
<b>
<p>Mousie Jig Size #4-1/20 oz.
<p>Mousie Jig Size #6-1/36 oz.
<p>Mousie Jig Size #8-1/36 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
28(array)
products_image(string) => JIG-TICK-4GLW-BLU.jpg
products_name(string) => Neon Ice Tic Glow Jigs
products_quantity(string) => 9918
products_id(string) => 71
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Neon Tic Jig was designed to drop fast and catch fish! The slender body of the Neon Tic Jig attracts fish with its gold hook and glow. Available in 5 brilliant NEON LITES colors in sizes #4, #6 and #8. Walleyes, crappies and other panfish can’t resist the action of this jig.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
29(array)
products_image(string) => gh.jpg
products_name(string) => Nite-Lite Glow Hooks
products_quantity(string) => 301
products_id(string) => 50
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 0.5000
products_tax_class_id(string) => 1
products_description(string) => <img src="includes/templates/westminster_new/images/nitelitelogo.gif" class="descriptionLogo" /></a>
These hooks are painted with our popular Nite-Lite Glow paint. They are sold individually.
specials_new_products_price(NULL) =>
final_price(string) => 0.5000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
30(array)
products_image(string) => ML_Glow Blue.jpg
products_name(string) => NWM-Moon Glow Jigs
products_quantity(string) => 9751
products_id(string) => 74
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Moon Glow Jig is one of our most popular jigs. It's moon shaped body resembles larva–and sends fish into a 'feeding frenzy'. It's available in 5 brilliant NEON LITES colors in sizes #4, #6, #8 and #10. Attract fish day or night–even in stained or muddy water. For best results use a camera flash to excite jig, then tip with minnow or waxworm.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
31(array)
products_image(string) => PE-011#6.jpg
products_name(string) => Perch Eye Glow Jigs
products_quantity(string) => 9821
products_id(string) => 77
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Perch Eye Jig is becoming a favorite for crappie fishermen. It's also effective on panfish and walleye and it can be easily seen on electronics. Available in 5 brilliant NEON LITES colors in sizes #4, #6, #8 and #10. Attract fish day or night–even in stained or muddy water. For best results use a camera flash to excite jig, then tip with minnow or waxworm.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
32(array)
products_image(string) => pa.jpg
products_name(string) => Plain Ant
products_quantity(string) => 9711
products_id(string) => 30
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Plain Ant is just a simple jig with two bodies and a double eye on each.
<b>
<p>Plain Ant Size #6-1/28 oz.
<p>Plain Ant Size #8-1/36 oz.
<p>Plain Ant Size #10-1/62 oz.
<p>Plain Ant Size #12-1/80 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
33(array)
products_image(string) => rj_ch_bl.jpg
products_name(string) => Rat'lr Glow Jigs
products_quantity(string) => 905
products_id(string) => 80
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => Combining the bright NEON LITES glow with the effectiveness of the loud rattle. The Rat'lr 'Glow' jig has an extra short shank and wide gap RED hook that provides a compact, natural presentation for a deadly hook-set. It also has a BRASS rattle that produces a loud enticing rattle that triggers fish to strike. Available in 3 brilliant NEON LITES colors in sizes 1/4oz., 1/8oz. and 3/8oz. Extremely effective in stained and muddy water. For best results, tip with a minnow, leach or crawler.
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
34(array)
products_image(string) => rjh.jpg
products_name(string) => Rattle Jig Head
products_quantity(string) => 9197
products_id(string) => 54
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.4000
products_tax_class_id(string) => 1
products_description(string) => The Rattle Jig Head has a high quality durable paint finish. Comes with a red hook and a very loud brass rattle built into the head. It is available in 3 sizes and 12 colors.
specials_new_products_price(NULL) =>
final_price(string) => 1.4000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
35(array)
products_image(string) => rr.jpg
products_name(string) => Rock-N-Roll
products_quantity(string) => 9623
products_id(string) => 31
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => This old time favorite is a great lure for jigging. This one sits in the water horizontally.
<b>
<p>Rock-N-Roll Size #2-1/4 oz.
<p>Rock-N-Roll Size #4-1/8 oz.
<p>Rock-N-Roll Size #6-1/16 oz.
<p>Rock-N-Roll Size #8-1/20 oz.
<p>Rock-N-Roll Size #10-1/50 oz.
<p>Rock-N-Roll Size #12-1/100 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
36(array)
products_image(string) => sb.jpg
products_name(string) => Skeeter Bug
products_quantity(string) => 9048
products_id(string) => 32
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1010
products_tax_class_id(string) => 1
products_description(string) => The Skeeter Bug sits in the water at a 45 degree angle increasing the hook set. This lure features a Hi Carbon quality bronze hook. All colors have a gold metal flake on the top for extra flash. It is a great little lure for those picky panfish.
<b>
<p>Skeeter Bug Size #10-1/24 oz.
<p>Skeeter Bug Size #12-1/36 oz.
<p>Skeeter Bug Size #14-1/50 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1010
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
37(array)
products_image(string) => STUPglow blue.jpg
products_name(string) => Stand-Up Glow Jigs
products_quantity(string) => 9892
products_id(string) => 76
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => Finally, a Stand-Up Jig that actually works! 75% to 100% standup average, compared to others that average 0% to 25%. Having a jig that allows the tail portion of the jig to stand up and not roll onto its side is key to triggering more strikes and having a better hookup percentage. This is the perfect jig for almost every river and lake-bottom jigging application.
Available in 6 brilliant NEON LITES colors in sizes 1/4oz., 1/8oz. and 3/8oz. Attract and catch fish day or night–even in stained or muddy water. Natural sunlight excites the jig, then tip with a minnow, leech or crawler.
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
38(array)
products_image(string) => sr.jpg
products_name(string) => Sting Ray
products_quantity(string) => 9530
products_id(string) => 33
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.5000
products_tax_class_id(string) => 1
products_description(string) => The Sting Ray is great for vertical jigging. It falls slowly in a semi-circle motion.
<b>
<p>Sting Ray Size #2-1/4 oz.
<p>Sting Ray Size #4-3/16 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.5000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
39(array)
products_image(string) => tb.jpg
products_name(string) => Tullibee
products_quantity(string) => 9822
products_id(string) => 35
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Tullibee is a favorite with many fisherman. This is a simple football shaped lure that comes in seven solid colors.
<b>
<p>Tullibee Size #6-1/24 oz.
<p>Tullibee Size #8-1/36 oz.
<p>Tullibee Size #10-1/50 oz.
<p>Tullibee Size #12-1/62 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
40(array)
products_image(string) => Walleye Jig-blue.jpg
products_name(string) => Walleye Glow Jigs
products_quantity(string) => 576
products_id(string) => 81
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => The Walleye Jig is designed with a wedge shape head that has less drag in strong current–excellent for river fishing. It also features a bait-holding collar for soft plastics and live bait. Available in 5 brilliant NEON LITES colors in sizes 1/4oz.,1/16oz., 1/8oz. and 3/8oz. Attract fish day or night–even in stained or muddy water. Tip with minnow, crawler or leech.
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
41(array)
products_image(string) => wt.jpg
products_name(string) => Water Tic
products_quantity(string) => 9797
products_id(string) => 36
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => <img src="includes/templates/westminster_new/images/nitelitelogo.gif" class="descriptionLogo" /></a>The Water Tic is colored on the top and glows in the dark on the bottom. It is also available in our popular <span style="font-weight: bold; color: rgb(255, 0, 0);">Nite-Lite Glow</span> colors.
<b>
<p>Water Tic Size #6-1/24 oz.
<p>Water Tic Size #8-1/36 oz.
<p>Water Tic Size #10-1/62 oz.
<p>Water Tic Size #12-1/62 oz.
</b>
</p>
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
42(array)
products_image(string) => WGGlow Blue.jpg
products_name(string) => Wide Gap Glow Jigs
products_quantity(string) => 9461
products_id(string) => 82
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Wide Gap Jig has a unique kahle style hook that sets quick and holds'em. It's deadly on crappie and walleye and is easily seen on electronics. Available in 5 brilliant NEON LITES colors in sizes #4, #6, and #8. Attract fish day or night–even in stained or muddy water. Tip with minnow or grub.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
43(array)
products_image(string) => wj.jpg
products_name(string) => Willy Jig
products_quantity(string) => 9485
products_id(string) => 37
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 1
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => This lure features a horizontal hook that is gold plated and has our fish catching painted patterns on the body. It also features a double hand-painted eyes.
<b>
<p>Willy Jig Size #4-1/16 oz.
<p>Willy Jig Size #6-1/20 oz.
</b>
</p>
sql_query(string) => SELECT p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) AS final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status FROM products p LEFT JOIN specials s ON s.products_id = p.products_id LEFT JOIN products_description pd ON pd.products_id = p.products_id AND pd.language_id = 1 LEFT JOIN products_to_categories p2c ON p2c.products_id = p.products_id LEFT JOIN manufacturers m ON m.manufacturers_id = p.manufacturers_id WHERE p.products_status = 1 AND p2c.categories_id = 7 ORDER BY p.products_sort_order, pd.products_name limit 9
number_of_rows(string) => 44
current_page_number(integer) => 1
number_of_pages(double) => 5
number_of_rows_per_page(integer) => 9
page_name(string) => page
countQuery(string) => SELECT p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) AS final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status FROM products p LEFT JOIN specials s ON s.products_id = p.products_id LEFT JOIN products_description pd ON pd.products_id = p.products_id AND pd.language_id = 1 LEFT JOIN products_to_categories p2c ON p2c.products_id = p.products_id LEFT JOIN manufacturers m ON m.manufacturers_id = p.manufacturers_id WHERE p.products_status = 1 AND p2c.categories_id = 7 ORDER BY p.products_sort_order, pd.products_name
Tungsten Fishing Jigs
Featured Products ...
Page 2
