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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


FIR TRABUCCO T-FORCE XPS ULTRA SOFT FC403 50MT 0.201MM

FIR TRABUCCO T-FORCE XPS ULTRA SOFT FC403 50MT 0.201MM

053-58-200
Livrare imediată!

49,00Lei

FIR KORDA TEXTIL SUPERNATURAL SOFT VERDE 25LBS/20M
Exclusiv online!

FIR KORDA TEXTIL SUPERNATURAL SOFT VERDE 25LBS/20M

a.ksng25
Livrare 24-48 ore

70,04Lei

Plumb Sondare Carp Spirit Marker Lead 140g

Plumb Sondare Carp Spirit Marker Lead 140g

acs550102
Livrare imediată!

21,00Lei

Carlig Owner CT-5 Teflonat Carp Iseama Nr.8

Carlig Owner CT-5 Teflonat Carp Iseama Nr.8

5000051
Livrare imediată!

18,17Lei

CARLIGE HAYABUSA CHN121GO NR 2 15BUC
Exclusiv online!

CARLIGE HAYABUSA CHN121GO NR 2 15BUC

7127
Livrare 48-72 ore

13,10Lei

FIR TEXTIL EXTRA CARP DYNA TEC LEADER 10 M 0.18MM 13.50 KG
Exclusiv online!

FIR TEXTIL EXTRA CARP DYNA TEC LEADER 10 M 0.18MM 13.50 KG

ec2672
Livrare 48-72 ore

9,00Lei

MOMITOR CU ANTITANGLE JAXON 15GR 21cm 25BUC/PLIC
Exclusiv online!

MOMITOR CU ANTITANGLE JAXON 15GR 21cm 25BUC/PLIC

aj-051
Livrare 48-72 ore

134,01Lei

Plumb cu agrafa Delphin BARBED 120g -30%

Plumb cu agrafa Delphin BARBED 120g

830511120
Livrare imediată!

10,00Lei(-30%) 7,00Lei

Aligner PB Products X - Stiff Curved Silt 8buc/plic silt

Aligner PB Products X - Stiff Curved Silt 8buc/plic silt

pb20611
Livrare imediată!

22,00Lei

Anouri Carp Expert Rotunde D-Rig Chod Rig Nr.2 (20buc)

Anouri Carp Expert Rotunde D-Rig Chod Rig Nr.2 (20buc)

82197202
Livrare imediată!

8,00Lei

FIR TEXTIL KRYSTON QUICKSILVER GRAVEL BROWN 25M 35LBS
Exclusiv online!

FIR TEXTIL KRYSTON QUICKSILVER GRAVEL BROWN 25M 35LBS

krqs2
Livrare 48-72 ore

56,00Lei

Carlige Owner Cut Gure 50330, Auriu, Nr.1/0, 7buc/plic -23%

Carlige Owner Cut Gure 50330, Auriu, Nr.1/0, 7buc/plic

5033006
Livrare imediată!

12,88Lei(-23%) 9,90Lei

Nada Benzar Mix Baza Crap 1kg

Nada Benzar Mix Baza Crap 1kg

94005048
Livrare imediată!

11,50Lei

CARLIGE FUDO DELTA GURE BLACK NICKEL NR.7 -20%

CARLIGE FUDO DELTA GURE BLACK NICKEL NR.7

0021-7
Livrare imediată!

10,00Lei(-20%) 8,00Lei

Carlig Owner Cps 5106 Negru Nr 6 - 9buc/plic
Exclusiv online!

Carlig Owner Cps 5106 Negru Nr 6 - 9buc/plic

5106005
Livrare 48-72 ore

18,75Lei

FIR TEXTIL EXTRA CARP DYNA TEC LEADER 10 M 0.30MM 22.60 KG

FIR TEXTIL EXTRA CARP DYNA TEC LEADER 10 M 0.30MM 22.60 KG

ec2719
Livrare imediată!

9,00Lei

PLUMB IN LINE EXTRA CARP PLAT PEAR 100 gr

PLUMB IN LINE EXTRA CARP PLAT PEAR 100 gr

ec3908-100
Livrare imediată!

7,00Lei

CARLIG GAMAKATSU FORJAT LS-3510F BL 10BUC/PLIC NR. 1

CARLIG GAMAKATSU FORJAT LS-3510F BL 10BUC/PLIC NR. 1

gk.147968.1
Livrare imediată!

12,20Lei

Fir Textil CPK Semistiff Skin Hooklink Brown 25lb 10m

Fir Textil CPK Semistiff Skin Hooklink Brown 25lb 10m

999951
Livrare imediată!

32,00Lei

PROLOGIC MAGOT CLIP LM 8MM 20BUC/PLIC -40%

PROLOGIC MAGOT CLIP LM 8MM 20BUC/PLIC

a.pro.49945
Livrare imediată!

29,52Lei(-40%) 17,71Lei

Afişare 4501 - 4520 din 10407 (521 pagini)
Queries: 6, Total time: 279.495 ms [By time] [By id] [By file]
1 (0.118)
SELECT data
FROM `oc_session`
WHERE session_id = '78d9b9d24aa5f7952ba3d5d665'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.115)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.125)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (239.862)
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('+crap' 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
5 (39.077)
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 4500, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.198)
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