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


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

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

Fir Textil BERKLEY X5 FLURO VERDE 0.20MM/20.0KG/150M
Exclusiv online!

Fir Textil BERKLEY X5 FLURO VERDE 0.20MM/20.0KG/150M

p.1486749
Livrare 24-48 ore

88,61Lei

Swinger Carp Academy Detect Verde
Exclusiv online!

Swinger Carp Academy Detect Verde

6355-001
Livrare 48-72 ore

39,00Lei

KICKER KORDA RIG ALIGNER VERDE 10BUC/PL MARIMEA M
Exclusiv online!

KICKER KORDA RIG ALIGNER VERDE 10BUC/PL MARIMEA M

a.kick02
Livrare 24-48 ore

26,91Lei

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

FIR TEXTIL JAXON HEGEMON 8X FLASH 150m 0.22mm 25kg Verde Fluo

zj-deh022a
Livrare 48-72 ore

131,00Lei

SWINGER JAXON BRAN CU LUMINA VERDE -21%

SWINGER JAXON BRAN CU LUMINA VERDE

aj-sys201c
Livrare imediată!

72,99Lei(-21%) 57,91Lei

Swinger Carp Academy Fara Led Verde

Swinger Carp Academy Fara Led Verde

6352-001
Livrare imediată!

17,10Lei

FIR BERKLEY TEXTIL X9 LOW VIS VERDE 0.25MM 150M
Exclusiv online!

FIR BERKLEY TEXTIL X9 LOW VIS VERDE 0.25MM 150M

p.1486816
Livrare 24-48 ore

149,49Lei

Fir Textil BERKLEY X5 FLURO VERDE 0.17MM/17.0KG/150M
Exclusiv online!

Fir Textil BERKLEY X5 FLURO VERDE 0.17MM/17.0KG/150M

p.1486748
Livrare 24-48 ore

88,61Lei

Husa Lansete Nevis 165D 3Compartimente Verde
Exclusiv online!

Husa Lansete Nevis 165D 3Compartimente Verde

5202-166
Livrare 48-72 ore

190,00Lei

Geanta izoterma Baracuda B37 44x25x27cm verde

Geanta izoterma Baracuda B37 44x25x27cm verde

b37 geanta
Livrare imediată!

86,14Lei

LINGURITA ROTATIVA MEPPS BUG VERDE 7,0G
Exclusiv online!

LINGURITA ROTATIVA MEPPS BUG VERDE 7,0G

f.bug2.v
Livrare 24-48 ore

20,67Lei

Afişare 561 - 580 din 1279 (64 pagini)
Queries: 4, Total time: 28.364 ms [By time] [By id] [By file]
1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = '941365f4174f1da62860435fd1'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.074)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (27.991)
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.150)
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