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 Carp Spirit Reaction Braid Camo Brown 20m 35lbs 15.90kg

Fir Textil Carp Spirit Reaction Braid Camo Brown 20m 35lbs 15.90kg

acs640065
Livrare imediată!

45,01Lei

Fir Textil Jaxon SUMATO PREMIUM 10m 0.25mm

Fir Textil Jaxon SUMATO PREMIUM 10m 0.25mm

zj-rap025c
Livrare imediată!

11,00Lei

Montura Savage Gear Carbon Ancore Nr. 6/6.5 Cm

Montura Savage Gear Carbon Ancore Nr. 6/6.5 Cm

a.sg.54878
Livrare imediată!

26,70Lei

Agrafe Delphin A 01 BN NR.8 -2%

Agrafe Delphin A 01 BN NR.8

969a01008
Livrare imediată!

5,00Lei(-2%) 4,90Lei

MONTURA PROLOGIC STIFF 15CM/28LBS CU CARLIG XC7 NR.4
Exclusiv online!

MONTURA PROLOGIC STIFF 15CM/28LBS CU CARLIG XC7 NR.4

a.pro.50139
Livrare 24-48 ore

25,64Lei

FIR TEXTIL EXTRA CARP DYNA TEC LEADER 10 M 0.22MM 17.20 KG

FIR TEXTIL EXTRA CARP DYNA TEC LEADER 10 M 0.22MM 17.20 KG

ec2696
Livrare imediată!

9,00Lei

Agrafa Nevis NR.00 Silver
Exclusiv online!

Agrafa Nevis NR.00 Silver

5524-100
Livrare 48-72 ore

4,20Lei

Rig Strategy Position Snowman Rig Nr.8

Rig Strategy Position Snowman Rig Nr.8

008541-00308-00000
Livrare imediată!

15,80Lei

Fir Monofilament Carp Spirit Monturi Riga Mortis Lo-Vis-Brown 20m 25lbs 11.30kg

Fir Monofilament Carp Spirit Monturi Riga Mortis Lo-Vis-Brown 20m 25lbs 11.30kg

acs640052
Livrare imediată!

39,00Lei

Fir Monofilament Sunset Amnesia Clear, 10lb/4.5kg, 100m

Fir Monofilament Sunset Amnesia Clear, 10lb/4.5kg, 100m

755181000
Livrare imediată!

37,00Lei

Opritoare Mostiro cauciuc negre Marimea M

Opritoare Mostiro cauciuc negre Marimea M

4056
Livrare imediată!

2,00Lei

Montura Savage Gear Carbon Ancore Nr. 4/7.5 Cm

Montura Savage Gear Carbon Ancore Nr. 4/7.5 Cm

a.sg.54879
Livrare imediată!

27,49Lei

RECIPIENT KORDA MIC PT DIPUIRE BOILIES INFUZA
Exclusiv online!

RECIPIENT KORDA MIC PT DIPUIRE BOILIES INFUZA

a.kinzs
Livrare 24-48 ore

34,84Lei

Fir textil Kryston Super Nova Solid Bag Supple Dark Silt 35lb 20m

Fir textil Kryston Super Nova Solid Bag Supple Dark Silt 35lb 20m

krsu12
Livrare imediată!

48,00Lei

SUPORT ENERGOTEAM MONTURI FEEDER 8 POZITII 6,5CM

SUPORT ENERGOTEAM MONTURI FEEDER 8 POZITII 6,5CM

80306065
Livrare imediată!

34,11Lei

Vartej Extra Carp cu Agrafa Snap, Nr.16/13kg 10buc/plic
Exclusiv online!

Vartej Extra Carp cu Agrafa Snap, Nr.16/13kg 10buc/plic

ec6939
Livrare 48-72 ore

6,00Lei

FIR MONOFILAMENT CARBOTEX FLUOROCARBON 035MM/12,50KG/30M
Exclusiv online!

FIR MONOFILAMENT CARBOTEX FLUOROCARBON 035MM/12,50KG/30M

e.3000.035
Livrare 24-48 ore

31,89Lei

Fir textil CPK Silky Natural Feeder Hooklink Brown 0.14mm/5.44kg/15m

Fir textil CPK Silky Natural Feeder Hooklink Brown 0.14mm/5.44kg/15m

999959
Livrare imediată!

29,00Lei

FIR TEXTIL DYNEEMAX KAMASAKI FORFAC 0.25MM 10M
Exclusiv online!

FIR TEXTIL DYNEEMAX KAMASAKI FORFAC 0.25MM 10M

34020025
Livrare 24-48 ore

9,50Lei

Stoper Zebco Silicone Bung SS

Stoper Zebco Silicone Bung SS

3163002
Livrare imediată!

8,78Lei

Afişare 1781 - 1800 din 4582 (230 pagini)
Queries: 4, Total time: 95.236 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = '8d3cbae51541351ad940faba5d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (94.829)
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.195)
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