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


FIR TRABUCO T FORCE SPINNING PERCH 150M 0.250 mm 8.46 Kg

FIR TRABUCO T FORCE SPINNING PERCH 150M 0.250 mm 8.46 Kg

053-50-250
Stoc epuizat

38,00Lei

FIR TRABUCO T FORCE SPIN-PIKE 150M 0.160 mm 3.65 Kg

FIR TRABUCO T FORCE SPIN-PIKE 150M 0.160 mm 3.65 Kg

053-55-160
Stoc epuizat

29,00Lei

FIR TRABUCO T FORCE FLUOROCARBON 50M 0.201 mm 3.85 Kg

FIR TRABUCO T FORCE FLUOROCARBON 50M 0.201 mm 3.85 Kg

053-60-200
Stoc epuizat

32,24Lei

FIR TRABUCCO FIR T FORCE TOUR TOUGH 0.35 15.85 kg 150M

FIR TRABUCCO FIR T FORCE TOUR TOUGH 0.35 15.85 kg 150M

052-30-350
Stoc epuizat

27,00Lei

FIR TRABUCO T FORCE FLUOROCARBON 50M 0.164 mm 2.58 Kg

FIR TRABUCO T FORCE FLUOROCARBON 50M 0.164 mm 2.58 Kg

053-60-160
Stoc epuizat

27,41Lei

FIR TRABUCO T FORCE FLUOROCARBON 50M 0.125 mm 1.60 Kg

FIR TRABUCO T FORCE FLUOROCARBON 50M 0.125 mm 1.60 Kg

053-60-120
Stoc epuizat

25,79Lei

FIR TRABUCO T FORCE MATCH-PRO 100M 0.12 mm 2.15 Kg

FIR TRABUCO T FORCE MATCH-PRO 100M 0.12 mm 2.15 Kg

053-25-120
Stoc epuizat

21,00Lei

Lanseta Zebco Quantum G-Force Shad 2.40m 7-28gr -39%

Lanseta Zebco Quantum G-Force Shad 2.40m 7-28gr

14350240
Stoc epuizat

337,28Lei(-39%) 204,18Lei

Mulineta FL Cast Force CF 5000

Mulineta FL Cast Force CF 5000

64-2404
Stoc epuizat

148,39Lei

Forceps Ron Thompson Curbat 12.5cm

Forceps Ron Thompson Curbat 12.5cm

6010915237
Stoc epuizat

34,99Lei

Mulineta FL Cast Force CF 2000

Mulineta FL Cast Force CF 2000

64-2401
Stoc epuizat

138,00Lei

Mulineta FL Cast Force CF 3000

Mulineta FL Cast Force CF 3000

64-2402
Stoc epuizat

142,00Lei

MULINETA FL BLACK FORCE 6000 10RULMENTI

MULINETA FL BLACK FORCE 6000 10RULMENTI

64-2503
Stoc epuizat

112,90Lei

Lanterna de cap RidgeMonkey VRH150X USB Rechargeable Headtorch -10%

Lanterna de cap RidgeMonkey VRH150X USB Rechargeable Headtorch

rm512
Stoc epuizat

252,40Lei(-10%) 227,16Lei

MULINETA FL BLACK FORCE 5000 10RULMENTI

MULINETA FL BLACK FORCE 5000 10RULMENTI

64-2502
Stoc epuizat

109,90Lei

Lanseta Feeder FL Black Force 4.20M 60-180Gr 3Seg

Lanseta Feeder FL Black Force 4.20M 60-180Gr 3Seg

2114240674377
Stoc epuizat

256,90Lei

Fir Monofilament Trabucco T-Force Special Feeder, 0.25mm, 8.40kg, 300m

Fir Monofilament Trabucco T-Force Special Feeder, 0.25mm, 8.40kg, 300m

051-42-250
Stoc epuizat

55,00Lei

Lanterna Enterprise Tackle UV Torch

Lanterna Enterprise Tackle UV Torch

et43
Stoc epuizat

30,00Lei

Fir Monofilament Trabucco T-Force Special Feeder, 0.18mm, 4.60kg, 300m

Fir Monofilament Trabucco T-Force Special Feeder, 0.18mm, 4.60kg, 300m

051-42-180
Stoc epuizat

55,00Lei

Fir Monofilament Trabucco T-Force Special Feeder, 0.22mm, 6.95kg, 300m

Fir Monofilament Trabucco T-Force Special Feeder, 0.22mm, 6.95kg, 300m

051-42-220
Stoc epuizat

55,00Lei

Afişare 621 - 640 din 755 (38 pagini)
Queries: 6, Total time: 608.399 ms [By time] [By id] [By file]
1 (0.093)
SELECT data
FROM `oc_session`
WHERE session_id = '925e999406a452f577d42545bf'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (607.743)
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 (pd.tag LIKE "%orc%") 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.209)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.132)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CARP INTELLIGENCE LTD"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.131)
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