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 - Ske-blink - Colonel



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 = 'Ske-blink' AND VareTabel.Kategori3 = 'Colonel' AND VareTabel.VejledendeUdsalgsPris > 0 ORDER BY VareTabel.Kategori1 ASC, VareTabel.Kategori2 ASC, VareTabel.Kategori3 ASC, VareTabel.VareNr DESC
4005652860534
  • 4005652860534 - Colonel Classic HB Spoon - 56mm. - Vægt:22g. - Farve:Fireshark - 001 3256 022<br>Our classic spoon with optimised motion. Due to the greater curvature the spoon runs considerably more actively no matter how slowly it moves. With excellent treble hooks and top quality workmanship!
Beskrivelse:Colonel Classic HB Spoon - 56mm. - Vægt:22g. - Farve:Fireshark - 001 3256 022
Lagerantal:Er på lager
Pris48,95
+
-
4005652860497
  • 4005652860497 - Colonel Classic HB Spoon - 56mm. - Vægt:22g. - Farve:Holo-Perch - 001 3255 022<br>Our classic spoon with optimised motion. Due to the greater curvature the spoon runs considerably more actively no matter how slowly it moves. With excellent treble hooks and top quality workmanship!
Beskrivelse:Colonel Classic HB Spoon - 56mm. - Vægt:22g. - Farve:Holo-Perch - 001 3255 022
Lagerantal:Er på lager
Pris48,95
+
-
4005652860459
  • 4005652860459 - Colonel Classic HB Spoon - 56mm. - Vægt:22g. - Farve:Holo-Roach - 001 3254 022<br>Our classic spoon with optimised motion. Due to the greater curvature the spoon runs considerably more actively no matter how slowly it moves. With excellent treble hooks and top quality workmanship!
Beskrivelse:Colonel Classic HB Spoon - 56mm. - Vægt:22g. - Farve:Holo-Roach - 001 3254 022
Lagerantal:Er på lager
Pris48,95
+
-
4005652859682
  • 4005652859682 - Colonel Weed Spoon - 56mm. - Vægt:22g. - Farve:Fireshark - 001 3253 422<br>Weed Spoon: The two wires over the twin hook ensure that no weed gets caught on the hook tips. This way you can still fish on (catchy!) weedy sections, which is no longer possible with normal spoons.
Beskrivelse:Colonel Weed Spoon - 56mm. - Vægt:22g. - Farve:Fireshark - 001 3253 422
Lagerantal:Er på lager
Pris48,95
+
-
4005652859651
  • 4005652859651 - Colonel Weed Spoon - 56mm. - Vægt:22g. - Farve:Holo-Perch - 001 3253 322<br>Weed Spoon: The two wires over the twin hook ensure that no weed gets caught on the hook tips. This way you can still fish on (catchy!) weedy sections, which is no longer possible with normal spoons.
Beskrivelse:Colonel Weed Spoon - 56mm. - Vægt:22g. - Farve:Holo-Perch - 001 3253 322
Lagerantal:Er på lager
Pris48,95
+
-
4005652842844
  • 4005652842844 - Colonel Classic HB Spoon - 46mm. - Vægt:16g. - Farve:Rød reflex - 001 3251 116<br>Colonel Classic Curvy spoon: Our classic spoon with optimised motion. Due to the greater curvature the spoon runs considerably more actively no matter how slowly it moves. Excellent treble hooks and top quality workmanship!
Beskrivelse:Colonel Classic HB Spoon - 46mm. - Vægt:16g. - Farve:Rød reflex - 001 3251 116
Lagerantal:Er på lager
Pris44,95
+
-
4005652841526
  • 4005652841526 - Colonel Weed Spoon - 56mm. - Vægt:22g. - Farve:Holo-Roach - 001 3253 222<br>Weed Spoon: The two wires over the twin hook ensure that no weed gets caught on the hook tips. This way you can still fish on (catchy!) weedy sections, which is no longer possible with normal spoons.
Beskrivelse:Colonel Weed Spoon - 56mm. - Vægt:22g. - Farve:Holo-Roach - 001 3253 222
Lagerantal:Er på lager
Pris48,95
+
-
4005652841496
  • 4005652841496 - Colonel Weed Spoon - 56mm. - Vægt:22g. - Farve:Kobber - 001 3253 122<br>Weed Spoon: The two wires over the twin hook ensure that no weed gets caught on the hook tips. This way you can still fish on (catchy!) weedy sections, which is no longer possible with normal spoons.
Beskrivelse:Colonel Weed Spoon - 56mm. - Vægt:22g. - Farve:Kobber - 001 3253 122
Lagerantal:Er på lager
Pris48,95
+
-
4005652841472
  • 4005652841472 - Colonel Weed Spoon - 66mm. - Vægt:30g. - Farve:Sølv - 001 3253 030<br>Weed Spoon: The two wires over the twin hook ensure that no weed gets caught on the hook tips. This way you can still fish on (catchy!) weedy sections, which is no longer possible with normal spoons.
Beskrivelse:Colonel Weed Spoon - 66mm. - Vægt:30g. - Farve:Sølv - 001 3253 030
Lagerantal:Er på lager
Pris52,95
+
-
4005652193519
  • 4005652193519 - Colonel Classic HB Spoon - 66mm. - Vægt:30g. - Farve:Sølv - 001 3241 030<br>Colonel Classic Curvy spoon: Our classic spoon with optimised motion. Due to the greater curvature the spoon runs considerably more actively no matter how slowly it moves. Excellent treble hooks and top quality workmanship!
Beskrivelse:Colonel Classic HB Spoon - 66mm. - Vægt:30g. - Farve:Sølv - 001 3241 030
Lagerantal:Er på lager
Pris52,95
+
-
4005652171548
  • 4005652171548 - Colonel Weed Spoon - 56mm. - Vægt:22g. - Farve:Sølv - 001 3253 022<br>Weed Spoon: The two wires over the twin hook ensure that no weed gets caught on the hook tips. This way you can still fish on (catchy!) weedy sections, which is no longer possible with normal spoons.
Beskrivelse:Colonel Weed Spoon - 56mm. - Vægt:22g. - Farve:Sølv - 001 3253 022
Lagerantal:Er på lager
Pris48,95
+
-