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 - Maver

Produse ce potrivesc criteriilor de căutare


LANSETA SHIMANO TRIBAL TX-A MARKER 3.66 m 3.00 Lbs 2seg -38%

LANSETA SHIMANO TRIBAL TX-A MARKER 3.66 m 3.00 Lbs 2seg

txam12300
Livrare imediată!

565,00Lei(-38%) 353,00Lei

Motor Rhino BLX 70 Electric Outboard -25%

Motor Rhino BLX 70 Electric Outboard

9930070
Livrare imediată!

2.924,00Lei(-25%) 2.200,00Lei

ANCORA MUSTAD TRIPLA BRONZ ROTUNDA NR 8

ANCORA MUSTAD TRIPLA BRONZ ROTUNDA NR 8

m.35647.8
Livrare imediată!

31,13Lei

Carp Zoom VARGA ENTRANT MULTI POLE 2.0m
Exclusiv online!

Carp Zoom VARGA ENTRANT MULTI POLE 2.0m

cz2835
Livrare 48-72 ore

28,00Lei

Varga Tica Lacus 7.00m

Varga Tica Lacus 7.00m

lovba70007
Livrare imediată!

470,00Lei

ANCORA, MUSTAD, TRIPLA, BRONZ, ROTUNDA, NR, 10, m.35647.10, Ancore, Ancore Mustad, Mustad

ANCORA, MUSTAD, TRIPLA, BRONZ, ROTUNDA, NR, 10, m.35647.10, Ancore, Ancore Mustad, Mustad

m.35647.10
Livrare imediată!

31,13Lei

CIP ARROW PENTRU CHEMATOARE ELECTRICA R810 10 SPECII CU BLANA
Exclusiv online!

CIP ARROW PENTRU CHEMATOARE ELECTRICA R810 10 SPECII CU BLANA

vte.c450.a
Livrare 24-48 ore

260,62Lei

Croseta Matrix Super Stop Needle

Croseta Matrix Super Stop Needle

gac419
Livrare imediată!

15,60Lei

CAP MINCIOG MATRIX CARP LANDING NETS 60x50 cm

CAP MINCIOG MATRIX CARP LANDING NETS 60x50 cm

gln065
Livrare imediată!

83,20Lei

VARF MATRIX FEEDER COMMERCIAL BOMB ROD CARBON TIPS 2.4mm 1.5 OZ
Exclusiv online!

VARF MATRIX FEEDER COMMERCIAL BOMB ROD CARBON TIPS 2.4mm 1.5 OZ

grd156
Livrare 7-14 zile

143,95Lei

VARF MATRIX FEEDER COMMERCIAL BOMB ROD CARBON TIPS 2.4mm 2OZ
Exclusiv online!

VARF MATRIX FEEDER COMMERCIAL BOMB ROD CARBON TIPS 2.4mm 2OZ

grd157
Livrare 7-14 zile

143,95Lei

Fir textil K-Karp Dynatex Eazy Strip 35lbs 16m Camou Green

Fir textil K-Karp Dynatex Eazy Strip 35lbs 16m Camou Green

198-60-035
Livrare imediată!

25,00Lei

LANSETA FEEDER MATRIX X PRO COMMERCIAL FEEDER RODS 10FT -14%
Exclusiv online!

LANSETA FEEDER MATRIX X PRO COMMERCIAL FEEDER RODS 10FT

grd150
Livrare 7-14 zile

1.394,97Lei(-14%) 1.198,90Lei

METHOD FEEDER MATRIX OPEN ALLOY INTER FEEDERS 20GR

METHOD FEEDER MATRIX OPEN ALLOY INTER FEEDERS 20GR

gfr236
Livrare imediată!

15,71Lei

Fir textil K-Karp Dynatex Eazy Strip 45lbs 16m Camou Green

Fir textil K-Karp Dynatex Eazy Strip 45lbs 16m Camou Green

198-60-045
Livrare imediată!

28,00Lei

Fir Textil Varivas AVANI EGING TIP RUN PREMIUM PE 150m 0.128mm 10.0lb Tricolore
Exclusiv online!

Fir Textil Varivas AVANI EGING TIP RUN PREMIUM PE 150m 0.128mm 10.0lb Tricolore

v30115006
Livrare 48-72 ore

152,00Lei

CAP MINCIOG MATRIX CARP LANDING NETS 45x35 cm

CAP MINCIOG MATRIX CARP LANDING NETS 45x35 cm

gln064
Livrare imediată!

65,21Lei

Lanseta Bolognesa Mifine Magician Bolo 4 M

Lanseta Bolognesa Mifine Magician Bolo 4 M

4129196213813
Livrare imediată!

149,90Lei

Carp Zoom VARGA ENTRANT MULTI POLE 4.0m

Carp Zoom VARGA ENTRANT MULTI POLE 4.0m

cz2859
Livrare imediată!

43,99Lei

Carp Zoom VARGA ENTRANT MULTI POLE 5.0m

Carp Zoom VARGA ENTRANT MULTI POLE 5.0m

cz2866
Livrare imediată!

63,00Lei

Afişare 61 - 80 din 5551 (278 pagini)
Queries: 6, Total time: 293.940 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = 'fcf1d51755bd5f40787063c0db'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.134)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (273.287)
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 "%tri%") 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
5 (20.154)
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 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.139)
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