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


Ancora Black Cat No.2/0 Treble Hook DG Coating

Ancora Black Cat No.2/0 Treble Hook DG Coating

4551200
Livrare imediată!

49,28Lei

Fir Delphin FIN Strong CARP 1200m Galben Fluo 0.28mm -51%

Fir Delphin FIN Strong CARP 1200m Galben Fluo 0.28mm

500604528
Livrare imediată!

75,01Lei(-51%) 36,90Lei

Lanseta Trabucco Energhia XR Dynamic Match 4.50m 8-22g
Exclusiv online!

Lanseta Trabucco Energhia XR Dynamic Match 4.50m 8-22g

153-32-450
Livrare 48-72 ore

2.350,00Lei

CARLIGE CARP ZOOM MARSHAL ORIGO CLASSIC BOILIE nr 6 10/PLIC

CARLIGE CARP ZOOM MARSHAL ORIGO CLASSIC BOILIE nr 6 10/PLIC

cz4595
Livrare imediată!

11,50Lei

Carlig Black Cat No.1/0 Ghost Gripper Hook DG Coating

Carlig Black Cat No.1/0 Ghost Gripper Hook DG Coating

4553100
Livrare imediată!

58,27Lei

NALUCA SAVAGE GEAR HYBRID PIKE 17CM 45GR SS04 -25%

NALUCA SAVAGE GEAR HYBRID PIKE 17CM 45GR SS04

f1.sg.50223
Livrare imediată!

70,00Lei(-25%) 52,34Lei

K-KARP XTR ANTI TANGLE SLEEVES XL
Exclusiv online!

K-KARP XTR ANTI TANGLE SLEEVES XL

190-00-145
Livrare 48-72 ore

20,96Lei

Cap Minciog Nevis 55x45cm

Cap Minciog Nevis 55x45cm

4238-106
Livrare imediată!

52,00Lei

Fir textil Kryston Score Zero Leadfree Muddy Brown 45lb/10m
Exclusiv online!

Fir textil Kryston Score Zero Leadfree Muddy Brown 45lb/10m

krsc31
Livrare 48-72 ore

66,00Lei

Carlig Black Cat No.8/0 Mega Hook DG Coating

Carlig Black Cat No.8/0 Mega Hook DG Coating

4555800
Livrare imediată!

49,28Lei

Spatula Campingaz Premium pentru Gratar din Otel Inoxidabil
Exclusiv online!

Spatula Campingaz Premium pentru Gratar din Otel Inoxidabil

2000014564
Livrare 24-48 ore

115,00Lei

Mulineta DAM Quick 4 8000 FD, 0.45mm-390m, 5.1:1, 6+1BB

Mulineta DAM Quick 4 8000 FD, 0.45mm-390m, 5.1:1, 6+1BB

dam.60856
Livrare imediată!

445,02Lei

Fir inaintas Climax CULT CRAP SHOCK LEADER 100m 0.60mm 45lb 20.3kg Camouflage
Exclusiv online!

Fir inaintas Climax CULT CRAP SHOCK LEADER 100m 0.60mm 45lb 20.3kg Camouflage

8511-10100-060
Livrare 48-72 ore

30,00Lei

Spinnertail Biwaa Divinator, Red Head, 14cm, 22g

Spinnertail Biwaa Divinator, Red Head, 14cm, 22g

b000545
Livrare imediată!

50,00Lei

Suport Lanseta Haldorado Feeder Buzz Bar 3X-450 -25%

Suport Lanseta Haldorado Feeder Buzz Bar 3X-450

hd-kt4503x
Livrare imediată!

75,01Lei(-25%) 55,89Lei

PLUTE MOSTIRO MARIAN 0.30GR 10 BUC
Exclusiv online!

PLUTE MOSTIRO MARIAN 0.30GR 10 BUC

bf45-0003
Livrare 48-72 ore

36,50Lei

CIZME LEMIGO -30 C EVA GRENLANDER 862 MAR.45

CIZME LEMIGO -30 C EVA GRENLANDER 862 MAR.45

lx.7586244.45
Livrare imediată!

141,71Lei

Carlig Black Cat No.6/0 Mega Hook DG Coating

Carlig Black Cat No.6/0 Mega Hook DG Coating

4555600
Livrare imediată!

44,78Lei

Fir Textil Spiderwire Dura 4 Galben 020MM/17KG/150M
Exclusiv online!

Fir Textil Spiderwire Dura 4 Galben 020MM/17KG/150M

p.1450408
Livrare 24-48 ore

72,28Lei

Cap Minciog Nevis Nylon 55x45cm Plasa 7mm Rotund

Cap Minciog Nevis Nylon 55x45cm Plasa 7mm Rotund

4238-007
Livrare imediată!

72,99Lei

Afişare 1901 - 1920 din 5029 (252 pagini)
Queries: 5, Total time: 572.008 ms [By time] [By id] [By file]
1 (0.114)
SELECT data
FROM `oc_session`
WHERE session_id = '9f05c4693161486f2834bba78d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (552.036)
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 "%45%") 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 (19.605)
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 1900, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.144)
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