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


Mulineta, Nevis, Epic, Feeder, 4000,, 5.0:1,, 0.20mm/150m,, 4rul, 2536-440, Mulinete Feeder, Mulinete Feeder Nevis, Mulinete Nevis, Feeder Nevis, Nevis
Plumb Culisant Backlead Nevis 113g
Exclusiv online!

Plumb Culisant Backlead Nevis 113g

7336-004
Livrare 48-72 ore

50,50Lei

Vartej Nevis cu Rulment Nr. 4, 100kg, 3buc/pac
Exclusiv online!

Vartej Nevis cu Rulment Nr. 4, 100kg, 3buc/pac

5580-004
Livrare 48-72 ore

12,99Lei

Carlige Legate Nevis + Croseta, 10cm, Nr.12, 0.25mm, 5buc/plic
Exclusiv online!

Carlige Legate Nevis + Croseta, 10cm, Nr.12, 0.25mm, 5buc/plic

8108-312
Livrare 48-72 ore

10,90Lei

Carlige Somn Nevis 9644, Nr.1/0, 6buc/pac
Exclusiv online!

Carlige Somn Nevis 9644, Nr.1/0, 6buc/pac

5652-001
Livrare 48-72 ore

6,60Lei

Carlige Somn Nevis 9644, Nr.3/0, 6buc/pac
Exclusiv online!

Carlige Somn Nevis 9644, Nr.3/0, 6buc/pac

5652-003
Livrare 48-72 ore

8,29Lei

Lanseta Bolognesa Nevis Dynamic Bolo, 5-20g, 7.00m, 7seg
Exclusiv online!

Lanseta Bolognesa Nevis Dynamic Bolo, 5-20g, 7.00m, 7seg

1776-701
Livrare 48-72 ore

367,99Lei

Lanseta Bolognesa Nevis Tidal Bolo, 10-30g, 6.00m, 6seg
Exclusiv online!

Lanseta Bolognesa Nevis Tidal Bolo, 10-30g, 6.00m, 6seg

1777-601
Livrare 48-72 ore

312,00Lei

Lanseta Bolognesa Nevis Tidal Bolo, 10-30g, 7.00m, 7seg
Exclusiv online!

Lanseta Bolognesa Nevis Tidal Bolo, 10-30g, 7.00m, 7seg

1777-701
Livrare 48-72 ore

376,00Lei

Plumb Cu Vartej Nevis 30g
Exclusiv online!

Plumb Cu Vartej Nevis 30g

7351-030
Livrare 48-72 ore

5,30Lei

Tub Anti Tangle Nevis Inox, 10cm, 3buc/pac

Tub Anti Tangle Nevis Inox, 10cm, 3buc/pac

8100-295
Livrare imediată!

5,20Lei

Agrafa, cu, Vartej, Nevis, Feeder, Swivel, +, Snap, Strong, Nr.14,, 10buc/pac, 5576-014, Vartejuri Feeder, Vartejuri Feeder Nevis, Vartejuri Nevis, Feeder Nevis, Nevis
Agrafa, cu, Vartej, Nevis, Nr.14,, 10buc/pac, 5574-014, Vartejuri Feeder, Vartejuri Feeder Nevis, Vartejuri Nevis, Feeder Nevis, Nevis
Carlige Legate Nevis + Croseta, 10cm, Nr.8, 0.25mm, 5buc/plic
Exclusiv online!

Carlige Legate Nevis + Croseta, 10cm, Nr.8, 0.25mm, 5buc/plic

8108-308
Livrare 48-72 ore

10,90Lei

Carlige Legate Nevis Feeder Bait Spike Braided Line Rig, Nr.6, 3buc/plic

Carlige Legate Nevis Feeder Bait Spike Braided Line Rig, Nr.6, 3buc/plic

8103-706
Livrare imediată!

10,50Lei

Carlige Somn Nevis 9314, Nr.6/0, 6buc/pac
Exclusiv online!

Carlige Somn Nevis 9314, Nr.6/0, 6buc/pac

5653-006
Livrare 48-72 ore

8,29Lei

Carlige, Somn, Nevis, 9314,, Nr.8/0,, 6buc/pac, 5653-008, Carlige Somn, Carlige Somn Nevis, Carlige Nevis, Somn Nevis, Nevis
Exclusiv online!

Carlige, Somn, Nevis, 9314,, Nr.8/0,, 6buc/pac, 5653-008, Carlige Somn, Carlige Somn Nevis, Carlige Nevis, Somn Nevis, Nevis

5653-008
Livrare 48-72 ore

10,81Lei

Carlige, Somn, Nevis, 9644,, Nr.8/0,, 4buc/pac, 5652-008, Carlige Somn, Carlige Somn Nevis, Carlige Nevis, Somn Nevis, Nevis
Fir Monofilament Nevis Sinking Match 0.18mm, 5.90 kg, 150m
Exclusiv online!

Fir Monofilament Nevis Sinking Match 0.18mm, 5.90 kg, 150m

3261-118
Livrare 48-72 ore

14,70Lei

Lanseta Bolognesa Nevis River Power, 5-20g, 5.00m, 5seg
Exclusiv online!

Lanseta Bolognesa Nevis River Power, 5-20g, 5.00m, 5seg

1779-501
Livrare 48-72 ore

238,00Lei

Afişare 81 - 100 din 1037 (52 pagini)
Queries: 5, Total time: 208.935 ms [By time] [By id] [By file]
1 (0.139)
SELECT data
FROM `oc_session`
WHERE session_id = 'e8ef1fad4949c3a9c803223054'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (204.619)
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 = '3' AND (pd.tag LIKE "%nevis%") 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 (3.914)
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 80, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.160)
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