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


HUSA CORMORAN 5121 PENTRU LANSETE 155CM

HUSA CORMORAN 5121 PENTRU LANSETE 155CM

a8.65.12155
Livrare imediată!

148,35Lei

Vasle Sevylor pentru barca KB-Hobby 250

Vasle Sevylor pentru barca KB-Hobby 250

204768
Livrare imediată!

179,00Lei

Geanta pentru Momeala De Carlig Fox R-Series 25x12x16cm

Geanta pentru Momeala De Carlig Fox R-Series 25x12x16cm

clu381
Livrare imediată!

121,46Lei

Geanta de Umar Daiwa Prorex pentru Naluci XL 46x34x27cm 3 Cutii -30%
Exclusiv online!

Geanta de Umar Daiwa Prorex pentru Naluci XL 46x34x27cm 3 Cutii

d.15809.420
Livrare 24-48 ore

586,31Lei(-30%) 411,31Lei

PLUMB BETISOR JAXON CU VARTEJ 15GR 2BUC/PLIC

PLUMB BETISOR JAXON CU VARTEJ 15GR 2BUC/PLIC

ck-aa15
Livrare imediată!

8,00Lei

Cutit Cu maner De Lemn Pt Filetat

Cutit Cu maner De Lemn Pt Filetat

8413-001
Livrare imediată!

27,00Lei

Pelete MG Special Carp Porumb 4mm 500gr

Pelete MG Special Carp Porumb 4mm 500gr

mg5570
Livrare imediată!

15,00Lei

Suport Matrix 3D-R Cross Arm Short pentru Scaun Modular 18cm

Suport Matrix 3D-R Cross Arm Short pentru Scaun Modular 18cm

gba021
Livrare imediată!

94,46Lei

Masa Carp expert Pentru Rulat Boilies Italy 16mm
Exclusiv online!

Masa Carp expert Pentru Rulat Boilies Italy 16mm

80325016
Livrare 24-48 ore

137,00Lei

Sita Galeata Maver 17L Mediu

Sita Galeata Maver 17L Mediu

1050001
Livrare imediată!

77,00Lei

CUTIT HELLEFISK LAMA=123 MM

CUTIT HELLEFISK LAMA=123 MM

h.h120
Livrare imediată!

487,59Lei

PRASTIE CORMORAN PRO CARP 1001 PENTRU BOILIES -21%

PRASTIE CORMORAN PRO CARP 1001 PENTRU BOILIES

a.11.01001
Livrare imediată!

37,83Lei(-21%) 29,90Lei

Geanta Carp Spirit Enduro Pentru Accesorii
Exclusiv online!

Geanta Carp Spirit Enduro Pentru Accesorii

125500360
Livrare 48-72ore

139,00Lei

BOILIES CPK XXL TARE 1KG 20MM

BOILIES CPK XXL TARE 1KG 20MM

999001
Livrare imediată!

50,00Lei

SET FOX COOKWARE LARGE 4 PIESE

SET FOX COOKWARE LARGE 4 PIESE

ccw002
Livrare imediată!

427,46Lei

Spreader Block Carp Zoom pentru Minciog

Spreader Block Carp Zoom pentru Minciog

cz5738
Livrare imediată!

26,00Lei

CUTIE KORDA COMPAC SMALL 100
Exclusiv online!

CUTIE KORDA COMPAC SMALL 100

a4.klug01
Livrare 24-48 ore

88,24Lei

Stage Stand X lite -21%

Stage Stand X lite

1406902
Livrare imediată!

80,96Lei(-21%) 63,90Lei

Topor Coghlans la Purtator

Topor Coghlans la Purtator

c1160
Livrare imediată!

173,00Lei

BOILIES CPK XXL TARE 24MM 1KG

BOILIES CPK XXL TARE 24MM 1KG

999184
Livrare imediată!

50,00Lei

Afişare 1481 - 1500 din 5142 (258 pagini)
Queries: 5, Total time: 125.341 ms [By time] [By id] [By file]
1 (0.113)
SELECT data
FROM `oc_session`
WHERE session_id = 'b3cb8ed85b43ad7622ee9862f8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (124.849)
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('+pentru' 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.144)
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
5 (0.149)
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