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


SHAD BASS ASSASSIN TURBO SHAD ALBINO GHOST 10CM 10BUC/PLIC

SHAD BASS ASSASSIN TURBO SHAD ALBINO GHOST 10CM 10BUC/PLIC

091538304746
Livrare imediată!

33,90Lei

Shad Relax King Shad 3inch Laminat 7.5cm RKS3-L045 10 buc/plic

Shad Relax King Shad 3inch Laminat 7.5cm RKS3-L045 10 buc/plic

ks3-l045
Livrare imediată!

24,00Lei

Surub Pop-up Nash Double Ended Screw 10buc/plic
Exclusiv online!

Surub Pop-up Nash Double Ended Screw 10buc/plic

t8101
Livrare 7-14 zile

29,99Lei

Agrafa Cralusso clips cu vartej Nr.6 10buc/plic
Exclusiv online!

Agrafa Cralusso clips cu vartej Nr.6 10buc/plic

82161406
Livrare 24-48 ore

8,00Lei

CARLIGE FUDO ISEAMA BN-1701 Nr. 4 Black Nikel 17 buc/plic -20%

CARLIGE FUDO ISEAMA BN-1701 Nr. 4 Black Nikel 17 buc/plic

1701-4
Livrare imediată!

10,00Lei(-20%) 8,00Lei

Agrafe cu Vartej Daiwa Tournament D-SNAP, 7buc/plic Nr. 7 / 13kg
Exclusiv online!

Agrafe cu Vartej Daiwa Tournament D-SNAP, 7buc/plic Nr. 7 / 13kg

a7.16513.000
Livrare 24-48 ore

27,11Lei

Carlige Fudo Sode (SODE-BN) nr.8 BN - Black Nickel 20 buc/plic -20%

Carlige Fudo Sode (SODE-BN) nr.8 BN - Black Nickel 20 buc/plic

1201-8
Livrare imediată!

10,00Lei(-20%) 8,00Lei

PLUMB ROMB JAXON CU TUB ANTITANGLE MARO 80GR 1BUC/PLIC
Exclusiv online!

PLUMB ROMB JAXON CU TUB ANTITANGLE MARO 80GR 1BUC/PLIC

cp-128280
Livrare 48-72 ore

15,51Lei

CARLIG GURU SUPER MWG EYED NR.12 10BUC/PLIC

CARLIG GURU SUPER MWG EYED NR.12 10BUC/PLIC

gu.gsmwb12
Livrare imediată!

13,90Lei

Carlige Energo Team Excalibur Carp Classic Ns Nr 4 10buc/plic

Carlige Energo Team Excalibur Carp Classic Ns Nr 4 10buc/plic

47020004
Livrare imediată!

8,00Lei

Jig Lestat Owner 11751, Nr.5/0, 11g, 4buc/plic -27%

Jig Lestat Owner 11751, Nr.5/0, 11g, 4buc/plic

117515011
Livrare imediată!

15,01Lei(-27%) 10,90Lei

SHAD BASS ASSASSIN TURBO SHAD CALCASIEU BREW 10CM 10BUC/PLIC

SHAD BASS ASSASSIN TURBO SHAD CALCASIEU BREW 10CM 10BUC/PLIC

091538303268
Livrare imediată!

33,90Lei

Shad Sakura Jackax 140mm Fire Tiger 1Buc/Plic -49%

Shad Sakura Jackax 140mm Fire Tiger 1Buc/Plic

130134saplf5005140-ft
Livrare imediată!

22,72Lei(-49%) 11,60Lei

VARTEJ CRALUSSO CU AGRAFA 12BUC/PLIC Nr.5 2115
Exclusiv online!

VARTEJ CRALUSSO CU AGRAFA 12BUC/PLIC Nr.5 2115

82075305
Livrare 24-48 ore

10,00Lei

Carlige Maruto 8355BD-BN Nr 4 10buc/plic
Exclusiv online!

Carlige Maruto 8355BD-BN Nr 4 10buc/plic

43202004
Livrare 24-48 ore

9,50Lei

Ancore Mivardi Yamatsu Treble Nr.2/0 4buc/plic

Ancore Mivardi Yamatsu Treble Nr.2/0 4buc/plic

m-ythr20
Livrare imediată!

15,01Lei

Carlige Cralusso Koaji Round Nr.10 14Buc/Plic
Exclusiv online!

Carlige Cralusso Koaji Round Nr.10 14Buc/Plic

46602010
Livrare 24-48 ore

9,00Lei

Shad Relax Kopyto 2.5inch Standard 6.2cm RKBLS25-S035 10 buc/plic

Shad Relax Kopyto 2.5inch Standard 6.2cm RKBLS25-S035 10 buc/plic

bls25-s035
Livrare imediată!

17,01Lei

Carlige Fudo Chinu with Ring (CHNR-TF) nr.1/0 TF - Teflonat 6 buc/plic -20%

Carlige Fudo Chinu with Ring (CHNR-TF) nr.1/0 TF - Teflonat 6 buc/plic

1107-1/0
Livrare imediată!

10,00Lei(-20%) 8,00Lei

Line Aligner Carp Spirit Weed Green 2/4 15buc/plic

Line Aligner Carp Spirit Weed Green 2/4 15buc/plic

acs010127
Livrare imediată!

19,00Lei

Afişare 3781 - 3800 din 10439 (522 pagini)
Queries: 4, Total time: 676.923 ms [By time] [By id] [By file]
1 (0.132)
SELECT data
FROM `oc_session`
WHERE session_id = '15370306379e176f95e19d40a5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.083)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (676.595)
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 (pd.tag LIKE "%buc/plic%") 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.113)
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