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 300 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

Căutare

Produse ce potrivesc criteriilor de căutare


Carlige Feeder Claumar CLM-3 Micro Barbed Teflon Technology 10Buc/Plic Nr 12

Carlige Feeder Claumar CLM-3 Micro Barbed Teflon Technology 10Buc/Plic Nr 12

clm222107
Livrare imediată!

10,90Lei

Gratar Instant Mini Grill 30x25x5cm

Gratar Instant Mini Grill 30x25x5cm

4750721000501
Livrare imediată!

15,90Lei

Pelete Crap Claumar Red Krill 4.5mm 800gr

Pelete Crap Claumar Red Krill 4.5mm 800gr

clm242105
Livrare imediată!

34,90Lei

Plumb ZHEN LEADS Long Cast Cu Vartej Vopsit Maro Camu 120Gr

Plumb ZHEN LEADS Long Cast Cu Vartej Vopsit Maro Camu 120Gr

clm64210120
Livrare imediată!

6,72Lei

Plumb ZHEN LEADS Long Cast Cu Vartej Vopsit Maro Camu 130Gr

Plumb ZHEN LEADS Long Cast Cu Vartej Vopsit Maro Camu 130Gr

clm64210130
Livrare imediată!

7,20Lei

Plumb ZHEN LEADS Long Cast Cu Vartej Vopsit Maro Camu 70Gr

Plumb ZHEN LEADS Long Cast Cu Vartej Vopsit Maro Camu 70Gr

clm64210070
Livrare imediată!

3,92Lei

Plumb ZHEN LEADS Long Cast Cu Vartej Vopsit Maro Camu 90Gr

Plumb ZHEN LEADS Long Cast Cu Vartej Vopsit Maro Camu 90Gr

clm64210090
Livrare imediată!

5,05Lei

Lanseta FL FLX10 3.96M 3.75Lbs 3Seg

Lanseta FL FLX10 3.96M 3.75Lbs 3Seg

1153210103890
Livrare imediată!

358,20Lei

Lanseta Fox Rage Warrior Light Spin, 210cm, 5-15gr

Lanseta Fox Rage Warrior Light Spin, 210cm, 5-15gr

nrd343
Livrare imediată!

269,95Lei

CORT FOX FRONTIER XD 270 x 210 x 165cm -10%

CORT FOX FRONTIER XD 270 x 210 x 165cm

cum300
Livrare imediată!

3.599,96Lei(-10%) 3.255,79Lei

Lanseta Feeder FL AQUA River Feeder 4.20M 100-200Gr 3Seg

Lanseta Feeder FL AQUA River Feeder 4.20M 100-200Gr 3Seg

6153210823977
Livrare imediată!

289,90Lei

Mulineta Mifine FA 6000

Mulineta Mifine FA 6000

7133172101442
Livrare imediată!

98,40Lei

CORT FOX FRONTIER XD 270 x 210 x 165cm PLUS INNER DOME -14%

CORT FOX FRONTIER XD 270 x 210 x 165cm PLUS INNER DOME

cum302
Livrare imediată!

4.115,10Lei(-14%) 3.519,00Lei

LANSETA CASTING DAIWA 2SEG TATULA BAITCAST 2.15M 8-35G
Exclusiv online!

LANSETA CASTING DAIWA 2SEG TATULA BAITCAST 2.15M 8-35G

d.11460.210
Livrare 24-48 ore

817,71Lei

LANSETA SPINNING CORMORAN 2SEG CROSS WATER POWER STICK 2.10M 7-28G -20%
Exclusiv online!

LANSETA SPINNING CORMORAN 2SEG CROSS WATER POWER STICK 2.10M 7-28G

c.27.4028210
Livrare 24-48 ore

248,17Lei(-20%) 198,54Lei

Lanseta spinning EnergoTeam BOKOR PRO SPIN 2.10m 7-21/10-30g 1Seg Plus 2 tronsoane

Lanseta spinning EnergoTeam BOKOR PRO SPIN 2.10m 7-21/10-30g 1Seg Plus 2 tronsoane

13175210
Livrare imediată!

243,00Lei

LANSETA SPINNING DAIWA 2SEG CALDIA LURE SPIN 2.10M 7-21G -40%

LANSETA SPINNING DAIWA 2SEG CALDIA LURE SPIN 2.10M 7-21G

d.11480.210
Livrare imediată!

499,45Lei(-40%) 299,67Lei

LANSETA SPINNING DAIWA 2SEG NINJA X SPIN 2.10M 3-15G

LANSETA SPINNING DAIWA 2SEG NINJA X SPIN 2.10M 3-15G

d.11205.210
Livrare imediată!

221,69Lei

CAP MINCIOG TRABUCCO GNT BLACK EDITION HEAD QUICKDRY 4 ROUND 50 50X40X30
Exclusiv online!

CAP MINCIOG TRABUCCO GNT BLACK EDITION HEAD QUICKDRY 4 ROUND 50 50X40X30

083-67-210
Livrare 48-72 ore

80,00Lei

Cutie Krabica Delphin TBX Duo 210-12P Clip 210x165x40mm

Cutie Krabica Delphin TBX Duo 210-12P Clip 210x165x40mm

101000502
Livrare imediată!

30,00Lei

Afişare 1 - 20 din 1424 (72 pagini)
Queries: 10, Total time: 1,342.878 ms [By time] [By id] [By file]
1 (0.124)
SELECT data
FROM `oc_session`
WHERE session_id = '3c222b157fdd6ed26a54f3b61f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (848.810)
SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%210%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555
5 (465.171)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%210%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.159)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '3' AND p2c.category_id = '226' AND (pd.tag LIKE "%210%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1014
7 (28.057)
SELECT COUNT(*) AS val, filter_group, filter_id
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '3' AND p2c.category_id = '226' AND (pd.tag LIKE "%210%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE f.language_id = '2' AND f.filter_group NOT LIKE 'a%' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:923
8 (0.133)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.116)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.087)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38