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


INEL FUJI TITANIUM TORZITE T-KTTG NR 8
Exclusiv online!

INEL FUJI TITANIUM TORZITE T-KTTG NR 8

mtkttg8
Livrare 48-72 ore

51,00Lei

LANSETA SPRO CRX BAITCASTING TWITCH 2.00 M 20-50 GR 2 BUC
Exclusiv online!

LANSETA SPRO CRX BAITCASTING TWITCH 2.00 M 20-50 GR 2 BUC

002410-00200-00000
Livrare 48-72 ore

340,99Lei

INELE JAXON VARF SIC/TS NR 12 6.0MM
Exclusiv online!

INELE JAXON VARF SIC/TS NR 12 6.0MM

ok-a1260
Livrare 48-72 ore

12,00Lei

INEL FUJI SIC SERIA K KBSG NR 6
Exclusiv online!

INEL FUJI SIC SERIA K KBSG NR 6

mkbsg6
Livrare 48-72 ore

32,00Lei

INEL VARF FUJI ALCONITE CCLGAT 5.5 1.8
Exclusiv online!

INEL VARF FUJI ALCONITE CCLGAT 5.5 1.8

mcclgat5518
Livrare 48-72 ore

21,00Lei

Inel Varf Fuji TITANIUM TORZITE T KGTT NR 4.5 1.6
Exclusiv online!

Inel Varf Fuji TITANIUM TORZITE T KGTT NR 4.5 1.6

mtkgtt4516
Livrare 48-72 ore

121,00Lei

Lanseta Spro C-TEC Governor Carp Spod New 3.90m 5lb 2seg

Lanseta Spro C-TEC Governor Carp Spod New 3.90m 5lb 2seg

002968-00391-00000
Livrare imediată!

315,00Lei

Lanseta Fox EOS Pro Spod Marker 3.60m 5lb 2seg -17%

Lanseta Fox EOS Pro Spod Marker 3.60m 5lb 2seg

crd334
Livrare imediată!

359,96Lei(-17%) 299,90Lei

LANSETA LINEAEFFE TS CARP STALKER 3.60M 3LBS 3SEG -20%
Exclusiv online!

LANSETA LINEAEFFE TS CARP STALKER 3.60M 3LBS 3SEG

l.2742336
Livrare 24-48 ore

178,85Lei(-20%) 143,09Lei

Lanseta spinning Baracuda Sooty 2.10M 10-40g 2SEG

Lanseta spinning Baracuda Sooty 2.10M 10-40g 2SEG

sooty 210
Livrare imediată!

144,92Lei

INEL FUJI TITANIUM TORZITE T-KWTG NR 8
Exclusiv online!

INEL FUJI TITANIUM TORZITE T-KWTG NR 8

mtkwtg8
Livrare 48-72 ore

65,50Lei

Lanseta Sportex Mystix Trout 1.88m 0.7-5g 2buc
Exclusiv online!

Lanseta Sportex Mystix Trout 1.88m 0.7-5g 2buc

my1800
Livrare 48-72 ore

1.460,00Lei

LANSETA JAXON GREY STREAM SPIN 2.85M 10-40GR
Exclusiv online!

LANSETA JAXON GREY STREAM SPIN 2.85M 10-40GR

wj-dsf28540
Livrare 48-72 ore

315,00Lei

VARF LANSETA MATRIX Spare Distance Tip 3.0oz Carbon
Exclusiv online!

VARF LANSETA MATRIX Spare Distance Tip 3.0oz Carbon

grd182
Livrare 7-14 zile

157,46Lei

Inel Varf Energo Team USSIT Light Sic 10x2.5mm
Exclusiv online!

Inel Varf Energo Team USSIT Light Sic 10x2.5mm

81910025
Livrare 24-48 ore

6,50Lei

Lanseta L&K Spin Blade Elite 2.70m 30-80g 2buc

Lanseta L&K Spin Blade Elite 2.70m 30-80g 2buc

13138272
Livrare imediată!

288,00Lei

LANSETA SPINNING CORMORAN RAYCOR X 2.05M, 3-10G, 2SEG
Exclusiv online!

LANSETA SPINNING CORMORAN RAYCOR X 2.05M, 3-10G, 2SEG

c.27.8001020
Livrare 24-48 ore

268,25Lei

INEL FUJI TITANIUM TORZITE T-KLTG NR 5.5L
Exclusiv online!

INEL FUJI TITANIUM TORZITE T-KLTG NR 5.5L

mtkltg5.5l
Livrare 48-72 ore

41,00Lei

VARF LANSETA MATRIX Spare Feeder Tip 1.5oz Carbon

VARF LANSETA MATRIX Spare Feeder Tip 1.5oz Carbon

grd179
Livrare imediată!

157,46Lei

VARF LANSETA TRABUCCO SPECTRUM XTC COMPETITION 1282 Tip Light 71cm
Exclusiv online!

VARF LANSETA TRABUCCO SPECTRUM XTC COMPETITION 1282 Tip Light 71cm

150-81-011
Livrare 48-72 ore

89,00Lei

Afişare 4361 - 4380 din 8578 (429 pagini)
Queries: 4, Total time: 207.501 ms [By time] [By id] [By file]
1 (0.183)
SELECT data
FROM `oc_session`
WHERE session_id = 'fbd6632782f191a09ea3162169'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (207.009)
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 = '3' AND (MATCH(pd.tag) AGAINST('+lanseta' 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.222)
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