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

Produse ce potrivesc criteriilor de căutare


INEL FUJI SIC LSG NR 7

INEL FUJI SIC LSG NR 7

mlsg7
Livrare imediată!

24,00Lei

INEL LINEAEFE VIRF SIC TUB=3,5MM/D=8,0MM
Exclusiv online!

INEL LINEAEFE VIRF SIC TUB=3,5MM/D=8,0MM

a9.2999535
Livrare 24-48 ore

2,81Lei

INEL LINEAEFE VIRF SIC TUB=5,0MM/D=12,0MM

INEL LINEAEFE VIRF SIC TUB=5,0MM/D=12,0MM

a9.2999550
Livrare imediată!

3,37Lei

INEL VARF FUJI TITANIUM TORZITE T-MNTT NR 6 2.8
Exclusiv online!

INEL VARF FUJI TITANIUM TORZITE T-MNTT NR 6 2.8

mtmntt628
Livrare 48-72 ore

127,00Lei

Lanseta Rapture Edge Master 2.13m 2-10g
Exclusiv online!

Lanseta Rapture Edge Master 2.13m 2-10g

126-53-200
Livrare 48-72 ore

850,01Lei

Lanseta Savage Gear SG4 Ultra Light Game 2.21m 3-10g
Exclusiv online!

Lanseta Savage Gear SG4 Ultra Light Game 2.21m 3-10g

o.sg.72192
Livrare 24-48 ore

489,61Lei

Lanseta Sert Exceed Agressor 1.90m 10-35g
Exclusiv online!

Lanseta Sert Exceed Agressor 1.90m 10-35g

20401seprj8737190-2m
Livrare 48-72 ore

201,38Lei

INEL LINEAEFFE 1 PICIOR SIC KTTSG NR.5

INEL LINEAEFFE 1 PICIOR SIC KTTSG NR.5

a9.2998105
Livrare imediată!

3,93Lei

Lanseta spinning Baracuda Predator XP 2702 12-40g 2seg

Lanseta spinning Baracuda Predator XP 2702 12-40g 2seg

predator xp 2702
Livrare imediată!

146,91Lei

Lanseta Delphin XAWER TeleFLOAT 360cm 30g

Lanseta Delphin XAWER TeleFLOAT 360cm 30g

101001411
Livrare imediată!

185,00Lei

Lanseta Rapture Edge Master 2.28m 2-10g
Exclusiv online!

Lanseta Rapture Edge Master 2.28m 2-10g

126-53-400
Livrare 48-72 ore

780,00Lei

Lanseta Telescopica Delphin Telepikes 6.00M 85g

Lanseta Telescopica Delphin Telepikes 6.00M 85g

101000556
Livrare imediată!

244,70Lei

INEL JAXON PICIOARE DUBLE SIC KW 16
Exclusiv online!

INEL JAXON PICIOARE DUBLE SIC KW 16

ok-sn016
Livrare 48-72 ore

17,01Lei

INEL LINEAEFE VIRF SIC TUB=6,0MM/D=16,0MM
Exclusiv online!

INEL LINEAEFE VIRF SIC TUB=6,0MM/D=16,0MM

a9.2999560
Livrare 24-48 ore

4,50Lei

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

Inel Varf Fuji TITANIUM TORZITE T KGTT NR 4.5 2.2

mtkgtt4522
Livrare 48-72 ore

121,00Lei

INEL FUJI TITANIUM TORZITE T-KLTG NR 10H
Exclusiv online!

INEL FUJI TITANIUM TORZITE T-KLTG NR 10H

mtkltg10h
Livrare 48-72 ore

83,00Lei

Lanseta Baracuda Passion Power 2.70M 40-125g 2SEG

Lanseta Baracuda Passion Power 2.70M 40-125g 2SEG

passion power 2702
Livrare imediată!

180,20Lei

Lanseta Rapture Edge Master 1.95m 1-7gG
Exclusiv online!

Lanseta Rapture Edge Master 1.95m 1-7gG

126-53-100
Livrare 48-72 ore

780,00Lei

INEL FUJI TITANIUM TORZITE T-KLTG NR 20H
Exclusiv online!

INEL FUJI TITANIUM TORZITE T-KLTG NR 20H

mtkltg20h
Livrare 48-72 ore

184,00Lei

Lanseta Daiwa Fuego UL Trout 1.80m 1.5-5g 2seg
Exclusiv online!

Lanseta Daiwa Fuego UL Trout 1.80m 1.5-5g 2seg

d.11124.180
Livrare 24-48 ore

339,38Lei

Afişare 4361 - 4380 din 8579 (429 pagini)
Queries: 6, Total time: 270.113 ms [By time] [By id] [By file]
1 (0.124)
SELECT data
FROM `oc_session`
WHERE session_id = '20b8c367db627c515513c19797'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.100)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.118)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (235.324)
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:724
5 (34.185)
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 4360, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.262)
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