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


ANCORE BKK SPEAR-21 SS ANCORE COMPETITION SUPER SLIDE Treble Hook Nr 8 8/Plic

ANCORE BKK SPEAR-21 SS ANCORE COMPETITION SUPER SLIDE Treble Hook Nr 8 8/Plic

6939067093660
Livrare imediată!

32,00Lei

Lanseta OKUMA Competition Spin 228cm 5-25g 2sec

Lanseta OKUMA Competition Spin 228cm 5-25g 2sec

cm-s-762ml
Livrare imediată!

197,10Lei

LANSETA SPINNING OKUMA COMPETITION SPIN 1.98m 10-30g 2buc
Exclusiv online!

LANSETA SPINNING OKUMA COMPETITION SPIN 1.98m 10-30g 2buc

cm-s-662m
Livrare 48-72ore

179,10Lei

LANSETA SPINNING OKUMA COMPETITION SPIN 2.74m 20-50g 2buc
Exclusiv online!

LANSETA SPINNING OKUMA COMPETITION SPIN 2.74m 20-50g 2buc

cm-s-902m
Livrare 48-72ore

251,10Lei

LANSETA SPINNING OKUMA COMPETITION SPIN 2.13m 10-30g 2buc -14%

LANSETA SPINNING OKUMA COMPETITION SPIN 2.13m 10-30g 2buc

cm-s-702m
Livrare imediată!

188,10Lei(-14%) 160,90Lei

FIR, MONOFILAMENT, TRABUCCO, T-FORCE, COMPETITION, GP, TRANSPARENT, 25M, 0.255mm, 8.24kg, 052-72-250, Fire Varga Bolo, Fire Varga Bolo Trabucco, Trabucco
FIR, MONOFILAMENT, TRABUCCO, T-FORCE, COMPETITION, GP, TRANSPARENT, 25M, 0.309mm, 12.08kg, 052-72-300, Fire Varga Bolo, Fire Varga Bolo Trabucco, Trabucco
Wafters Steg Method Mini Upters Competition Serie, N-Butyric & Orange, 6-7mm, 25g
Exclusiv online!

Wafters Steg Method Mini Upters Competition Serie, N-Butyric & Orange, 6-7mm, 25g

sp316762
Livrare 48-72 ore

19,40Lei

LANSETA SPINNING OKUMA COMPETITION SPIN 2.74m 20-80g 2buc
Exclusiv online!

LANSETA SPINNING OKUMA COMPETITION SPIN 2.74m 20-80g 2buc

cm-s-902mh
Livrare 48-72ore

251,10Lei

Nada Feeder Bait Method Mix Competition Caras 800g
Exclusiv online!

Nada Feeder Bait Method Mix Competition Caras 800g

fb31-2
Livrare 48-72 ore

20,00Lei

Juvelnic Pro FL Ultra Match Plus Competition 50x40 4.00m

Juvelnic Pro FL Ultra Match Plus Competition 50x40 4.00m

64-23382
Livrare imediată!

225,90Lei

MANER MINCIOG PRO FL COMPETITION TELE 2.00M

MANER MINCIOG PRO FL COMPETITION TELE 2.00M

64-45766
Livrare imediată!

72,90Lei

Juvelnic Trabucco Ultra Match Plus Competition 3.50m

Juvelnic Trabucco Ultra Match Plus Competition 3.50m

082-61-350
Livrare imediată!

510,00Lei

Scaun Modular Garbolino D36 Competition 36-31 Airvent
Exclusiv online!

Scaun Modular Garbolino D36 Competition 36-31 Airvent

90830gomek3731
Livrare 48-72 ore

2.448,69Lei

Carlig Garbolino Competition Match 2300BZ, Nr.14, 15buc
Exclusiv online!

Carlig Garbolino Competition Match 2300BZ, Nr.14, 15buc

120130gomam02300bz-0014
Livrare 48-72 ore

13,38Lei

Geanta Juvelnic Garbolino Competition PVC Stink Bag XL, 65x65x20cm

Geanta Juvelnic Garbolino Competition PVC Stink Bag XL, 65x65x20cm

90430gomlg3880-1cxl
Livrare imediată!

320,53Lei

Wafter Feeder Bait Burger, Competition Karp, Rosu, 9mm, 25ml
Exclusiv online!

Wafter Feeder Bait Burger, Competition Karp, Rosu, 9mm, 25ml

fb37-5
Livrare 48-72 ore

14,00Lei

Juvelnic Trabucco Ultra Match Plus Competition 4.00m
Exclusiv online!

Juvelnic Trabucco Ultra Match Plus Competition 4.00m

082-61-400
Livrare 48-72 ore

540,00Lei

Carlig Garbolino Competition Match 2300BZ, Nr.12, 15buc
Exclusiv online!

Carlig Garbolino Competition Match 2300BZ, Nr.12, 15buc

120130gomam02300bz-0012
Livrare 48-72 ore

13,38Lei

MANER MINCIOG PRO FL COMPETITION TELE 3.00M

MANER MINCIOG PRO FL COMPETITION TELE 3.00M

64-45773
Livrare imediată!

85,89Lei

Afişare 61 - 80 din 571 (29 pagini)
Queries: 11, Total time: 220.368 ms [By time] [By id] [By file]
1 (0.066)
SELECT data
FROM `oc_session`
WHERE session_id = '60f419c9463a8bf501c42a1ea7'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.062)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.064)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (215.964)
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 = '0' AND (pd.tag LIKE "%competition%") 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.529)
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 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.129)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.125)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.092)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.078)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
11 (0.136)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38