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


INEL LINEAEFFE VARF TITAN TUB=1.2MM D=6MM -30%
Exclusiv online!

INEL LINEAEFFE VARF TITAN TUB=1.2MM D=6MM

a9.3000212
Livrare 24-48 ore

4,50Lei(-30%) 3,15Lei

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 1/L 3.20x600mm

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 1/L 3.20x600mm

101-00-210
Livrare imediată!

69,00Lei

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 0/UL 2.20x550
Exclusiv online!

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 0/UL 2.20x550

101-00-010
Livrare 48-72 ore

65,00Lei

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 0/UL 2.85x700mm
Exclusiv online!

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 0/UL 2.85x700mm

101-00-110
Livrare 48-72 ore

69,00Lei

INEL LINEAEFFE VARF TITAN TUB=2.0MM D=4MM -30%
Exclusiv online!

INEL LINEAEFFE VARF TITAN TUB=2.0MM D=4MM

a9.3000220
Livrare 24-48 ore

4,50Lei(-30%) 3,15Lei

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 3/M 2.85x600mm
Exclusiv online!

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 3/M 2.85x600mm

101-00-140
Livrare 48-72 ore

69,00Lei

STARLITA LINEAEFFE NIGHTLIGHT PENTRU VARF MARIME XL
Exclusiv online!

STARLITA LINEAEFFE NIGHTLIGHT PENTRU VARF MARIME XL

a.4922057
Livrare 24-48 ore

4,50Lei

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 1/L 2.20x500mm
Exclusiv online!

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 1/L 2.20x500mm

101-00-020
Livrare 48-72 ore

55,00Lei

STARLITA LINEAEFFE NIGHTLIGHT PENTRU VARF MARIME L
Exclusiv online!

STARLITA LINEAEFFE NIGHTLIGHT PENTRU VARF MARIME L

a.4922056
Livrare 24-48 ore

4,50Lei

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 1/L 2.85x700mm
Exclusiv online!

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 1/L 2.85x700mm

101-00-120
Livrare 48-72 ore

69,00Lei

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 2/ML 2.20x500mm
Exclusiv online!

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 2/ML 2.20x500mm

101-00-030
Livrare 48-72 ore

55,00Lei

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 2/ML 2.86x700mm
Exclusiv online!

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 2/ML 2.86x700mm

101-00-130
Livrare 48-72 ore

69,00Lei

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 2/ML 3.20x600mm
Exclusiv online!

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 2/ML 3.20x600mm

101-00-220
Livrare 48-72 ore

69,00Lei

Varf de Rezerva pentru Lansete Arrow SOLID MG 3,0OZ Galben -5%

Varf de Rezerva pentru Lansete Arrow SOLID MG 3,0OZ Galben

arr.fmg.tip
Livrare imediată!

22,80Lei(-5%) 21,71Lei

Varf Feeder Garbolino Fibra Plina Carbon Challenger 4oz, 52cm, 2.9mm
Exclusiv online!

Varf Feeder Garbolino Fibra Plina Carbon Challenger 4oz, 52cm, 2.9mm

21130gofre8299-c-4
Livrare 48-72 ore

56,72Lei

Varf Feeder Garbolino Fibra Plina Carbon Challenger 2oz, 46cm, 2.2mm
Exclusiv online!

Varf Feeder Garbolino Fibra Plina Carbon Challenger 2oz, 46cm, 2.2mm

21130gofre8299-c-2
Livrare 48-72 ore

56,72Lei

Varf Feeder Garbolino Fibra Plina Carbon Challenger 8oz, 52cm, 2.9mm
Exclusiv online!

Varf Feeder Garbolino Fibra Plina Carbon Challenger 8oz, 52cm, 2.9mm

21130gofre8299-c-8
Livrare 48-72 ore

57,48Lei

Varf Guru N-Gauge Specimen 4oz
Exclusiv online!

Varf Guru N-Gauge Specimen 4oz

gu.grd185
Livrare 24-48 ore

92,67Lei

Varf Feeder Garbolino Fibra Plina Carbon Challenger 7oz, 52cm, 2.9mm
Exclusiv online!

Varf Feeder Garbolino Fibra Plina Carbon Challenger 7oz, 52cm, 2.9mm

21130gofre8299-c-7
Livrare 48-72 ore

57,48Lei

Varf Garbolino Oversized Fibra Carbon Plina, 4.00oz, 2.8mm, 0.53m
Exclusiv online!

Varf Garbolino Oversized Fibra Carbon Plina, 4.00oz, 2.8mm, 0.53m

20530gofrj8120-c-4
Livrare 48-72 ore

56,83Lei

Afişare 601 - 620 din 929 (47 pagini)
Queries: 4, Total time: 23.323 ms [By time] [By id] [By file]
1 (0.148)
SELECT data
FROM `oc_session`
WHERE session_id = '9f12a2af31dac144cbe2386114'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (22.941)
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 (MATCH(pd.tag) AGAINST('+varf' 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:722
4 (0.131)
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