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 - Fire Monturi Carp Academy

Produse ce potrivesc criteriilor de căutare


Kit Pva Sistem Claumar Slow Melt 25mm/7m + 35mm/7m cu Tub + Plunger

Kit Pva Sistem Claumar Slow Melt 25mm/7m + 35mm/7m cu Tub + Plunger

clm243331
Livrare imediată!

56,50Lei

Rezerva Plasa Pva Claumar Slow Melt 25mm, 7m

Rezerva Plasa Pva Claumar Slow Melt 25mm, 7m

clm243348
Livrare imediată!

27,91Lei

Rezerva Plasa Pva Claumar Slow Melt 35mm, 7m

Rezerva Plasa Pva Claumar Slow Melt 35mm, 7m

clm243355
Livrare imediată!

27,91Lei

BANDA PVA SOLUBILA FOX EDGES SLOW MELT 20M

BANDA PVA SOLUBILA FOX EDGES SLOW MELT 20M

cpv081
Livrare imediată!

21,40Lei

LANSETA RAPTURE SX AREA SXS552 XUL 1.65m X-Slow 0.2-3g
Exclusiv online!

LANSETA RAPTURE SX AREA SXS552 XUL 1.65m X-Slow 0.2-3g

126-27-100
Livrare 48-72 ore

540,00Lei

LANSETA RAPTURE SX AREA SXS552 1.88m X-Slow XUL 0.2-3g
Exclusiv online!

LANSETA RAPTURE SX AREA SXS552 1.88m X-Slow XUL 0.2-3g

126-27-200
Livrare 48-72 ore

545,00Lei

LANSETA RAPTURE SX AREA SXS552 1.88m Reg Slow UL 0.3-5g

LANSETA RAPTURE SX AREA SXS552 1.88m Reg Slow UL 0.3-5g

126-27-300
Livrare imediată!

545,00Lei

LANSETA RAPTURE SX AREA SXS552 1.88m Reg Slow L 0.3-5g
Exclusiv online!

LANSETA RAPTURE SX AREA SXS552 1.88m Reg Slow L 0.3-5g

126-27-400
Livrare 48-72 ore

545,00Lei

PORUMB ARTIFICIAL SLOW SINKING KORDA MAIZE CITRUS ZING LIME 10BUC/PLIC

PORUMB ARTIFICIAL SLOW SINKING KORDA MAIZE CITRUS ZING LIME 10BUC/PLIC

a.kpb41
Livrare imediată!

18,54Lei

PORUMB ARTIFICIAL KORDA SLOW SINKING CORN CITRUS ZING LIME 12BUC/PLIC

PORUMB ARTIFICIAL KORDA SLOW SINKING CORN CITRUS ZING LIME 12BUC/PLIC

a.kpb43
Livrare imediată!

19,87Lei

WAFTERS CARP ZOOM FLAT SLOW SINKING 15G Halibut Magic
Exclusiv online!

WAFTERS CARP ZOOM FLAT SLOW SINKING 15G Halibut Magic

cz8806
Livrare 48-72 ore

19,50Lei

WAFTERS CARP ZOOM FLAT SLOW SINKING 15G Spice Magic
Exclusiv online!

WAFTERS CARP ZOOM FLAT SLOW SINKING 15G Spice Magic

cz8813
Livrare 48-72 ore

19,50Lei

WAFTERS CARP ZOOM FLAT SLOW SINKING 15G Fruit Magic
Exclusiv online!

WAFTERS CARP ZOOM FLAT SLOW SINKING 15G Fruit Magic

cz8790
Livrare 48-72 ore

19,50Lei

PUNGA PVA SOLUBILA FL Slow MELT 70X140 10BUC

PUNGA PVA SOLUBILA FL Slow MELT 70X140 10BUC

64-19378
Livrare imediată!

10,90Lei

PUNGA PVA SOLUBILA FL Slow MELT 60X120 10BUC

PUNGA PVA SOLUBILA FL Slow MELT 60X120 10BUC

64-19361
Livrare imediată!

9,90Lei

Shad Live Target Slow Roll Shiner Paddle Tail, Silver / Blue, 10cm, 4buc/pac
Exclusiv online!

Shad Live Target Slow Roll Shiner Paddle Tail, Silver / Blue, 10cm, 4buc/pac

f1.lt.srs100sk201
Livrare 24-48 ore

42,88Lei

Shad Live Target Slow Roll Shiner Paddle Tail, Silver / Brown, 8.5cm, 4buc/pac

Shad Live Target Slow Roll Shiner Paddle Tail, Silver / Brown, 8.5cm, 4buc/pac

f1.lt.srs85sk934
Livrare imediată!

42,88Lei

Shad Live Target Slow Roll Shiner Paddle Tail, Silver / Pearl, 8.5cm, 4buc/pac
Exclusiv online!

Shad Live Target Slow Roll Shiner Paddle Tail, Silver / Pearl, 8.5cm, 4buc/pac

f1.lt.srs85sk134
Livrare 24-48 ore

42,88Lei

Shad Live Target Slow Roll Shiner Paddle Tail, Silver / Pearl, 12.5cm, 4buc/pac
Exclusiv online!

Shad Live Target Slow Roll Shiner Paddle Tail, Silver / Pearl, 12.5cm, 4buc/pac

f1.lt.srs125sk134
Livrare 24-48 ore

42,88Lei

Shad Live Target Slow Roll Shiner Paddle Tail, Silver / Purple, 12.5cm, 4buc/pac
Exclusiv online!

Shad Live Target Slow Roll Shiner Paddle Tail, Silver / Purple, 12.5cm, 4buc/pac

f1.lt.srs125sk207
Livrare 24-48 ore

42,88Lei

Afişare 1 - 20 din 159 (8 pagini)
Queries: 7, Total time: 231.674 ms [By time] [By id] [By file]
1 (0.113)
SELECT data
FROM `oc_session`
WHERE session_id = '3fe96b49896a2dc49ca950f25f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (231.066)
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 "%slow%") 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 (0.101)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
6 (0.094)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.093)
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