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


Fir ASSO Ultra Molecular Shield Dark Green 0.47mm 300m

Fir ASSO Ultra Molecular Shield Dark Green 0.47mm 300m

602080017
Livrare imediată!

65,24Lei

Fir Monofilament Sufix SHOCK MAX Tapered Line 15M CLEAR 0.23-0.57mm, 5x15m/75m -10%

Fir Monofilament Sufix SHOCK MAX Tapered Line 15M CLEAR 0.23-0.57mm, 5x15m/75m

tpr23c15x5
Livrare imediată!

51,00Lei(-10%) 46,01Lei

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.37mm 10.40kg Fluo Orange -25%

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.37mm 10.40kg Fluo Orange

cz6971
Livrare imediată!

72,99Lei(-25%) 54,80Lei

Starlite Cormoran 33x37mm cu Prindere pentru Lanseta 2buc/plic

Starlite Cormoran 33x37mm cu Prindere pentru Lanseta 2buc/plic

a.49.08001
Livrare imediată!

3,80Lei

Fir Select Baits HyperCast Neon Yellow 0.37mm/600m

Fir Select Baits HyperCast Neon Yellow 0.37mm/600m

sel-218031
Livrare imediată!

34,00Lei

Fir Fluorocarbon Colmic Seaguar Secol PowerF 0.117mm 50m
Exclusiv online!

Fir Fluorocarbon Colmic Seaguar Secol PowerF 0.117mm 50m

nysc117
Livrare 48-72 ore

103,99Lei

FIR MONOFILAMENT MAVER SMART EXEL 57 50M 0.07MM
Exclusiv online!

FIR MONOFILAMENT MAVER SMART EXEL 57 50M 0.07MM

653007
Livrare 48-72 ore

27,00Lei

Fir Carp Expert Carbon 0.27mm 300m

Fir Carp Expert Carbon 0.27mm 300m

30101027
Livrare imediată!

18,00Lei

FIR MONOFILAMENT MAVER SMART SLR 50M 0.07MM

FIR MONOFILAMENT MAVER SMART SLR 50M 0.07MM

621007
Livrare imediată!

32,00Lei

Fir Monofilament Jaxon Eternum Spinning Transparent, 150m, 0.27mm, 14kg
Exclusiv online!

Fir Monofilament Jaxon Eternum Spinning Transparent, 150m, 0.27mm, 14kg

zj-ets027a
Livrare 48-72 ore

17,50Lei

Cap Minciog Nevis Nylon 55x45cm Plasa 7mm Rotund

Cap Minciog Nevis Nylon 55x45cm Plasa 7mm Rotund

4238-007
Livrare imediată!

72,99Lei

Fir Carp Expert Carbon 0.17mm 150m

Fir Carp Expert Carbon 0.17mm 150m

30100017
Livrare imediată!

11,00Lei

MOMITOR FEEDER JAXON OVAL 20GR 32*37mm
Exclusiv online!

MOMITOR FEEDER JAXON OVAL 20GR 32*37mm

aw-oc020m
Livrare 48-72 ore

23,00Lei

FIR JAXON ETERNUM PREMIUM 150m 0.27mm
Exclusiv online!

FIR JAXON ETERNUM PREMIUM 150m 0.27mm

zj-etpa027
Livrare 48-72 ore

17,50Lei

Stoper Black Cat Silicone Oval 7mm

Stoper Black Cat Silicone Oval 7mm

3166015
Livrare imediată!

17,78Lei

Momitor Colmic Standard Cage Feeder 50gr 25x37mm
Exclusiv online!

Momitor Colmic Standard Cage Feeder 50gr 25x37mm

fed68d
Livrare 48-72 ore

13,99Lei

FIR MONOFILAMENT CARBOTEX FEEDER ORANGE 027MM/9,95KG/250M
Exclusiv online!

FIR MONOFILAMENT CARBOTEX FEEDER ORANGE 027MM/9,95KG/250M

e.2500.027
Livrare 24-48 ore

26,44Lei

MOMITOR JAXON FEEDER PATRAT 20GR 25X32X37mm 10BUC/SET
Exclusiv online!

MOMITOR JAXON FEEDER PATRAT 20GR 25X32X37mm 10BUC/SET

av-pb020
Livrare 48-72 ore

92,00Lei

KIT PROLOGIC BAIT BALANCING M 7MM

KIT PROLOGIC BAIT BALANCING M 7MM

a.pro.57135
Livrare imediată!

31,99Lei

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.37mm 10.40kg Fluo Pink -25%

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.37mm 10.40kg Fluo Pink

cz7039
Livrare imediată!

72,99Lei(-25%) 54,80Lei

Afişare 281 - 300 din 690 (35 pagini)
Queries: 5, Total time: 2,568.074 ms [By time] [By id] [By file]
1 (0.197)
SELECT data
FROM `oc_session`
WHERE session_id = 'a71c03fb4867a095da1a3e84c6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (2.508)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (2,559.127)
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 (pd.tag LIKE "%7mm%") 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:725
4 (6.091)
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 280, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.151)
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