Firma Privat








Glemt kode?

Login Firma
Og bestil alt det bedste danske fiskegrej her


Bliv forhandler her









Glemt kode?

Login
Og bestil alt det bedste danske fiskegrej her.


Ikke kunde endnu?
opret dig her

Kurv. 0
Kategorier
Endegrej
Endegrej

Endegrej

Kategorier - Endegrej - Gummiagn - Jig-Rig



SELECT VareTabel.varenr , VareTabel.Kategori1 , VareTabel.Kategori2 , VareTabel.Kategori3 , VareTabel.Beskriv , VareTabel.Lagersted1 , VareTabel.LagerAntal , VareTabel.Beskriv100 , VareTabel.Fabrikat , VareTabel.Tilbud , VareTabel.Pris , VareTabel.varetype , VareTabel.Opretdato , VareTabel.VejledendeUdsalgsPris , VareTabel.VareNr1AfSaet , VareTabel.VareNr2AfSaet , VareTabel.VareNr3AfSaet , VareTabel.VareNr4AfSaet , VareTabel.VareNr5AfSaet , VareTabel.VareNr6AfSaet , VareTabel.VareNr7AfSaet , VareTabel.VareNr8AfSaet , VareTabel.Rabatgruppe , VareTabel.netrabat , VareTabel.PrisVed2Stk , VareTabel.PrisVed3Stk , VareTabel.PrisVed4Stk , VareTabel.PrisVed5Stk , VareTabel.PrisVed10Stk , VareTabel.PrisVed20Stk , VareTabel.PrisVed50Stk , VareTabel.PrisVed100Stk , VareTabel.PrisVed250Stk , VareTabel.Kolli , VareTabel.LagerAntalGrej FROM Varer AS VareTabel WHERE (VareTabel.VareType = 'GREJ') AND VareTabel.Kategori1 = 'Endegrej' AND VareTabel.Kategori2 = 'Gummiagn' AND VareTabel.Kategori3 = 'Jig-Rig' AND VareTabel.VejledendeUdsalgsPris > 0 ORDER BY VareTabel.Kategori1 ASC, VareTabel.Kategori2 ASC, VareTabel.Kategori3 ASC, VareTabel.VareNr DESC LIMIT 0, 50
4005652843032
  • 4005652843032 - Aborre forfang, Micro Minnow - Længde:175cm. - 30mm. - Farve:Rainbow - 001 4782 016<br>Very luring perch rig attached to fluorocarbon. All soft lures are UV-active! Supplied on a winding board! The 2 barbed hook prevent the soft lure from sliding on the rear side so that the soft lure slides onto the shank - simply fantastic!
Beskrivelse:Aborre forfang, Micro Minnow - Længde:175cm. - 30mm. - Farve:Rainbow - 001 4782 016
Lagerantal:Ikke på lager
Pris53,95
+
-
4005652815589
  • 4005652815589 - Aborre forfang, ekstra stærk - Længde:175cm. - 60mm. - Farve:Natur, UV - 001 4789 016<br>Very luring perch rig attached to fluorocarbon. All soft lures are UV-active! Supplied on a winding board! The 2 barbed hook prevent the soft lure from sliding on the rear side so that the soft lure slides onto the shank - simply fantastic!
Beskrivelse:Aborre forfang, ekstra stærk - Længde:175cm. - 60mm. - Farve:Natur, UV - 001 4789 016
Lagerantal:Ikke på lager
Pris61,95
+
-
4005652807652
  • 4005652807652 - Aborre UV forfang, Leaf Tail - Længde:175cm. - 60mm. - 001 4782 015<br>Very luring perch rig attached to fluorocarbon. All soft lures are UV-active! Supplied on a winding board! The 2 barbed hook prevent the soft lure from sliding on the rear side so that the soft lure slides onto the shank - simply fantastic!
Beskrivelse:Aborre UV forfang, Leaf Tail - Længde:175cm. - 60mm. - 001 4782 015
Lagerantal:Ikke på lager
Pris53,95
+
-
4005652807645
  • 4005652807645 - Aborre UV forfang, Bullet Tail - Længde:175cm. - 50mm. - 001 4782 014<br>Very luring perch rig attached to fluorocarbon. All soft lures are UV-active! Supplied on a winding board! The 2 barbed hook prevent the soft lure from sliding on the rear side so that the soft lure slides onto the shank - simply fantastic!
Beskrivelse:Aborre UV forfang, Bullet Tail - Længde:175cm. - 50mm. - 001 4782 014
Lagerantal:Ikke på lager
Pris53,95
+
-
4005652807638
  • 4005652807638 - Aborre UV forfang, orm - Længde:175cm. - 55mm. - 001 4782 013<br>Very luring perch rig attached to fluorocarbon. All soft lures are UV-active! Supplied on a winding board! The 2 barbed hook prevent the soft lure from sliding on the rear side so that the soft lure slides onto the shank - simply fantastic!
Beskrivelse:Aborre UV forfang, orm - Længde:175cm. - 55mm. - 001 4782 013
Lagerantal:Ikke på lager
Pris61,95
+
-
4005652807621
  • 4005652807621 - Aborre UV forfang, Creature - Længde:175cm. - 45mm. - 001 4782 012<br>Very luring perch rig attached to fluorocarbon. All soft lures are UV-active! Supplied on a winding board! The 2 barbed hook prevent the soft lure from sliding on the rear side so that the soft lure slides onto the shank - simply fantastic!
Beskrivelse:Aborre UV forfang, Creature - Længde:175cm. - 45mm. - 001 4782 012
Lagerantal:Ikke på lager
Pris61,95
+
-
4005652807614
  • 4005652807614 - Aborre UV forfang, Creature - Længde:175cm. - 40mm. - 001 4782 011<br>Very luring perch rig attached to fluorocarbon. All soft lures are UV-active! Supplied on a winding board! The 2 barbed hook prevent the soft lure from sliding on the rear side so that the soft lure slides onto the shank - simply fantastic!
Beskrivelse:Aborre UV forfang, Creature - Længde:175cm. - 40mm. - 001 4782 011
Lagerantal:Ikke på lager
Pris61,95
+
-
4005652807607
  • 4005652807607 - Aborre forfang, Micro Minnow - Længde:175cm. - 30mm. - Farve:Natur, UV - 001 4782 010<br>Very luring perch rig attached to fluorocarbon. All soft lures are UV-active! Supplied on a winding board! The 2 barbed hook prevent the soft lure from sliding on the rear side so that the soft lure slides onto the shank - simply fantastic!
Beskrivelse:Aborre forfang, Micro Minnow - Længde:175cm. - 30mm. - Farve:Natur, UV - 001 4782 010
Lagerantal:Ikke på lager
Pris61,95
+
-
4005652802190
  • 4005652802190 - Lavaret forfang - Længde:210cm. - Variant:Mix 3 - 001 4788 303<br>Very high-quality lavaret rigs. The nymphs are sealed with epoxy varnish. Due to the special loop binding the nymphs move very naturally.
Beskrivelse:Lavaret forfang - Længde:210cm. - Variant:Mix 3 - 001 4788 303
Lagerantal:Ikke på lager
Pris66,95
+
-
4005652802183
  • 4005652802183 - Lavaret forfang - Længde:210cm. - Variant:Mix 2 - 001 4788 302<br>Very high-quality lavaret rigs. The nymphs are sealed with epoxy varnish. Due to the special loop binding the nymphs move very naturally.
Beskrivelse:Lavaret forfang - Længde:210cm. - Variant:Mix 2 - 001 4788 302
Lagerantal:Ikke på lager
Pris66,95
+
-
4005652802176
  • 4005652802176 - Lavaret forfang - Længde:210cm. - Variant:Mix 1 - 001 4788 301<br>Very high-quality lavaret rigs. The nymphs are sealed with epoxy varnish. Due to the special loop binding the nymphs move very naturally.
Beskrivelse:Lavaret forfang - Længde:210cm. - Variant:Mix 1 - 001 4788 301
Lagerantal:Ikke på lager
Pris66,95
+
-
4005652802169
  • 4005652802169 - Lavaret forfang - Længde:180cm. - Variant:Mix 3 - 001 4788 203<br>Very high-quality lavaret rigs. The nymphs are sealed with epoxy varnish. Due to the special loop binding the nymphs move very naturally.
Beskrivelse:Lavaret forfang - Længde:180cm. - Variant:Mix 3 - 001 4788 203
Lagerantal:Ikke på lager
Pris66,95
+
-
4005652802152
  • 4005652802152 - Lavaret forfang - Længde:180cm. - Variant:Mix 2 - 001 4788 202<br>Very high-quality lavaret rigs. The nymphs are sealed with epoxy varnish. Due to the special loop binding the nymphs move very naturally.
Beskrivelse:Lavaret forfang - Længde:180cm. - Variant:Mix 2 - 001 4788 202
Lagerantal:Ikke på lager
Pris66,95
+
-
4005652802145
  • 4005652802145 - Lavaret forfang - Længde:180cm. - Variant:Mix 1 - 001 4788 201<br>Very high-quality lavaret rigs. The nymphs are sealed with epoxy varnish. Due to the special loop binding the nymphs move very naturally.
Beskrivelse:Lavaret forfang - Længde:180cm. - Variant:Mix 1 - 001 4788 201
Lagerantal:Ikke på lager
Pris66,95
+
-
4005652802138
  • 4005652802138 - Lavaret forfang - Længde:210cm. - Variant:Mix 3 - 001 4788 103<br>Very high-quality lavaret rigs. The nymphs are sealed with epoxy varnish. Due to the special loop binding the nymphs move very naturally.
Beskrivelse:Lavaret forfang - Længde:210cm. - Variant:Mix 3 - 001 4788 103
Lagerantal:Ikke på lager
Pris66,95
+
-
4005652802121
  • 4005652802121 - Lavaret forfang - Længde:210cm. - Variant:Mix 2 - 001 4788 102<br>Very high-quality lavaret rigs. The nymphs are sealed with epoxy varnish. Due to the special loop binding the nymphs move very naturally.
Beskrivelse:Lavaret forfang - Længde:210cm. - Variant:Mix 2 - 001 4788 102
Lagerantal:Ikke på lager
Pris66,95
+
-
4005652802114
  • 4005652802114 - Lavaret forfang - Længde:210cm. - Variant:Mix 1 - 001 4788 101<br>Very high-quality lavaret rigs. The nymphs are sealed with epoxy varnish. Due to the special loop binding the nymphs move very naturally.
Beskrivelse:Lavaret forfang - Længde:210cm. - Variant:Mix 1 - 001 4788 101
Lagerantal:Ikke på lager
Pris66,95
+
-
4005652204987
  • 4005652204987 - Lavaret forfang - Længde:180cm. - Variant:Mix 3 - 001 4788 003<br>Very high-quality lavaret rigs. The nymphs are sealed with epoxy varnish. Due to the special loop binding the nymphs move very naturally.
Beskrivelse:Lavaret forfang - Længde:180cm. - Variant:Mix 3 - 001 4788 003
Lagerantal:Ikke på lager
Pris66,95
+
-
4005652204970
  • 4005652204970 - Lavaret forfang - Længde:180cm. - Variant:Mix 2 - 001 4788 002<br>Very high-quality lavaret rigs. The nymphs are sealed with epoxy varnish. Due to the special loop binding the nymphs move very naturally.
Beskrivelse:Lavaret forfang - Længde:180cm. - Variant:Mix 2 - 001 4788 002
Lagerantal:Ikke på lager
Pris66,95
+
-
4005652204963
  • 4005652204963 - Lavaret forfang - Længde:180cm. - Variant:Mix 1 - 001 4788 001<br>Very high-quality lavaret rigs. The nymphs are sealed with epoxy varnish. Due to the special loop binding the nymphs move very naturally.
Beskrivelse:Lavaret forfang - Længde:180cm. - Variant:Mix 1 - 001 4788 001
Lagerantal:Ikke på lager
Pris66,95
+
-