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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Croseta Leadcore Strategy Glow In The Dark Pink

Croseta Leadcore Strategy Glow In The Dark Pink

008036-00619-00000
Livrare imediată!

19,90Lei

Croseta Soft Bait Strategy Glow In The Dark Green

Croseta Soft Bait Strategy Glow In The Dark Green

008036-00618-00000
Livrare imediată!

19,90Lei

CROSETA PRO FL PVA STRINGER NEEDLE

CROSETA PRO FL PVA STRINGER NEEDLE

64-66051
Livrare imediată!

12,90Lei

Croseta Nash Micro Boilie Needle

Croseta Nash Micro Boilie Needle

t8801
Livrare imediată!

19,99Lei

CROSETA PRO FL Leadcore NEEDLE

CROSETA PRO FL Leadcore NEEDLE

64-66068
Livrare imediată!

10,90Lei

CROSETA PRO FL MICRO BOILIE NEEDLE

CROSETA PRO FL MICRO BOILIE NEEDLE

64-66044
Livrare imediată!

10,90Lei

Set Zfish Baiting Tool 2 In 1 Croseta + Burghiu, Inox

Set Zfish Baiting Tool 2 In 1 Croseta + Burghiu, Inox

zf-2252
Livrare imediată!

11,75Lei

CROSETA MOSTIRO RETRACTABILA INOX DE LUXE
Exclusiv online!

CROSETA MOSTIRO RETRACTABILA INOX DE LUXE

ai-0977
Livrare 48-72 ore

5,30Lei

CROSETA KORDA PT LEADCORE 7CM ORANGE
Exclusiv online!

CROSETA KORDA PT LEADCORE 7CM ORANGE

a.kspn
Livrare 24-48 ore

20,91Lei

CARP EXPERT CROSETA PVA

CARP EXPERT CROSETA PVA

80203061
Livrare imediată!

6,70Lei

MINI CROSETA MOSTIRO LEADCORE LUX

MINI CROSETA MOSTIRO LEADCORE LUX

4085
Livrare imediată!

8,20Lei

Croseta STONFO XXL, 11cm

Croseta STONFO XXL, 11cm

8028651018344
Stoc epuizat

28,00Lei

Varf de Rezerva Climax CROSETA CULT CRAP NEEDLE SYSTEM REFILL

Varf de Rezerva Climax CROSETA CULT CRAP NEEDLE SYSTEM REFILL

300508
Stoc epuizat

29,00Lei

SET CROSETA Climax CULT SPLICING NEEDLE SYSTEM 1+3buc

SET CROSETA Climax CULT SPLICING NEEDLE SYSTEM 1+3buc

300507
Stoc epuizat

80,00Lei

Croseta Claumar Pescar Leadcore Needle Fine 1Buc

Croseta Claumar Pescar Leadcore Needle Fine 1Buc

clm236975
Stoc epuizat

9,90Lei

CROSETA JAXON PENTRU PESTISOR 20CM 2BUC/SET

CROSETA JAXON PENTRU PESTISOR 20CM 2BUC/SET

ac-3339x
Stoc epuizat

13,49Lei

Croseta Delphin Ihla SLIM Safety -29%

Croseta Delphin Ihla SLIM Safety

101000415
Stoc epuizat

16,01Lei(-29%) 11,31Lei

CROSETA Pro Line GLOW IN THE DARK STRINGER NEEDLE

CROSETA Pro Line GLOW IN THE DARK STRINGER NEEDLE

pl2656
Stoc epuizat

25,00Lei

Croseta FL Leadcore Needle Fine 1.27mm

Croseta FL Leadcore Needle Fine 1.27mm

ak-k1.27
Livrare imediată!

6,90Lei

CROSETA Pro Line GLOW IN THE DARK BARBED BOILIE NEEDLE

CROSETA Pro Line GLOW IN THE DARK BARBED BOILIE NEEDLE

pl2654
Stoc epuizat

25,00Lei

Afişare 161 - 180 din 218 (11 pagini)
Queries: 10, Total time: 8.451 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = '0ea5e0eb49f425deae33b26d12'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.074)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (5.118)
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 (MATCH(pd.tag) AGAINST('+croseta' 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 (0.095)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (1.002)
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.379)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
7 (0.080)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270
8 (0.091)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035
9 (1.384)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
10 (0.118)
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