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


Carlige Fanatik FK-1011 No.12 Carp 6buc/plic

Carlige Fanatik FK-1011 No.12 Carp 6buc/plic

120513fk101112
Livrare imediată!

5,50Lei

Shad Sakura Swimy Pompei K012 5cm 0.8g 6buc/plic
Exclusiv online!

Shad Sakura Swimy Pompei K012 5cm 0.8g 6buc/plic

130135swplf500750-k012
Livrare 48-72 ore

17,21Lei

Shad Rapture Mini Minnow Shad Tail 4.5cm 6buc/plic Hot Silver

Shad Rapture Mini Minnow Shad Tail 4.5cm 6buc/plic Hot Silver

187-99-071
Livrare imediată!

25,00Lei

Jig Fudo Bila BN black nickel nr.5/0 21gr 6buc/plic

Jig Fudo Bila BN black nickel nr.5/0 21gr 6buc/plic

jfb-5/0-021
Livrare imediată!

15,01Lei

Agrafa Rapida Lucky John Power Lure Snap LJP5126 Nr.003, 35kg, 6buc/plic

Agrafa Rapida Lucky John Power Lure Snap LJP5126 Nr.003, 35kg, 6buc/plic

ljp5126-003
Livrare imediată!

8,98Lei

Micro Jig Fudo Bila nr.5/0 BN black nickel 7gr 6buc/plic

Micro Jig Fudo Bila nr.5/0 BN black nickel 7gr 6buc/plic

mjfb-5/0-007
Livrare imediată!

15,01Lei

Jig Fudo Bila BN black nickel nr.5/0 18gr 6buc/plic

Jig Fudo Bila BN black nickel nr.5/0 18gr 6buc/plic

jfb-5/0-018
Livrare imediată!

15,01Lei

Shad Noike Wobble Ninja 10.2cm 34 6buc/plic

Shad Noike Wobble Ninja 10.2cm 34 6buc/plic

noik-ninj4-34
Livrare imediată!

28,00Lei

TAPARINA MUSTAD PISCATOR NR.5 6BUC/PLIC
Exclusiv online!

TAPARINA MUSTAD PISCATOR NR.5 6BUC/PLIC

m.cl.rig5.8
Livrare 24-48 ore

9,03Lei

Micro Jig Fudo Bila nr.5/0 BN black nickel 5gr 6buc/plic

Micro Jig Fudo Bila nr.5/0 BN black nickel 5gr 6buc/plic

mjfb-5/0-005
Livrare imediată!

15,01Lei

SHAD STRIKE PRO PIGLET C026 10CM 6BUC/PLIC
Exclusiv online!

SHAD STRIKE PRO PIGLET C026 10CM 6BUC/PLIC

sp.sp172e.c026
Livrare 24-48 ore

53,17Lei

Shad Lucky John Roach Paddle Tail G03 8.9cm 6buc/plic -33%

Shad Lucky John Roach Paddle Tail G03 8.9cm 6buc/plic

140180-g03
Livrare imediată!

28,00Lei(-33%) 18,90Lei

AGRAFA SENSAS CULISANTA NR.18 PT MONTURI 6BUC/PLIC
Exclusiv online!

AGRAFA SENSAS CULISANTA NR.18 PT MONTURI 6BUC/PLIC

a.s36936
Livrare 24-48 ore

8,27Lei

Shad Lucky John Roach Paddle Tail G04 8.9cm 6buc/plic -33%

Shad Lucky John Roach Paddle Tail G04 8.9cm 6buc/plic

140180-g04
Livrare imediată!

28,00Lei(-33%) 18,90Lei

AGRAFA SENSAS CULISANTA NR.20 PT MONTURI 6BUC/PLIC
Exclusiv online!

AGRAFA SENSAS CULISANTA NR.20 PT MONTURI 6BUC/PLIC

a.s36935
Livrare 24-48 ore

8,27Lei

Rac Savage Gear 4D Craw Summer Craw 7.5cm 5.5g 6buc/plic
Exclusiv online!

Rac Savage Gear 4D Craw Summer Craw 7.5cm 5.5g 6buc/plic

f1.sg.77462
Livrare 24-48 ore

33,24Lei

SHAD GUNKI TIPSY SXL PINK PARADISE 7.6CM 4.1G 6BUC/PLIC
Exclusiv online!

SHAD GUNKI TIPSY SXL PINK PARADISE 7.6CM 4.1G 6BUC/PLIC

f1.spm.34858
Livrare 24-48 ore

20,61Lei

Shad Lucky John Roach Paddle Tail G06 8.9cm 6buc/plic -33%

Shad Lucky John Roach Paddle Tail G06 8.9cm 6buc/plic

140180-g06
Livrare imediată!

28,00Lei(-33%) 18,90Lei

Shad Lucky John Roach Paddle Tail G07 8.9cm 6buc/plic

Shad Lucky John Roach Paddle Tail G07 8.9cm 6buc/plic

140180-g07
Livrare imediată!

28,00Lei

Shad Lucky John Roach Paddle Tail G02 8.9cm 6buc/plic -33%

Shad Lucky John Roach Paddle Tail G02 8.9cm 6buc/plic

140180-g02
Livrare imediată!

28,00Lei(-33%) 18,90Lei

Afişare 181 - 200 din 443 (23 pagini)
Queries: 4, Total time: 23.055 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = 'df7cbbde11e5c83d39aac576a0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.090)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (22.695)
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('+6buc/plic' 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:725
4 (0.151)
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