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


Rod Pod Carp Expert EXTEND ROD POD 3 POSTURI

Rod Pod Carp Expert EXTEND ROD POD 3 POSTURI

77106013
Livrare imediată!

328,00Lei

Rodpod Delphin RPX Stalk BlackWay

Rodpod Delphin RPX Stalk BlackWay

101001623
Livrare imediată!

528,00Lei

Tripod Delphin TPX3 BlackWay

Tripod Delphin TPX3 BlackWay

101000976
Livrare imediată!

615,00Lei

Cleme PICIOARE Maver UK ROLA MV-R LOW
Exclusiv online!

Cleme PICIOARE Maver UK ROLA MV-R LOW

l266
Livrare 48-72 ore

114,00Lei

Rod Pod Baracuda RP4 4 posturi

Rod Pod Baracuda RP4 4 posturi

rodpod 4 pentru 4 lansete
Livrare imediată!

360,90Lei

Stabilizator Carp Spirit Blax Single Bankstick -54%
Exclusiv online!

Stabilizator Carp Spirit Blax Single Bankstick

acs370073
Livrare 48-72ore

89,00Lei(-54%) 41,00Lei

Forfac Boilie Strategy Rig Shot On The Pod Nr.6
Exclusiv online!

Forfac Boilie Strategy Rig Shot On The Pod Nr.6

8517-006
Livrare 48-72 ore

10,81Lei

Forfac Boilie Strategy Rig Shot On The Pod Nr.10
Exclusiv online!

Forfac Boilie Strategy Rig Shot On The Pod Nr.10

8517-010
Livrare 48-72 ore

10,81Lei

STABILIZATOR TRAKKO INOX SUPORT LANSETA

STABILIZATOR TRAKKO INOX SUPORT LANSETA

1240
Livrare imediată!

49,00Lei

Rod Pod FOX Black Label QR 3 COMPLETE KIT -14%
Exclusiv online!

Rod Pod FOX Black Label QR 3 COMPLETE KIT

crp045
Livrare 7-14 zile

1.394,97Lei(-14%) 1.199,98Lei

Forfac Boilie Strategy Rig Shot On The Pod Nr.8
Exclusiv online!

Forfac Boilie Strategy Rig Shot On The Pod Nr.8

8517-008
Livrare 48-72 ore

10,81Lei

Suport Mivardi Feeder Pod Multi
Exclusiv online!

Suport Mivardi Feeder Pod Multi

m-fpmult
Livrare 48-72 ore

20,00Lei

ROD-POD PROLOGIC C-SERIES CONVERTIBLE 3 POSTURI

ROD-POD PROLOGIC C-SERIES CONVERTIBLE 3 POSTURI

a6.pro.72722
Livrare imediată!

360,97Lei

STABILIZATOR PICHET FOX Black Label Slim
Exclusiv online!

STABILIZATOR PICHET FOX Black Label Slim

cbs071
Livrare 7-14 zile

44,15Lei

SET ROD POD LINEAEFFE 3 POSTURI 3 SWINGERS HUSA

SET ROD POD LINEAEFFE 3 POSTURI 3 SWINGERS HUSA

a6.6313014
Livrare imediată!

312,70Lei

Adaptor FOX BLACK LABEL QR STABILISER

Adaptor FOX BLACK LABEL QR STABILISER

cbs060
Livrare imediată!

85,47Lei

PICIOARE Trabucco SUPORT GNT BLACK ROLLER REST
Exclusiv online!

PICIOARE Trabucco SUPORT GNT BLACK ROLLER REST

086-21-510
Livrare 48-72 ore

60,00Lei

Rod Pod Fox Horizon Duo Camo Pod 4 posturi -14%
Exclusiv online!

Rod Pod Fox Horizon Duo Camo Pod 4 posturi

crp038
Livrare 7-14 zile

1.282,46Lei(-14%) 1.099,99Lei

ROD POD PROLOGIC STAINLESS STEEL 2 POSTURI

ROD POD PROLOGIC STAINLESS STEEL 2 POSTURI

a6.pro.72767
Livrare imediată!

1.005,34Lei

Picioare de rezervă pentru RPX-4 BW / 2buc 70-140cm

Picioare de rezervă pentru RPX-4 BW / 2buc 70-140cm

870000331
Livrare imediată!

134,01Lei

Afişare 81 - 100 din 220 (11 pagini)
Queries: 5, Total time: 7.302 ms [By time] [By id] [By file]
1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = '5cdb2a789406b07734d7be8407'
/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 (6.788)
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 (MATCH(pd.tag) AGAINST('+pod' 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:737
4 (0.145)
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
5 (0.119)
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