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


SNUR LMF XP SENSE FLY LINE-EURONYMPH 90ft-24.4m / 0.022mm
Exclusiv online!

SNUR LMF XP SENSE FLY LINE-EURONYMPH 90ft-24.4m / 0.022mm

059-90-020
Livrare 48-72 ore

180,00Lei

NALUCA WIZARD NYMPH 004 3CM 10BUC/PLIC

NALUCA WIZARD NYMPH 004 3CM 10BUC/PLIC

86961040
Livrare imediată!

10,92Lei

NALUCA WIZARD NYMPH 005 3CM 10BUC/PLIC

NALUCA WIZARD NYMPH 005 3CM 10BUC/PLIC

86961050
Livrare imediată!

10,92Lei

NALUCA WIZARD NYMPH 001 3CM 10BUC/PLIC
Exclusiv online!

NALUCA WIZARD NYMPH 001 3CM 10BUC/PLIC

86961010
Livrare 24-48 ore

10,92Lei

NALUCA WIZARD NYMPH 003 3CM 10BUC/PLIC

NALUCA WIZARD NYMPH 003 3CM 10BUC/PLIC

86961030
Livrare imediată!

10,92Lei

NALUCA WIZARD NYMPH 002 3CM 10BUC/PLIC
Exclusiv online!

NALUCA WIZARD NYMPH 002 3CM 10BUC/PLIC

86961020
Livrare 24-48 ore

10,92Lei

Lanseta Rapture Loomis & Franklin LMF Radius Nymph 3WT, 3.20m, 3seg
Exclusiv online!

Lanseta Rapture Loomis & Franklin LMF Radius Nymph 3WT, 3.20m, 3seg

121-71-070
Livrare 48-72 ore

770,00Lei

Lanseta Rapture Loomis & Franklin LMF Radius Nymph Still Water 7-8WT, 3.00m, 3seg
Exclusiv online!

Lanseta Rapture Loomis & Franklin LMF Radius Nymph Still Water 7-8WT, 3.00m, 3seg

121-71-060
Livrare 48-72 ore

780,00Lei

Shad Reiva Nymph Verde Fluo 6cm 12buc/plic

Shad Reiva Nymph Verde Fluo 6cm 12buc/plic

9904-601
Livrare imediată!

11,50Lei

Lanseta Rapture Loomis & Franklin LMF Radius Nymph 3WT, 3.00m, 3seg
Exclusiv online!

Lanseta Rapture Loomis & Franklin LMF Radius Nymph 3WT, 3.00m, 3seg

121-71-050
Livrare 48-72 ore

780,00Lei

Creature BOMB Nympha 10buc 2.5cm NEON -22%

Creature BOMB Nympha 10buc 2.5cm NEON

690040304
Livrare imediată!

17,01Lei(-22%) 13,30Lei

Naluca Savage Mafly Nymph 5cm/2.5G 06 -29%

Naluca Savage Mafly Nymph 5cm/2.5G 06

f1.sg.50676
Livrare imediată!

19,30Lei(-29%) 13,79Lei

Carlige Kamatsu Light Nymph O Nr.10 BLN

Carlige Kamatsu Light Nymph O Nr.10 BLN

k-9003bln-10-u
Livrare imediată!

4,50Lei

Lanseta Rapture Loomis & franklin SFT Nymph IM12 2.90m Clasa 2-3 4seg

Lanseta Rapture Loomis & franklin SFT Nymph IM12 2.90m Clasa 2-3 4seg

121-74-276
Livrare imediată!

630,00Lei

Lanseta Rapture Loomis & franklin SFT Nymph IM12 2.90m Clasa 4-5 4seg
Exclusiv online!

Lanseta Rapture Loomis & franklin SFT Nymph IM12 2.90m Clasa 4-5 4seg

121-74-275
Livrare 48-72 ore

650,00Lei

SHAD, DELPHIN, BOMB, NYMPHA, 2.5CM, BRICK, 690040301, Creaturi, Creaturi Delphin, Delphin -22%

SHAD, DELPHIN, BOMB, NYMPHA, 2.5CM, BRICK, 690040301, Creaturi, Creaturi Delphin, Delphin

690040301
Livrare imediată!

17,01Lei(-22%) 13,30Lei

Lanseta Rapture Loomis & franklin SFT Nymph IM12 11' Clasa 3 4seg
Exclusiv online!

Lanseta Rapture Loomis & franklin SFT Nymph IM12 11' Clasa 3 4seg

121-74-326
Livrare 48-72 ore

730,01Lei

Nimfa Rapture Dragonfly Nymph 4.2cm 1g Green Pump 8buc/plic
Exclusiv online!

Nimfa Rapture Dragonfly Nymph 4.2cm 1g Green Pump 8buc/plic

187-21-092
Livrare 48-72 ore

21,00Lei

Nimfa Rapture Dragonfly Nymph 4.2cm 1g Chartreuse BF 8buc/plic
Exclusiv online!

Nimfa Rapture Dragonfly Nymph 4.2cm 1g Chartreuse BF 8buc/plic

187-21-096
Livrare 48-72 ore

21,00Lei

Nimfa Rapture Dragonfly Nymph 4.2cm 1g Pearl Blue 8buc/plic
Exclusiv online!

Nimfa Rapture Dragonfly Nymph 4.2cm 1g Pearl Blue 8buc/plic

187-21-095
Livrare 48-72 ore

21,00Lei

Afişare 1 - 20 din 77 (4 pagini)
Queries: 10, Total time: 2,856.838 ms [By time] [By id] [By file]
1 (0.136)
SELECT data
FROM `oc_session`
WHERE session_id = 'a5397f6fda5d8659cfa9d8cce4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.126)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.157)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (1,525.375)
SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%nymph%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555
5 (1,330.277)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%nymph%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.167)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
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)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%nymph%") AND p.status_filtru > 0 AND p.price > 0 HAVING match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1066
7 (0.144)
SELECT COUNT(*) AS val, filter_group, filter_id
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)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%nymph%") AND p.status_filtru > 0 AND p.price > 0 AND f.language_id = '2' GROUP BY p.product_id, filter_group, filter_id HAVING match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:911
8 (0.132)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.192)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.132)
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