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


Laneta Somn Filfishing Titan, 200-400g, 3.00m, 2seg
Exclusiv online!

Laneta Somn Filfishing Titan, 200-400g, 3.00m, 2seg

FIL6730
Livrare 48-72 ore

199,00Lei

Lanseta Black Cat Black Passion G2 Allround, 600g, 2.70m , 2seg

Lanseta Black Cat Black Passion G2 Allround, 600g, 2.70m , 2seg

16570270
Livrare imediată!

296,55Lei

Lanseta Black Cat Black Passion G2 Bank, 600g, 3.00m , 2seg

Lanseta Black Cat Black Passion G2 Bank, 600g, 3.00m , 2seg

16570300
Livrare imediată!

323,55Lei

Lanseta Black Cat Black Passion G2 Spin, 50-200g, 2.70m , 2seg

Lanseta Black Cat Black Passion G2 Spin, 50-200g, 2.70m , 2seg

16572270
Livrare imediată!

278,56Lei

Lanseta Black Cat Black Passion G2 Vertical, 240g, 1.80cm, 1seg

Lanseta Black Cat Black Passion G2 Vertical, 240g, 1.80cm, 1seg

16573180
Livrare imediată!

229,05Lei

Lanseta Black Cat Black Passion Long Ranger, 600g, 3.30m , 2seg

Lanseta Black Cat Black Passion Long Ranger, 600g, 3.30m , 2seg

16571330
Livrare imediată!

350,55Lei

Lanseta Black Cat Passion G2 Spin CW, 50-200g, 2.40m, 2seg

Lanseta Black Cat Passion G2 Spin CW, 50-200g, 2.40m, 2seg

16572240
Livrare imediată!

251,49Lei

Lanseta Somn Mikado Intro Catfish, 500g, 3.00m, 2seg
Exclusiv online!

Lanseta Somn Mikado Intro Catfish, 500g, 3.00m, 2seg

WAA879-300
Livrare 48-72 ore

306,00Lei

Lingura Somn Mikado Clicker 75G/13Cm - Red And Black
Exclusiv online!

Lingura Somn Mikado Clicker 75G/13Cm - Red And Black

pmb-wctd-75
Livrare 48-72 ore

42,00Lei

Montura Catfish - Mono Set I-Adjustable Combi Rig 10G-200Cm-100Kg - Ancora: 2/0 -
Exclusiv online!

Montura Catfish - Mono Set I-Adjustable Combi Rig 10G-200Cm-100Kg - Ancora: 2/0 -

HIC093-2/0
Livrare 48-72 ore

87,00Lei

Montura Catfish - Mono Set Iii - Big Bait Ready Rig 10G-200Cm-100Kg - Ancora: 2/0 Carlig Nr 4/0
Exclusiv online!

Montura Catfish - Mono Set Iii - Big Bait Ready Rig 10G-200Cm-100Kg - Ancora: 2/0 Carlig Nr 4/0

HIC095-2/0
Livrare 48-72 ore

85,00Lei

Mulineta Zfish Zeus ZX 8000

Mulineta Zfish Zeus ZX 8000

zf-9177
Livrare imediată!

238,89Lei

Oprioare Cat Gum Stoppers
Exclusiv online!

Oprioare Cat Gum Stoppers

AMR7046
Livrare 48-72 ore

17,01Lei

Plumb Somn Zfish Monturi Catfish, 100g
Exclusiv online!

Plumb Somn Zfish Monturi Catfish, 100g

33-3144
Livrare 48-72ore

8,16Lei

Plumb Somn Zfish Monturi Catfish, 150g
Exclusiv online!

Plumb Somn Zfish Monturi Catfish, 150g

33-3145
Livrare 48-72ore

10,17Lei

Plumb Somn Zfish Monturi Catfish, 200g
Exclusiv online!

Plumb Somn Zfish Monturi Catfish, 200g

33-3146
Livrare 48-72ore

11,75Lei

Plumb Somn Zfish Monturi Catfish, 250g
Exclusiv online!

Plumb Somn Zfish Monturi Catfish, 250g

33-3147
Livrare 48-72ore

14,36Lei

Plumb Somn Zfish Monturi Catfish, 300g
Exclusiv online!

Plumb Somn Zfish Monturi Catfish, 300g

33-3148
Livrare 48-72ore

15,74Lei

Pluta Ex - Catfish 009 - 280G
Exclusiv online!

Pluta Ex - Catfish 009 - 280G

smct-009-280
Livrare 48-72 ore

39,00Lei

Pluta Somn Filfishing Catfish Float FPK 43, 100g
Exclusiv online!

Pluta Somn Filfishing Catfish Float FPK 43, 100g

50-8741
Livrare 48-72ore

15,55Lei

Afişare 461 - 480 din 2568 (129 pagini)
Queries: 10, Total time: 56.378 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '629b38d7d41ae914dab3858ef0'
/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 (55.354)
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('+somn' 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.150)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.119)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.116)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.090)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.117)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.093)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.118)
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