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

Produse ce potrivesc criteriilor de căutare


Lanseta Telescopica Mitchell Catch Spinning, 4-15g, 1.80m, 5sec -40%

Lanseta Telescopica Mitchell Catch Spinning, 4-15g, 1.80m, 5sec

1406788
Livrare imediată!

54,50Lei(-40%) 32,70Lei

Lanseta Sportex Jig-Xpert Zander 265 17-53g

Lanseta Sportex Jig-Xpert Zander 265 17-53g

jx2602
Livrare imediată!

799,00Lei

Lanseta Mitchell Adventure Il Spinning 1.80m, 4-15g, 2buc -29%

Lanseta Mitchell Adventure Il Spinning 1.80m, 4-15g, 2buc

1558842
Livrare imediată!

52,00Lei(-29%) 37,00Lei

Lanseta Mitchell Adventure Il Spinning 2.70m, 15-40g, 2buc -28%
Exclusiv online!

Lanseta Mitchell Adventure Il Spinning 2.70m, 15-40g, 2buc

1558845
Livrare 7-14 zile

92,00Lei(-28%) 66,00Lei

Lanseta Telescopica Carp Expert Advancer Tele 3.00m, 40-80g, 5Seg

Lanseta Telescopica Carp Expert Advancer Tele 3.00m, 40-80g, 5Seg

12170301
Livrare imediată!

109,00Lei

Lanseta Abu Garcia Vendetta V3 702M 2.13m 10-30g Fast

Lanseta Abu Garcia Vendetta V3 702M 2.13m 10-30g Fast

1544427
Livrare imediată!

359,96Lei

Lanseta Colmic Herakles Kasumi T603ML 1.87m 0.9-2.8g
Exclusiv online!

Lanseta Colmic Herakles Kasumi T603ML 1.87m 0.9-2.8g

cahkak06
Livrare 48-72 ore

1.850,00Lei

Lanseta Dragon Millenium Pro Guide X-Series 2.28m 4-21g 2seg
Exclusiv online!

Lanseta Dragon Millenium Pro Guide X-Series 2.28m 4-21g 2seg

chc-26-86-228
Livrare 48-72 ore

720,00Lei

Lanseta Spinning Daiwa 2seg Triforce Target Zander Spin, 2.40m, 15-50g -23%

Lanseta Spinning Daiwa 2seg Triforce Target Zander Spin, 2.40m, 15-50g

d.11400.246
Livrare imediată!

205,75Lei(-23%) 158,90Lei

Lanseta Spinning Daiwa Tournament XT 2.15m, 4-18g, 2seg

Lanseta Spinning Daiwa Tournament XT 2.15m, 4-18g, 2seg

d.11128.215
Livrare imediată!

1.988,78Lei

Lanseta Sportex Jig-Xpert Zander 210 11-39g

Lanseta Sportex Jig-Xpert Zander 210 11-39g

jx2102
Livrare imediată!

630,00Lei

LANSETA FL TELE SPIN SIRENIA 5-25G 3.60M

LANSETA FL TELE SPIN SIRENIA 5-25G 3.60M

5253247810740
Livrare imediată!

64,90Lei

Lanseta Mitchell Adventure Il Tele Spinning 1.80m, 4-15g

Lanseta Mitchell Adventure Il Tele Spinning 1.80m, 4-15g

1558846
Livrare imediată!

59,96Lei

Lanseta Sportex Rapid Spin 270 40g

Lanseta Sportex Rapid Spin 270 40g

rp2702
Livrare imediată!

680,00Lei

Lanseta Colmic Herakles Kiar Eclisse HKEC2-600L 1.8m 1.5-5g
Exclusiv online!

Lanseta Colmic Herakles Kiar Eclisse HKEC2-600L 1.8m 1.5-5g

cahkkec01
Livrare 48-72 ore

585,00Lei

LANSETA FL TELE SPIN SIRENIA 5-25G 2.10M

LANSETA FL TELE SPIN SIRENIA 5-25G 2.10M

6253240906432
Livrare imediată!

44,90Lei

LANSETA FL TELE SPIN SIRENIA 5-25G 2.40M

LANSETA FL TELE SPIN SIRENIA 5-25G 2.40M

8253242882916
Livrare imediată!

48,90Lei

Lanseta Mitchell Epic MX1 Spinning 152 L, 1.50m, 1-8g, 2seg

Lanseta Mitchell Epic MX1 Spinning 152 L, 1.50m, 1-8g, 2seg

1561463
Livrare imediată!

119,96Lei

Lanseta Spinning Daiwa 2seg Prorex S, 2,40m/7-21g

Lanseta Spinning Daiwa 2seg Prorex S, 2,40m/7-21g

d.11280.240
Livrare imediată!

368,80Lei

Lanseta Sportex Rapid Spin 240 60g

Lanseta Sportex Rapid Spin 240 60g

rp2403
Livrare imediată!

670,01Lei

Afişare 1861 - 1880 din 3184 (160 pagini)
Queries: 4, Total time: 112.735 ms [By time] [By id] [By file]
1 (0.094)
SELECT data
FROM `oc_session`
WHERE session_id = '4b4dd985b0a6a8888471563293'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (112.362)
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('+lansete +rapitori' 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:724
4 (0.178)
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