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 - Mulinete Crap

Produse ce potrivesc criteriilor de căutare


Micro Pelete Senzor Black Halibut 2mm 800g

Micro Pelete Senzor Black Halibut 2mm 800g

snz99634
Livrare imediată!

24,00Lei

Suport Orizontal Spro Pentru Depozitat 6 Lansete
Exclusiv online!

Suport Orizontal Spro Pentru Depozitat 6 Lansete

006106-00020-00000
Livrare 48-72 ore

48,90Lei

Carp Zoom BOILIES START FEEDING 16-20mm 2.5kg Fish-Meat Mix
Exclusiv online!

Carp Zoom BOILIES START FEEDING 16-20mm 2.5kg Fish-Meat Mix

cz4693
Livrare 48-72 ore

83,00Lei

Carp Zoom BOILIES CZ MAGNET-X 20mm 800gr Strawberry-Fish
Exclusiv online!

Carp Zoom BOILIES CZ MAGNET-X 20mm 800gr Strawberry-Fish

cz4167
Livrare 48-72 ore

38,00Lei

CARLIGE LEGATE TRABUCCO AKURA PENTRU CLEAN SCOBAR SI MREANA Nr14x0.14mm 10BUC/PLIC
Exclusiv online!

CARLIGE LEGATE TRABUCCO AKURA PENTRU CLEAN SCOBAR SI MREANA Nr14x0.14mm 10BUC/PLIC

028-50-065
Livrare 48-72 ore

12,90Lei

CARLIGE LEGATE TRABUCCO AKURA PENTRU PASTRAV SI CLEAN Nr06x0.20mm 10BUC/PLIC

CARLIGE LEGATE TRABUCCO AKURA PENTRU PASTRAV SI CLEAN Nr06x0.20mm 10BUC/PLIC

027-05-060
Livrare imediată!

12,99Lei

CARLIGE LEGATE TRABUCCO AKURA PENTRU PASTRAV SI CLEAN Nr02x0.25mm 10BUC/PLIC

CARLIGE LEGATE TRABUCCO AKURA PENTRU PASTRAV SI CLEAN Nr02x0.25mm 10BUC/PLIC

027-05-020
Livrare imediată!

12,99Lei

FIR INAINTAS PENTRU STRUNA Climax FLUOROCARBON 10m 10kg
Exclusiv online!

FIR INAINTAS PENTRU STRUNA Climax FLUOROCARBON 10m 10kg

8610-10006-010
Livrare 48-72 ore

28,00Lei

PLUMB JAXON DROP SHOT BETISOR CU VARTEJ 5 GR 4BUC/PLIC

PLUMB JAXON DROP SHOT BETISOR CU VARTEJ 5 GR 4BUC/PLIC

cp-dr05
Livrare imediată!

9,00Lei

Pelete Daiwa Advantage Method Box + Booster 500g/cutie Green Betain

Pelete Daiwa Advantage Method Box + Booster 500g/cutie Green Betain

a0.13300.200
Livrare imediată!

62,82Lei

CARLIGE LEGATE TRABUCCO AKURA PENTRU PASTRAV SI CLEAN Nr04x0.25mm 10BUC/PLIC
Exclusiv online!

CARLIGE LEGATE TRABUCCO AKURA PENTRU PASTRAV SI CLEAN Nr04x0.25mm 10BUC/PLIC

027-05-040
Livrare 48-72 ore

12,99Lei

Carp Zoom BOILIES RAPID WEEKEND 16-20mm 2.5kg Fruit Mix
Exclusiv online!

Carp Zoom BOILIES RAPID WEEKEND 16-20mm 2.5kg Fruit Mix

cz4686
Livrare 48-72 ore

83,00Lei

Boilies Mainline Fiert High Impact Spicy Crab 15mm 3kg
Exclusiv online!

Boilies Mainline Fiert High Impact Spicy Crab 15mm 3kg

a0.m.m23092
Livrare 24-48 ore

202,23Lei

Micropelete 220Baits Green Betain 2mm, 800g

Micropelete 220Baits Green Betain 2mm, 800g

1242219031959
Livrare imediată!

36,00Lei

Carp Zoom BOILIES CZ MAGNET-X 20mm 800gr Spicy Squid-Krill
Exclusiv online!

Carp Zoom BOILIES CZ MAGNET-X 20mm 800gr Spicy Squid-Krill

cz4198
Livrare 48-72 ore

38,00Lei

Carp Zoom BOILIES CZ MAGNET-X 20mm 800gr Black Pepper-Liver
Exclusiv online!

Carp Zoom BOILIES CZ MAGNET-X 20mm 800gr Black Pepper-Liver

cz4181
Livrare 48-72 ore

38,00Lei

Boilies, Bucovina, Fishmeal, The, Secret, Solubil, 20mm, 5940000004439, Boilies pentru Nadit, Boilies pentru Nadit Bucovina Baits, Bucovina Baits
Pelete Senzor Faina De Peste 4mm 800g

Pelete Senzor Faina De Peste 4mm 800g

snz99636
Livrare imediată!

24,00Lei

CARLIG MUSTAD PENTRU MOMEALA LARVA NR 12

CARLIG MUSTAD PENTRU MOMEALA LARVA NR 12

m.90339bln.12
Livrare imediată!

6,44Lei

Ciorapi pentru Cizme Delphin Bronto Green, 41

Ciorapi pentru Cizme Delphin Bronto Green, 41

101000344
Livrare imediată!

52,00Lei

Afişare 221 - 240 din 5198 (260 pagini)
Queries: 7, Total time: 268.411 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = '0573bd901cc4c509836cb23fcb'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (267.861)
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 = '0' AND (pd.tag LIKE "%pentru%") 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 (0.092)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
6 (0.070)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.077)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38