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 300 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


AROMA CARP ZOOM ADITIV PRAF 250GR BIG CARP SPICY
Exclusiv online!

AROMA CARP ZOOM ADITIV PRAF 250GR BIG CARP SPICY

cz5596
Livrare 48-72 ore

11,00Lei

LANSETA CARP EXPERT PRO POWER FEEDER 3.90MT 100-150GR

LANSETA CARP EXPERT PRO POWER FEEDER 3.90MT 100-150GR

12330391
Livrare imediată!

299,00Lei

PELETE CARLIG GAURITE CARP ZOOM BLOODY HALIBUT 15MM 150GR
Exclusiv online!

PELETE CARLIG GAURITE CARP ZOOM BLOODY HALIBUT 15MM 150GR

cz9646
Livrare 48-72 ore

13,00Lei

PLUTA MOSTIRO PANA CULISANTA 2.50GR

PLUTA MOSTIRO PANA CULISANTA 2.50GR

2420250225000-bucxxx
Livrare imediată!

3,50Lei

COSULET METALIC MOSTIRO DREPTUNGHIULAR INCHIS 50GR

COSULET METALIC MOSTIRO DREPTUNGHIULAR INCHIS 50GR

ai-0774a-50
Livrare imediată!

8,29Lei

LANSETA COLMIC MALIB TELEBOAT 3.00M 50-150GR
Exclusiv online!

LANSETA COLMIC MALIB TELEBOAT 3.00M 50-150GR

cama91b
Livrare 48-72 ore

379,00Lei

Pelete Dynamite Baits The Source 8mm Pre-Drilled 350Gr

Pelete Dynamite Baits The Source 8mm Pre-Drilled 350Gr

dy147
Livrare imediată!

25,00Lei

Pelete Dynamite Baits The Source Pellets 14mm Pre -Drilled 350Gr

Pelete Dynamite Baits The Source Pellets 14mm Pre -Drilled 350Gr

dy148
Livrare imediată!

25,00Lei

LANSETA RAPTURE CALIBRA TECH CASTER 2.43MT MEDIU FAST 14-50GR

LANSETA RAPTURE CALIBRA TECH CASTER 2.43MT MEDIU FAST 14-50GR

126-37-500
Livrare imediată!

258,00Lei

PELETE CARLIG GAURITE CARP ZOOM BLOODY HALIBUT 20MM 150GR

PELETE CARLIG GAURITE CARP ZOOM BLOODY HALIBUT 20MM 150GR

cz4926
Livrare imediată!

13,00Lei

AROMA CARP ZOOM ADITIV PRAF 250GR FISH MEAT

AROMA CARP ZOOM ADITIV PRAF 250GR FISH MEAT

cz8556
Livrare imediată!

11,00Lei

CUTIE PLUMBI MAVER ALICE SUPERCALIBRATI nr.3 la 7/0 250GR

CUTIE PLUMBI MAVER ALICE SUPERCALIBRATI nr.3 la 7/0 250GR

87001
Livrare imediată!

97,00Lei

PLUTA BFF PORTSTARLITE TF4004 2.50GR

PLUTA BFF PORTSTARLITE TF4004 2.50GR

bx24004250
Livrare imediată!

5,00Lei

Pluta Balsa Mostiro Cristina R 1.50Gr

Pluta Balsa Mostiro Cristina R 1.50Gr

2420030515000-bucxxx
Livrare imediată!

3,80Lei

MOMITOR PELET FEEDER IN LINE 50GR

MOMITOR PELET FEEDER IN LINE 50GR

5021050
Livrare imediată!

9,90Lei

COSULET AS FEEDER RIVER TUNNEL 27X43MM 150Gr

COSULET AS FEEDER RIVER TUNNEL 27X43MM 150Gr

26 7x17 150g
Livrare imediată!

12,99Lei

NADA CARP ZOOM LA SIRENE X21 ROSU 850GR
Exclusiv online!

NADA CARP ZOOM LA SIRENE X21 ROSU 850GR

ri110005
Livrare 48-72 ore

27,00Lei

Pluta Balsa Mostiro Crisul 1.50Gr

Pluta Balsa Mostiro Crisul 1.50Gr

2420060215000-bucxxx
Livrare imediată!

3,80Lei

Lanseta Maver UK REALITY PLUS FEEDER 11FT 3.3M 50GR 2sec
Exclusiv online!

Lanseta Maver UK REALITY PLUS FEEDER 11FT 3.3M 50GR 2sec

a2980
Livrare 48-72 ore

453,00Lei

Pluta Balsa Mostiro Cristina R 2.50Gr

Pluta Balsa Mostiro Cristina R 2.50Gr

2420030525000-bucxxx
Livrare imediată!

3,50Lei

Afişare 101 - 120 din 491 (25 pagini)
Queries: 8, Total time: 198.385 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = 'be28502421d36937d0fe1285d8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.091)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (195.526)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%50gr%") 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:698
5 (2.255)
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 100, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.110)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.075)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.115)
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