articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Oferte speciale


Turbotail Quantum 4street Spin-jig 35g 4.7cm Ghost -60%

Turbotail Quantum 4street Spin-jig 35g 4.7cm Ghost

3494203
Livrare imediată!

40,28Lei(-60%) 16,25Lei

Turbotail Quantum 4street Spin-jig 35g 4.7cm Perch -60%

Turbotail Quantum 4street Spin-jig 35g 4.7cm Perch

3494201
Livrare imediată!

40,28Lei(-60%) 16,25Lei

Turbotail Sakura Tailspin 14 33mm 14gr 075 Electric Shad -24%

Turbotail Sakura Tailspin 14 33mm 14gr 075 Electric Shad

131634saple500214-075
Livrare imediată!

40,15Lei(-24%) 30,48Lei

Turbotail Sakura Tailspin 14 33mm 14gr 076 Magma -24%

Turbotail Sakura Tailspin 14 33mm 14gr 076 Magma

131634saple500214-076
Livrare imediată!

40,15Lei(-24%) 30,48Lei

Twister Big Hammer Perch Grub Hpg13060 60culoare 4.5cm -25%

Twister Big Hammer Perch Grub Hpg13060 60culoare 4.5cm

hpg13060
Livrare imediată!

14,00Lei(-25%) 10,56Lei

Twister Big Hammer Ring Swim Rhs40028 28culoare 10cm -26%

Twister Big Hammer Ring Swim Rhs40028 28culoare 10cm

rhs40028
Livrare imediată!

29,00Lei(-26%) 21,33Lei

Twister Big Hammer Ring Swim Rhs40040 40culoare 10cm -26%

Twister Big Hammer Ring Swim Rhs40040 40culoare 10cm

rhs40040
Livrare imediată!

29,00Lei(-26%) 21,33Lei

Twister Big Hammer Ring Swim Rhs40106 106culoare 10cm -26%

Twister Big Hammer Ring Swim Rhs40106 106culoare 10cm

rhs40106
Livrare imediată!

29,00Lei(-26%) 21,33Lei

Twister Big Hammer Ring Swim Rhs40209 209culoare 10cm -26%

Twister Big Hammer Ring Swim Rhs40209 209culoare 10cm

rhs40209
Livrare imediată!

29,00Lei(-26%) 21,33Lei

Twister Big Hammer Ring Swim Rhs40225 225culoare 10cm -26%

Twister Big Hammer Ring Swim Rhs40225 225culoare 10cm

rhs40225
Livrare imediată!

29,00Lei(-26%) 21,33Lei

Twister Big Hammer Ring Swim Rhs40259 259culoare 10cm -26%

Twister Big Hammer Ring Swim Rhs40259 259culoare 10cm

rhs40259
Livrare imediată!

29,00Lei(-26%) 21,33Lei

Twister Delaland Shad 8 Cm White 4 Buc -15%

Twister Delaland Shad 8 Cm White 4 Buc

005514b
Livrare imediată!

8,30Lei(-15%) 7,04Lei

Twister Jaxon 6cm J -42%
Exclusiv online!

Twister Jaxon 6cm J

tj-d60j
Livrare 48-72 ore

13,90Lei(-42%) 8,12Lei

Twister Lunker City Swimming Ribster 4” Grub, 001 Alewife, 10cm, 10buc/blister -25%

Twister Lunker City Swimming Ribster 4” Grub, 001 Alewife, 10cm, 10buc/blister

725442880019
Livrare imediată!

24,10Lei(-25%) 18,17Lei

Twister Lunker City Swimming Ribster 4” Grub, 132 Ice Shad, 10cm, 10buc/blister -23%

Twister Lunker City Swimming Ribster 4” Grub, 132 Ice Shad, 10cm, 10buc/blister

725442881320
Livrare imediată!

31,50Lei(-23%) 24,28Lei

Twister Lunker City Swimming Ribster 4” Grub, 144 Watermelon Red, 10cm, 10buc/blister -23%

Twister Lunker City Swimming Ribster 4” Grub, 144 Watermelon Red, 10cm, 10buc/blister

725442881443
Livrare imediată!

31,50Lei(-23%) 24,28Lei

Twister Lunker City Swimming Ribster 4” Grub, 147 Bubblegum, 10cm, 10buc/blister -23%

Twister Lunker City Swimming Ribster 4” Grub, 147 Bubblegum, 10cm, 10buc/blister

725442881474
Livrare imediată!

31,50Lei(-23%) 24,28Lei

Twister Lunker City Swimming Ribster 4” Grub, 211 Blue Halo, 10cm, 10buc/blister -25%

Twister Lunker City Swimming Ribster 4” Grub, 211 Blue Halo, 10cm, 10buc/blister

725442882112
Livrare imediată!

24,10Lei(-25%) 18,17Lei

Twister Lunker City Swimming Ribster 4” Grub, 214 Motor Oil, 10cm, 10buc/blister -13%
Exclusiv online!

Twister Lunker City Swimming Ribster 4” Grub, 214 Motor Oil, 10cm, 10buc/blister

725442882143
Livrare 48-72 ore

31,50Lei(-13%) 27,54Lei

Twister Lunker City Swimming Ribster 4” Grub, 216 Silver Flash, 10cm, 10buc/blister -25%

Twister Lunker City Swimming Ribster 4” Grub, 216 Silver Flash, 10cm, 10buc/blister

725442882167
Livrare imediată!

24,10Lei(-25%) 18,17Lei

Afişare 8521 - 8540 din 9305 (466 pagini)
Queries: 5, Total time: 681.140 ms [By time] [By id] [By file]
1 (0.175)
SELECT data
FROM `oc_session`
WHERE session_id = '6aa4a7456566101b6564a9fdf9'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.092)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (350.028)
SELECT COUNT(1) AS total
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p2s.store_id = '2' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) AND p.quantity > '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1714
4 (330.714)
SELECT DISTINCT ps.product_id
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.quantity > '0' AND p2s.store_id = '2' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 8520,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.131)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37