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 3 Swingere FOX MK2 Illuminated Swinger 3 Rod Set (R,O,G) -16%
Exclusiv online!

Set 3 Swingere FOX MK2 Illuminated Swinger 3 Rod Set (R,O,G)

csi054
Livrare 7-14 zile

832,46Lei(-16%) 699,99Lei

Banda fixare lanseta Carp Zoom Neopren Rod Band 4x26cm
Exclusiv online!

Banda fixare lanseta Carp Zoom Neopren Rod Band 4x26cm

cz3390
Livrare 48-72 ore

26,00Lei

Rod Pod Carp Academy Eco
Exclusiv online!

Rod Pod Carp Academy Eco

6102-001
Livrare 48-72 ore

122,00Lei

Suport Matrix 3D-R Angled Rod Holder pentru Scaun Modular

Suport Matrix 3D-R Angled Rod Holder pentru Scaun Modular

gba016
Livrare imediată!

76,46Lei

ATA MATISAJ FUJI A-ULTRA BRIGHT 100m 50 GOLDEN ROD 014
Exclusiv online!

ATA MATISAJ FUJI A-ULTRA BRIGHT 100m 50 GOLDEN ROD 014

mftupa0014
Livrare 48-72 ore

21,00Lei

Husa pentru Buzz Bar Fox R-Series 3-Rod 51x6x23cm

Husa pentru Buzz Bar Fox R-Series 3-Rod 51x6x23cm

clu382
Livrare imediată!

112,46Lei

STABILIZATOR STARBAITS INOX PT. SUPORT LANSETA -60%
Exclusiv online!

STABILIZATOR STARBAITS INOX PT. SUPORT LANSETA

a6.s24668
Livrare 24-48 ore

174,25Lei(-60%) 69,70Lei

Picioare Extensibile Pentru Rod Pod Fox Horizon Duo Pod, 2 buc/set

Picioare Extensibile Pentru Rod Pod Fox Horizon Duo Pod, 2 buc/set

crp033
Livrare imediată!

193,46Lei

ROD POD MIVARDI HARDCORE XL CU 3 POSTURI -29%

ROD POD MIVARDI HARDCORE XL CU 3 POSTURI

m-rphc
Livrare imediată!

863,00Lei(-29%) 616,90Lei

Rod Pod Prologic Tri-Sky Aluminiu 3 Posturi

Rod Pod Prologic Tri-Sky Aluminiu 3 Posturi

a6.pro.54367
Livrare imediată!

728,33Lei

Bank Stick DAM 105cm Telescopic Rod Rest cu V

Bank Stick DAM 105cm Telescopic Rod Rest cu V

40929140402
Livrare imediată!

28,99Lei

Suport Stabilizator CARP ZOOM Bankstick Stabilizer

Suport Stabilizator CARP ZOOM Bankstick Stabilizer

cz2508
Livrare imediată!

42,99Lei

Husa ZEBCO Rod Holdall 150x10x8cm

Husa ZEBCO Rod Holdall 150x10x8cm

8420005
Livrare imediată!

71,78Lei

RODPOD CARP ZOOM FANATIC N4
Exclusiv online!

RODPOD CARP ZOOM FANATIC N4

cz3796
Livrare 48-72 ore

657,00Lei

STABILIZATOR PICHET NGT INOX 76MM

STABILIZATOR PICHET NGT INOX 76MM

ngt-frr-stabiliser-dlx
Livrare imediată!

30,00Lei

Rod Pod Prowess Starpod 3-4 poz.
Exclusiv online!

Rod Pod Prowess Starpod 3-4 poz.

41333prceh3007
Livrare 48-72 ore

945,85Lei

RODPOD CARP ZOOM FANATIC N3
Exclusiv online!

RODPOD CARP ZOOM FANATIC N3

cz2362
Livrare 48-72 ore

636,00Lei

Bank Stick DAM 130cm Telescopic Rod Rest cu V
Exclusiv online!

Bank Stick DAM 130cm Telescopic Rod Rest cu V

40929140403
Livrare 48-72 ore

29,85Lei

BANDA CATGEAR NEOPRENE ROD BELTS -19%

BANDA CATGEAR NEOPRENE ROD BELTS

302-00-600
Livrare imediată!

22,00Lei(-19%) 17,90Lei

Suport Matrix 3D-R Multi Angle Rod Holder pentru Scaun Modular -26%

Suport Matrix 3D-R Multi Angle Rod Holder pentru Scaun Modular

gba034
Livrare imediată!

269,95Lei(-26%) 198,90Lei

Afişare 301 - 320 din 1505 (76 pagini)
Queries: 4, Total time: 34.902 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = '820a8a7d4a2e0c5a83d62bd519'
/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 (34.524)
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('+rod' 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.162)
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