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


Ringers Duo Wafters Orange & Yellow, 6-10mm, 50g

Ringers Duo Wafters Orange & Yellow, 6-10mm, 50g

8256241150246
Livrare imediată!

35,00Lei

Lanseta Bolognesa Mifine Gloria 7m 10-50g

Lanseta Bolognesa Mifine Gloria 7m 10-50g

4268144592249
Livrare imediată!

232,89Lei

Plumb Daiwa Feeder N Zon Tri Bomb 50g, 2buc/pac
Exclusiv online!

Plumb Daiwa Feeder N Zon Tri Bomb 50g, 2buc/pac

a.13360.050
Livrare 24-48 ore

18,99Lei

Lanseta Trabucco Feeder Kompass XS Stillwater Feeder 3.60m 50g
Exclusiv online!

Lanseta Trabucco Feeder Kompass XS Stillwater Feeder 3.60m 50g

153-73-360
Livrare 48-72 ore

450,00Lei

Lanseta Rapture Acrux 2.74m 15-50g
Exclusiv online!

Lanseta Rapture Acrux 2.74m 15-50g

126-51-600
Livrare 48-72 ore

1.170,00Lei

Lanseta Rapture Sothis 2.43m 15-50g
Exclusiv online!

Lanseta Rapture Sothis 2.43m 15-50g

126-36-400
Livrare 48-72 ore

360,00Lei

TELEMATCH FL SUPER STAR MATCH SUPER STRONG 4.50M 20-50G

TELEMATCH FL SUPER STAR MATCH SUPER STRONG 4.50M 20-50G

7721782334963
Livrare imediată!

246,60Lei

Lanseta Bolognesa Mifine Gloria 6m 10-50g

Lanseta Bolognesa Mifine Gloria 6m 10-50g

3268142031185
Livrare imediată!

183,30Lei

Momitor Method Feeder FL Tija Interschimbabila Dura Flat Marime M 50g

Momitor Method Feeder FL Tija Interschimbabila Dura Flat Marime M 50g

64-0703
Stoc epuizat

9,50Lei

Lanseta Fox Rage Terminator Jigger 2.40m 15-50g 2seg -25%

Lanseta Fox Rage Terminator Jigger 2.40m 15-50g 2seg

nrd293
Stoc epuizat

939,30Lei(-25%) 708,80Lei

COSULET JAXON FEEDER KB PATRAT Z MEDIUM 25X30X44MM 50G 10BUC/SET

COSULET JAXON FEEDER KB PATRAT Z MEDIUM 25X30X44MM 50G 10BUC/SET

aw-kb050
Stoc epuizat

118,00Lei

Lanseta Shimano Vengeance CX Sea Bass MH 2.10m 10-50g 2seg -37%

Lanseta Shimano Vengeance CX Sea Bass MH 2.10m 10-50g 2seg

svcx21sbmh
Stoc epuizat

235,00Lei(-37%) 147,00Lei

Plumb Tungsten Korda Dark Matter Balancing 0.50g

Plumb Tungsten Korda Dark Matter Balancing 0.50g

a.kdmw06
Stoc epuizat

32,30Lei

Momitor Method Feeder Inline FL L 50g 1Buc/plic

Momitor Method Feeder Inline FL L 50g 1Buc/plic

64-2554
Stoc epuizat

9,90Lei

Momitor Feeder Inline Fl Sticky Maggots L 50g 1buc/plic

Momitor Feeder Inline Fl Sticky Maggots L 50g 1buc/plic

64-2516
Stoc epuizat

9,90Lei

Momitor Korda Bait Up 50g

Momitor Korda Bait Up 50g

a.kda011
Stoc epuizat

20,87Lei

Lanseta bolognesa EnergoTeam Emerald River Bolo 5.00M 20-50g -20%

Lanseta bolognesa EnergoTeam Emerald River Bolo 5.00M 20-50g

11023502
Stoc epuizat

166,01Lei(-20%) 132,80Lei

Pasta Trout Trout Bait Taste 50g Roz Crabby -46%

Pasta Trout Trout Bait Taste 50g Roz Crabby

3988012
Stoc epuizat

31,29Lei(-46%) 17,02Lei

LANSETA FEEDER GURU 2 SEG N-GAUGE FEEDER 3.00M 50G

LANSETA FEEDER GURU 2 SEG N-GAUGE FEEDER 3.00M 50G

gu.grd008
Stoc epuizat

828,53Lei

LANSETA SPINNING DAIWA 2SEG MORETHAN SHAD ATTACK 2.40M 15-50G -32%

LANSETA SPINNING DAIWA 2SEG MORETHAN SHAD ATTACK 2.40M 15-50G

d.11115.246
Stoc epuizat

2.011,34Lei(-32%) 1.375,00Lei

Afişare 461 - 480 din 630 (32 pagini)
Queries: 6, Total time: 14.721 ms [By time] [By id] [By file]
1 (0.072)
SELECT data
FROM `oc_session`
WHERE session_id = '3e2dbc8c26f6ca0b891592abe9'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (14.145)
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('+50g' 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.143)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.141)
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
6 (0.117)
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