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


MONTURA CORMORAN LINE ALIGNER RIG T3 NR.4/2BUC
Exclusiv online!

MONTURA CORMORAN LINE ALIGNER RIG T3 NR.4/2BUC

a.11.02301.4
Livrare 24-48 ore

22,40Lei

EXTRA CARP VARTEJ CU AGRAFA HOOK Nr 8 /22Kg/10Buc/Plic

EXTRA CARP VARTEJ CU AGRAFA HOOK Nr 8 /22Kg/10Buc/Plic

ec2925
Livrare imediată!

7,00Lei

Kit Montura Jaxon Plumb Pierdut

Kit Montura Jaxon Plumb Pierdut

ac-356411
Livrare imediată!

4,50Lei

MONTURA ENERGOTEAM FEEDER ROTUNDA 40GR
Exclusiv online!

MONTURA ENERGOTEAM FEEDER ROTUNDA 40GR

79265240
Livrare 24-48 ore

18,00Lei

Agrafa Vartej Sunset ST Rolling WT Shape Snap ST-S-1043 Nr10 14kg
Exclusiv online!

Agrafa Vartej Sunset ST Rolling WT Shape Snap ST-S-1043 Nr10 14kg

412013308
Livrare 48-72 ore

9,09Lei

Montura Plumb Pierdut EXTRA CARP, 3buc/pac

Montura Plumb Pierdut EXTRA CARP, 3buc/pac

ec7937
Livrare imediată!

8,50Lei

Kit Montura Extra Carp Helicopter, 5buc/plic

Kit Montura Extra Carp Helicopter, 5buc/plic

ec3786
Livrare imediată!

15,01Lei

MARGELE MONTURI CARP ZOOM SOFT 6 MM VERDE MAT
Exclusiv online!

MARGELE MONTURI CARP ZOOM SOFT 6 MM VERDE MAT

cz1786
Livrare 48-72 ore

8,50Lei

CARLIGE SPRO C-TEC LEGATE STOPPER VARTEJ BROWN CARLIG NR8 2 BUC/PLIC -31%

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

008620-00104-00000
Livrare imediată!

7,50Lei(-31%) 5,20Lei

Con Plumb Pierdut Nash Lead Clip, Silt, 10buc/plic -30%

Con Plumb Pierdut Nash Lead Clip, Silt, 10buc/plic

t8424
Livrare imediată!

19,99Lei(-30%) 13,99Lei

Montura Sunset ST-S-9343 Urfe Perles Phospho 70mm

Montura Sunset ST-S-9343 Urfe Perles Phospho 70mm

40111stsag13517cm
Livrare imediată!

9,31Lei

MONTURA MOSTIRO BOMBA VOPSITA TIJA PB INT FIR TEXTIL FIR DE PAR 2 AC NR 4

MONTURA MOSTIRO BOMBA VOPSITA TIJA PB INT FIR TEXTIL FIR DE PAR 2 AC NR 4

1701920100204
Livrare imediată!

9,00Lei

FIR COLMIC SHADE COLMICE FLUOROCARBON 50M 0.14mm
Exclusiv online!

FIR COLMIC SHADE COLMICE FLUOROCARBON 50M 0.14mm

nysh14
Livrare 48-72 ore

51,00Lei

LEADCORE MOSTIRO 35 LBS 10M SAND/GREEN

LEADCORE MOSTIRO 35 LBS 10M SAND/GREEN

2598
Livrare imediată!

27,30Lei

Fir Monofilament Sunset Amnesia Clear, 12lb/5.4kg, 100m

Fir Monofilament Sunset Amnesia Clear, 12lb/5.4kg, 100m

895181001
Livrare imediată!

40,00Lei

TUB PRO CARP TUNGSTEN JAXON GRI 1M -30%
Exclusiv online!

TUB PRO CARP TUNGSTEN JAXON GRI 1M

ac-pc037a
Livrare 48-72 ore

18,40Lei(-30%) 12,90Lei

Fir Fluorocarbon Jaxon Satori Premium Clear, 20m, 0.20mm, 8kg

Fir Fluorocarbon Jaxon Satori Premium Clear, 20m, 0.20mm, 8kg

zj-sagp020f
Livrare imediată!

24,00Lei

CARLIGE LEGATE DAIWA TOURNAMENT PT.CRAP NR.6/10BUC
Exclusiv online!

CARLIGE LEGATE DAIWA TOURNAMENT PT.CRAP NR.6/10BUC

a.14450.006
Livrare 24-48 ore

22,26Lei

Tub Siliconic 0.7mm Colmic
Exclusiv online!

Tub Siliconic 0.7mm Colmic

gs107
Livrare 48-72 ore

12,99Lei

Agrafa Vartej Sunset ST Rolling Insurance Snap ST-S-3006 Nr6 15kg
Exclusiv online!

Agrafa Vartej Sunset ST Rolling Insurance Snap ST-S-3006 Nr6 15kg

412015120
Livrare 48-72 ore

9,09Lei

Afişare 1641 - 1660 din 4583 (230 pagini)
Queries: 5, Total time: 116.405 ms [By time] [By id] [By file]
1 (0.116)
SELECT data
FROM `oc_session`
WHERE session_id = '9a97bd3fdb13e4215df342c6d0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (99.525)
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('+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 (16.551)
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 1640, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.104)
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