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

Produse ce potrivesc criteriilor de căutare


NADA CARP ZOOM BIG CATCH 1KG Amur
Exclusiv online!

NADA CARP ZOOM BIG CATCH 1KG Amur

cz3172
Livrare 48-72 ore

15,00Lei

NADA, SENSAS, 3000, SUPER, FEEDER, BIG, FISH, 1KG, a0.s10551, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas
Vartej DAM MAD Big Eye Swivel Teflon Nr7
Exclusiv online!

Vartej DAM MAD Big Eye Swivel Teflon Nr7

407090035
Livrare 48-72 ore

7,45Lei

GROUNDBAIT DYNAMITE BAITS BIG FISH RIVER Shrimp And Krill 1.8KG

GROUNDBAIT DYNAMITE BAITS BIG FISH RIVER Shrimp And Krill 1.8KG

dy1370
Livrare imediată!

49,00Lei

Lanseta Cormoran Big Cat Pro V-Power 2.10M 100-280g 2SEG
Exclusiv online!

Lanseta Cormoran Big Cat Pro V-Power 2.10M 100-280g 2SEG

c.20.1280215
Livrare 24-48 ore

256,45Lei

QUICK CHANGE STRATEGY BIG EYE SWIVEL NR8 8 PCS -25%

QUICK CHANGE STRATEGY BIG EYE SWIVEL NR8 8 PCS

008035-00007-00000
Livrare imediată!

18,60Lei(-25%) 13,90Lei

Nada Benzar Mix Big Series Crap Dunare 1kg

Nada Benzar Mix Big Series Crap Dunare 1kg

94005803
Livrare imediată!

14,00Lei

Multifilanet Nevis Big Cat 200m 0.80mm
Exclusiv online!

Multifilanet Nevis Big Cat 200m 0.80mm

3224-080
Livrare 48-72 ore

89,00Lei

Multifilanet Nevis Big Cat 200m 0.60mm

Multifilanet Nevis Big Cat 200m 0.60mm

3224-060
Livrare imediată!

95,20Lei

Cosulet Naditor Browning Big Pit Inline Feeder 30g 2.5cm

Cosulet Naditor Browning Big Pit Inline Feeder 30g 2.5cm

6621230
Livrare imediată!

13,28Lei

Cosulet Naditor Browning Big Pit Inline Feeder 25g 2.5cm

Cosulet Naditor Browning Big Pit Inline Feeder 25g 2.5cm

6621225
Livrare imediată!

13,28Lei

NADA, SENSAS, 3000, CLUB, CARP/BIG, FISH, RED, 1KG, a0.s11081, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas
Exclusiv online!

NADA, SENSAS, 3000, CLUB, CARP/BIG, FISH, RED, 1KG, a0.s11081, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas

a0.s11081
Livrare 24-48 ore

18,23Lei

CARLIGE ENERGO TEAM EXCALIBUR BIG CORN NS NR 4

CARLIGE ENERGO TEAM EXCALIBUR BIG CORN NS NR 4

47050004
Livrare imediată!

8,00Lei

Cosulet Naditor Browning Big Pit Inline Feeder 40g 2.5cm

Cosulet Naditor Browning Big Pit Inline Feeder 40g 2.5cm

6621240
Livrare imediată!

13,28Lei

STRUNA OTEL JAXON TANAMI BIG GAME 40CM 20KG
Exclusiv online!

STRUNA OTEL JAXON TANAMI BIG GAME 40CM 20KG

aj-prc2040
Livrare 48-72 ore

12,50Lei

PORUMB FLOTANT CPK BIG CARP

PORUMB FLOTANT CPK BIG CARP

999676
Livrare imediată!

15,00Lei

Nada Benzar Mix Big Fish 3kg

Nada Benzar Mix Big Fish 3kg

94005600
Livrare imediată!

25,00Lei

COSULET FEEDER NISA BIG PIGS CAGE LARGE 120G

COSULET FEEDER NISA BIG PIGS CAGE LARGE 120G

bk7
Livrare imediată!

14,49Lei

Nada, Benzar, Mix, Big, Series, Crap, Caras, 3kg, 94005815, Nada (Groundbait), Nada (Groundbait) Benzar Mix, Benzar Mix
NADA, SENSAS, 3000, CLUB, CARP/BIG, FISH, JAUNE, 1KG, a0.s11091, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas
Exclusiv online!

NADA, SENSAS, 3000, CLUB, CARP/BIG, FISH, JAUNE, 1KG, a0.s11091, Nada (Groundbait), Nada (Groundbait) Sensas, Sensas

a0.s11091
Livrare 24-48 ore

18,23Lei

Afişare 221 - 240 din 565 (29 pagini)
Queries: 6, Total time: 230.927 ms [By time] [By id] [By file]
1 (0.130)
SELECT data
FROM `oc_session`
WHERE session_id = 'ec264514f6e241869f8196f4b8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.122)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.131)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (227.875)
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 "%big%") 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.572)
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 220, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.097)
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