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


Strună Delphin Wolfram BOMB cu vârtej si agrafă 40cm 14kg -29%

Strună Delphin Wolfram BOMB cu vârtej si agrafă 40cm 14kg

917211440
Stoc epuizat

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

Lanseta Delphin HAZARD 3.10M 500g

Lanseta Delphin HAZARD 3.10M 500g

160911420
Stoc epuizat

305,00Lei

Foarfeca îndoita DELPHIN 17.5cm -20%

Foarfeca îndoita DELPHIN 17.5cm

830921017
Stoc epuizat

29,00Lei(-20%) 23,21Lei

Mulineta Delphin MODECO Feeder Marime 60

Mulineta Delphin MODECO Feeder Marime 60

276001261
Stoc epuizat

151,80Lei

Lanseta Delphin BANG 2.15M 7-26g

Lanseta Delphin BANG 2.15M 7-26g

110382215
Stoc epuizat

174,00Lei

Mulineta Delphin MANTRA 12000

Mulineta Delphin MANTRA 12000

286034010
Stoc epuizat

217,90Lei

Fir monofilament Delphin CITRUS galben 0,25mm 11lbs 34800m

Fir monofilament Delphin CITRUS galben 0,25mm 11lbs 34800m

101001330
Stoc epuizat

1.075,00Lei

Mulineta Delphin NORD Marime 6000

Mulineta Delphin NORD Marime 6000

289029160
Stoc epuizat

121,50Lei

Lanseta Delphin ARMADA TRAVELER BlackWay 3.60m 3.00lbs

Lanseta Delphin ARMADA TRAVELER BlackWay 3.60m 3.00lbs

121210660
Stoc epuizat

307,00Lei

Pat Delphin GT6 Carpath

Pat Delphin GT6 Carpath

410095960
Stoc epuizat

870,00Lei

Suport swinger Delphin I-KSW, 1buc/pac

Suport swinger Delphin I-KSW, 1buc/pac

900021220-bucxxx
Stoc epuizat

4,11Lei

Set 4 Avertizoare + Statie Delphin CODER -30%

Set 4 Avertizoare + Statie Delphin CODER

101001355
Stoc epuizat

721,00Lei(-30%) 503,70Lei

Sac De Dormit Delphin ATRA 180x 80Cm

Sac De Dormit Delphin ATRA 180x 80Cm

410096020
Stoc epuizat

217,00Lei

LANSETA TELESCOPICA CRAP Delphin PARTISAN 2.40M 50G

LANSETA TELESCOPICA CRAP Delphin PARTISAN 2.40M 50G

101001348
Stoc epuizat

122,00Lei

Galeata Pliabila Delphin Cubo 10L -26%

Galeata Pliabila Delphin Cubo 10L

101001019
Stoc epuizat

46,01Lei(-26%) 34,00Lei

Avertizor Delphin pentru OPTIMO 9V CSWII cu Snag verde

Avertizor Delphin pentru OPTIMO 9V CSWII cu Snag verde

900022410
Stoc epuizat

133,30Lei

Lanseta Delphin Capri Tele 3.60M 180g

Lanseta Delphin Capri Tele 3.60M 180g

150852366
Stoc epuizat

228,00Lei

Maner Minciog Delphin ATOMA Feeder 320cm Tele -29%

Maner Minciog Delphin ATOMA Feeder 320cm Tele

941001570
Stoc epuizat

178,00Lei(-29%) 126,00Lei

Fir monofilament Delphin MAMBA Carp camuflaj 0.26mm 11.4lbs 6000m

Fir monofilament Delphin MAMBA Carp camuflaj 0.26mm 11.4lbs 6000m

101001666
Stoc epuizat

594,00Lei

Galeata Pliabila Delphin Cubo 5L -26%

Galeata Pliabila Delphin Cubo 5L

101001018
Stoc epuizat

42,99Lei(-26%) 32,00Lei

Afişare 2721 - 2740 din 4001 (201 pagini)
Queries: 5, Total time: 88.184 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = 'fcc4e829f6c3145122d1626517'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (73.874)
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('+delphin' 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 (14.015)
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 2720, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.094)
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