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


Tambur Rezerva Grey Tital Spare Spool 3/4
Exclusiv online!

Tambur Rezerva Grey Tital Spare Spool 3/4

1546699
Livrare 7-14 zile

594,96Lei

Tambur Rezerva Mulineta Sonik XTractor Pro 5000
Exclusiv online!

Tambur Rezerva Mulineta Sonik XTractor Pro 5000

bc0014
Livrare 48-72 ore

99,86Lei

Vobler Rapture Pro Vibe Silent 5cm, 14g, NAY

Vobler Rapture Pro Vibe Silent 5cm, 14g, NAY

180-22-302
Livrare imediată!

34,00Lei

Vobler Rapture Pro Vibe Silent 6cm, 16g, OB
Exclusiv online!

Vobler Rapture Pro Vibe Silent 6cm, 16g, OB

180-22-404
Livrare 48-72 ore

35,00Lei

Vobler Rapture Pro X Vibe Sinking, MAY, 8.5g, 4.5cm

Vobler Rapture Pro X Vibe Sinking, MAY, 8.5g, 4.5cm

180-22-502
Livrare imediată!

32,00Lei

Atractant Lichid Pro Line Booster, Scopex, 500ml
Exclusiv online!

Atractant Lichid Pro Line Booster, Scopex, 500ml

pl2803
Livrare 48-72 ore

49,00Lei

Banda Antialunecare Pentru Undita 2.5x180cm

Banda Antialunecare Pentru Undita 2.5x180cm

4962393612771
Livrare imediată!

17,90Lei

Carlige pentru Somn Profi Blinker OShaughnessy Inox, Nr.6/0, 5buc/plic

Carlige pentru Somn Profi Blinker OShaughnessy Inox, Nr.6/0, 5buc/plic

670-60
Livrare imediată!

14,49Lei

CARLIGE PRO FL CAT FISH HOOK TEFLONATE NR 2/0 10BUC

CARLIGE PRO FL CAT FISH HOOK TEFLONATE NR 2/0 10BUC

64-26291
Livrare imediată!

10,90Lei

Cizme Sold Garbolino Neopren 4mm Cauciuc Precision Pro, 42-43
Exclusiv online!

Cizme Sold Garbolino Neopren 4mm Cauciuc Precision Pro, 42-43

81430gotbc2077-42/43
Livrare 48-72 ore

481,05Lei

Cizme Sold Garbolino Neopren 4mm Cauciuc Precision Pro, 44-45
Exclusiv online!

Cizme Sold Garbolino Neopren 4mm Cauciuc Precision Pro, 44-45

81430gotbc2077-44/45
Livrare 48-72 ore

481,05Lei

Combo Mitchell Catch Pro Tele Light, 20-60g, 3.30m, 4seg
Exclusiv online!

Combo Mitchell Catch Pro Tele Light, 20-60g, 3.30m, 4seg

1544448
Livrare 7-14 zile

118,70Lei

Copertina Rive Waterproof Negru XL, 49x39cm
Exclusiv online!

Copertina Rive Waterproof Negru XL, 49x39cm

90810708054
Livrare 48-72 ore

327,90Lei

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

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

3572307862027
Livrare imediată!

383,20Lei

Cutie Plano ProLatch 3500 StowAway

Cutie Plano ProLatch 3500 StowAway

pmc2350000
Livrare imediată!

26,97Lei

Dispozitiv Mikado pentru Transport si Protectie Lansete 130-200cm
Exclusiv online!

Dispozitiv Mikado pentru Transport si Protectie Lansete 130-200cm

uwd-mini-130
Livrare 48-72 ore

42,00Lei

Faina Krill 100G
Exclusiv online!

Faina Krill 100G

fk-100
Livrare 48-72 ore

12,99Lei

Fir Monofilament Guru Pulse Pro, 0.20mm, 6.1lb, 300m
Exclusiv online!

Fir Monofilament Guru Pulse Pro, 0.20mm, 6.1lb, 300m

a.gu.gpro06
Livrare 24-48 ore

74,32Lei

Galeata Prologic Element Water Bag Transparent - Camo, Medium, 7.9l

Galeata Prologic Element Water Bag Transparent - Camo, Medium, 7.9l

a8.pro.72825
Livrare imediată!

111,03Lei

Geaca Impermeabila Trakker TechPro Waterproof Jacket, Marime XL
Exclusiv online!

Geaca Impermeabila Trakker TechPro Waterproof Jacket, Marime XL

206504
Livrare 7-14 zile

749,95Lei

Afişare 961 - 980 din 7178 (359 pagini)
Queries: 5, Total time: 725.426 ms [By time] [By id] [By file]
1 (0.120)
SELECT data
FROM `oc_session`
WHERE session_id = '7de75e16f7255fd2ae53f1990a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (696.761)
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 (pd.tag LIKE "%pro%") 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 (28.287)
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 960, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.145)
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