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


Cap minciog Delphin ATM Floaty RN VARIO 50X40cm -37%

Cap minciog Delphin ATM Floaty RN VARIO 50X40cm

101001548
Livrare imediată!

101,99Lei(-37%) 64,00Lei

Cap, minciog, Delphin, ATM, Floaty, RN, X-Deep, 50x40cm, 101001542, Capete de Minciog, Capete de Minciog Delphin, Capete de Minciog, Capete de Minciog Delphin, Delphin -25%
Cap, minciog, Delphin, ATM, Floaty, NYLO, VARI, 50x40cm, 101001550, Capete de Minciog, Capete de Minciog Delphin, Capete de Minciog, Capete de Minciog Delphin, Delphin -56%
Juvelnic Patrat Team Feeder By Dome 1.50m 50x40cm

Juvelnic Patrat Team Feeder By Dome 1.50m 50x40cm

4265-150
Livrare imediată!

131,99Lei

CAP MINCIOG DAIWA N ZONE 50X40CM

CAP MINCIOG DAIWA N ZONE 50X40CM

a2.m13420.050
Livrare imediată!

72,84Lei

Juvelnic Preston Carp Mesh Keepnet 50x40cm

Juvelnic Preston Carp Mesh Keepnet 50x40cm

p0140048
Livrare imediată!

247,46Lei

Juvelnic DAM O.T.T. Keepnet Micro Mesh 3.00m 50x40cm 2mm

Juvelnic DAM O.T.T. Keepnet Micro Mesh 3.00m 50x40cm 2mm

5050974993
Livrare imediată!

253,71Lei

Juvelnic Patrat Team Feeder By Dome 2m 50x40cm

Juvelnic Patrat Team Feeder By Dome 2m 50x40cm

4265-200
Livrare imediată!

154,00Lei

Juvelnic Patrat Team Feeder By Dome 3m 50x40cm

Juvelnic Patrat Team Feeder By Dome 3m 50x40cm

4265-300
Livrare imediată!

197,00Lei

CAP DE MINCIOG GURU BARB SAFE 500 NET 50X40CM
Exclusiv online!

CAP DE MINCIOG GURU BARB SAFE 500 NET 50X40CM

a2.gu.glnb50
Livrare 24-48 ore

78,94Lei

Minciog, DAM, Base-X, Landing, Net, 2seg,, 50x50x40cm,, 1.50m, a2.dam.60830, Mincioguri Rapitor, Mincioguri Rapitor DAM, DAM
Cap Minciog Garbolino Latex Match 50x40cm

Cap Minciog Garbolino Latex Match 50x40cm

50330gomnj6415-50x40
Livrare imediată!

101,58Lei

Minciog, Telescopic, DAM, Ontario, V2, Nylon, Folding, Net, 50x50x40cm,, 6mm, a2.dam.65465, Mincioguri Rapitor, Mincioguri Rapitor DAM, DAM
Minciog, DAM, Alu, Head, Tele, Cauciuc, 50x50x40cm, 2.0m, 50109608422, Mincioguri Rapitor, Mincioguri Rapitor DAM, DAM
Exclusiv online!

Minciog, DAM, Alu, Head, Tele, Cauciuc, 50x50x40cm, 2.0m, 50109608422, Mincioguri Rapitor, Mincioguri Rapitor DAM, DAM

50109608422
Livrare 48-72 ore

127,37Lei

Minciog, DAM, Alu, Head, Tele, Cauciuc, 50x50x40cm, 1.7m, 50109608421, Mincioguri Rapitor, Mincioguri Rapitor DAM, DAM
Exclusiv online!

Minciog, DAM, Alu, Head, Tele, Cauciuc, 50x50x40cm, 1.7m, 50109608421, Mincioguri Rapitor, Mincioguri Rapitor DAM, DAM

50109608421
Livrare 48-72 ore

111,51Lei

Cap Minciog Garbolino Latex Carp Scoop 50x40cm
Exclusiv online!

Cap Minciog Garbolino Latex Carp Scoop 50x40cm

50330gomnj6410-50x40
Livrare 48-72 ore

101,46Lei

Cap Minciog Maver Cauciucat Signature Hyper-Lite 50x40cm
Exclusiv online!

Cap Minciog Maver Cauciucat Signature Hyper-Lite 50x40cm

e605
Livrare 48-72 ore

128,00Lei

MINCIOG RAPTURE WADING NET COMPACT RUBBA M 50x40cm

MINCIOG RAPTURE WADING NET COMPACT RUBBA M 50x40cm

084-51-810
Livrare imediată!

199,00Lei

Cap Minciog Garbolino Light Scoop 50x40cm
Exclusiv online!

Cap Minciog Garbolino Light Scoop 50x40cm

50330gomnj6405-50x40
Livrare 48-72 ore

76,16Lei

MINCIOG RAPTURE KYK NET RUBBA M 50x40cm/135cm
Exclusiv online!

MINCIOG RAPTURE KYK NET RUBBA M 50x40cm/135cm

084-51-900
Livrare 48-72 ore

220,00Lei

Afişare 41 - 60 din 83 (5 pagini)
Queries: 9, Total time: 174.855 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = '25a417fec01804234631b25fc2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (172.513)
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 = '2' AND (pd.tag LIKE "%50x40cm%") 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.176)
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.644)
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 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.265)
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.111)
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
8 (0.815)
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
9 (0.115)
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