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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


WINDOW GURU FEEDER SMALL 40G + 50G
Exclusiv online!

WINDOW GURU FEEDER SMALL 40G + 50G

a.gu.gwf04
Livrare 24-48 ore

25,51Lei

METHOD FEEDER GURU IN LINE X-SAFE S 36G

METHOD FEEDER GURU IN LINE X-SAFE S 36G

a.gu.gsmx36
Livrare imediată!

18,04Lei

Set Nevis Method Feeder Matrita plus Momitor plus Conector 20g

Set Nevis Method Feeder Matrita plus Momitor plus Conector 20g

8100-420
Livrare imediată!

17,40Lei

Lanseta DAM Sensomax II Heavy Feeder 3.90m 100-150gr

Lanseta DAM Sensomax II Heavy Feeder 3.90m 100-150gr

2050966326
Livrare imediată!

331,32Lei

MULINETA JAXON BLUE BIRD RD GT300 5RUL
Exclusiv online!

MULINETA JAXON BLUE BIRD RD GT300 5RUL

kj-bbr300
Livrare 48-72 ore

146,00Lei

Lanseta Mivardi Magnetic Feeder 3.60m, 50-100g, 3+3buc
Exclusiv online!

Lanseta Mivardi Magnetic Feeder 3.60m, 50-100g, 3+3buc

miv-maf360h
Livrare 48-72 ore

330,00Lei

Nada Benzar Feeder Special Concurs 1Kg

Nada Benzar Feeder Special Concurs 1Kg

94400157
Livrare imediată!

13,51Lei

SET METHOD FEEDER + MATRITA TRABUCCO AIRTEK PRO FEEDER X-LARGE 60G
Exclusiv online!

SET METHOD FEEDER + MATRITA TRABUCCO AIRTEK PRO FEEDER X-LARGE 60G

140-70-030
Livrare 48-72 ore

33,00Lei

CARLIGE COLMIC NUCLEAR NK800 NICKEL NR 16
Exclusiv online!

CARLIGE COLMIC NUCLEAR NK800 NICKEL NR 16

amo16
Livrare 48-72 ore

17,50Lei

Preston ICS Quick Change Beads Small

Preston ICS Quick Change Beads Small

p0030006
Livrare imediată!

16,87Lei

CARLIGE HISASHI TRABUCCO 11014 NR 8
Exclusiv online!

CARLIGE HISASHI TRABUCCO 11014 NR 8

024-02-080
Livrare 48-72 ore

13,99Lei

FIR AZZURRO MONOFILAMENT 0.22mm/100m/4.75kg

FIR AZZURRO MONOFILAMENT 0.22mm/100m/4.75kg

a22100
Livrare imediată!

6,00Lei

VARTEJ COLMIC DUBLU 1045 NR 20
Exclusiv online!

VARTEJ COLMIC DUBLU 1045 NR 20

gm104520
Livrare 48-72 ore

13,99Lei

Lanseta Colmic Ghepard Feeder 3.60m 120g -25%
Exclusiv online!

Lanseta Colmic Ghepard Feeder 3.60m 120g

cagh70b
Livrare 48-72 ore

646,00Lei(-25%) 484,00Lei

Lanseta Maver UK REALITY PLUS FEEDER 9FT 2.7M 30GR 2sec
Exclusiv online!

Lanseta Maver UK REALITY PLUS FEEDER 9FT 2.7M 30GR 2sec

a2970
Livrare 48-72 ore

430,99Lei

Suport Feeder Browning Rod Rest 35cm

Suport Feeder Browning Rod Rest 35cm

8203013
Livrare imediată!

53,78Lei

VARF LANSETA COLMIC ARATON PRO CARBON MH ALB

VARF LANSETA COLMIC ARATON PRO CARBON MH ALB

caar02n
Livrare imediată!

103,99Lei

VARTEJ CORMORAN NR.10 / 30KG / 7BUC/PLIC

VARTEJ CORMORAN NR.10 / 30KG / 7BUC/PLIC

a7.80.07010
Livrare imediată!

4,46Lei

KAMASAKI Cap Suport Lansete 17042

KAMASAKI Cap Suport Lansete 17042

77041552
Livrare imediată!

9,40Lei

TUB ANTITANGLE JAXON CU CARABINA 24CM MODEL 2

TUB ANTITANGLE JAXON CU CARABINA 24CM MODEL 2

aj-414m
Livrare imediată!

8,50Lei

Afişare 5461 - 5480 din 12491 (625 pagini)
Queries: 6, Total time: 336.439 ms [By time] [By id] [By file]
1 (0.122)
SELECT data
FROM `oc_session`
WHERE session_id = '5af286cccf905d2dd7cbb1a870'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.090)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (282.300)
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('+feeder' 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
5 (53.742)
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 5460, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.108)
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