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


Agrafa Cross Lock Colmic Cu Vartej Dublu Nr 10 -25%

Agrafa Cross Lock Colmic Cu Vartej Dublu Nr 10

gm303510
Livrare imediată!

23,00Lei(-25%) 17,27Lei

Agrafa Cross Lock Colmic Cu Vartej Dublu Nr 18 -24%

Agrafa Cross Lock Colmic Cu Vartej Dublu Nr 18

gm303518
Livrare imediată!

19,00Lei(-24%) 14,52Lei

Agrafa Cross Lock Colmic Cu Vartej Dublu Nr 22 -24%
Exclusiv online!

Agrafa Cross Lock Colmic Cu Vartej Dublu Nr 22

gm303522
Livrare 48-72 ore

19,00Lei(-24%) 14,52Lei

Agrafa Cross Lock Colmic Cu Vartej Dublu Nr 24 -24%
Exclusiv online!

Agrafa Cross Lock Colmic Cu Vartej Dublu Nr 24

gm303524
Livrare 48-72 ore

19,00Lei(-24%) 14,52Lei

Agrafa Cu Vartej Dam Effzett Swivel Quick Change Snap Nr 6 16kg -38%

Agrafa Cu Vartej Dam Effzett Swivel Quick Change Snap Nr 6 16kg

410090091
Livrare imediată!

10,99Lei(-38%) 6,76Lei

Agrafa Cu Vartej Decoy Sn-9 Swivel Snap Nr1 -4%

Agrafa Cu Vartej Decoy Sn-9 Swivel Snap Nr1

4989540827024
Livrare imediată!

19,51Lei(-4%) 18,77Lei

Agrafa Cu Vartej Lucky John Duolock Nr.002, 38kg, 7buc/plic -27%

Agrafa Cu Vartej Lucky John Duolock Nr.002, 38kg, 7buc/plic

ljp5101-002
Livrare imediată!

9,99Lei(-27%) 7,30Lei

Agrafa Cu Vartej Savage Egg Snap Nr.4 22kg 10buc -20%

Agrafa Cu Vartej Savage Egg Snap Nr.4 22kg 10buc

a7.sg.54913
Livrare imediată!

12,98Lei(-20%) 10,43Lei

Agrafa Cu Vartej Si Margea Culisanta Dam Detek Feeder Bead 10buc/pac -38%
Exclusiv online!

Agrafa Cu Vartej Si Margea Culisanta Dam Detek Feeder Bead 10buc/pac

a.dam.66004
Livrare 24-48 ore

12,34Lei(-38%) 7,70Lei

Agrafa Fixare Tubertini Crossiline Tb 6201, Marime L, 6buc/pac -4%

Agrafa Fixare Tubertini Crossiline Tb 6201, Marime L, 6buc/pac

554000l
Livrare imediată!

9,99Lei(-4%) 9,64Lei

Agrafa Fixare Tubertini Crossiline Tb 6201, Marime M, 6buc/pac -4%

Agrafa Fixare Tubertini Crossiline Tb 6201, Marime M, 6buc/pac

554000m
Livrare imediată!

9,99Lei(-4%) 9,64Lei

Agrafa Fixare Tubertini Moved Plastic Headw Interlock, Marime L, 6buc/pac -4%

Agrafa Fixare Tubertini Moved Plastic Headw Interlock, Marime L, 6buc/pac

553450l
Livrare imediată!

10,50Lei(-4%) 10,08Lei

Agrafa Fixare Tubertini Moved Plastic Headw Interlock, Marime M, 6buc/pac -4%
Exclusiv online!

Agrafa Fixare Tubertini Moved Plastic Headw Interlock, Marime M, 6buc/pac

553450m
Livrare 7-14 zile

10,50Lei(-4%) 10,08Lei

Agrafa Fixare Tubertini Moved Plastic Headw Interlock, Marime S, 6buc/pac -4%

Agrafa Fixare Tubertini Moved Plastic Headw Interlock, Marime S, 6buc/pac

553450s
Livrare imediată!

10,50Lei(-4%) 10,08Lei

Agrafa Garbolino S Feeder Htn Speed Clip -18%

Agrafa Garbolino S Feeder Htn Speed Clip

40230gofah1303-s
Livrare imediată!

18,46Lei(-18%) 15,13Lei

Agrafa Korda Stik Klip Medium 20buc/pl -17%

Agrafa Korda Stik Klip Medium 20buc/pl

a.kscm
Livrare imediată!

25,51Lei(-17%) 21,24Lei

Agrafa Maver Mv-r Duo Look Spin Steel Nr.12 60kg 7/plic -3%
Exclusiv online!

Agrafa Maver Mv-r Duo Look Spin Steel Nr.12 60kg 7/plic

01572012
Livrare 48-72 ore

6,50Lei(-3%) 6,29Lei

Agrafa Maver Mv-r Duo Look Spin Steel Nr.14 50kg 10/plic -3%
Exclusiv online!

Agrafa Maver Mv-r Duo Look Spin Steel Nr.14 50kg 10/plic

01572014
Livrare 48-72 ore

6,50Lei(-3%) 6,29Lei

Agrafa Maver Mv-r Duo Look Spin Steel Nr.16 40kg 10/plic -3%
Exclusiv online!

Agrafa Maver Mv-r Duo Look Spin Steel Nr.16 40kg 10/plic

01572016
Livrare 48-72 ore

6,50Lei(-3%) 6,29Lei

Agrafa Maver Mv-r Duo Look Spin Steel Nr.18 25kg 10/plic -3%
Exclusiv online!

Agrafa Maver Mv-r Duo Look Spin Steel Nr.18 25kg 10/plic

01572018
Livrare 48-72 ore

6,50Lei(-3%) 6,29Lei

Afişare 3281 - 3300 din 9311 (466 pagini)
Queries: 5, Total time: 685.792 ms [By time] [By id] [By file]
1 (0.154)
SELECT data
FROM `oc_session`
WHERE session_id = 'ed0bbb81225ef595d48dd9ed24'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (284.142)
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 (401.227)
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 3280,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.167)
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