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


Naluca Carp Zoom PREDATOR-Z POPPER FROG 6cm 16gr Culoare: 12

Naluca Carp Zoom PREDATOR-Z POPPER FROG 6cm 16gr Culoare: 12

cz3412
Livrare imediată!

23,00Lei

Carlig Owner C-5 Carp Iseama With Eye Nr.9

Carlig Owner C-5 Carp Iseama With Eye Nr.9

5000046
Livrare imediată!

14,88Lei

CARLIGE CARP ZOOM FEEDER COMPETITION 571 nr.4 10/PLIC

CARLIGE CARP ZOOM FEEDER COMPETITION 571 nr.4 10/PLIC

cz6698
Livrare imediată!

8,50Lei

Method Feeder Glue MG Special Carp G-Amino

Method Feeder Glue MG Special Carp G-Amino

mg0030
Livrare imediată!

20,00Lei

MONTURA CARP ZOOM METHOD FC-545 NR10 SPIN 10mm 8cm 0.18mm

MONTURA CARP ZOOM METHOD FC-545 NR10 SPIN 10mm 8cm 0.18mm

cz6728
Livrare imediată!

12,00Lei

FIR ENERGOTEAM MONOFILAMENT CARP HUNTER UV 150M 0.22mm 6.80kg

FIR ENERGOTEAM MONOFILAMENT CARP HUNTER UV 150M 0.22mm 6.80kg

30041122
Livrare imediată!

7,50Lei

Momitor Ecologic Extra Carp Top Feeder 25G -16%

Momitor Ecologic Extra Carp Top Feeder 25G

f75-8231
Livrare imediată!

5,00Lei(-16%) 4,21Lei

Carlig Owner Nr.2 Carp DRig -29%

Carlig Owner Nr.2 Carp DRig

565592
Livrare imediată!

22,93Lei(-29%) 16,28Lei

Sapca Carp Spirit basebal Neagra CS Trilob -25%
Exclusiv online!

Sapca Carp Spirit basebal Neagra CS Trilob

acs680060
Livrare 48-72ore

59,00Lei(-25%) 44,30Lei

Fir Energo Team Excalibur Carp Fluoro Carbon Coated 200m 0.35mm

Fir Energo Team Excalibur Carp Fluoro Carbon Coated 200m 0.35mm

34055035
Livrare imediată!

21,00Lei

Momitor Extra Carp Method Feeder In Line 35g

Momitor Extra Carp Method Feeder In Line 35g

ec7920
Livrare imediată!

8,50Lei

Carlig Owner C-7 Carp Down Nr.10

Carlig Owner C-7 Carp Down Nr.10

5000057
Livrare imediată!

12,88Lei

Fir Fluorocarbon Carp Spirit cu Camasa Camo Skin Weed Green 20m 15lbs 6.80kg
Exclusiv online!

Fir Fluorocarbon Carp Spirit cu Camasa Camo Skin Weed Green 20m 15lbs 6.80kg

acs640089
Livrare 48-72ore

69,00Lei

FIR TEXTIL CARP ZOOM PREDATOR-Z CLASSIC CATFISH 100m 0.40mm

FIR TEXTIL CARP ZOOM PREDATOR-Z CLASSIC CATFISH 100m 0.40mm

cz7435
Livrare imediată!

37,00Lei

CARLIGE CARP ZOOM FEEDER COMPETITION 571 nr.8 10/PLIC

CARLIGE CARP ZOOM FEEDER COMPETITION 571 nr.8 10/PLIC

cz6674
Livrare imediată!

8,50Lei

Method Feeder Glue MG Special Carp Miere -36%

Method Feeder Glue MG Special Carp Miere

mg0016
Livrare imediată!

20,00Lei(-36%) 12,84Lei

Minciog Carp Expert 8603 240cm

Minciog Carp Expert 8603 240cm

71048240
Livrare imediată!

110,00Lei

Stopper Carp Spirit Boilies Corn Portocaliu 20buc

Stopper Carp Spirit Boilies Corn Portocaliu 20buc

acs010103
Livrare imediată!

16,01Lei

Carlige Fudo Slider Carp (SLCR BN) nr.6 BN Black Nickel 11 buc/plic -20%

Carlige Fudo Slider Carp (SLCR BN) nr.6 BN Black Nickel 11 buc/plic

2801-6
Livrare imediată!

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

Mulineta Okuma Custom Carp CC 7000
Exclusiv online!

Mulineta Okuma Custom Carp CC 7000

cc-7000
Livrare 48-72ore

359,00Lei

Afişare 3361 - 3380 din 7371 (369 pagini)
Queries: 8, Total time: 217.271 ms [By time] [By id] [By file]
1 (0.075)
SELECT data
FROM `oc_session`
WHERE session_id = '572a34c518c013cf4bb8455f9c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.092)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (186.779)
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('+carp' 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 (29.819)
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 3360, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.139)
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.119)
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
7 (0.120)
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
8 (0.128)
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