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 300 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 POKEE Hyper Sense 12X Braid, 0.18mm, 13kg, 125m

Fir Textil POKEE Hyper Sense 12X Braid, 0.18mm, 13kg, 125m

hypsblg018
Livrare imediată!

130,00Lei

FIR TEXTIL JAXON HEGEMON SUPRA 12X 125m 0.16mm 20kg Dark Olive
Exclusiv online!

FIR TEXTIL JAXON HEGEMON SUPRA 12X 125m 0.16mm 20kg Dark Olive

zj-dsp016a
Livrare 48-72 ore

218,00Lei

Fir, Textil, POKEE, Hyper, Sense, 12X, Braid,, 0.14mm,, 10kg,, 125m, hypsblg014, Fire Textile Rapitori, Fire Textile Rapitori Pokee, Pokee
CUTIE, JAXON, DUBLA, NALUCI, RH186, 19x12x5CM, rh-186, Cutii, Cutii Jaxon, Jaxon

CUTIE, JAXON, DUBLA, NALUCI, RH186, 19x12x5CM, rh-186, Cutii, Cutii Jaxon, Jaxon

rh-186
Livrare imediată!

21,00Lei

FIR, TEXTIL, JAXON, HEGEMON, SUPRA, 12X, FLUO, 125m, 0.10mm, 8kg, zj-dsf010a, Fire Textile Rapitori, Fire Textile Rapitori Jaxon, Jaxon
FIR TEXTIL JAXON HEGEMON SUPRA 12X FLUO 125m 0.16mm 20kg
Exclusiv online!

FIR TEXTIL JAXON HEGEMON SUPRA 12X FLUO 125m 0.16mm 20kg

zj-dsf016a
Livrare 48-72 ore

218,00Lei

FIR, TEXTIL, JAXON, HEGEMON, SUPRA, 12X, FLUO, 125m, 0.06mm, 5kg, zj-dsf006a, Fire Textile Rapitori, Fire Textile Rapitori Jaxon, Jaxon
Fir Textil POKEE Hyper Sense 12X Braid, 0.16mm, 11kg, 125m

Fir Textil POKEE Hyper Sense 12X Braid, 0.16mm, 11kg, 125m

hypsblg016
Livrare imediată!

130,00Lei

Inel, Varf, Energo, Team, USSIT, Light, Sic, 12x4.0mm, 81912040, Inele de Lanseta, Inele de Lanseta EnergoTeam, Inele EnergoTeam, Lanseta EnergoTeam, EnergoTeam
CUTIE NALUCI JAXON RH317 23X12X3CM
Exclusiv online!

CUTIE NALUCI JAXON RH317 23X12X3CM

rh-317
Livrare 48-72 ore

21,00Lei

Fir, Textil, POKEE, Hyper, Sense, 12X, Braid,, 0.20mm,, 15kg,, 125m, hypsblg020, Fire Textile Rapitori, Fire Textile Rapitori Pokee, Pokee
FIR, TEXTIL, JAXON, HEGEMON, SUPRA, 12X, 125m, 0.20mm, 28kg, Dark, Olive, zj-dsp020a, Fire Textile Rapitori, Fire Textile Rapitori Jaxon, Jaxon
CUTIE, JAXON, DUBLA, NALUCI, RH185, 19x12x5CM, rh-185, Cutii, Cutii Jaxon, Jaxon
Exclusiv online!

CUTIE, JAXON, DUBLA, NALUCI, RH185, 19x12x5CM, rh-185, Cutii, Cutii Jaxon, Jaxon

rh-185
Livrare 48-72 ore

21,00Lei

FIR, TEXTIL, JAXON, HEGEMON, SUPRA, 12X, 125m, 0.06mm, 5kg, Dark, Olive, zj-dsp006a, Fire Textile Rapitori, Fire Textile Rapitori Jaxon, Jaxon
HUSA Maver IT REALITY BOLO 150x12x15cm
Exclusiv online!

HUSA Maver IT REALITY BOLO 150x12x15cm

6108002
Livrare 48-72 ore

240,00Lei

PLUTA Maver UK SIGNATURE INLINE STICK 12x4
Exclusiv online!

PLUTA Maver UK SIGNATURE INLINE STICK 12x4

h2693
Livrare 48-72 ore

19,00Lei

Cutie Kamasaki Feeder Accesorii Monturi Diverse 12x6x3cm

Cutie Kamasaki Feeder Accesorii Monturi Diverse 12x6x3cm

12044504
Livrare imediată!

24,00Lei

POP-UP MAINLINE WAFTER BARRELS PEACH 12X15MM

POP-UP MAINLINE WAFTER BARRELS PEACH 12X15MM

a0.m.m35002
Livrare imediată!

42,08Lei

POP-UP MAINLINE WAFTER BARRELS BLACKCURRANT 12X15MM
Exclusiv online!

POP-UP MAINLINE WAFTER BARRELS BLACKCURRANT 12X15MM

a0.m.m35004
Livrare 24-48 ore

42,08Lei

Husa 4 lansete DAM Rod Bag 165cm 165x12x28cm
Exclusiv online!

Husa 4 lansete DAM Rod Bag 165cm 165x12x28cm

9050960352
Livrare 48-72 ore

248,54Lei

Afişare 61 - 80 din 144 (8 pagini)
Queries: 10, Total time: 165.705 ms [By time] [By id] [By file]
1 (0.146)
SELECT data
FROM `oc_session`
WHERE session_id = '7c613150eb346f446664885515'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (162.236)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%12x%") 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:698
4 (0.149)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (0.896)
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 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.321)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1209
7 (0.114)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1231
8 (0.116)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:996
9 (1.502)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:910
10 (0.119)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38