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


Suport Lanseta Feeder Nevis 35cm, 5 Posturi

Suport Lanseta Feeder Nevis 35cm, 5 Posturi

6218-600
Livrare imediată!

27,00Lei

Suport Lanseta Nevis, Feeder Frontrunner Rod Rest Head, 3x7cm
Exclusiv online!

Suport Lanseta Nevis, Feeder Frontrunner Rod Rest Head, 3x7cm

8100-273
Livrare 48-72 ore

6,50Lei

Suport Spate Team Feeder by Dome Butt Rest

Suport Spate Team Feeder by Dome Butt Rest

7325-021
Livrare imediată!

21,00Lei

Suport Spate Team Feeder by Dome Tornado Butt Rest

Suport Spate Team Feeder by Dome Tornado Butt Rest

7325-017
Livrare imediată!

21,00Lei

Tava Laterala Feeder Delphin Reaxe Flat Worx, 50x30cm

Tava Laterala Feeder Delphin Reaxe Flat Worx, 50x30cm

101004403
Livrare imediată!

142,00Lei

Tava Laterala Rive D36, M, 39x39cm
Exclusiv online!

Tava Laterala Rive D36, M, 39x39cm

90810103004
Livrare 48-72 ore

454,21Lei

Tava Laterala Rive D36, Size XL, 49x39cm
Exclusiv online!

Tava Laterala Rive D36, Size XL, 49x39cm

90810103015
Livrare 48-72 ore

561,51Lei

Vartej Nevis X-Strong, Nr.12, 10buc/pac

Vartej Nevis X-Strong, Nr.12, 10buc/pac

5575-012
Livrare imediată!

4,30Lei

Juvelnic Colmic S31 Carp Patrat 3m
Exclusiv online!

Juvelnic Colmic S31 Carp Patrat 3m

nacr123b
Livrare 48-72 ore

529,00Lei

Juvelnic Colmic S31 Fishery Patrat 3m
Exclusiv online!

Juvelnic Colmic S31 Fishery Patrat 3m

nacr124b
Livrare 48-72 ore

519,99Lei

Juvelnic Colmic S31 Fishery Patrat 4m
Exclusiv online!

Juvelnic Colmic S31 Fishery Patrat 4m

nacr124d
Livrare 48-72 ore

675,00Lei

Aditiv Lichid MG Special Carp Method Feeder Glue Ananas 100ml

Aditiv Lichid MG Special Carp Method Feeder Glue Ananas 100ml

mg0964
Livrare imediată!

20,00Lei

Agrafa Culisanta Feeder Nevis 3buc/pac

Agrafa Culisanta Feeder Nevis 3buc/pac

8100-099
Livrare imediată!

13,90Lei

Brat Feeder Trabucco GNT X-Connect
Exclusiv online!

Brat Feeder Trabucco GNT X-Connect

116-26-210
Livrare 48-72 ore

160,00Lei

Brat Trabucco GNT X-Connect Ripple Cross Long Arm
Exclusiv online!

Brat Trabucco GNT X-Connect Ripple Cross Long Arm

116-26-020
Livrare 48-72 ore

120,00Lei

Cap Suport Feeder Team Feeder by Dome Flexi Rod Rest

Cap Suport Feeder Team Feeder by Dome Flexi Rod Rest

7325-024
Livrare imediată!

30,00Lei

Cap Suport Filfishing Superior Back Rest
Exclusiv online!

Cap Suport Filfishing Superior Back Rest

fil4315
Livrare 48-72 ore

19,99Lei

Carlige Legate DAM Detek Method Pellet BL Nr.8, 0.28mm, 5kg, 10cm, 8buc/pac
Exclusiv online!

Carlige Legate DAM Detek Method Pellet BL Nr.8, 0.28mm, 5kg, 10cm, 8buc/pac

a.dam.70457
Livrare 24-48 ore

20,10Lei

Carlige Legate Guru Bayonets QM1, Carlig Nr.12, 0.19mm, 38cm, 8buc/pac
Exclusiv online!

Carlige Legate Guru Bayonets QM1, Carlig Nr.12, 0.19mm, 38cm, 8buc/pac

a.gu.grr146
Livrare 24-48 ore

27,75Lei

Carlige Legate Guru Bayonets Rig, Carlig Nr.10, 0.19mm, 10cm, 8buc/pac
Exclusiv online!

Carlige Legate Guru Bayonets Rig, Carlig Nr.10, 0.19mm, 10cm, 8buc/pac

a.gu.grr214
Livrare 24-48 ore

22,19Lei

Afişare 9281 - 9300 din 12499 (625 pagini)
Queries: 4, Total time: 262.598 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = '264c2a2d940882ec886c5700fa'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (262.200)
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('+feeder' 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.169)
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