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


Carp Zoom WAFTERS DUO DUMBEL 8x12mm 15gr NBC-Cheese

Carp Zoom WAFTERS DUO DUMBEL 8x12mm 15gr NBC-Cheese

cz4723
Livrare imediată!

14,50Lei

Fir DAM Damyl New Spezi Line Carp 0.35mm 300m

Fir DAM Damyl New Spezi Line Carp 0.35mm 300m

a.dam.66627
Livrare imediată!

19,94Lei

MULINETA NEVIS METHOD CARP FEEDER 6000

MULINETA NEVIS METHOD CARP FEEDER 6000

2512-560
Livrare imediată!

190,00Lei

Mulineta Team Feeder Pearl Carp LCS 5000

Mulineta Team Feeder Pearl Carp LCS 5000

2507-550
Livrare imediată!

203,00Lei

MINCIOG CARP EXPERT LIGHT 2M 50x60x40 cm

MINCIOG CARP EXPERT LIGHT 2M 50x60x40 cm

71050200
Livrare imediată!

60,00Lei

BUZZ BAR CARP ACADEMY 2 POSTURI 24CM

BUZZ BAR CARP ACADEMY 2 POSTURI 24CM

6227-607
Livrare imediată!

24,80Lei

Carp Zoom WAFTERS DUO DUMBEL 8x12mm 15gr Lemon-Biscuit

Carp Zoom WAFTERS DUO DUMBEL 8x12mm 15gr Lemon-Biscuit

cz4730
Livrare imediată!

14,50Lei

COADA MINCIOG TEAM FEEDER MASTER CARP PRO BY DOME 440 -15%

COADA MINCIOG TEAM FEEDER MASTER CARP PRO BY DOME 440

1255-440
Livrare imediată!

277,00Lei(-15%) 234,39Lei

Plumb Tungsten tip Alica Carp Zoom Quick Change Sinker 10buc/plic

Plumb Tungsten tip Alica Carp Zoom Quick Change Sinker 10buc/plic

cz8371
Livrare imediată!

20,00Lei

FIR TRABUCCO T FORCE CARP ENDURO 600M 0.400 MM 21.15 Kg

FIR TRABUCCO T FORCE CARP ENDURO 600M 0.400 MM 21.15 Kg

053-12-400
Livrare imediată!

139,00Lei

BUZZ BAR CARP ACADEMY 25CM 2 POSTURI

BUZZ BAR CARP ACADEMY 25CM 2 POSTURI

6226-225
Livrare imediată!

32,00Lei

Degetar Carp Expert Neopren

Degetar Carp Expert Neopren

74300911
Livrare imediată!

34,00Lei

Carp Zoom PORUMB SUPER SWEET 425ml 340gr

Carp Zoom PORUMB SUPER SWEET 425ml 340gr

cz5164
Livrare imediată!

10,00Lei

CAP MINCIOG KAMASAKI CAUCIUCAT BIG CARP OVAL 45x46x30

CAP MINCIOG KAMASAKI CAUCIUCAT BIG CARP OVAL 45x46x30

71024540
Livrare imediată!

52,00Lei

CAP MINCIOG MATRIX CARP LANDING NETS 60x50 cm

CAP MINCIOG MATRIX CARP LANDING NETS 60x50 cm

gln065
Livrare imediată!

83,20Lei

FIR TRABUCCO T FORCE CARP ENDURO 600M 0.300 MM 11.95 Kg

FIR TRABUCCO T FORCE CARP ENDURO 600M 0.300 MM 11.95 Kg

053-12-300
Livrare imediată!

95,00Lei

Carp Zoom BOILIE WAFTERS MAGNET-X 15mm 50gr Pepper-Liver
Exclusiv online!

Carp Zoom BOILIE WAFTERS MAGNET-X 15mm 50gr Pepper-Liver

cz4785
Livrare 48-72ore

22,00Lei

FIR TRABUCCO T FORCE CARP ENDURO 600M 0.250 MM 8.36 Kg

FIR TRABUCCO T FORCE CARP ENDURO 600M 0.250 MM 8.36 Kg

053-12-250
Livrare imediată!

89,00Lei

Carp Zoom BOILIE WAFTERS MAGNET-X 15mm 50gr Chilli-Krill

Carp Zoom BOILIE WAFTERS MAGNET-X 15mm 50gr Chilli-Krill

cz4808
Livrare imediată!

22,00Lei

Lanseta Crap Daiwa Crosscast Extention Carp 3.05m 3.5lbs 2SEG -10%

Lanseta Crap Daiwa Crosscast Extention Carp 3.05m 3.5lbs 2SEG

d.11560.309
Livrare imediată!

465,47Lei(-10%) 420,09Lei

Afişare 41 - 60 din 7371 (369 pagini)
Queries: 6, Total time: 218.538 ms [By time] [By id] [By file]
1 (0.146)
SELECT data
FROM `oc_session`
WHERE session_id = '07f01bacb1df5c21909ff9b72a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (189.777)
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('+carp' 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 (28.278)
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 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.104)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.127)
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