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


GRIPPER ENERGOTEAM CUDA SKIN 15cm
Exclusiv online!

GRIPPER ENERGOTEAM CUDA SKIN 15cm

80950852
Livrare 24-48 ore

62,00Lei

Plumb Energo Team Betisor Tirolez 10g

Plumb Energo Team Betisor Tirolez 10g

52290010
Livrare imediată!

3,00Lei

Boilies Dynamite Baits Big Fish Robin Red 15mm 5kg
Exclusiv online!

Boilies Dynamite Baits Big Fish Robin Red 15mm 5kg

dy1539
Livrare 48-72ore

239,00Lei

BORSETA NGT PENTRU PLUMBI LEAD BAG 207 / 22 x 14 x 8 CM
Exclusiv online!

BORSETA NGT PENTRU PLUMBI LEAD BAG 207 / 22 x 14 x 8 CM

ngt-fla-leadbag-207
Livrare 48-72 ore

69,00Lei

CUTIE EnergoTeam PATRATA CU GRILA PENTRU VIERMUSI
Exclusiv online!

CUTIE EnergoTeam PATRATA CU GRILA PENTRU VIERMUSI

75505003
Livrare 24-48 ore

7,50Lei

Boilies Benzar Mix Feed Fish (Brown) 20mm 5kg

Boilies Benzar Mix Feed Fish (Brown) 20mm 5kg

98019004
Livrare imediată!

99,00Lei

Boilies Dynamite Baits Big Fish Mulberry Plum 15mm 5kg
Exclusiv online!

Boilies Dynamite Baits Big Fish Mulberry Plum 15mm 5kg

dy1537
Livrare 48-72ore

239,00Lei

HUSA CORMORAN 5122 PENTRU LANSETE L=155CM
Exclusiv online!

HUSA CORMORAN 5122 PENTRU LANSETE L=155CM

a8.65.12255
Livrare 24-48 ore

170,24Lei

ANTISEPTIC KORDA PENTRU INGRIJIRE CRAP ULCER SWAB
Exclusiv online!

ANTISEPTIC KORDA PENTRU INGRIJIRE CRAP ULCER SWAB

a.kcc3
Livrare 24-48 ore

55,57Lei

Prastie Baracuda pentru nadit 04 aluminiu

Prastie Baracuda pentru nadit 04 aluminiu

prastie pt. nadit 4
Livrare imediată!

44,99Lei

Cosulet EnergoTeam Feeder Pentru Distante Mari 40g

Cosulet EnergoTeam Feeder Pentru Distante Mari 40g

58072040
Livrare imediată!

12,00Lei

Boilies Dynamite Baits Big Fish Squid & Octopus 20mm 5kg
Exclusiv online!

Boilies Dynamite Baits Big Fish Squid & Octopus 20mm 5kg

dy1528
Livrare 48-72ore

239,00Lei

PLUMB RAPTURE CILINDRIC TECK SINK STICK SINKER 7gr 5buc/plic

PLUMB RAPTURE CILINDRIC TECK SINK STICK SINKER 7gr 5buc/plic

188-11-107
Livrare imediată!

15,01Lei

Picioare de rezervă pentru RPX-4 BW / 2buc 70-140cm

Picioare de rezervă pentru RPX-4 BW / 2buc 70-140cm

870000331
Livrare imediată!

134,01Lei

Pelete CPK XXL, 800g

Pelete CPK XXL, 800g

999063
Livrare imediată!

24,00Lei

Pelete Method Feeder Sensas Mini Sticky Crazy 2mm 700g
Exclusiv online!

Pelete Method Feeder Sensas Mini Sticky Crazy 2mm 700g

a0.s44783
Livrare 24-48 ore

30,59Lei

Boilies Dynamite Baits Garlic Cheese Carp Tec 15mm 2kg
Exclusiv online!

Boilies Dynamite Baits Garlic Cheese Carp Tec 15mm 2kg

dy1186
Livrare 48-72ore

65,00Lei

CUTIE PLASTIC PANARO PENTRU MOMEALA VIE 0.5L
Exclusiv online!

CUTIE PLASTIC PANARO PENTRU MOMEALA VIE 0.5L

a4.p112
Livrare 24-48 ore

8,62Lei

Boilies Dynamite Baits Big Fish Squid & Octopus 15mm 5kg
Exclusiv online!

Boilies Dynamite Baits Big Fish Squid & Octopus 15mm 5kg

dy1538
Livrare 48-72ore

239,00Lei

Boilies The Purple One pentru carlig solubile 14/18/20mm 150g
Exclusiv online!

Boilies The Purple One pentru carlig solubile 14/18/20mm 150g

98036926
Livrare 24-48 ore

24,00Lei

Afişare 2181 - 2200 din 5144 (258 pagini)
Queries: 9, Total time: 97.334 ms [By time] [By id] [By file]
1 (0.192)
SELECT data
FROM `oc_session`
WHERE session_id = '388d429b95fc85858dd20091a1'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (96.313)
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 (0.157)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.101)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.116)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.108)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.122)
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