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


BOILIES CARLIG THE ONE PURPLE 14/18/20MM 150GR

BOILIES CARLIG THE ONE PURPLE 14/18/20MM 150GR

98036925
Livrare imediată!

24,00Lei

Boilies Dynamite Baits The Crave S/L 1Kg 20mm

Boilies Dynamite Baits The Crave S/L 1Kg 20mm

dy903
Livrare imediată!

69,00Lei

BOILIES DYNAMITE BAITS COMPLEX-T 20MM 1KG
Exclusiv online!

BOILIES DYNAMITE BAITS COMPLEX-T 20MM 1KG

dy1083
Livrare 48-72ore

69,00Lei

FIR MONOFILAMENT ADVANCE 150M 0.20MM/4.5KG 1.5/10LB/CLEAR
Exclusiv online!

FIR MONOFILAMENT ADVANCE 150M 0.20MM/4.5KG 1.5/10LB/CLEAR

sav20c150
Livrare 48-72ore

49,00Lei

FIR MONOFILAMENT SUFIX FEEDER Mono 0.20mm 150M 7.3LB BURGUNDY -30%

FIR MONOFILAMENT SUFIX FEEDER Mono 0.20mm 150M 7.3LB BURGUNDY

ds1xl0200mzb2o
Livrare imediată!

30,00Lei(-30%) 20,90Lei

MULINETA OKUMA AZAKI FD 3000 0.20mm/300m -0%

MULINETA OKUMA AZAKI FD 3000 0.20mm/300m

azaki-30
Livrare imediată!

125,10Lei(-0%) 124,90Lei

BOILIES SOLUBIL SENZOR PORUMB 20mm 1kg

BOILIES SOLUBIL SENZOR PORUMB 20mm 1kg

snz00180
Livrare imediată!

39,00Lei

Fir Cralusso Feeder Prestige 0,20mm 150m

Fir Cralusso Feeder Prestige 0,20mm 150m

33904020
Livrare imediată!

31,00Lei

BOILIES DE CARLIG CPK SQUID CAPSUNA SOLUBIL 16/20MM 100GR

BOILIES DE CARLIG CPK SQUID CAPSUNA SOLUBIL 16/20MM 100GR

999273
Livrare imediată!

18,00Lei

Fir Monofilament Filstar Tornado 0.20mm/100m/6.8Kg

Fir Monofilament Filstar Tornado 0.20mm/100m/6.8Kg

laz-00000436
Livrare imediată!

19,90Lei

BOILIES CPK XXL SOLUBIL 1KG 20MM

BOILIES CPK XXL SOLUBIL 1KG 20MM

999003
Livrare imediată!

57,00Lei

Fir Monofilament Jaxon Satori Feeder 150m, 0.20mm, 9kg

Fir Monofilament Jaxon Satori Feeder 150m, 0.20mm, 9kg

zj-saf020a
Livrare imediată!

18,00Lei

FIR TRABUCCO SUPER ELITE FLUORINE 0.20MM/50M
Exclusiv online!

FIR TRABUCCO SUPER ELITE FLUORINE 0.20MM/50M

058-58-200
Livrare 48-72 ore

19,00Lei

BOILIES SOLUBIL SENZOR CAPSUNA 20mm 1kg

BOILIES SOLUBIL SENZOR CAPSUNA 20mm 1kg

snz00175
Livrare imediată!

39,00Lei

FIR MONOFILAMENT TRABUCCO MAX PLUS LINE ALLROUND /150mt 0,20MM

FIR MONOFILAMENT TRABUCCO MAX PLUS LINE ALLROUND /150mt 0,20MM

057-00-200
Livrare imediată!

16,01Lei

BOILIES CPK SQUID CAPSUNA SOLUBIL 20MM 800GR

BOILIES CPK SQUID CAPSUNA SOLUBIL 20MM 800GR

999534
Livrare imediată!

25,00Lei

FIR TRABUCCO S-FORCE XPS SURF CASTING 300mt-0,20mm

FIR TRABUCCO S-FORCE XPS SURF CASTING 300mt-0,20mm

053-47-200
Livrare imediată!

41,00Lei

BASON NGT DE NADIRE 20MM 92CM

BASON NGT DE NADIRE 20MM 92CM

ngt-fo-stick -20mm
Livrare imediată!

35,00Lei

BOILIES CPK STINKY FISH TARE 1KG 20MM

BOILIES CPK STINKY FISH TARE 1KG 20MM

999249
Livrare imediată!

57,00Lei

Masa Pentru Rulat Boilies Carp Expert 20mm

Masa Pentru Rulat Boilies Carp Expert 20mm

80325020
Livrare imediată!

137,00Lei

Afişare 261 - 280 din 1194 (60 pagini)
Queries: 6, Total time: 28.285 ms [By time] [By id] [By file]
1 (0.139)
SELECT data
FROM `oc_session`
WHERE session_id = 'd810f3f167d4a002be3bbb4557'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (27.590)
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 = '2' AND (MATCH(pd.tag) AGAINST('+20mm' 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.142)
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.121)
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
6 (0.187)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38