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


Creatura Zeck Edward 7.1cm Kiwi Lemon 8buc/plic

Creatura Zeck Edward 7.1cm Kiwi Lemon 8buc/plic

131905220409
Livrare imediată!

34,74Lei

Creatura Zeck Edward 7.1cm Moor Kiwi 8buc/plic
Exclusiv online!

Creatura Zeck Edward 7.1cm Moor Kiwi 8buc/plic

131905220183
Livrare 48-72 ore

34,74Lei

Creatura, Zeck, Edward, 7.1cm, Red, Crab, 8buc/plic, 131905220184, Creaturi, Creaturi Zeck, Zeck
Exclusiv online!

Creatura, Zeck, Edward, 7.1cm, Red, Crab, 8buc/plic, 131905220184, Creaturi, Creaturi Zeck, Zeck

131905220184
Livrare 48-72 ore

34,74Lei

Shad Reins Rockvibe, Marble Chart Orange, 3cm, 18buc/plic

Shad Reins Rockvibe, Marble Chart Orange, 3cm, 18buc/plic

reins-rs12308
Livrare imediată!

24,00Lei

Shad Relax Stinger Standard SS013, 5cm, 1g, 8buc/plic

Shad Relax Stinger Standard SS013, 5cm, 1g, 8buc/plic

ss2-ss013-b
Livrare imediată!

11,00Lei

Agrafa Spro Double Insurace Matt Black, Nr.4, 55kg, 8buc/plic

Agrafa Spro Double Insurace Matt Black, Nr.4, 55kg, 8buc/plic

004620-01204-00000
Livrare imediată!

8,90Lei

Carlige Benzar Mix Concourse Method Carp Winner Nr.6, 8buc/plic

Carlige Benzar Mix Concourse Method Carp Winner Nr.6, 8buc/plic

43463006
Livrare imediată!

15,01Lei

Carlige BKK Chinu-R Shark Nr.2, 8buc/plic -23%

Carlige BKK Chinu-R Shark Nr.2, 8buc/plic

6970595289057
Livrare imediată!

11,50Lei(-23%) 8,90Lei

Carlige, Legate, Mikado, Method, Feeder, Rig,, 10cm,, Nr.12,, 0.23mm,, 8buc/plic, hmfb13i-12, Carlige Legate Feeder, Carlige Legate Feeder Mikado, Carlige Mikado, Legate Mikado, Feeder Mikado, Mikado -20%
Carlige Legate Mikado Method Feeder Rig, 10cm, Nr.6, 0.23mm, 8buc/plic -20%

Carlige Legate Mikado Method Feeder Rig, 10cm, Nr.6, 0.23mm, 8buc/plic

hmfb13i-6
Livrare imediată!

24,00Lei(-20%) 19,19Lei

Carlige Mustad Ruthless In Line Drop Shot Cu Ochet, Nr.4, 8buc/plic
Exclusiv online!

Carlige Mustad Ruthless In Line Drop Shot Cu Ochet, Nr.4, 8buc/plic

m.10850ap.ts.4
Livrare 24-48 ore

20,55Lei

Creatura Zeck Edward 7.1cm Green Flake Moor 8buc/plic
Exclusiv online!

Creatura Zeck Edward 7.1cm Green Flake Moor 8buc/plic

131905220410
Livrare 48-72 ore

34,74Lei

Creatura Zeck Edward 7.1cm Just Black 8buc/plic
Exclusiv online!

Creatura Zeck Edward 7.1cm Just Black 8buc/plic

131905220185
Livrare 48-72 ore

34,74Lei

Shad Reins Rockvibe, Oikawa, 3cm, 18buc/plic

Shad Reins Rockvibe, Oikawa, 3cm, 18buc/plic

reins-rs12b39
Livrare imediată!

24,00Lei

Shad Relax Stinger Standard SS006, 5cm, 1g, 8buc/plic

Shad Relax Stinger Standard SS006, 5cm, 1g, 8buc/plic

ss2-ss006-b
Livrare imediată!

11,00Lei

Shad Relax Stinger Standard SS014, 5cm, 1g, 8buc/plic

Shad Relax Stinger Standard SS014, 5cm, 1g, 8buc/plic

ss2-ss014-b
Livrare imediată!

11,00Lei

Shad Relax Stinger Standard SS016, 5cm, 1g, 8buc/plic

Shad Relax Stinger Standard SS016, 5cm, 1g, 8buc/plic

ss2-ss016-b
Livrare imediată!

11,00Lei

Shad Relax Stinger Standard SS021, 5cm, 1g, 8buc/plic

Shad Relax Stinger Standard SS021, 5cm, 1g, 8buc/plic

ss2-ss021-b
Livrare imediată!

11,00Lei

Shad Relax Stinger Standard SS027, 5cm, 1g, 8buc/plic

Shad Relax Stinger Standard SS027, 5cm, 1g, 8buc/plic

ss2-ss027-b
Livrare imediată!

11,00Lei

Carlig Mustad Chebu Titan, Nr.2/0, 8buc/plic
Exclusiv online!

Carlig Mustad Chebu Titan, Nr.2/0, 8buc/plic

m.3255ap.tx.02
Livrare 24-48 ore

14,51Lei

Afişare 161 - 180 din 865 (44 pagini)
Queries: 8, Total time: 236.279 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = '13f100ae07ad1073e29b367dd2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.076)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (232.113)
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 "%8buc/plic%") 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
5 (3.561)
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 160, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.152)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.106)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.111)
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