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


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 -30%
Exclusiv online!

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

a.dam.66004
Livrare 24-48 ore

12,34Lei(-30%) 8,62Lei

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

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

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

01572020
Livrare 48-72 ore

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

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

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

01572022
Livrare 48-72 ore

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

Agrafa Maver Mv-r Duo Look Spin Steel Nr.6 100kg 4/plic -3%
Exclusiv online!

Agrafa Maver Mv-r Duo Look Spin Steel Nr.6 100kg 4/plic

01572006
Livrare 48-72 ore

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

Agrafa Maver Mv-r Duo Look Spin Steel Nr.8 80kg 5/plic -3%
Exclusiv online!

Agrafa Maver Mv-r Duo Look Spin Steel Nr.8 80kg 5/plic

01572008
Livrare 48-72 ore

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

Agrafa Maver Mv-r Monster Steel Nr.10 100kg 7buc/plic -6%
Exclusiv online!

Agrafa Maver Mv-r Monster Steel Nr.10 100kg 7buc/plic

01574010
Livrare 48-72 ore

8,00Lei(-6%) 7,51Lei

Agrafa Maver Mv-r Monster Steel Nr.12 80kg 10buc/plic -6%
Exclusiv online!

Agrafa Maver Mv-r Monster Steel Nr.12 80kg 10buc/plic

01574012
Livrare 48-72 ore

8,00Lei(-6%) 7,51Lei

Afişare 3101 - 3120 din 8977 (449 pagini)
Queries: 5, Total time: 674.297 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = '54bbd2a2592092176515c0b3c6'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (321.699)
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 (352.311)
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 3100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.117)
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