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


Cutie Plano ProLatch 3700 StowAway -20%

Cutie Plano ProLatch 3700 StowAway

pmc2370002
Livrare imediată!

53,95Lei(-20%) 42,90Lei

Cutie Riguri Korum Rig Blox, 6.8x10.9x7.4cm

Cutie Riguri Korum Rig Blox, 6.8x10.9x7.4cm

k0290083
Livrare imediată!

33,75Lei

Geanta Abu Garcia Large Lure Bag (7 cutii incluse), 38x23x30cm -21%

Geanta Abu Garcia Large Lure Bag (7 cutii incluse), 38x23x30cm

1530846
Livrare imediată!

386,96Lei(-21%) 304,90Lei

Rucsac Zeck Backpack 24000 + Cutii Tackle Box WP S 30x25x45cm

Rucsac Zeck Backpack 24000 + Cutii Tackle Box WP S 30x25x45cm

90405260012
Livrare imediată!

381,84Lei

Tava Laterala Filfishing Feeder Cu 2 Cutii, 37x37x8cm

Tava Laterala Filfishing Feeder Cu 2 Cutii, 37x37x8cm

fil9090
Livrare imediată!

199,99Lei

Cutie Accesorii Carp Zoom Practic Tackle Box, 21.5x11x6.7cm

Cutie Accesorii Carp Zoom Practic Tackle Box, 21.5x11x6.7cm

cz0571
Livrare imediată!

39,00Lei

Cutie Accesorii Delphin KlikBOX Mini 8 10x8.5x2cm

Cutie Accesorii Delphin KlikBOX Mini 8 10x8.5x2cm

101004299
Livrare imediată!

26,00Lei

CUTIE ACCESORII MIKADO PENTRU SETUL DE CRAP 1 comp. 10.5x7x2.5cm
Exclusiv online!

CUTIE ACCESORII MIKADO PENTRU SETUL DE CRAP 1 comp. 10.5x7x2.5cm

uac-ca001-h
Livrare 48-72 ore

6,00Lei

CUTIE ACCESORII MIKADO PENTRU SETUL DE CRAP 2 comp. 10.5x7x2.5cm
Exclusiv online!

CUTIE ACCESORII MIKADO PENTRU SETUL DE CRAP 2 comp. 10.5x7x2.5cm

uac-ca002-h
Livrare 48-72 ore

6,00Lei

CUTIE ACCESORII MIKADO PENTRU SETUL DE CRAP 4 comp.10.5x7x2.5cm
Exclusiv online!

CUTIE ACCESORII MIKADO PENTRU SETUL DE CRAP 4 comp.10.5x7x2.5cm

uac-ca004-h
Livrare 48-72 ore

6,00Lei

Cutie FL Feeder Water Pro L351 x W250 x H 80 MM Fara Accesorii

Cutie FL Feeder Water Pro L351 x W250 x H 80 MM Fara Accesorii

2572361778440
Livrare imediată!

159,90Lei

Cutie Korum Glide Float Blox, 11.6x29.5x4cm
Exclusiv online!

Cutie Korum Glide Float Blox, 11.6x29.5x4cm

k0290088
Livrare 7-14 zile

89,96Lei

Cutie Nevis Accesorii, 20x13x4cm
Exclusiv online!

Cutie Nevis Accesorii, 20x13x4cm

4515-003
Livrare 48-72 ore

18,00Lei

Cutie Plano LockJaw Satchel

Cutie Plano LockJaw Satchel

pmc395010
Livrare imediată!

134,96Lei

Cutie Accesorii Delphin KlikBOX Ideal 24x14x4cm -32%

Cutie Accesorii Delphin KlikBOX Ideal 24x14x4cm

101004297
Livrare imediată!

76,01Lei(-32%) 52,00Lei

Cutie Accesorii Mikado Dubla H318, 18.5x9x5cm
Exclusiv online!

Cutie Accesorii Mikado Dubla H318, 18.5x9x5cm

uach-h318
Livrare 48-72 ore

17,50Lei

Cutie Accesorii Mikado H409, 17.7x9.2x3.5cm
Exclusiv online!

Cutie Accesorii Mikado H409, 17.7x9.2x3.5cm

uach-h409
Livrare 48-72 ore

17,01Lei

Cutie Jackall 2300D Double Open M Clear Black -20%
Exclusiv online!

Cutie Jackall 2300D Double Open M Clear Black

a4.ja.807231984
Livrare 24-48 ore

100,34Lei(-20%) 80,27Lei

Cutie Jackall 2300D Double Open M Clear Red -20%
Exclusiv online!

Cutie Jackall 2300D Double Open M Clear Red

a4.ja.807231991
Livrare 24-48 ore

100,34Lei(-20%) 80,27Lei

Cutie Jackall 2800D Tackle M Clear Black -20%
Exclusiv online!

Cutie Jackall 2800D Tackle M Clear Black

a4.ja.807232011
Livrare 24-48 ore

107,42Lei(-20%) 85,94Lei

Afişare 81 - 100 din 1137 (57 pagini)
Queries: 5, Total time: 28.850 ms [By time] [By id] [By file]
1 (0.159)
SELECT data
FROM `oc_session`
WHERE session_id = '223ab2eb857239e27bbcb10a87'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (23.895)
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('+cutii' 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 (4.550)
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 80, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.135)
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