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


Vaselina Mikado Pentru Mulinete

Vaselina Mikado Pentru Mulinete

wzi07
Livrare imediată!

9,00Lei

Victorinox Clip Swiss Tool Spirit BS, argintiu 3.0240.B1
Exclusiv online!

Victorinox Clip Swiss Tool Spirit BS, argintiu 3.0240.B1

3.0240.B1
Livrare 48-72ore

88,00Lei

Victorinox Clip Swiss Tool Spirit BS, negru 3.0240.3B1
Exclusiv online!

Victorinox Clip Swiss Tool Spirit BS, negru 3.0240.3B1

3.0240.3b1
Livrare 48-72ore

88,00Lei

Victorinox Clip Swiss Tool, negru 3.0340.3B1
Exclusiv online!

Victorinox Clip Swiss Tool, negru 3.0340.3B1

3.0340.3B1
Livrare 48-72ore

88,00Lei

HUSA PENTRU 3 LANSETE CU 3 MULINETE NGT 13FT

HUSA PENTRU 3 LANSETE CU 3 MULINETE NGT 13FT

ngt-fla-rodholdall-104
Livrare imediată!

295,00Lei

Dispozitiv Electronic Carp Zoom pentru Legat Carlige -21%

Dispozitiv Electronic Carp Zoom pentru Legat Carlige

cz4207
Livrare imediată!

141,00Lei(-21%) 110,90Lei

HUSA CORMORAN 5083 PENTRU LANSETE L 130CM
Exclusiv online!

HUSA CORMORAN 5083 PENTRU LANSETE L 130CM

a8.65.09325
Livrare 24-48 ore

235,05Lei

Sita Extra Carp Diametru 30cm/3mm Din Plastic Dur

Sita Extra Carp Diametru 30cm/3mm Din Plastic Dur

ec3204
Livrare imediată!

32,00Lei

AVERTIZOR ELECTRONIC JAXON PENTRU PRINS PE LANSETA

AVERTIZOR ELECTRONIC JAXON PENTRU PRINS PE LANSETA

aj-syx005
Livrare imediată!

46,01Lei

FeederX - Krill Pellets 4mm 800 GR

FeederX - Krill Pellets 4mm 800 GR

plf005
Livrare imediată!

23,70Lei

Tava laterala Mivardi pentru accesorii small 39.5x24 cm 25-36 mm

Tava laterala Mivardi pentru accesorii small 39.5x24 cm 25-36 mm

m-sbaaps2
Livrare imediată!

86,00Lei

CUTIT MIGUEL NIETO SPANIA MINER LEMN,LAMA=155MM

CUTIT MIGUEL NIETO SPANIA MINER LEMN,LAMA=155MM

h.n8904
Livrare imediată!

359,15Lei

Varf de Rezerva pentru Lansete Matrix Aquos Ultra-D Class 58cm 3.4mm 1.5oz

Varf de Rezerva pentru Lansete Matrix Aquos Ultra-D Class 58cm 3.4mm 1.5oz

grd145
Livrare imediată!

98,96Lei

PENAR NGT PENTRU RIGURI 6 COMPARTIMENTE 72 RIGURI

PENAR NGT PENTRU RIGURI 6 COMPARTIMENTE 72 RIGURI

ngt-fla-rig-920
Livrare imediată!

43,99Lei

Plasa Halau Energo Team Pestisori 1mx1m

Plasa Halau Energo Team Pestisori 1mx1m

72525150
Livrare imediată!

8,00Lei

NGT BORSETA PENTRU PLUMBI 3 COMPARTIMENTE 18 X 12.5 X 8 cm

NGT BORSETA PENTRU PLUMBI 3 COMPARTIMENTE 18 X 12.5 X 8 cm

ngt-fla-leadbag-046
Livrare imediată!

42,99Lei

SUPORT GURU PENTRU FEEDER REAPER ROD REST 22 CM

SUPORT GURU PENTRU FEEDER REAPER ROD REST 22 CM

a6.gu.grpf
Livrare imediată!

88,24Lei

CLIP GURU PENTRU METHOD FEEDER MARIMEA S 3BUC/PAC -20%

CLIP GURU PENTRU METHOD FEEDER MARIMEA S 3BUC/PAC

a.gu.gmcs
Livrare imediată!

18,60Lei(-20%) 14,90Lei

Buzz Bar Pentru Rod Pod Delphin RPX 4 Silver, Capacitate 4 lansete, 2buc/pac -24%

Buzz Bar Pentru Rod Pod Delphin RPX 4 Silver, Capacitate 4 lansete, 2buc/pac

870000336
Livrare imediată!

161,99Lei(-24%) 123,00Lei

AC MICRO JAXON QUICKSTOP PENTRU PELETE JAXON 1mm

AC MICRO JAXON QUICKSTOP PENTRU PELETE JAXON 1mm

ac-pc111
Livrare imediată!

5,00Lei

Afişare 1241 - 1260 din 5142 (258 pagini)
Queries: 8, Total time: 113.041 ms [By time] [By id] [By file]
1 (0.072)
SELECT data
FROM `oc_session`
WHERE session_id = '242f0b2590c8eba94f75c76895'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (93.193)
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 (MATCH(pd.tag) AGAINST('+pentru' 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 (19.151)
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 1240, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.132)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.121)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.136)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM 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 = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38