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


PLUMBI OLIVETA MAVER INLINE 1.75GR
Exclusiv online!

PLUMBI OLIVETA MAVER INLINE 1.75GR

k654
Livrare 48-72 ore

15,01Lei

SET PLUMBI JAXON OLIVETA NR 3 440GR 2/3/4/5/6/7/9/12GR
Exclusiv online!

SET PLUMBI JAXON OLIVETA NR 3 440GR 2/3/4/5/6/7/9/12GR

cc-z003
Livrare 48-72 ore

125,00Lei

Shad Mann s Q-Paddler 7g 10cm Spicy Olive -77%

Shad Mann s Q-Paddler 7g 10cm Spicy Olive

3281012
Livrare imediată!

8,78Lei(-77%) 1,99Lei

Fir monofilament Climax CULT CRAP EXTREME 1000m 0.40mm 11.20kg Matt Olive

Fir monofilament Climax CULT CRAP EXTREME 1000m 0.40mm 11.20kg Matt Olive

8461-11000-040
Livrare imediată!

126,00Lei

PLUMB SPRO C-TEC CULISANT OLIVE 5GR 5BUC

PLUMB SPRO C-TEC CULISANT OLIVE 5GR 5BUC

008620-00214-00000
Livrare imediată!

4,90Lei

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G OLIVE STRIPES
Exclusiv online!

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G OLIVE STRIPES

sg.71442
Livrare 24-48 ore

35,25Lei

PLUMB SPRO C-TEC CULISANT OLIVE 3GR 5BUC

PLUMB SPRO C-TEC CULISANT OLIVE 3GR 5BUC

008620-00212-00000
Livrare imediată!

4,40Lei

FIR TEXTIL JAXON HEGEMON SUPRA 12X 125m 0.14mm 16kg Dark Olive
Exclusiv online!

FIR TEXTIL JAXON HEGEMON SUPRA 12X 125m 0.14mm 16kg Dark Olive

zj-dsp014a
Livrare 48-72 ore

218,00Lei

PLUMBI JAXON OLIVETA INLINE 1.0GR

PLUMBI JAXON OLIVETA INLINE 1.0GR

cc-ab1g
Livrare imediată!

8,50Lei

SET PLUMBI JAXON OLIVETA NR 4 480GR 3/5/7/10/15/20GR -24%

SET PLUMBI JAXON OLIVETA NR 4 480GR 3/5/7/10/15/20GR

cc-z004
Livrare imediată!

78,00Lei(-24%) 59,50Lei

FIR TEXTIL Climax CATFISH KEVLAR LEADER 20m 1.00mm 100kg Olive Green
Exclusiv online!

FIR TEXTIL Climax CATFISH KEVLAR LEADER 20m 1.00mm 100kg Olive Green

9381-10020-100
Livrare 48-72 ore

53,00Lei

Fir textil Climax iBRAID OLIVE GREEN 135m 0.12mm 9.2kg
Exclusiv online!

Fir textil Climax iBRAID OLIVE GREEN 135m 0.12mm 9.2kg

9403-10135-012
Livrare 48-72 ore

94,00Lei

Fir textil Climax MIG8 OLIVE GREEN 135m 0.20mm 19.5kg
Exclusiv online!

Fir textil Climax MIG8 OLIVE GREEN 135m 0.20mm 19.5kg

9351-10135-020
Livrare 48-72 ore

82,00Lei

Vobler Rapture Pro Under Silent Sinking, Olive Shiner, 6.5cm, 11g

Vobler Rapture Pro Under Silent Sinking, Olive Shiner, 6.5cm, 11g

180-02-902
Livrare imediată!

26,00Lei

PLUMBI JAXON OLIVETA INLINE 12GR

PLUMBI JAXON OLIVETA INLINE 12GR

cc-ab12g
Livrare imediată!

7,00Lei

FIR TEXTIL JAXON HEGEMON SUPRA 12X 125m 0.18mm 24kg Dark Olive
Exclusiv online!

FIR TEXTIL JAXON HEGEMON SUPRA 12X 125m 0.18mm 24kg Dark Olive

zj-dsp018a
Livrare 48-72 ore

218,00Lei

Fir textil Climax iBRAID OLIVE GREEN 135m 0.20mm 19.0kg
Exclusiv online!

Fir textil Climax iBRAID OLIVE GREEN 135m 0.20mm 19.0kg

9403-10135-020
Livrare 48-72 ore

86,00Lei

FIR TEXTIL JAXON HEGEMON SUPRA 12X 125m 0.08mm 6kg Dark Olive
Exclusiv online!

FIR TEXTIL JAXON HEGEMON SUPRA 12X 125m 0.08mm 6kg Dark Olive

zj-dsp008a
Livrare 48-72 ore

218,00Lei

PLUMB C-TEC CULISANT OLIVE 4GR 5BUC

PLUMB C-TEC CULISANT OLIVE 4GR 5BUC

008620-00213-00000
Livrare imediată!

4,40Lei

PLUMBI JAXON OLIVETA INLINE 5.0GR

PLUMBI JAXON OLIVETA INLINE 5.0GR

cc-ab5g
Livrare imediată!

8,50Lei

Afişare 301 - 320 din 754 (38 pagini)
Queries: 4, Total time: 722.324 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = 'a0f3fee57d6a56a58a07be4b27'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.092)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (722.003)
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 "%olive%") 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.117)
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