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


Lanseta Telescopica Daiwa Black Widow Feeder 3.60m 120g 6+2SEG
Exclusiv online!

Lanseta Telescopica Daiwa Black Widow Feeder 3.60m 120g 6+2SEG

d.11574.365
Livrare 24-48 ore

365,65Lei

LANSETA TRABUCCO SPECTRUM XTC COMPETITION FEEDER 3.60M 40 ML
Exclusiv online!

LANSETA TRABUCCO SPECTRUM XTC COMPETITION FEEDER 3.60M 40 ML

150-81-200
Livrare 48-72 ore

675,00Lei

Montura Feeder Jaxon, Model FG, 30cm, Nr.6, 0.22mm, 8buc/plic

Montura Feeder Jaxon, Model FG, 30cm, Nr.6, 0.22mm, 8buc/plic

hy-mfg06
Livrare imediată!

11,00Lei

METHOD FEEDER TRABUCCO AIRTEK PRO FEEDER FLATBED LARGE 50g

METHOD FEEDER TRABUCCO AIRTEK PRO FEEDER FLATBED LARGE 50g

140-70-160
Livrare imediată!

18,00Lei

Minciog Delphin mijloc din guma 2 tronsoane 50x50cm 170cm

Minciog Delphin mijloc din guma 2 tronsoane 50x50cm 170cm

942420020
Livrare imediată!

64,00Lei

MOMITOR MAVER PRO-FEEDER PLASTIC GRIP MESH 50GR -30%
Exclusiv online!

MOMITOR MAVER PRO-FEEDER PLASTIC GRIP MESH 50GR

179150
Livrare 48-72 ore

15,60Lei(-30%) 10,90Lei

Suport Matrix 3D-R Cross Arm Medium pentru Scaun Modular 28cm
Exclusiv online!

Suport Matrix 3D-R Cross Arm Medium pentru Scaun Modular 28cm

gba022
Livrare 7-14 zile

98,37Lei

Varf Feeder Sportex Rapid Method Feeder 3.60m/4.0oz -32%

Varf Feeder Sportex Rapid Method Feeder 3.60m/4.0oz

mf3622a3
Livrare imediată!

69,00Lei(-32%) 47,01Lei

VARTEJ SIMPLU NR 24 MAVER
Exclusiv online!

VARTEJ SIMPLU NR 24 MAVER

1504024
Livrare 48-72 ore

5,70Lei

MULINETA JAXON PIANO VT 300
Exclusiv online!

MULINETA JAXON PIANO VT 300

kj-pvt300
Livrare 48-72 ore

120,00Lei

Rig Feeder Owner 56930 No.8 0.22 FD 01 Spear

Rig Feeder Owner 56930 No.8 0.22 FD 01 Spear

5693008
Livrare imediată!

19,49Lei

Varf pentru Delphin Opium feeder CarbonGlass 2 OZ

Varf pentru Delphin Opium feeder CarbonGlass 2 OZ

130383730
Livrare imediată!

43,99Lei

MOMITOR FEEDER JAXON OVAL 10GR 25X29mm 10BUC/PLIC
Exclusiv online!

MOMITOR FEEDER JAXON OVAL 10GR 25X29mm 10BUC/PLIC

aw-oa010
Livrare 48-72 ore

93,00Lei

VARF JAXON FEEDER GLASS 2.8mm 50cm Super Soft
Exclusiv online!

VARF JAXON FEEDER GLASS 2.8mm 50cm Super Soft

ak-sws280aa
Livrare 48-72 ore

25,00Lei

FIR MONOFILAMENT MIVARDI FEEDER CARP 0.165mm/200m/2.80kg -26%

FIR MONOFILAMENT MIVARDI FEEDER CARP 0.165mm/200m/2.80kg

miv-lcf216
Livrare imediată!

20,00Lei(-26%) 14,90Lei

Fir Multifilament Nevis S Braid 15m 0.26mm
Exclusiv online!

Fir Multifilament Nevis S Braid 15m 0.26mm

3227-026
Livrare 48-72 ore

13,99Lei

Lanseta Browning Argon 2.0 Feeder MHD 3.60m 120gr

Lanseta Browning Argon 2.0 Feeder MHD 3.60m 120gr

12213361
Livrare imediată!

449,78Lei

Mulineta Okuma Powerliner Pro 8000 -17%

Mulineta Okuma Powerliner Pro 8000

plp-8000
Livrare imediată!

359,09Lei(-17%) 299,00Lei

Juvelnic Delphin BASE 35 80cm

Juvelnic Delphin BASE 35 80cm

950900320
Livrare imediată!

41,00Lei

Mulineta Mivardi Sigma 6000
Exclusiv online!

Mulineta Mivardi Sigma 6000

miv-rsig60
Livrare 48-72 ore

219,00Lei

Afişare 6161 - 6180 din 12495 (625 pagini)
Queries: 4, Total time: 280.884 ms [By time] [By id] [By file]
1 (0.166)
SELECT data
FROM `oc_session`
WHERE session_id = '1bfed7d779cfb867848419b27a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.092)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (280.387)
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('+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
4 (0.239)
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