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


Pelete Umectate Feeder Bait, Bloodworm, 2mm, 600g
Exclusiv online!

Pelete Umectate Feeder Bait, Bloodworm, 2mm, 600g

fb28-6
Livrare 48-72 ore

30,80Lei

Penar Riguri Zeck 25x21x6cm
Exclusiv online!

Penar Riguri Zeck 25x21x6cm

90405160033
Livrare 48-72 ore

151,03Lei

Suport Pentru 4 Lansete Zeck pentru Barca Gonflabila Sau Belly Boat
Exclusiv online!

Suport Pentru 4 Lansete Zeck pentru Barca Gonflabila Sau Belly Boat

150205260029
Livrare 48-72 ore

308,23Lei

Fir Monofilament Nytro Sublime Power Rig Mono Transparent, 100m, 0.15mm, 1.9kg

Fir Monofilament Nytro Sublime Power Rig Mono Transparent, 100m, 0.15mm, 1.9kg

20600023
Livrare imediată!

25,09Lei

Fir Monofilament Nytro Sublime Power Rig Mono Transparent, 100m, 0.23mm, 4.4kg
Exclusiv online!

Fir Monofilament Nytro Sublime Power Rig Mono Transparent, 100m, 0.23mm, 4.4kg

20600027
Livrare 48-72 ore

25,09Lei

Fir Monofilament Nytro Sublime Power Rig Mono Transparent, 100m, 0.25mm, 5.5kg

Fir Monofilament Nytro Sublime Power Rig Mono Transparent, 100m, 0.25mm, 5.5kg

20600028
Livrare imediată!

25,09Lei

Fir Sensual N.G. Carp 0.24Mm/10.5Kg/600M - Transparent
Exclusiv online!

Fir Sensual N.G. Carp 0.24Mm/10.5Kg/600M - Transparent

zsn100-600-024
Livrare 48-72 ore

31,20Lei

Fir Textil Nash Baseline Sinking Braid, UV Yellow, 13.6kg, 30lbs, 0.28mm, 600m
Exclusiv online!

Fir Textil Nash Baseline Sinking Braid, UV Yellow, 13.6kg, 30lbs, 0.28mm, 600m

t6010
Livrare 7-14 zile

391,95Lei

Geanta Impermeabila Zeck Tackle Container HT, Size M, 35x23x25cm

Geanta Impermeabila Zeck Tackle Container HT, Size M, 35x23x25cm

90405260060
Livrare imediată!

218,70Lei

Leadcore Konger Primavara Vara, 25lbs, 5m
Exclusiv online!

Leadcore Konger Primavara Vara, 25lbs, 5m

110206960006025
Livrare 48-72 ore

27,27Lei

Montura CARP EXPERT Smart Classic Boilie Rig, Nr.2, 2buc/pac
Exclusiv online!

Montura CARP EXPERT Smart Classic Boilie Rig, Nr.2, 2buc/pac

42860020
Livrare 24-48 ore

8,16Lei

Montura CARP EXPERT Smart Classic Boilie Rig, Nr.4, 2buc/pac
Exclusiv online!

Montura CARP EXPERT Smart Classic Boilie Rig, Nr.4, 2buc/pac

42860040
Livrare 24-48 ore

8,16Lei

Mulineta DAIWA Tournament S 6000T ENTO, 0.35mm/360m, 3.5:1, 8rul
Exclusiv online!

Mulineta DAIWA Tournament S 6000T ENTO, 0.35mm/360m, 3.5:1, 8rul

d.10124.065
Livrare 24-48 ore

1.785,40Lei

Mulineta Sonik Vaderx, 6000RS
Exclusiv online!

Mulineta Sonik Vaderx, 6000RS

vxr060rs
Livrare 48-72 ore

295,39Lei

Nada Method Feeder Champion By Filip G. Amb. Easy-Open Resigilabil
Exclusiv online!

Nada Method Feeder Champion By Filip G. Amb. Easy-Open Resigilabil

fhp-mf600-cf
Livrare 48-72 ore

24,00Lei

Ochelari Polarizati Zeck Gray

Ochelari Polarizati Zeck Gray

70105260043
Livrare imediată!

162,63Lei

Tambur de Rezerva pentru Mulineta TRABUCCO Venger FA 6000
Exclusiv online!

Tambur de Rezerva pentru Mulineta TRABUCCO Venger FA 6000

034-47-960
Livrare 48-72 ore

68,00Lei

Ancore Triple VMC 7560BN Cat Spirit, Nr.2/0, 5buc/pac
Exclusiv online!

Ancore Triple VMC 7560BN Cat Spirit, Nr.2/0, 5buc/pac

rg6000026
Livrare 48-72ore

65,00Lei

Ancore Triple VMC 7560BN Cat Spirit, Nr.3/0, 5buc/pac
Exclusiv online!

Ancore Triple VMC 7560BN Cat Spirit, Nr.3/0, 5buc/pac

rg6000027
Livrare 48-72ore

82,00Lei

Ancore Triple VMC 7560BN Cat Spirit, Nr.4/0, 4buc/pac
Exclusiv online!

Ancore Triple VMC 7560BN Cat Spirit, Nr.4/0, 4buc/pac

rg6000028
Livrare 48-72ore

87,00Lei

Afişare 421 - 440 din 2036 (102 pagini)
Queries: 8, Total time: 585.883 ms [By time] [By id] [By file]
1 (0.190)
SELECT data
FROM `oc_session`
WHERE session_id = 'bdea787ddd7dc9da46008e2c39'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (576.718)
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 (pd.tag LIKE "%600%") 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 (8.348)
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 420, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.138)
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.124)
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
7 (0.131)
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
8 (0.150)
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