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

Căutare

Produse ce potrivesc criteriilor de căutare


Sapca Nevis Verde
Exclusiv online!

Sapca Nevis Verde

8816-001
Livrare 48-72 ore

49,00Lei

Leadcore Delphin FIN LEAD Core 5m Verde Camuflaj 45lbs -26%

Leadcore Delphin FIN LEAD Core 5m Verde Camuflaj 45lbs

500735260
Livrare imediată!

28,00Lei(-26%) 20,69Lei

Fir Textil Delphin HERO Verde, 0.12mm, 8.20kg, 15m

Fir Textil Delphin HERO Verde, 0.12mm, 8.20kg, 15m

500793515
Livrare imediată!

10,00Lei

Husa Lansete Nevis 155D 3Compartimente Verde
Exclusiv online!

Husa Lansete Nevis 155D 3Compartimente Verde

5202-156
Livrare 48-72 ore

190,00Lei

Fir EnergoTeam Excalibur Feeder Fluo Galben-Verde Camou 300m 0.35mm

Fir EnergoTeam Excalibur Feeder Fluo Galben-Verde Camou 300m 0.35mm

34066035
Livrare imediată!

21,00Lei

FIR TEXTIL JAXON HEGEMON 8X FLASH 150m 0.14mm 15kg Verde Fluo
Exclusiv online!

FIR TEXTIL JAXON HEGEMON 8X FLASH 150m 0.14mm 15kg Verde Fluo

zj-deh014a
Livrare 48-72 ore

145,00Lei

Cordelina Coghlans verde 15.24m
Exclusiv online!

Cordelina Coghlans verde 15.24m

c1454
Livrare 24-48 ore

52,00Lei

JIG ROTUND MADAI 16gr GALBEN,ORANGE,VERDE TRABUCCO
Exclusiv online!

JIG ROTUND MADAI 16gr GALBEN,ORANGE,VERDE TRABUCCO

186-96-016
Livrare 48-72 ore

17,01Lei

Fir Textil Spiderwire Dura 4 Verde 014MM/11.8KG/150M
Exclusiv online!

Fir Textil Spiderwire Dura 4 Verde 014MM/11.8KG/150M

p.1450379
Livrare 24-48 ore

73,76Lei

Geanta lansete Baracuda B18 3 compartimente 160cm

Geanta lansete Baracuda B18 3 compartimente 160cm

b18 - geanta lans.3 comp. l 1.6m verde
Livrare imediată!

131,90Lei

KIT REPARATII BARCA ALLROUNDMARIN VERDE

KIT REPARATII BARCA ALLROUNDMARIN VERDE

am.563198
Livrare imediată!

71,13Lei

FIR TEXTIL JAXON HEGEMON 8X FLASH 150m 0.20mm 22kg Verde Fluo
Exclusiv online!

FIR TEXTIL JAXON HEGEMON 8X FLASH 150m 0.20mm 22kg Verde Fluo

zj-deh020a
Livrare 48-72 ore

131,00Lei

Fir textil WFT Strong Verde 0.08mm 150m
Exclusiv online!

Fir textil WFT Strong Verde 0.08mm 150m

30441108
Livrare 24-48 ore

154,00Lei

Mormasca Shark EM007093 Verde Phospho 1.40gr Carlig nr 6
Exclusiv online!

Mormasca Shark EM007093 Verde Phospho 1.40gr Carlig nr 6

803em00706140093
Livrare 48-72 ore

13,38Lei

JIG GAMAKATSU SKIP GAP SHAKY VERDE NR 3/0 3.5GR 4BUC
Exclusiv online!

JIG GAMAKATSU SKIP GAP SHAKY VERDE NR 3/0 3.5GR 4BUC

f2.gk.140315.03.3.5
Livrare 24-48 ore

30,96Lei

Hanorac Carp Spirit verde XXL -25%
Exclusiv online!

Hanorac Carp Spirit verde XXL

acs680088
Livrare 48-72ore

189,00Lei(-25%) 141,80Lei

Fir EnergoTeam Excalibur Feeder Fluo Galben-Verde Camou 300m 0.20mm
Exclusiv online!

Fir EnergoTeam Excalibur Feeder Fluo Galben-Verde Camou 300m 0.20mm

34066020
Livrare 24-48 ore

18,00Lei

Broasca Savage Gear 3D Pop Frog, Verde, 7cm, 20g -20%

Broasca Savage Gear 3D Pop Frog, Verde, 7cm, 20g

f1.sg.62029
Livrare imediată!

46,28Lei(-20%) 37,02Lei

Husa Lansete Nevis 145D 3Compartimente Verde
Exclusiv online!

Husa Lansete Nevis 145D 3Compartimente Verde

5202-146
Livrare 48-72 ore

179,00Lei

FIR TEXTIL JAXON HEGEMON 8X FLASH 150m 0.06mm 4kg Verde Fluo
Exclusiv online!

FIR TEXTIL JAXON HEGEMON 8X FLASH 150m 0.06mm 4kg Verde Fluo

zj-deh006a
Livrare 48-72 ore

162,99Lei

Afişare 561 - 580 din 1279 (64 pagini)
Queries: 11, Total time: 50.560 ms [By time] [By id] [By file]
1 (0.117)
SELECT data
FROM `oc_session`
WHERE session_id = 'b96b0122fb8c95c62b70b22643'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (31.122)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
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)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (MATCH(pd.tag) AGAINST('+verde' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:737
4 (0.239)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (7.031)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
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 match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 560, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.143)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (1.135)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
8 (0.119)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270
9 (0.287)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035
10 (10.112)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
11 (0.146)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38