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


MORMISTE JAXON WOLFRAM PB045 C 0.8G
Exclusiv online!

MORMISTE JAXON WOLFRAM PB045 C 0.8G

mw-pb045c
Livrare 48-72 ore

103,99Lei

Cizme Energo Team Outdoor EVA Polar -40C Nr45
Exclusiv online!

Cizme Energo Team Outdoor EVA Polar -40C Nr45

74237045
Livrare 24-48 ore

208,00Lei

Vartej Owner Amaz Rolling Dublu W Crane Swivel 72457, Nr.20, 6.8kg, 12buc/plic -30%

Vartej Owner Amaz Rolling Dublu W Crane Swivel 72457, Nr.20, 6.8kg, 12buc/plic

410260014
Livrare imediată!

14,14Lei(-30%) 9,90Lei

VOBLER JAXON HS FAT PIKE 2 SEC F FPT 16CM 45GR
Exclusiv online!

VOBLER JAXON HS FAT PIKE 2 SEC F FPT 16CM 45GR

vj-ph16fpt
Livrare 48-72 ore

61,00Lei

OCHELARI JAXON POLARIZANTI X45 AM GRI
Exclusiv online!

OCHELARI JAXON POLARIZANTI X45 AM GRI

ak-okx45sm
Livrare 48-72 ore

59,00Lei

Vartej Agrafa Owner 52459 Nr 14 Sinker Hook W Crane

Vartej Agrafa Owner 52459 Nr 14 Sinker Hook W Crane

410020011
Livrare imediată!

27,99Lei

COSULET FEEDER NISA PLASTIC FLYER Large 28g 45x32mm
Exclusiv online!

COSULET FEEDER NISA PLASTIC FLYER Large 28g 45x32mm

c3
Livrare 48-72ore

8,29Lei

PELETE GAURITE CARP ZOOM HALIBUT 15 MM 800GR

PELETE GAURITE CARP ZOOM HALIBUT 15 MM 800GR

cz4573
Livrare imediată!

32,00Lei

Rod Pod FOX Black Label QR 3 COMPLETE KIT -14%
Exclusiv online!

Rod Pod FOX Black Label QR 3 COMPLETE KIT

crp045
Livrare 7-14 zile

1.394,97Lei(-14%) 1.199,98Lei

Carlig Delphin HKD Feeder HALFER NR.14 -50%

Carlig Delphin HKD Feeder HALFER NR.14

622045014
Livrare imediată!

11,00Lei(-50%) 5,50Lei

CARLIGE CARP ZOOM MARSHAL ORIGO SNAG nr 4
Exclusiv online!

CARLIGE CARP ZOOM MARSHAL ORIGO SNAG nr 4

cz4557
Livrare 48-72 ore

11,50Lei

VOBLER JAXON HS FAT PIKE 2 SEC F FP 16CM 45GR
Exclusiv online!

VOBLER JAXON HS FAT PIKE 2 SEC F FP 16CM 45GR

vj-ph16fp
Livrare 48-72 ore

61,00Lei

Vobler Salmo Slider SD7S, HGS, 7cm, 21g

Vobler Salmo Slider SD7S, HGS, 7cm, 21g

84577533
Livrare imediată!

58,00Lei

Shad BIWAA TailGunR Swimbait 4.5", 310 Kaleido Star, 11.50cm, 5buc/pac
Exclusiv online!

Shad BIWAA TailGunR Swimbait 4.5", 310 Kaleido Star, 11.50cm, 5buc/pac

b001452
Livrare 48-72 ore

26,00Lei

Van Den Eynde nada Amorce Crap 2,5kg
Exclusiv online!

Van Den Eynde nada Amorce Crap 2,5kg

vn00454
Livrare 48-72 ore

31,00Lei

CARLIGE MAVER KATANA 1245 NEGRU NR 10
Exclusiv online!

CARLIGE MAVER KATANA 1245 NEGRU NR 10

1245a010
Livrare 48-72 ore

7,50Lei

Vartej Owner 52445 Rolling King Stainless Swivel KS-11, 45kg, Nr.6, 14buc/plic -29%

Vartej Owner 52445 Rolling King Stainless Swivel KS-11, 45kg, Nr.6, 14buc/plic

407020003
Livrare imediată!

23,70Lei(-29%) 16,90Lei

Carlig Black Cat No.2/0 Gripper Hook DG Coating
Exclusiv online!

Carlig Black Cat No.2/0 Gripper Hook DG Coating

4556200
Livrare 7-14 zile

35,78Lei

Vartej Owner Rolling Dublu W Crane 52457, No.16, 17.8kg, 12buc/plic -28%

Vartej Owner Rolling Dublu W Crane 52457, No.16, 17.8kg, 12buc/plic

410020003
Livrare imediată!

23,40Lei(-28%) 16,90Lei

Vartej Owner Rolling Dublu W Crane 52457, No.12, 35.9kg, 11buc/plic
Exclusiv online!

Vartej Owner Rolling Dublu W Crane 52457, No.12, 35.9kg, 11buc/plic

410020001
Livrare 48-72 ore

23,40Lei

Afişare 2081 - 2100 din 5029 (252 pagini)
Queries: 6, Total time: 676.776 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = 'c59a4fa6a27c9965a250c1105d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.120)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (652.458)
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 = '3' AND (pd.tag LIKE "%45%") 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 (23.786)
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 2080, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.143)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.126)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38