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


Suport Maver EVA pentru monturi 11 compartimente 4.5x20cm

Suport Maver EVA pentru monturi 11 compartimente 4.5x20cm

1262003
Livrare imediată!

10,00Lei

FIR MONOFILAMENT MIVARDI ROYAL SPINNING 0.205mm 200m 4.80kg -26%

FIR MONOFILAMENT MIVARDI ROYAL SPINNING 0.205mm 200m 4.80kg

miv-rs220
Livrare imediată!

25,50Lei(-26%) 18,90Lei

CUTIE RIGIDA SPRO FREESTYLE RIGGED BOXES M 19X12X4CM
Exclusiv online!

CUTIE RIGIDA SPRO FREESTYLE RIGGED BOXES M 19X12X4CM

006515-03200-00000
Livrare 48-72 ore

81,00Lei

Minciog Delphin mijloc din guma 2 tronsoane 60x60cm 200cm

Minciog Delphin mijloc din guma 2 tronsoane 60x60cm 200cm

942420030
Livrare imediată!

77,00Lei

FIR CARP EXPERT METHOD FEEDDER PINK 0.20MM 200m
Exclusiv online!

FIR CARP EXPERT METHOD FEEDDER PINK 0.20MM 200m

30127520
Livrare 24-48 ore

15,01Lei

Vartej DAM Madcat Power Swivels 140kg

Vartej DAM Madcat Power Swivels 140kg

403098152002
Livrare imediată!

26,68Lei

Lanseta Energo Team Koss Phantom 3m 200-500g 2seg

Lanseta Energo Team Koss Phantom 3m 200-500g 2seg

14176300
Livrare imediată!

238,00Lei

FIR MONOFILAMENT ATTACK SPECIAL CASTING 1200MT 0.35MM 9.0 KG

FIR MONOFILAMENT ATTACK SPECIAL CASTING 1200MT 0.35MM 9.0 KG

mfsfgly035
Livrare imediată!

33,20Lei

Pungi PVA Carp Spirit Soluron 10 buc plic 70x200mm

Pungi PVA Carp Spirit Soluron 10 buc plic 70x200mm

152500361
Livrare imediată!

12,99Lei

Carlige Energo Team Excalibur D-killer Ns Nr 2/0 10buc/plic

Carlige Energo Team Excalibur D-killer Ns Nr 2/0 10buc/plic

47055200
Livrare imediată!

8,00Lei

Carlige Maruto 2267-BN Nr 2/0 10buc/plic

Carlige Maruto 2267-BN Nr 2/0 10buc/plic

43602200
Livrare imediată!

9,50Lei

Fir Erson Taifun 200m 0.16mm

Fir Erson Taifun 200m 0.16mm

30091016
Livrare imediată!

7,50Lei

Lanterna Coleman cu LED Divide Plus 75

Lanterna Coleman cu LED Divide Plus 75

2000024455
Livrare imediată!

97,00Lei

Carlig Owner 50120 Nr.8 Kappa Style 3 15buc/plic -29%

Carlig Owner 50120 Nr.8 Kappa Style 3 15buc/plic

5012008
Livrare imediată!

9,40Lei(-29%) 6,68Lei

Fir textil YGK X-Braid X8 Upgrade PE Fluo Green 0.26mm 20.41kg 200m
Exclusiv online!

Fir textil YGK X-Braid X8 Upgrade PE Fluo Green 0.26mm 20.41kg 200m

x00725
Livrare 48-72ore

180,00Lei

Carlige Maruto 8355BD-BN Nr 8 10buc/plic
Exclusiv online!

Carlige Maruto 8355BD-BN Nr 8 10buc/plic

43202008
Livrare 24-48 ore

9,50Lei

Cort Coleman Kobuk Valley 4 Plus
Exclusiv online!

Cort Coleman Kobuk Valley 4 Plus

2000030281
Livrare 24-48 ore

1.199,00Lei

Porumb Zebco Trophy Sugar Mais Green Mussel 125gr

Porumb Zebco Trophy Sugar Mais Green Mussel 125gr

3802008
Livrare imediată!

26,78Lei

Fir monofilament P-Line CXX X-TRA Strong Crystal Clear 0.36mm/15.60kg/2000m

Fir monofilament P-Line CXX X-TRA Strong Crystal Clear 0.36mm/15.60kg/2000m

750186428
Livrare imediată!

113,00Lei

Inel EnergoTeam Bolognese BHSFSIG 8 SIC
Exclusiv online!

Inel EnergoTeam Bolognese BHSFSIG 8 SIC

81022008
Livrare 24-48 ore

6,00Lei

Afişare 1481 - 1500 din 4352 (218 pagini)
Queries: 6, Total time: 714.986 ms [By time] [By id] [By file]
1 (0.125)
SELECT data
FROM `oc_session`
WHERE session_id = '3de39fa91a325839fe6e30f63a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.117)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (688.536)
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 (pd.tag LIKE "%200%") 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 (25.805)
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 1480, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.196)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.207)
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