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


Plumb Distance Orange Inline, 71g

Plumb Distance Orange Inline, 71g

40341ld171
Livrare imediată!

8,37Lei

Plumb Hexagonal Inline Carp Expert Go Green LF-Distance Torpedo 120g
Exclusiv online!

Plumb Hexagonal Inline Carp Expert Go Green LF-Distance Torpedo 120g

fl217920
Livrare 24-48 ore

15,12Lei

Plumbi Advance Helicopter Long Distance 110g

Plumbi Advance Helicopter Long Distance 110g

3155234295351
Livrare imediată!

7,00Lei

Method Feeder Mostiro Inline Distance 80g

Method Feeder Mostiro Inline Distance 80g

5013ms
Livrare imediată!

11,90Lei

Plumbi Advance Helicopter Long Distance 125g

Plumbi Advance Helicopter Long Distance 125g

2155234088695
Livrare imediată!

8,00Lei

Plumbi Advance Helicopter Long Distance 130g

Plumbi Advance Helicopter Long Distance 130g

6155235290871
Livrare imediată!

8,00Lei

Plumb Hexagonal Inline Carp Expert Go Green LF-Distance Torpedo 60g
Exclusiv online!

Plumb Hexagonal Inline Carp Expert Go Green LF-Distance Torpedo 60g

fl217860
Livrare 24-48 ore

11,00Lei

Plumbi Advance Helicopter Long Distance 115g

Plumbi Advance Helicopter Long Distance 115g

8155237686885
Livrare imediată!

7,00Lei

Plumbi Advance Helicopter Long Distance 90g

Plumbi Advance Helicopter Long Distance 90g

4155234245713
Livrare imediată!

6,00Lei

Cosulet Orange Cage Feeder Distance 50g

Cosulet Orange Cage Feeder Distance 50g

4094110df950
Livrare imediată!

9,94Lei

Plumb Distance Orange cu Vartej, 71g
Exclusiv online!

Plumb Distance Orange cu Vartej, 71g

40341ld271
Livrare 48-72 ore

8,82Lei

Plumb Distance Orange cu Vartej, 85g
Exclusiv online!

Plumb Distance Orange cu Vartej, 85g

40341ld285
Livrare 48-72 ore

9,71Lei

Plumb Distance Orange cu Vartej, 99g
Exclusiv online!

Plumb Distance Orange cu Vartej, 99g

40341ld299
Livrare 48-72 ore

10,38Lei

Plumb Hexagonal Inline Carp Expert Go Green LF-Distance Torpedo 160g
Exclusiv online!

Plumb Hexagonal Inline Carp Expert Go Green LF-Distance Torpedo 160g

fl217960
Livrare 24-48 ore

16,31Lei

Plumb Hexagonal Inline Carp Expert Go Green LF-Distance Torpedo 40g

Plumb Hexagonal Inline Carp Expert Go Green LF-Distance Torpedo 40g

fl217840
Livrare imediată!

9,01Lei

Plumbi Advance Helicopter Long Distance 80g

Plumbi Advance Helicopter Long Distance 80g

7155235287047
Livrare imediată!

6,00Lei

Plumb Hexagonal Inline Carp Expert Go Green LF-Distance Torpedo 140g
Exclusiv online!

Plumb Hexagonal Inline Carp Expert Go Green LF-Distance Torpedo 140g

fl217940
Livrare 24-48 ore

16,31Lei

Plumb Hexagonal Inline Carp Expert Go Green LF-Distance Torpedo 180g
Exclusiv online!

Plumb Hexagonal Inline Carp Expert Go Green LF-Distance Torpedo 180g

fl217980
Livrare 24-48 ore

17,75Lei

Lanseta Trabucco Feeder Precision RPL Extreme Distance 3.90m 180g

Lanseta Trabucco Feeder Precision RPL Extreme Distance 3.90m 180g

152-22-390
Livrare imediată!

475,00Lei

Lanseta Feeder FL Strategist Distance MH 3.90M 80-150G 3Seg

Lanseta Feeder FL Strategist Distance MH 3.90M 80-150G 3Seg

6153210490711
Stoc epuizat

299,90Lei

Afişare 201 - 220 din 356 (18 pagini)
Queries: 9, Total time: 13.497 ms [By time] [By id] [By file]
1 (0.153)
SELECT data
FROM `oc_session`
WHERE session_id = '5bd09db6a498bb3946f049e90c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (8.796)
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 = '3' AND (MATCH(pd.tag) AGAINST('+distance' 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.167)
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 (0.488)
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
6 (0.112)
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
7 (0.151)
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
8 (3.407)
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
9 (0.115)
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