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


Inele Luneta Warne Scope Mounts Set Ring Weaver 34mm, Obiectiv 52-56mm
Exclusiv online!

Inele Luneta Warne Scope Mounts Set Ring Weaver 34mm, Obiectiv 52-56mm

vwm.222m
Livrare 24-48 ore

650,39Lei

Line Aligner Mikado, Green, 15buc/plic
Exclusiv online!

Line Aligner Mikado, Green, 15buc/plic

amc-11001-dg
Livrare 48-72 ore

6,00Lei

Pluta Abu Garcia Bombarda Float Stop, Clear, 15g

Pluta Abu Garcia Bombarda Float Stop, Clear, 15g

1110077
Livrare imediată!

16,84Lei

Pompa de Santina Manuala Scotty 65cm
Exclusiv online!

Pompa de Santina Manuala Scotty 65cm

sct545k
Livrare 24-48 ore

280,00Lei

Sapca Blaser Striker SL 566 Dark Olive, Marime Universala
Exclusiv online!

Sapca Blaser Striker SL 566 Dark Olive, Marime Universala

bl.231043.107
Livrare 24-48 ore

156,32Lei

Sapca Blaser Striker SL 566 Orange, Marime Universala
Exclusiv online!

Sapca Blaser Striker SL 566 Orange, Marime Universala

bl.231043.107.1
Livrare 24-48 ore

156,32Lei

Set 3+1buc Bac / Geanta Accesorii Nytro Starkx System Tray 40x27x8.5cm

Set 3+1buc Bac / Geanta Accesorii Nytro Starkx System Tray 40x27x8.5cm

22400007
Livrare imediată!

300,24Lei

Suport cu Plasa pentru Barca Savage Gear, 85x95cm -20%
Exclusiv online!

Suport cu Plasa pentru Barca Savage Gear, 85x95cm

a6.sg.70786
Livrare 24-48 ore

467,31Lei(-20%) 373,84Lei

Valiza Jackall Tackle Container R fara Suporturi Lanseta, Marime M
Exclusiv online!

Valiza Jackall Tackle Container R fara Suporturi Lanseta, Marime M

ja.807246933
Livrare 24-48 ore

720,59Lei

Agrafa Nevis Cross Lock Extra Strong cu Vartej Rolling Nr.4/0, 64mm, 100kg, 5buc/pac

Agrafa Nevis Cross Lock Extra Strong cu Vartej Rolling Nr.4/0, 64mm, 100kg, 5buc/pac

5582-400
Livrare imediată!

10,00Lei

Anouri Solide Cultiva Amaz 72814 Solid Ring Heavy Duty Nr.6.5, 136kg, 12buc/pac

Anouri Solide Cultiva Amaz 72814 Solid Ring Heavy Duty Nr.6.5, 136kg, 12buc/pac

41602110412
Livrare imediată!

19,98Lei

CHOD TOOL CARP ZOOM
Exclusiv online!

CHOD TOOL CARP ZOOM

cz8066
Livrare 48-72 ore

17,01Lei

Cutie Accesorii Rapture Tekbox Tackle System Large D5 (5 Removable Dividers)
Exclusiv online!

Cutie Accesorii Rapture Tekbox Tackle System Large D5 (5 Removable Dividers)

113-20-613
Livrare 48-72 ore

60,00Lei

Cutie Accesorii Rapture Tekbox Tackle System Medium D12 (12 Removable Dividers)
Exclusiv online!

Cutie Accesorii Rapture Tekbox Tackle System Medium D12 (12 Removable Dividers)

113-20-623
Livrare 48-72 ore

43,99Lei

CUTIE CU VARNISURI SILICONICE 0.6-0.7-0.8-0.9-1MM

CUTIE CU VARNISURI SILICONICE 0.6-0.7-0.8-0.9-1MM

64-16230
Livrare imediată!

7,50Lei

Cutie pentru Accesorii Delphin CRP Tackle 36.5x30.0x5.5cm -21%

Cutie pentru Accesorii Delphin CRP Tackle 36.5x30.0x5.5cm

101002320
Livrare imediată!

167,00Lei(-21%) 131,99Lei

Dispozitiv Aplicare Inel Silicon Colmic Bait Bander + Mix 30 Inele Silicon 4-6-8mm

Dispozitiv Aplicare Inel Silicon Colmic Bait Bander + Mix 30 Inele Silicon 4-6-8mm

stop34
Livrare imediată!

45,01Lei

Elastic Trabucco Power Gum, 1.00mm, 10m

Elastic Trabucco Power Gum, 1.00mm, 10m

102-81-010
Livrare imediată!

19,00Lei

FEEDER GUM MARO FL 10M 0.6MM

FEEDER GUM MARO FL 10M 0.6MM

65-25796
Livrare imediată!

8,90Lei

FEEDER GUM MARO FL 10M 1.0MM

FEEDER GUM MARO FL 10M 1.0MM

65-25819
Livrare imediată!

8,90Lei

Afişare 381 - 400 din 3319 (166 pagini)
Queries: 6, Total time: 81.810 ms [By time] [By id] [By file]
1 (0.176)
SELECT data
FROM `oc_session`
WHERE session_id = 'ceadbec206a7d5ee484934604f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.124)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.129)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (67.756)
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('+accesorii' 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 (13.441)
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 380, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.184)
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