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 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Oferte speciale


Turbotail Quantum 4street Spin-jig 28g 4.1cm Baitfish -63%

Turbotail Quantum 4street Spin-jig 28g 4.1cm Baitfish

3494104
Livrare imediată!

40,28Lei(-63%) 15,01Lei

Turbotail Quantum 4street Spin-jig 28g 4.1cm Firetiger -63%

Turbotail Quantum 4street Spin-jig 28g 4.1cm Firetiger

3494102
Livrare imediată!

40,28Lei(-63%) 15,01Lei

Turbotail Quantum 4street Spin-jig 28g 4.1cm Ghost -63%

Turbotail Quantum 4street Spin-jig 28g 4.1cm Ghost

3494103
Livrare imediată!

40,28Lei(-63%) 15,01Lei

Turbotail Quantum 4street Spin-jig 28g 4.1cm Perch -63%

Turbotail Quantum 4street Spin-jig 28g 4.1cm Perch

3494101
Livrare imediată!

40,28Lei(-63%) 15,01Lei

Turbotail Quantum 4street Spin-jig 35g 4.7cm Baitfish -63%

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

3494204
Livrare imediată!

40,28Lei(-63%) 15,01Lei

Turbotail Quantum 4street Spin-jig 35g 4.7cm Firetiger -63%

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

3494202
Livrare imediată!

40,28Lei(-63%) 15,01Lei

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

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

3494203
Livrare imediată!

40,28Lei(-63%) 15,01Lei

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

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

3494201
Livrare imediată!

40,28Lei(-63%) 15,01Lei

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

Turbotail Sakura Tailspin 14 33mm 14gr 075 Electric Shad

131634saple500214-075
Livrare imediată!

40,15Lei(-28%) 28,99Lei

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

Turbotail Sakura Tailspin 14 33mm 14gr 076 Magma

131634saple500214-076
Livrare imediată!

40,15Lei(-28%) 28,99Lei

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

Twister Big Hammer Perch Grub Hpg13060 60culoare 4.5cm

hpg13060
Livrare imediată!

13,99Lei(-33%) 9,40Lei

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

Twister Big Hammer Ring Swim Rhs40028 28culoare 10cm

rhs40028
Livrare imediată!

29,00Lei(-31%) 19,99Lei

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

Twister Big Hammer Ring Swim Rhs40040 40culoare 10cm

rhs40040
Livrare imediată!

29,00Lei(-31%) 19,99Lei

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

Twister Big Hammer Ring Swim Rhs40106 106culoare 10cm

rhs40106
Livrare imediată!

29,00Lei(-31%) 19,99Lei

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

Twister Big Hammer Ring Swim Rhs40209 209culoare 10cm

rhs40209
Livrare imediată!

29,00Lei(-31%) 19,99Lei

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

Twister Big Hammer Ring Swim Rhs40225 225culoare 10cm

rhs40225
Livrare imediată!

29,00Lei(-31%) 19,99Lei

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

Twister Big Hammer Ring Swim Rhs40259 259culoare 10cm

rhs40259
Livrare imediată!

29,00Lei(-31%) 19,99Lei

Twister Crazy Fish Vibro Worm 7.5cm 7 Squid -7%

Twister Crazy Fish Vibro Worm 7.5cm 7 Squid

117576
Livrare imediată!

12,00Lei(-7%) 11,10Lei

Twister Delaland Shad 8 Cm White 4 Buc -28%

Twister Delaland Shad 8 Cm White 4 Buc

005514b
Livrare imediată!

8,29Lei(-28%) 5,94Lei

Twister Jaxon 6cm J -50%
Exclusiv online!

Twister Jaxon 6cm J

tj-d60j
Livrare 48-72 ore

13,90Lei(-50%) 7,00Lei

Afişare 8361 - 8380 din 9149 (458 pagini)
Queries: 5, Total time: 639.997 ms [By time] [By id] [By file]
1 (0.168)
SELECT data
FROM `oc_session`
WHERE session_id = '0b0210ebc328f1d5f1a979dc2c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.072)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (291.959)
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 = '3' 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 (347.690)
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 = '3' 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 8360,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.108)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37