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


FIR TEXTIL KORDA N-TRAP SOFT COATED VERDE 20M, 15LBS

FIR TEXTIL KORDA N-TRAP SOFT COATED VERDE 20M, 15LBS

a.knt01
Livrare imediată!

90,58Lei

PLUMB KORDA CULISANT 5G PT.MONTURI 6BUC/PLIC -60%

PLUMB KORDA CULISANT 5G PT.MONTURI 6BUC/PLIC

a3.kfb5
Livrare imediată!

37,00Lei(-60%) 14,80Lei

INELE JAXON OVALE LATEX MONTURI
Exclusiv online!

INELE JAXON OVALE LATEX MONTURI

ac-359030a
Livrare 48-72 ore

6,50Lei

MONTURA Climax CULT CATFISH NATURAL BAIT COMBI RIG 180cm 120kg 2/0
Exclusiv online!

MONTURA Climax CULT CATFISH NATURAL BAIT COMBI RIG 180cm 120kg 2/0

9910-00018-130
Livrare 48-72 ore

71,00Lei

Manson Scurt Prowess Suplu Kaki
Exclusiv online!

Manson Scurt Prowess Suplu Kaki

acpr3150012
Livrare 48-72 ore

11,69Lei

Vartej Spro Butoias Cu Agrafa Interlock Nr 10 10 Buc 14 Kg
Exclusiv online!

Vartej Spro Butoias Cu Agrafa Interlock Nr 10 10 Buc 14 Kg

004551-00110-00000
Livrare 48-72 ore

7,29Lei

PB CARLIG BUNGY RING 6

PB CARLIG BUNGY RING 6

pb25051
Livrare imediată!

18,50Lei

FIR TEXTIL MIVARDI TERMINAL DYNEEMA 0.18MM 15MT

FIR TEXTIL MIVARDI TERMINAL DYNEEMA 0.18MM 15MT

miv-dtdg1518
Livrare imediată!

13,99Lei

INELE JAXON ROTUNDE MEDIUM MONTURI

INELE JAXON ROTUNDE MEDIUM MONTURI

ac-359010a
Livrare imediată!

12,40Lei

CARLIGE SPRO C-TEC LEGATE STOPPER VARTEJ BROWN CARLIG NR4 2 BUC/PLIC

CARLIGE SPRO C-TEC LEGATE STOPPER VARTEJ BROWN CARLIG NR4 2 BUC/PLIC

008620-00102-00000
Livrare imediată!

7,50Lei

Tava Modulara Plus 42 Suporturi Monturi/Linii Matrix Pole Winders Trays Light Blue 13cm
Exclusiv online!

Tava Modulara Plus 42 Suporturi Monturi/Linii Matrix Pole Winders Trays Light Blue 13cm

gpw001
Livrare 7-14 zile

155,21Lei

PB JELLY WIRE WEED-VEGETATIE 35LB 20M FIR FORFAC CU CAMASA

PB JELLY WIRE WEED-VEGETATIE 35LB 20M FIR FORFAC CU CAMASA

pb10024
Livrare imediată!

70,00Lei

OPRITOARE MOSTIRO SILICON MARIMEA L
Exclusiv online!

OPRITOARE MOSTIRO SILICON MARIMEA L

4051
Livrare 48-72 ore

1,80Lei

SET CARP SPIRIT 3BUC ANTI TANGLE LEAD CLIP WEED GREEN -21%

SET CARP SPIRIT 3BUC ANTI TANGLE LEAD CLIP WEED GREEN

acs010227
Livrare imediată!

42,99Lei(-21%) 33,90Lei

Struna Jaxon Sumato cu Ancore si Spirala X2, 10cm, 12kg

Struna Jaxon Sumato cu Ancore si Spirala X2, 10cm, 12kg

aj-pak10
Livrare imediată!

9,50Lei

Sistem Stocare Monturi FOX Zig Rig 5 Discuri Zig Plus 20 Pini de Fixare Plus Husa
Exclusiv online!

Sistem Stocare Monturi FOX Zig Rig 5 Discuri Zig Plus 20 Pini de Fixare Plus Husa

cac498
Livrare 7-14 zile

116,97Lei

Set Swivel Ring & Camo Tubing Extra Carp -27%

Set Swivel Ring & Camo Tubing Extra Carp

ec7944
Livrare imediată!

9,50Lei(-27%) 6,90Lei

MONTURA JAXON ANTITANGLE LEAD CLIP RIGID
Exclusiv online!

MONTURA JAXON ANTITANGLE LEAD CLIP RIGID

ac-3463
Livrare 48-72 ore

6,00Lei

Agrafa Vartej Sunset ST Rolling WT Shape Snap ST-S-1043 Nr8 19kg

Agrafa Vartej Sunset ST Rolling WT Shape Snap ST-S-1043 Nr8 19kg

412013306
Livrare imediată!

9,09Lei

Fir fluorocarbon Climax CULT CHIMERA SOFT FLUOROCARBON HOOKLINK 20m 0.40mm 20lb
Exclusiv online!

Fir fluorocarbon Climax CULT CHIMERA SOFT FLUOROCARBON HOOKLINK 20m 0.40mm 20lb

8700-10001-040
Livrare 48-72 ore

42,99Lei

Afişare 1781 - 1800 din 4580 (229 pagini)
Queries: 4, Total time: 121.080 ms [By time] [By id] [By file]
1 (0.096)
SELECT data
FROM `oc_session`
WHERE session_id = 'c4d4e172d1e7ba9ff1e10ff4f1'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (120.698)
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('+monturi' 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.168)
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