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


SET SAIBE CARBON 3BUC PT SHIMANO AERLEX 10.000, ULTEGRA XTD SI XSD 14000, SPEEDCAST SI BIG BAIT RUNNER

SET SAIBE CARBON 3BUC PT SHIMANO AERLEX 10.000, ULTEGRA XTD SI XSD 14000, SPEEDCAST SI BIG BAIT RUNNER

5173170340919
Livrare imediată!

35,00Lei

SET SAIBE CARBON 3BUC PT SHIMANO ULTEGRA XTD SI XSD 5500 SI MEDIUM BAITRUNNER

SET SAIBE CARBON 3BUC PT SHIMANO ULTEGRA XTD SI XSD 5500 SI MEDIUM BAITRUNNER

3274178643568
Livrare imediată!

35,00Lei

Set 3 Saibe Carbon Okuma Axeon VII Plus Bolt Inlocuire Arc

Set 3 Saibe Carbon Okuma Axeon VII Plus Bolt Inlocuire Arc

7204177471660
Livrare imediată!

40,00Lei

Fir Carp Expert Carbon 0.25mm 300m

Fir Carp Expert Carbon 0.25mm 300m

30101025
Livrare imediată!

18,00Lei

VARF MATRIX FEEDER COMMERCIAL BOMB ROD CARBON TIPS 2.4mm 1.5 OZ
Exclusiv online!

VARF MATRIX FEEDER COMMERCIAL BOMB ROD CARBON TIPS 2.4mm 1.5 OZ

grd156
Livrare 7-14 zile

143,95Lei

VARF MATRIX FEEDER COMMERCIAL BOMB ROD CARBON TIPS 2.4mm 2OZ
Exclusiv online!

VARF MATRIX FEEDER COMMERCIAL BOMB ROD CARBON TIPS 2.4mm 2OZ

grd157
Livrare 7-14 zile

143,95Lei

Minciog FL Strategist 200K Coada 2 Segmente Carbon 3K 2M Deschidere 1M

Minciog FL Strategist 200K Coada 2 Segmente Carbon 3K 2M Deschidere 1M

5153213113250
Livrare imediată!

283,20Lei

VARF MATRIX FEEDER COMMERCIAL BOMB ROD CARBON TIPS 2.4mm 1 OZ
Exclusiv online!

VARF MATRIX FEEDER COMMERCIAL BOMB ROD CARBON TIPS 2.4mm 1 OZ

grd155
Livrare 7-14 zile

143,95Lei

MANER MINCIOG JAXON TELE CARBON 3.6M

MANER MINCIOG JAXON TELE CARBON 3.6M

pl-afe360
Livrare imediată!

209,00Lei

MANER JAXON MINCIOG TELE CARBON LM 3.0M
Exclusiv online!

MANER JAXON MINCIOG TELE CARBON LM 3.0M

pl-afc300
Livrare 48-72 ore

184,00Lei

VARF MATRIX FEEDER COMMERCIAL FEEDER ROD CARBON TIPS 2.4mm 2 OZ
Exclusiv online!

VARF MATRIX FEEDER COMMERCIAL FEEDER ROD CARBON TIPS 2.4mm 2 OZ

grd159
Livrare 7-14 zile

143,95Lei

VARF MATRIX FEEDER COMMERCIAL FEEDER ROD CARBON TIPS 2.4mm 2.5 OZ
Exclusiv online!

VARF MATRIX FEEDER COMMERCIAL FEEDER ROD CARBON TIPS 2.4mm 2.5 OZ

grd160
Livrare 7-14 zile

143,95Lei

MANER JAXON MINCIOG TELE CARBON 2.4M
Exclusiv online!

MANER JAXON MINCIOG TELE CARBON 2.4M

pl-afe240
Livrare 48-72 ore

156,00Lei

Maner Minciog Carbon FL Toreador Telescopic 2.5M

Maner Minciog Carbon FL Toreador Telescopic 2.5M

8153219062788
Livrare imediată!

99,90Lei

MANER JAXON MINCIOG TELE CARBON LM 4.0M
Exclusiv online!

MANER JAXON MINCIOG TELE CARBON LM 4.0M

pl-afc400
Livrare 48-72 ore

250,00Lei

Varf Rezerva Benzar Lanseta Universal Feeder 3oz Carbon Rosu -20%

Varf Rezerva Benzar Lanseta Universal Feeder 3oz Carbon Rosu

12329105
Livrare imediată!

35,00Lei(-20%) 28,00Lei

COBRA PRO LINE X-TREME CARBON BANANA
Exclusiv online!

COBRA PRO LINE X-TREME CARBON BANANA

pl13044
Livrare 48-72 ore

465,00Lei

Minciog FOX Horizon X6 42" Carbon Landing Net (Camo Mesh), 2 Tronsoane, 2.40m -25%
Exclusiv online!

Minciog FOX Horizon X6 42" Carbon Landing Net (Camo Mesh), 2 Tronsoane, 2.40m

cln056
Livrare 7-14 zile

1.403,95Lei(-25%) 1.052,96Lei

Minciog FOX Horizon X6 42" Carbon Landing Net (Camo Mesh), 1.80m -25%
Exclusiv online!

Minciog FOX Horizon X6 42" Carbon Landing Net (Camo Mesh), 1.80m

cln055
Livrare 7-14 zile

1.237,46Lei(-25%) 928,09Lei

Varf Maver Carbon Tubular Bolo 4.0-1.5mm/100cm
Exclusiv online!

Varf Maver Carbon Tubular Bolo 4.0-1.5mm/100cm

1580044
Livrare 48-72ore

23,00Lei

Afişare 1 - 20 din 503 (26 pagini)
Queries: 5, Total time: 12.676 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '8b3f37a9d63c11a661ba92211a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (12.127)
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('+carbon' 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.179)
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.115)
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