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


Geanta Penn Carry-All
Exclusiv online!

Geanta Penn Carry-All

1545361
Livrare 7-14 zile

629,96Lei

Geanta Sert Carryall K-Line 45L, 50x35x26cm
Exclusiv online!

Geanta Sert Carryall K-Line 45L, 50x35x26cm

90401seclm310445
Livrare 48-72 ore

196,27Lei

Geanta Colmic Arizona 300, 60x35x28 cm
Exclusiv online!

Geanta Colmic Arizona 300, 60x35x28 cm

bo264
Livrare 48-72 ore

320,00Lei

Geanta EVA Avid Carp Stormshield Compact Caddy 27x27x13cm
Exclusiv online!

Geanta EVA Avid Carp Stormshield Compact Caddy 27x27x13cm

a0430087
Livrare 7-14 zile

130,46Lei

Geanta Nash Carryall Small, 29x52x30cm

Geanta Nash Carryall Small, 29x52x30cm

t3546
Livrare imediată!

251,99Lei

Geanta Penn Waterproof Rollup Bag, 59x27x43cm
Exclusiv online!

Geanta Penn Waterproof Rollup Bag, 59x27x43cm

1543824
Livrare 7-14 zile

224,96Lei

Geanta Colmic Kansas 50, 24x9x22cm
Exclusiv online!

Geanta Colmic Kansas 50, 24x9x22cm

bo270
Livrare 48-72 ore

189,00Lei

GEANTA SPORTEX SUPER-SAFE SPINNING XV 40X26X14CM
Exclusiv online!

GEANTA SPORTEX SUPER-SAFE SPINNING XV 40X26X14CM

s320004
Livrare 48-72 ore

240,00Lei

GEANTA SHIMANO TRIBAL XTR 1 4 POUCH

GEANTA SHIMANO TRIBAL XTR 1 4 POUCH

shtrxtr102
Livrare imediată!

65,00Lei

Geanta Fox Roaba Barrow Front Bag -37%

Geanta Fox Roaba Barrow Front Bag

clu423
Stoc epuizat

196,77Lei(-37%) 124,59Lei

GEANTA GURU EVA FUSION BAIT PRO

GEANTA GURU EVA FUSION BAIT PRO

a4.gu.glg019
Stoc epuizat

417,98Lei

GEANTA K-KARP EVASION DESK CARRYALL

GEANTA K-KARP EVASION DESK CARRYALL

193-10-130
Stoc epuizat

320,00Lei

Geanta Delphin ATAK Carry All Multi -35%

Geanta Delphin ATAK Carry All Multi

101000337
Stoc epuizat

447,00Lei(-35%) 292,00Lei

Geanta Baracuda B15 accesorii 36x14x26cm -38%

Geanta Baracuda B15 accesorii 36x14x26cm

b15 -geanta
Stoc epuizat

85,89Lei(-38%) 52,99Lei

GEANTA SAVAGE GEAR BIG BAG XL 83L

GEANTA SAVAGE GEAR BIG BAG XL 83L

a8.sg.74255
Stoc epuizat

102,49Lei

Geanta Carp Spirit Accesorii Cu Multiple Compartimente 40x24x32 cm

Geanta Carp Spirit Accesorii Cu Multiple Compartimente 40x24x32 cm

acs070008
Stoc epuizat

518,99Lei

GEANTA GURU FUSION FEEDER BOX

GEANTA GURU FUSION FEEDER BOX

a8.gu.glg033
Stoc epuizat

455,50Lei

Geanta Shimano Tactical Compact Carryall

Geanta Shimano Tactical Compact Carryall

shtxl01
Stoc epuizat

230,00Lei

Geanta Delphin Classa CROSSBODY

Geanta Delphin Classa CROSSBODY

101001519
Stoc epuizat

85,89Lei

Geanta Korum Transition Tackle & Bait Stack 49x24x31cm

Geanta Korum Transition Tackle & Bait Stack 49x24x31cm

k0290043
Stoc epuizat

337,46Lei

Afişare 221 - 240 din 312 (16 pagini)
Queries: 7, Total time: 11.364 ms [By time] [By id] [By file]
1 (0.138)
SELECT data
FROM `oc_session`
WHERE session_id = '3851016cd4d5e746cea464d54c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.125)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (10.585)
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 (MATCH(pd.tag) AGAINST('+genti +universale' 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
4 (0.158)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.129)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.128)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.101)
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