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


Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.16mm, 2.1kg -20%

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.16mm, 2.1kg

1550687
Livrare imediată!

19,96Lei(-20%) 15,90Lei

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.25mm, 4.8kg -20%

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.25mm, 4.8kg

1550690
Livrare imediată!

19,96Lei(-20%) 15,90Lei

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.30mm, 6.8kg -20%

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.30mm, 6.8kg

1550691
Livrare imediată!

19,96Lei(-20%) 15,90Lei

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.35mm, 8.7kg -20%

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.35mm, 8.7kg

1550692
Livrare imediată!

19,96Lei(-20%) 15,90Lei

Fir Monofilament Carbotex 016mm/3,65kg/100m -29%

Fir Monofilament Carbotex 016mm/3,65kg/100m

e.4800.016
Livrare imediată!

11,84Lei(-29%) 8,43Lei

Fir Monofilament Carbotex Bison 0.22mm/5,20kg/100m -29%

Fir Monofilament Carbotex Bison 0.22mm/5,20kg/100m

e.6000.022
Livrare imediată!

5,09Lei(-29%) 3,64Lei

Fir Monofilament Carbotex Feeder Dm, Black, 0.18mm, 4.50kg, 250m -16%

Fir Monofilament Carbotex Feeder Dm, Black, 0.18mm, 4.50kg, 250m

e.2550.018
Livrare imediată!

23,78Lei(-16%) 19,92Lei

Fir Monofilament Carbotex Ice 010mm/1,75kg/30m -20%

Fir Monofilament Carbotex Ice 010mm/1,75kg/30m

e.4620.010
Livrare imediată!

4,81Lei(-20%) 3,86Lei

Fir Monofilament Carbotex Ice 016mm/3,65kg/30m -24%

Fir Monofilament Carbotex Ice 016mm/3,65kg/30m

e.4620.016
Livrare imediată!

4,53Lei(-24%) 3,45Lei

Fir Monofilament Carbotex Ice 018mm/4,50kg/30m -0%
Exclusiv online!

Fir Monofilament Carbotex Ice 018mm/4,50kg/30m

e.4620.018
Livrare 24-48 ore

4,53Lei(-0%) 4,52Lei

Fir Monofilament Carbotex Ice 020mm/5,60kg/30m -0%

Fir Monofilament Carbotex Ice 020mm/5,60kg/30m

e.4620.020
Livrare imediată!

4,53Lei(-0%) 4,52Lei

Fir Monofilament Carbotex Matrix Green 0.22mm/6.75kg/300m -20%

Fir Monofilament Carbotex Matrix Green 0.22mm/6.75kg/300m

e.1030.022
Livrare imediată!

22,65Lei(-20%) 18,12Lei

Fir Monofilament Carbotex Matrix Green 0.35mm/15.45kg/300m -17%
Exclusiv online!

Fir Monofilament Carbotex Matrix Green 0.35mm/15.45kg/300m

e.1030.035
Livrare 24-48 ore

29,54Lei(-17%) 24,53Lei

Fir Monofilament Carbotex Matrix Matrix Green 0.20mm/5.55kg/300m -13%

Fir Monofilament Carbotex Matrix Matrix Green 0.20mm/5.55kg/300m

e.1030.020
Livrare imediată!

21,75Lei(-13%) 19,02Lei

Fir Monofilament Carbotex Matrix Matrix Green 0.24mm/8.30kg/300m -16%
Exclusiv online!

Fir Monofilament Carbotex Matrix Matrix Green 0.24mm/8.30kg/300m

e.1030.024
Livrare 24-48 ore

25,39Lei(-16%) 21,22Lei

Fir Monofilament Carbotex Matrix Matrix Green 0.26mm/8.95kg/300m -16%
Exclusiv online!

Fir Monofilament Carbotex Matrix Matrix Green 0.26mm/8.95kg/300m

e.1030.026
Livrare 24-48 ore

25,39Lei(-16%) 21,22Lei

Fir Monofilament Carbotex Matrix Matrix Green 0.28mm/10.25kg/300m -16%
Exclusiv online!

Fir Monofilament Carbotex Matrix Matrix Green 0.28mm/10.25kg/300m

e.1030.028
Livrare 24-48 ore

25,39Lei(-16%) 21,22Lei

Fir Monofilament Carbotex Matrix Matrix Green 0.30mm/11.95kg/300m -16%
Exclusiv online!

Fir Monofilament Carbotex Matrix Matrix Green 0.30mm/11.95kg/300m

e.1030.030
Livrare 24-48 ore

25,39Lei(-16%) 21,22Lei

Fir Monofilament Carbotex Matrix, Galben Fluo, 0.28mm, 10.25kg, 1000m -17%
Exclusiv online!

Fir Monofilament Carbotex Matrix, Galben Fluo, 0.28mm, 10.25kg, 1000m

e.1000.028
Livrare 24-48 ore

28,18Lei(-17%) 23,44Lei

Fir Monofilament Carbotex Matrix, Galben Fluo, 0.30mm, 11.95kg, 1000m -7%

Fir Monofilament Carbotex Matrix, Galben Fluo, 0.30mm, 11.95kg, 1000m

e.1000.030
Livrare imediată!

29,57Lei(-7%) 27,51Lei

Afişare 4701 - 4720 din 9130 (457 pagini)
Queries: 5, Total time: 554.280 ms [By time] [By id] [By file]
1 (0.098)
SELECT data
FROM `oc_session`
WHERE session_id = '86a09bad3d2d1d4c127600d17c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (262.480)
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 (291.528)
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 4700,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.093)
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