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


Plumb Feeder Daiwa N Zon Quad Bomb, 50g, 2buc/pac

Plumb Feeder Daiwa N Zon Quad Bomb, 50g, 2buc/pac

a.13365.050
Stoc epuizat

18,99Lei

Plumb Feeder Daiwa N Zon Oval Bomb 20g, 2buc/pac

Plumb Feeder Daiwa N Zon Oval Bomb 20g, 2buc/pac

a.13368.020
Stoc epuizat

15,32Lei

Plumb Feeder Daiwa N Zon Quad Bomb 20g, 2buc/pac

Plumb Feeder Daiwa N Zon Quad Bomb 20g, 2buc/pac

a.13365.020
Stoc epuizat

13,74Lei

FIR ENERGOTEAM MONOFILAMENT CARP HUNTER UV 150M 0.25mm 8.30kg

FIR ENERGOTEAM MONOFILAMENT CARP HUNTER UV 150M 0.25mm 8.30kg

30041125
Stoc epuizat

8,00Lei

Tambur Rezerva CARP EXPERT FEEDER 4000

Tambur Rezerva CARP EXPERT FEEDER 4000

20890409
Stoc epuizat

29,00Lei

Plumb Daiwa Feeder N Zon Tri Bomb 30g, 2buc/pac

Plumb Daiwa Feeder N Zon Tri Bomb 30g, 2buc/pac

a.13360.030
Stoc epuizat

15,18Lei

Plumb Feeder Daiwa N Zon Quad Bomb 60g, 2buc/pac

Plumb Feeder Daiwa N Zon Quad Bomb 60g, 2buc/pac

a.13365.060
Stoc epuizat

20,96Lei

Mulineta Fl Strategist 5000s

Mulineta Fl Strategist 5000s

64-8032
Stoc epuizat

134,51Lei

Plumb Feeder Daiwa N Zon Oval Bomb 60g, 2buc/pac

Plumb Feeder Daiwa N Zon Oval Bomb 60g, 2buc/pac

a.13368.060
Stoc epuizat

20,96Lei

Plumbi Daiwa N Zon Quad Bomb 40g

Plumbi Daiwa N Zon Quad Bomb 40g

a.13365.040
Stoc epuizat

17,02Lei

Juvelnic Fl Necauciucat Cu Husa 2.5 M Diametru 45CM

Juvelnic Fl Necauciucat Cu Husa 2.5 M Diametru 45CM

7511725227441
Stoc epuizat

104,39Lei

Lanseta Trakko Javelin Method Feeder 3.60m, 320g, 3+3seg

Lanseta Trakko Javelin Method Feeder 3.60m, 320g, 3+3seg

tr12336-360
Stoc epuizat

215,00Lei

LANSETA FL FINEZZA PICKER 2.70M, 100-200G, 2+3SEG

LANSETA FL FINEZZA PICKER 2.70M, 100-200G, 2+3SEG

2201-2702
Stoc epuizat

229,90Lei

Lanseta Trakko Javelin Method Feeder 3.90m, 360g, 3+3seg

Lanseta Trakko Javelin Method Feeder 3.90m, 360g, 3+3seg

tr13337-390
Stoc epuizat

245,00Lei

Mulineta FL DA 6500

Mulineta FL DA 6500

4422169223155
Stoc epuizat

53,49Lei

Mulineta FL Tokushima EFB 6000

Mulineta FL Tokushima EFB 6000

7777003
Stoc epuizat

75,90Lei

Mulineta Shimano Ultegra XSC Ci4+ 5500 + Tambur de Rezerva + 3 Reductii Tambur -5%

Mulineta Shimano Ultegra XSC Ci4+ 5500 + Tambur de Rezerva + 3 Reductii Tambur

ultci45500xsc
Stoc epuizat

1.144,99Lei(-5%) 1.087,80Lei

Lanseta feeder Shimano Aero X1 Distance Power 3.96m 120g 3+2seg -38%

Lanseta feeder Shimano Aero X1 Distance Power 3.96m 120g 3+2seg

aex1dhpfdr13
Stoc epuizat

525,00Lei(-38%) 328,00Lei

Lanseta Feeder Shimano Aero X1 Distance 3.96m 90g 3+2seg -38%

Lanseta Feeder Shimano Aero X1 Distance 3.96m 90g 3+2seg

aex1dfdr13
Stoc epuizat

495,00Lei(-38%) 309,00Lei

JUVELNIC FL CAUCIUCAT + HUSA 2.5MT DIAMETRU 45CM

JUVELNIC FL CAUCIUCAT + HUSA 2.5MT DIAMETRU 45CM

5511729797010
Stoc epuizat

123,37Lei

Afişare 12421 - 12440 din 12464 (624 pagini)
Queries: 8, Total time: 365.206 ms [By time] [By id] [By file]
1 (0.096)
SELECT data
FROM `oc_session`
WHERE session_id = 'd2d102719f32e07a5db2ffce00'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (315.805)
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('+feeder' 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:724
4 (48.799)
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 12420, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.124)
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
6 (0.078)
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.075)
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
8 (0.131)
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