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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Pelete Sonubaits Feed 2mm Krill
Exclusiv online!

Pelete Sonubaits Feed 2mm Krill

s1800007
Livrare 7-14 zile

35,96Lei

PELETE GAURITE CARP ZOOM HALIBUT 15 MM 800GR

PELETE GAURITE CARP ZOOM HALIBUT 15 MM 800GR

cz4573
Livrare imediată!

32,00Lei

Pelete Genlog Method Soft Hook Ananas 8mm
Exclusiv online!

Pelete Genlog Method Soft Hook Ananas 8mm

mshp04
Livrare 48-72 ore

18,20Lei

PELETE DYNAMITE BAITS SWIM STIM Red Krill Carp 2 mm

PELETE DYNAMITE BAITS SWIM STIM Red Krill Carp 2 mm

dy1402
Livrare imediată!

35,00Lei

PELETE JAXON METHOD FEEDER FISH MIX 4mm 500g
Exclusiv online!

PELETE JAXON METHOD FEEDER FISH MIX 4mm 500g

fm-pe20
Livrare 48-72 ore

27,00Lei

PELETE JAXON METHOD FEEDER GREEN BETAIN 4mm 500g
Exclusiv online!

PELETE JAXON METHOD FEEDER GREEN BETAIN 4mm 500g

fm-pe21
Livrare 48-72 ore

27,00Lei

PELETE CARP ZOOM SOFT 8mm 30gr Spice
Exclusiv online!

PELETE CARP ZOOM SOFT 8mm 30gr Spice

cz8999
Livrare 48-72 ore

12,50Lei

PELETE CARP ZOOM SOFT 8mm 30gr Mussel
Exclusiv online!

PELETE CARP ZOOM SOFT 8mm 30gr Mussel

cz9002
Livrare 48-72 ore

12,50Lei

PELETE JAXON METHOD FEEDER SCOPEX 4mm 500g
Exclusiv online!

PELETE JAXON METHOD FEEDER SCOPEX 4mm 500g

fm-pe19
Livrare 48-72 ore

27,00Lei

Pelete Carlig Sonubaits Hookable Pro Expander F1 6mm 100g
Exclusiv online!

Pelete Carlig Sonubaits Hookable Pro Expander F1 6mm 100g

s1820015
Livrare 7-14 zile

26,96Lei

Pelete Genlog Method Soft Hook Banana 8mm
Exclusiv online!

Pelete Genlog Method Soft Hook Banana 8mm

mshp05
Livrare 48-72 ore

18,20Lei

PELETE JAXON METHOD FEEDER READY ARCTIC KRILL 2mm 500g
Exclusiv online!

PELETE JAXON METHOD FEEDER READY ARCTIC KRILL 2mm 500g

fm-pr14
Livrare 48-72 ore

29,00Lei

PELETE CARP ZOOM SOFT 8mm 30gr Orange
Exclusiv online!

PELETE CARP ZOOM SOFT 8mm 30gr Orange

cz9026
Livrare 48-72 ore

12,50Lei

PELETE FEEDER CPK GLM Betain 2MM 800g

PELETE FEEDER CPK GLM Betain 2MM 800g

999792
Livrare imediată!

27,00Lei

PELETE CARP ZOOM SOFT 8mm 30gr Pineapple
Exclusiv online!

PELETE CARP ZOOM SOFT 8mm 30gr Pineapple

cz8975
Livrare 48-72 ore

12,50Lei

Pelete Genlog Method Soft Hook Halibut 8mm
Exclusiv online!

Pelete Genlog Method Soft Hook Halibut 8mm

mshp07
Livrare 48-72 ore

18,20Lei

Pelete Dynamite Baits Carp Pellets 4mm 700g

Pelete Dynamite Baits Carp Pellets 4mm 700g

dy1071
Livrare imediată!

25,00Lei

PELETE JAXON METHOD FEEDER TURBO BREAM 4mm 500g
Exclusiv online!

PELETE JAXON METHOD FEEDER TURBO BREAM 4mm 500g

fm-pe18
Livrare 48-72 ore

27,00Lei

PELETE JAXON METHOD FEEDER ARCTIC KRILL 4mm 500g
Exclusiv online!

PELETE JAXON METHOD FEEDER ARCTIC KRILL 4mm 500g

fm-pe24
Livrare 48-72 ore

27,00Lei

PELETE CARP ZOOM SOFT 8mm 30gr Strawberry
Exclusiv online!

PELETE CARP ZOOM SOFT 8mm 30gr Strawberry

cz8968
Livrare 48-72 ore

12,50Lei

Afişare 441 - 460 din 811 (41 pagini)
Queries: 4, Total time: 21.577 ms [By time] [By id] [By file]
1 (0.148)
SELECT data
FROM `oc_session`
WHERE session_id = '0389354aa030d44152836851c5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (21.071)
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 = '3' AND (MATCH(pd.tag) AGAINST('+pelete' 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.231)
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