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 - cahkbr54

Produse ce potrivesc criteriilor de căutare


Mulineta Okuma Ceymar TX-FD 4000 -27%
Exclusiv online!

Mulineta Okuma Ceymar TX-FD 4000

cxt-40fd
Livrare 48-72ore

314,10Lei(-27%) 229,00Lei

Mulineta Browning Black Magic FD 440

Mulineta Browning Black Magic FD 440

0342040
Livrare imediată!

355,27Lei

Lanseta feeder Spro Petri Carp Feeder XXH 3.60m/180g

Lanseta feeder Spro Petri Carp Feeder XXH 3.60m/180g

002470-00361-00000
Livrare imediată!

484,00Lei

Lanseta Feeder Matrix Aquos Ultra-D 3.90m 120g 3 Seg Plus 2 Varfuri -14%

Lanseta Feeder Matrix Aquos Ultra-D 3.90m 120g 3 Seg Plus 2 Varfuri

grd140
Livrare imediată!

494,96Lei(-14%) 425,40Lei

Anti Tangle Rigid 15cm/3Buc/plic-negru
Exclusiv online!

Anti Tangle Rigid 15cm/3Buc/plic-negru

ec9913
Livrare 48-72 ore

4,80Lei

CARLIG GURU QM1 NR.18 10BUC/PL

CARLIG GURU QM1 NR.18 10BUC/PL

gu.gq18
Livrare imediată!

18,94Lei

Antitangle Feeder GoldStar

Antitangle Feeder GoldStar

79020125
Livrare imediată!

5,00Lei

Mulineta Carp Expert Feeder Neo 5000

Mulineta Carp Expert Feeder Neo 5000

20220500
Livrare imediată!

187,00Lei

Minciog Carp Zoom Beta N 2 Sec. 50x50x220cm -24%

Minciog Carp Zoom Beta N 2 Sec. 50x50x220cm

cz0078
Livrare imediată!

96,00Lei(-24%) 72,99Lei

Mulineta Okuma LS-6K Baitfeeder -18%

Mulineta Okuma LS-6K Baitfeeder

ls-6k
Livrare imediată!

488,99Lei(-18%) 399,00Lei

MULINETA TEAM FEEDER BY DOME CARP FIGHTER LCS 60

MULINETA TEAM FEEDER BY DOME CARP FIGHTER LCS 60

2503-460
Livrare imediată!

187,00Lei

ADAPTOR MIVARDI D25 PEENTRU SCAUN FEEDER MASTER

ADAPTOR MIVARDI D25 PEENTRU SCAUN FEEDER MASTER

m-chfmah
Livrare imediată!

24,00Lei

ANTI TANGLE CORMORAN 25CM PT.FEEDER 3BUC/PL

ANTI TANGLE CORMORAN 25CM PT.FEEDER 3BUC/PL

a.49.53125
Livrare imediată!

5,63Lei

MULINETA CORMORAN CORMAXX BR 4000 2RUL/290M/030MM

MULINETA CORMORAN CORMAXX BR 4000 2RUL/290M/030MM

c.19.81400
Livrare imediată!

148,85Lei

Mulineta NGT Max 60 Carp Runner

Mulineta NGT Max 60 Carp Runner

ngt-frl-max60-line
Livrare imediată!

79,00Lei

Bilute Cauciuc 6mm-25Buc Trakko
Exclusiv online!

Bilute Cauciuc 6mm-25Buc Trakko

tr11513-6
Livrare 48-72 ore

6,00Lei

MULINETA TEAM FEEDER BY DOME CARP FIGHTER LCS 50

MULINETA TEAM FEEDER BY DOME CARP FIGHTER LCS 50

2503-450
Livrare imediată!

181,00Lei

MULINETA TRABUCCO KRONOS SFX FD 6000

MULINETA TRABUCCO KRONOS SFX FD 6000

034-38-600
Livrare imediată!

235,00Lei

MULINETA TICA RAGE EA 6000 -21%

MULINETA TICA RAGE EA 6000

ea6000
Livrare imediată!

149,00Lei(-21%) 117,81Lei

MULINETA LINEAEFE VIGOR CARP BAITFEEDER 6000
Exclusiv online!

MULINETA LINEAEFE VIGOR CARP BAITFEEDER 6000

l.1287460
Livrare 24-48 ore

85,64Lei

Afişare 3761 - 3780 din 12491 (625 pagini)
Queries: 7, Total time: 364.672 ms [By time] [By id] [By file]
1 (0.171)
SELECT data
FROM `oc_session`
WHERE session_id = 'fce0ed4909edbceb0a9b133510'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.097)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.161)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (314.156)
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('+feeder' 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
5 (49.725)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 3760, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.192)
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
7 (0.170)
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