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


PLUTA ARROW BALSA CULISANTA 6.00G A1.V220.060

PLUTA ARROW BALSA CULISANTA 6.00G A1.V220.060

a1.v220.060
Livrare imediată!

4,61Lei

Inel EnergoTeam Bolognese BHSFSIG 20 SIC
Exclusiv online!

Inel EnergoTeam Bolognese BHSFSIG 20 SIC

81022020
Livrare 24-48 ore

12,00Lei

Geanta Spinning Reiva 41x25x20 cm 4 cutii
Exclusiv online!

Geanta Spinning Reiva 41x25x20 cm 4 cutii

5220-002
Livrare 48-72 ore

260,00Lei

Momitor Delphin striat cu tub 20g

Momitor Delphin striat cu tub 20g

925001220
Livrare imediată!

6,00Lei

MOMITOR JAXON METHOD FEEDER B2 20GR -20%

MOMITOR JAXON METHOD FEEDER B2 20GR

af-b220
Livrare imediată!

16,01Lei(-20%) 12,80Lei

Carlig Delphin HKD Feeder SMUTER NR.10 -35%

Carlig Delphin HKD Feeder SMUTER NR.10

622060010
Livrare imediată!

12,00Lei(-35%) 7,79Lei

PLUMB SPRO DROP SHOT CU AGRAFA 5.2G 5 BUCATI
Exclusiv online!

PLUMB SPRO DROP SHOT CU AGRAFA 5.2G 5 BUCATI

004622-02200-00052
Livrare 48-72 ore

12,30Lei

FIR MONOFILAMENT MIVARDI ROYAL FEEDER 0.205 mm 200m 4.8kg

FIR MONOFILAMENT MIVARDI ROYAL FEEDER 0.205 mm 200m 4.8kg

miv-rf220
Livrare imediată!

25,50Lei

Carlig Delphin HKD BAITHOLDER NR.10 -36%

Carlig Delphin HKD BAITHOLDER NR.10

622035010
Livrare imediată!

11,00Lei(-36%) 7,00Lei

Carlig Delphin HKD BAITHOLDER NR.1 -32%

Carlig Delphin HKD BAITHOLDER NR.1

622035001
Livrare imediată!

12,00Lei(-32%) 8,20Lei

Geanta Spinning Reiva 28x11x18 cm 2 cutii

Geanta Spinning Reiva 28x11x18 cm 2 cutii

5220-007
Livrare imediată!

131,99Lei

Porumb Cukk Natural Dipuit, Borcan 220ml Miere/Usturoi

Porumb Cukk Natural Dipuit, Borcan 220ml Miere/Usturoi

a0.c0192
Livrare imediată!

15,18Lei

Porumb Cukk pentru Carlig Goliath, 220ml/borcan MIERE

Porumb Cukk pentru Carlig Goliath, 220ml/borcan MIERE

a0.c0072
Livrare imediată!

18,22Lei

Porumb Cukk Natural Dipuit, Borcan 220ml Special

Porumb Cukk Natural Dipuit, Borcan 220ml Special

a0.c0063
Livrare imediată!

15,18Lei

Geanta Spinning Reiva 30x21x15 cm 1 cutie

Geanta Spinning Reiva 30x21x15 cm 1 cutie

5220-008
Livrare imediată!

190,00Lei

Porumb Cukk Natural Dipuit, Borcan 220ml Miere
Exclusiv online!

Porumb Cukk Natural Dipuit, Borcan 220ml Miere

a0.c0062
Livrare 24-48 ore

15,18Lei

Geanta Spinning Reiva 40x22x25 cm 4 cutii -30%

Geanta Spinning Reiva 40x22x25 cm 4 cutii

5220-001
Livrare imediată!

264,00Lei(-30%) 183,90Lei

Geanta Spinning Reiva 39x22x22 cm 4 cutii -23%

Geanta Spinning Reiva 39x22x22 cm 4 cutii

5220-005
Livrare imediată!

258,00Lei(-23%) 198,90Lei

Croseta Lineaeffe Boilies
Exclusiv online!

Croseta Lineaeffe Boilies

a.4990220
Livrare 24-48 ore

6,76Lei

Van Den Eynde nada Allan Scotthorne G5 2kg

Van Den Eynde nada Allan Scotthorne G5 2kg

vn16220
Livrare imediată!

39,00Lei

Afişare 681 - 700 din 1532 (77 pagini)
Queries: 5, Total time: 542.258 ms [By time] [By id] [By file]
1 (0.127)
SELECT data
FROM `oc_session`
WHERE session_id = '242be1f9cc5cae6cce1ec65e99'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (534.869)
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 = '2' AND (pd.tag LIKE "%220%") 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 (7.003)
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 680, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.166)
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