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


BROASCA JAXON MAGIC FISH FROG 03A 3.8CM 6GR

BROASCA JAXON MAGIC FISH FROG 03A 3.8CM 6GR

bt-fr103a
Livrare imediată!

29,00Lei

Twister Quantum Magic Trout B-Fish 2.5cm 0.25gr Natural Cheese

Twister Quantum Magic Trout B-Fish 2.5cm 0.25gr Natural Cheese

3495005
Livrare imediată!

22,28Lei

BROASCA JAXON MAGIC FISH FROG 02C 3.5CM 5GR
Exclusiv online!

BROASCA JAXON MAGIC FISH FROG 02C 3.5CM 5GR

bt-fr102c
Livrare 48-72 ore

27,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

28,00Lei

Spinertail Bertilure FISH-HELIC NR.4 COLORADO Culoare FIRE TIGER 17 gr

Spinertail Bertilure FISH-HELIC NR.4 COLORADO Culoare FIRE TIGER 17 gr

h-05-134
Livrare imediată!

17,85Lei

BROASCA JAXON MAGIC FISH FROG 03B 3.8CM 6GR
Exclusiv online!

BROASCA JAXON MAGIC FISH FROG 03B 3.8CM 6GR

bt-fr103b
Livrare 48-72 ore

29,00Lei

Spinertail Bertilure FISH-HELIC NR.4 COLORADO Culoare ALB 17 gr

Spinertail Bertilure FISH-HELIC NR.4 COLORADO Culoare ALB 17 gr

h-05-135
Livrare imediată!

17,85Lei

Varga Spro Spartan Tele Fish 5m

Varga Spro Spartan Tele Fish 5m

002808-00500-00000
Livrare imediată!

54,00Lei

Spinertail Bertilure FISH-HELIC NR.1 COLORADO Culoare ALB- ROZ FLUO 7 gr.

Spinertail Bertilure FISH-HELIC NR.1 COLORADO Culoare ALB- ROZ FLUO 7 gr.

h-05-101
Livrare imediată!

17,85Lei

BROASCA JAXON MAGIC FISH FROG 02B 3.5CM 5GR
Exclusiv online!

BROASCA JAXON MAGIC FISH FROG 02B 3.5CM 5GR

bt-fr102b
Livrare 48-72 ore

27,00Lei

Aditiv lichid CPK Bagman PVA Stinky Fish 250ml

Aditiv lichid CPK Bagman PVA Stinky Fish 250ml

1000166
Livrare imediată!

29,00Lei

CICADA JAXON MAGIC FISH 8CM 19GR F
Exclusiv online!

CICADA JAXON MAGIC FISH 8CM 19GR F

tx-e08f
Livrare 48-72 ore

70,00Lei

CICADA JAXON MAGIC FISH 8CM 16GR E
Exclusiv online!

CICADA JAXON MAGIC FISH 8CM 16GR E

tx-h08e
Livrare 48-72 ore

79,00Lei

CICADA JAXON MAGIC FISH 8CM 19GR B
Exclusiv online!

CICADA JAXON MAGIC FISH 8CM 19GR B

tx-e08b
Livrare 48-72 ore

70,00Lei

BROASCA JAXON MAGIC FISH FROG 03D 3.8CM 6GR
Exclusiv online!

BROASCA JAXON MAGIC FISH FROG 03D 3.8CM 6GR

bt-fr103d
Livrare 48-72 ore

29,00Lei

Spinertail Bertilure FISH-HELIC NR.2 COLORADO Culoare ALB 11 gr.

Spinertail Bertilure FISH-HELIC NR.2 COLORADO Culoare ALB 11 gr.

h-05-115
Livrare imediată!

17,85Lei

Streamer Zebco Z-Sea Holografix Herring Trace 1.40m Yellow Fish 5 carlige -33%

Streamer Zebco Z-Sea Holografix Herring Trace 1.40m Yellow Fish 5 carlige

1307173449003
Livrare imediată!

7,29Lei(-33%) 4,90Lei

BROASCA JAXON MAGIC FISH FROG 01C 3CM 4GR
Exclusiv online!

BROASCA JAXON MAGIC FISH FROG 01C 3CM 4GR

bt-fr101c
Livrare 48-72 ore

26,00Lei

Shad Crazy Fish Vibro Worm 8.5cm 13D Squid Floating -25%

Shad Crazy Fish Vibro Worm 8.5cm 13D Squid Floating

138513d6f
Livrare imediată!

19,00Lei(-25%) 14,26Lei

BROASCA JAXON MAGIC FISH FROG 01D 3CM 4GR

BROASCA JAXON MAGIC FISH FROG 01D 3CM 4GR

bt-fr101d
Livrare imediată!

26,00Lei

Afişare 501 - 520 din 962 (49 pagini)
Queries: 4, Total time: 21.655 ms [By time] [By id] [By file]
1 (0.093)
SELECT data
FROM `oc_session`
WHERE session_id = '429113f493ba8aea834351e351'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (21.259)
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('+fish' 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.226)
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