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 300 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


CARLIGE MAVER MV2 LONG SHANK NR 2 -50%
Exclusiv online!

CARLIGE MAVER MV2 LONG SHANK NR 2

t353
Livrare 48-72 ore

15,01Lei(-50%) 7,50Lei

CARLIGE MAVER MV2 LONG SHANK NR 4 -50%
Exclusiv online!

CARLIGE MAVER MV2 LONG SHANK NR 4

t354
Livrare 48-72 ore

15,01Lei(-50%) 7,50Lei

PLUMB LONGCAST JAXON CU ANTITANGLE MARO 100GR
Exclusiv online!

PLUMB LONGCAST JAXON CU ANTITANGLE MARO 100GR

cp-0005100
Livrare 48-72 ore

11,00Lei

LINGURITA, ROTATIVA, MEPPS, AGLIA, LONG, ARGINTATA, 17G, f.longrainbo4.a, Lingurite Rotative, Lingurite Rotative Mepps, Mepps
Exclusiv online!

LINGURITA, ROTATIVA, MEPPS, AGLIA, LONG, ARGINTATA, 17G, f.longrainbo4.a, Lingurite Rotative, Lingurite Rotative Mepps, Mepps

f.longrainbo4.a
Livrare 24-48 ore

34,16Lei

LINGURITA, ROTATIVA, MEPPS, , AGLIA, LONG, GOLD, 2.5G, f.longrainbo0.g, Lingurite Rotative, Lingurite Rotative Mepps, Mepps
MOMITOR MAVER PRO-FEEDER LONG ARM OPEN END 40GR -30%

MOMITOR MAVER PRO-FEEDER LONG ARM OPEN END 40GR

179240
Livrare imediată!

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

Carlige, Energo, Team, Excalibur, Carp, Long, Shank, Bn, Nr, 2, 6buc/plic, 47300002, Carlige Crap, Carlige Crap EnergoTeam, EnergoTeam
Lingura, rotativa, EnergoTeam, Wizard, Turbo, Long, nr., 3,, culoare, Yellow, 84074386, Lingurite Rotative, Lingurite Rotative EnergoTeam, EnergoTeam
PLUMB LONGCAST JAXON CU ANTITANGLE MARO 40GR

PLUMB LONGCAST JAXON CU ANTITANGLE MARO 40GR

cp-000540
Livrare imediată!

6,00Lei

Method Long Cast Feeder Extra Carp in line 60gr

Method Long Cast Feeder Extra Carp in line 60gr

ec4164
Livrare imediată!

9,81Lei

Carlige VMC 7026 Mystic Carp Long Curve Shank Nr.4 -27%

Carlige VMC 7026 Mystic Carp Long Curve Shank Nr.4

7026 nt4
Livrare imediată!

23,00Lei(-27%) 16,90Lei

PLUMB LONGCAST JAXON CU VARTEJ VERDE 90GR -30%
Exclusiv online!

PLUMB LONGCAST JAXON CU VARTEJ VERDE 90GR

cp-003290g
Livrare 48-72 ore

8,70Lei(-30%) 6,10Lei

Mulineta, Carp, Expert, Pro, Long, Cast, Runner, 8000, 20113800, Mulinete Crap, Mulinete Crap Carp Expert, Carp Expert
LINGURITA ROTATIVA MEPPS AGLIA LONG GOLD 4.5G
Exclusiv online!

LINGURITA ROTATIVA MEPPS AGLIA LONG GOLD 4.5G

f.longrainbo1.g
Livrare 24-48 ore

13,32Lei

Nash Long Range Throwing Handle

Nash Long Range Throwing Handle

t0720
Livrare imediată!

175,99Lei

Carlige Energo Team Excalibur Carp Long Shank Bn Nr 1/0 6buc/plic
Exclusiv online!

Carlige Energo Team Excalibur Carp Long Shank Bn Nr 1/0 6buc/plic

47300010
Livrare 24-48 ore

8,00Lei

CARLIGE MAVER MV2 LONG SHANK NR 8 -50%

CARLIGE MAVER MV2 LONG SHANK NR 8

t350
Livrare imediată!

15,01Lei(-50%) 7,50Lei

ROTATIVA MEPPS AGLIA LONG GOLD 17G
Exclusiv online!

ROTATIVA MEPPS AGLIA LONG GOLD 17G

f.longrainbo4.g
Livrare 24-48 ore

34,16Lei

Rig Somn Black Cat 6/0 Pellet and Chunk Rig Long Hair

Rig Somn Black Cat 6/0 Pellet and Chunk Rig Long Hair

4336133
Livrare imediată!

53,78Lei

Line, Aligner, DAM, MAD, Line, Aligner, 2-6, Green, Long, 4070952177, Accesorii Carlige Crap, Accesorii Carlige Crap D.A.M, D.A.M
Exclusiv online!

Line, Aligner, DAM, MAD, Line, Aligner, 2-6, Green, Long, 4070952177, Accesorii Carlige Crap, Accesorii Carlige Crap D.A.M, D.A.M

4070952177
Livrare 48-72 ore

24,54Lei

Afişare 321 - 340 din 748 (38 pagini)
Queries: 5, Total time: 214.834 ms [By time] [By id] [By file]
1 (0.096)
SELECT data
FROM `oc_session`
WHERE session_id = 'b0de1043c991ad7bafe0b601db'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (211.114)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%long%") 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:698
4 (3.383)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 320, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.142)
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