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


FIR TRABUCCO T FORCE CARP ENDURO 300M 0.350 MM 15.80 Kg

FIR TRABUCCO T FORCE CARP ENDURO 300M 0.350 MM 15.80 Kg

053-11-350
Livrare imediată!

72,00Lei

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

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

053-11-250
Livrare imediată!

54,00Lei

Lanseta Cormoran Pro Carp XR B 3.60m 3lbs 2Seg -20%

Lanseta Cormoran Pro Carp XR B 3.60m 3lbs 2Seg

c.20.0630361
Livrare imediată!

219,00Lei(-20%) 175,20Lei

Carp Zoom CRUMBS BRITHIS BREAD FLUO 120gr Fluo Yellow

Carp Zoom CRUMBS BRITHIS BREAD FLUO 120gr Fluo Yellow

cz4006
Livrare imediată!

11,00Lei

LANSETA C-TEC GOVERNOR CARP 3.60 3BUC 3 LBS

LANSETA C-TEC GOVERNOR CARP 3.60 3BUC 3 LBS

002968-00361-00000
Livrare imediată!

215,00Lei

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

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

053-11-300
Livrare imediată!

57,00Lei

FIR TRABUCCO T FORCE CARP ENDURO 600M 0.280 MM 9.80 Kg

FIR TRABUCCO T FORCE CARP ENDURO 600M 0.280 MM 9.80 Kg

053-12-280
Livrare imediată!

95,00Lei

Lanseta Nevis Dynamic Carp Feeder 390M 160gr 3+3seg
Exclusiv online!

Lanseta Nevis Dynamic Carp Feeder 390M 160gr 3+3seg

1618-391
Livrare 48-72 ore

249,00Lei

Carp Zoom PELETE SOFT 12mm 30gr Mussel

Carp Zoom PELETE SOFT 12mm 30gr Mussel

cz3917
Livrare imediată!

12,50Lei

FIR Carp Zoom FLUOROCARBON SOFT LEADER 25m 0.49mm 17.30kg

FIR Carp Zoom FLUOROCARBON SOFT LEADER 25m 0.49mm 17.30kg

cz5126
Livrare imediată!

83,00Lei

Carp Zoom NADA WET METHOD FEEDER 850gr Reed Milk Amur

Carp Zoom NADA WET METHOD FEEDER 850gr Reed Milk Amur

cz5218
Livrare imediată!

25,00Lei

Carp Zoom CRUMBS BRITHIS BREAD FLUO 120gr Fluo Red

Carp Zoom CRUMBS BRITHIS BREAD FLUO 120gr Fluo Red

cz3993
Livrare imediată!

11,00Lei

Carp Zoom TURBO SEED PLUS 1kg Tigernuts

Carp Zoom TURBO SEED PLUS 1kg Tigernuts

cz4983
Livrare imediată!

43,00Lei

Lanseta Team Feeder By Dome Royal Method Carp 3.60M 35-80gr 3+3SEG

Lanseta Team Feeder By Dome Royal Method Carp 3.60M 35-80gr 3+3SEG

1848-361
Livrare imediată!

675,00Lei

Carp Zoom BOILIE WAFTERS MAGNET-X 15mm 50gr Strwberry-Fish

Carp Zoom BOILIE WAFTERS MAGNET-X 15mm 50gr Strwberry-Fish

cz4761
Livrare imediată!

22,00Lei

Carp Zoom TURBO SEED PLUS 1kg Hemp - Canepa

Carp Zoom TURBO SEED PLUS 1kg Hemp - Canepa

cz4990
Livrare imediată!

43,00Lei

Lanseta Nevis Dynamic Carp Feeder 360M 130gr 3+3seg

Lanseta Nevis Dynamic Carp Feeder 360M 130gr 3+3seg

1618-360
Livrare imediată!

206,00Lei

Lanseta Team Feeder By Dome Royal Method Carp 3.90M 40-100gr 3+3SEG

Lanseta Team Feeder By Dome Royal Method Carp 3.90M 40-100gr 3+3SEG

1848-391
Livrare imediată!

727,99Lei

Carp Zoom TURBO SEED PLUS 1kg Porumb Natural

Carp Zoom TURBO SEED PLUS 1kg Porumb Natural

cz4921
Livrare imediată!

15,50Lei

Carp Zoom PELETE SOFT 12mm 30gr Garlic

Carp Zoom PELETE SOFT 12mm 30gr Garlic

cz3894
Livrare imediată!

12,50Lei

Afişare 81 - 100 din 7369 (369 pagini)
Queries: 4, Total time: 176.364 ms [By time] [By id] [By file]
1 (0.117)
SELECT data
FROM `oc_session`
WHERE session_id = 'b732ed0f676865c4f07846e14d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (175.974)
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('+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 (0.164)
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