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


VARF DAIWA PENTRU NINJA X FEEDER GALBEN

VARF DAIWA PENTRU NINJA X FEEDER GALBEN

d.11607.365y
Livrare imediată!

43,17Lei

VARF DAIWA PENTRU NINJA X FEEDER RED 50-150g

VARF DAIWA PENTRU NINJA X FEEDER RED 50-150g

d.11606.001r
Livrare imediată!

29,33Lei

VARF PRESTON QUIVERTIP PENTRU LANSETE ASCENSION FEEDER 4.0oz 3.5mm
Exclusiv online!

VARF PRESTON QUIVERTIP PENTRU LANSETE ASCENSION FEEDER 4.0oz 3.5mm

p0070039
Livrare 7-14 zile

107,96Lei

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

PELETE CARP ZOOM SWEET BABY CORN 800GR
Exclusiv online!

PELETE CARP ZOOM SWEET BABY CORN 800GR

cz7873
Livrare 48-72 ore

24,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

Rumegus Jaxon pentru Afumator
Exclusiv online!

Rumegus Jaxon pentru Afumator

ak-we101t
Livrare 48-72 ore

17,01Lei

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

Afişare 1341 - 1360 din 5143 (258 pagini)
Queries: 8, Total time: 132.696 ms [By time] [By id] [By file]
1 (0.194)
SELECT data
FROM `oc_session`
WHERE session_id = 'a5608e3f27b99dfd887e1bdbb6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (111.846)
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.954)
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 1340, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.167)
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.129)
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.122)
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.177)
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