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


LANSETA JAXON ANTRIS HTI METHOD FEEDER 3.00M 2SEG 3VARFURI 20-60GR -25%
Exclusiv online!

LANSETA JAXON ANTRIS HTI METHOD FEEDER 3.00M 2SEG 3VARFURI 20-60GR

wj-axf300060
Livrare 48-72 ore

240,00Lei(-25%) 180,00Lei

APICALE VARF EXTERN 3.0 MM MAVER
Exclusiv online!

APICALE VARF EXTERN 3.0 MM MAVER

j750
Livrare 48-72 ore

6,50Lei

VARF CORMORAN PT.FEEDER PRO GREEN 2,05OZ Model 3
Exclusiv online!

VARF CORMORAN PT.FEEDER PRO GREEN 2,05OZ Model 3

c.25.2180420g
Livrare 24-48 ore

41,59Lei

VARF, FEEDER, GARBOLINO, ROCKET, PICKER, 3OZ, /, 2.8MM, /, , 520MM, 205300036, Varfuri Feeder, Varfuri Feeder Garbolino, Garbolino
APICALE VERGI VARF BLACKTOR 2.00MM MAVER
Exclusiv online!

APICALE VERGI VARF BLACKTOR 2.00MM MAVER

j527
Livrare 48-72 ore

15,01Lei

CLOPOTEL SPRO DUBLU VARF LANSETA FEEDER NEON 1 BUC

CLOPOTEL SPRO DUBLU VARF LANSETA FEEDER NEON 1 BUC

004199-00008-00000
Livrare imediată!

4,90Lei

Varf Rezerva CARP EXPERT METHOD FEEDER 3.60 CARBON Rosu
Exclusiv online!

Varf Rezerva CARP EXPERT METHOD FEEDER 3.60 CARBON Rosu

12335367
Livrare 24-48 ore

24,00Lei

Varf Spro Carbon Solid 60 Cm 1.4 Mm

Varf Spro Carbon Solid 60 Cm 1.4 Mm

002502-00303-00000
Livrare imediată!

26,70Lei

LANSETA, CORMORAN, 3VARFURI, 3SEG, SPECILAND, ULTRA, FEEDER, 3.90M, 230G, 3SEG, c.25.5300399, Lansete Feeder, Lansete Feeder Cormoran, Cormoran
Varf Semnalizator Copca Shark KR-22100 35

Varf Semnalizator Copca Shark KR-22100 35

203kr2210035
Livrare imediată!

3,72Lei

VARF LANSETA SPRO PETRI FEEDER 2.70M 170 G TIP XH
Exclusiv online!

VARF LANSETA SPRO PETRI FEEDER 2.70M 170 G TIP XH

002470-00271-00101
Livrare 48-72 ore

36,40Lei

CRACAN, JAXON, TELE, VARF, CUI, V, FILETANT, 70-125CM, pz-poa120b, Picheti, Picheti Jaxon, Jaxon

CRACAN, JAXON, TELE, VARF, CUI, V, FILETANT, 70-125CM, pz-poa120b, Picheti, Picheti Jaxon, Jaxon

pz-poa120b
Livrare imediată!

33,00Lei

Varf Feeder Maver Genesis Pro XD 3.90m/100g 3sec 1oz
Exclusiv online!

Varf Feeder Maver Genesis Pro XD 3.90m/100g 3sec 1oz

a2536
Livrare 48-72 ore

67,00Lei

VARF, JAXON, CARBON, 5.0X900MM, 1.5mm, ak-swc50900, Varfuri Vergi, Varfuri Vergi Jaxon, Jaxon

VARF, JAXON, CARBON, 5.0X900MM, 1.5mm, ak-swc50900, Varfuri Vergi, Varfuri Vergi Jaxon, Jaxon

ak-swc50900
Livrare imediată!

25,00Lei

Varf Feeder Maver Genesis Extreme Distance 3.6m/130gr 1oz
Exclusiv online!

Varf Feeder Maver Genesis Extreme Distance 3.6m/130gr 1oz

a2306
Livrare 48-72 ore

49,00Lei

Varf Spro Carbon Solid 60 Cm 1.1 Mm
Exclusiv online!

Varf Spro Carbon Solid 60 Cm 1.1 Mm

002502-00302-00000
Livrare 48-72 ore

21,50Lei

Varf, de, Rezerva, pentru, Lansete, Matrix, Aquos, Ultra-D, Class, 58cm, 3.4mm, 2.5oz, grd146, Varfuri Feeder, Varfuri Feeder Matrix, Matrix
Inel, EnergoTeam, Varf, Match, SIC, UMHSIT, 2,5x4, 81504025, Inele de Lanseta, Inele de Lanseta EnergoTeam, EnergoTeam
Exclusiv online!

Inel, EnergoTeam, Varf, Match, SIC, UMHSIT, 2,5x4, 81504025, Inele de Lanseta, Inele de Lanseta EnergoTeam, EnergoTeam

81504025
Livrare 24-48 ore

7,00Lei

VARF, JAXON, VARGA, TUBULAR, A, 900mm, 7.5mm, Strong, ak-sw001c, Varfuri Vergi, Varfuri Vergi Jaxon, Jaxon
VARF, TRABUCCO, ULTIMATE, PROFESSIONAL, MASTER, FEEDER, PM4, 150-86-004, Varfuri Feeder, Varfuri Feeder Trabucco, Trabucco
Afişare 241 - 260 din 1000 (50 pagini)
Queries: 5, Total time: 197.137 ms [By time] [By id] [By file]
1 (0.078)
SELECT data
FROM `oc_session`
WHERE session_id = 'efd20883151851fa0cccb7090f'
/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 (192.911)
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 = '0' AND (pd.tag LIKE "%varf%") 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.907)
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 240, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.142)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38