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 Monofilament Sunset Amnesia Clear, 10lb/4.5kg, 100m

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

755181000
Livrare imediată!

37,00Lei

Momitor Nevis Method Feeder la Distanta L 60gr

Momitor Nevis Method Feeder la Distanta L 60gr

8100-961
Livrare imediată!

10,81Lei

Monofilament Konger Techron Soft Nylon 150m 0.12mm -40%

Monofilament Konger Techron Soft Nylon 150m 0.12mm

218150012
Livrare imediată!

23,32Lei(-40%) 13,90Lei

Cizme Piept Pvc Nevis Nr 46
Exclusiv online!

Cizme Piept Pvc Nevis Nr 46

8815-046
Livrare 48-72 ore

220,00Lei

Inel EnergoTeam Bolognese GUN-SSFSIG LIGHT 25 SIC
Exclusiv online!

Inel EnergoTeam Bolognese GUN-SSFSIG LIGHT 25 SIC

81023125
Livrare 24-48 ore

12,99Lei

CARLIGE GAMAKATSU FORJATE LS-3340N NR 10 NI 25BUC/PL

CARLIGE GAMAKATSU FORJATE LS-3340N NR 10 NI 25BUC/PL

gk.146581.10
Livrare imediată!

18,34Lei

Carlig Owner 50281 Nr.16 Sode Light -23%

Carlig Owner 50281 Nr.16 Sode Light

5000707
Livrare imediată!

10,25Lei(-23%) 7,90Lei

FIR FLUOROCARBON TRILENE BERKLEY 150M 0.18MM 2.3KG -20%
Exclusiv online!

FIR FLUOROCARBON TRILENE BERKLEY 150M 0.18MM 2.3KG

1391581
Livrare 48-72 ore

79,50Lei(-20%) 63,61Lei

Gamakatsu Double NS 2

Gamakatsu Double NS 2

gk.147281.2
Livrare imediată!

29,11Lei

FIR MONOFILAMENT MOMOI HI-MAX EXTRA 0.181MM 150M -21%

FIR MONOFILAMENT MOMOI HI-MAX EXTRA 0.181MM 150M

himaxextra0181
Livrare imediată!

39,00Lei(-21%) 30,90Lei

INEL ENERGOTEAM 2 PICIOARE UVSIG LIGHT 20 SIC

INEL ENERGOTEAM 2 PICIOARE UVSIG LIGHT 20 SIC

81014120
Livrare imediată!

8,00Lei

MOMITOR CARP ZOOM METHOD FEEDER FANATIC XL 120GR

MOMITOR CARP ZOOM METHOD FEEDER FANATIC XL 120GR

cz8197
Livrare imediată!

21,00Lei

Opritor Tip Umbrela Carp Academy -39%

Opritor Tip Umbrela Carp Academy

8100-138
Livrare imediată!

6,40Lei(-39%) 3,90Lei

Shad Mann s Q-Paddler 7g 10cm Red Shad

Shad Mann s Q-Paddler 7g 10cm Red Shad

3281021
Livrare imediată!

8,78Lei

Inel EnergoTeam Lansete 2 picioare SEG : 25
Exclusiv online!

Inel EnergoTeam Lansete 2 picioare SEG : 25

81011025
Livrare 24-48 ore

8,50Lei

Inel EnergoTeam Bolognese GUN-SSFSIG LIGHT 10 SIC

Inel EnergoTeam Bolognese GUN-SSFSIG LIGHT 10 SIC

81023110
Livrare imediată!

7,00Lei

CICADA STRIKE PRO CYBER VIBE 3,5CM. 4,5G

CICADA STRIKE PRO CYBER VIBE 3,5CM. 4,5G

sp.jg005a.781
Livrare imediată!

29,55Lei

Set Crosete Iox Cu 2 Capete Carp Academy

Set Crosete Iox Cu 2 Capete Carp Academy

8100-125
Livrare imediată!

14,49Lei

NADA SENSAS 3000 READY LAKE 1,25KG

NADA SENSAS 3000 READY LAKE 1,25KG

a0.s10981
Livrare imediată!

40,92Lei

LANSETA JAXON GREY STREAM ULTRA SPIN 1.98M 2 12G

LANSETA JAXON GREY STREAM ULTRA SPIN 1.98M 2 12G

wj-dsb19812
Livrare imediată!

215,00Lei

Afişare 981 - 1000 din 3336 (167 pagini)
Queries: 5, Total time: 512.282 ms [By time] [By id] [By file]
1 (0.066)
SELECT data
FROM `oc_session`
WHERE session_id = '0d6d20eff34df4cded60b4b257'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.071)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (498.738)
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 (pd.tag LIKE "%81%%") 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 (13.288)
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 980, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.119)
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