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


Minciog Zfish Landing Net DLX, 160x70x60cm

Minciog Zfish Landing Net DLX, 160x70x60cm

zf-3022
Livrare imediată!

149,24Lei

Minciog Zfish Telescopic Classic Landing Net, 150cm

Minciog Zfish Telescopic Classic Landing Net, 150cm

zf-2363
Livrare imediată!

57,58Lei

Minciog Zfish Telescopic Classic Landing Net, 190cm
Exclusiv online!

Minciog Zfish Telescopic Classic Landing Net, 190cm

zf-2364
Livrare 48-72ore

65,55Lei

Minciog Zfish Telescopic Landing Net Compact RM, 187cm

Minciog Zfish Telescopic Landing Net Compact RM, 187cm

zf-1179
Livrare imediată!

119,35Lei

Minciog Zfish Telescopic Select Landing Net, 190cm

Minciog Zfish Telescopic Select Landing Net, 190cm

zf-2366
Livrare imediată!

79,52Lei

Plasa Rezerva Minciog Zfish Synapse Landing Net Replacement 36, 90x95cm
Exclusiv online!

Plasa Rezerva Minciog Zfish Synapse Landing Net Replacement 36, 90x95cm

zf-1128
Livrare 48-72ore

73,51Lei

Plasa Rezerva Minciog Zfish Synapse Landing Net Replacement 42, 117x117x117cm
Exclusiv online!

Plasa Rezerva Minciog Zfish Synapse Landing Net Replacement 42, 117x117x117cm

zf-1135
Livrare 48-72ore

79,52Lei

Suport Minciog JACKALL T-Connection Timon Net Stand
Exclusiv online!

Suport Minciog JACKALL T-Connection Timon Net Stand

a6.ja.807260472
Livrare 24-48 ore

350,40Lei

Minciog Shimano TX Extreme Landing Net 185cm -5%

Minciog Shimano TX Extreme Landing Net 185cm

txelnp42
Livrare imediată!

721,22Lei(-5%) 685,00Lei

Flotor Minciog Nash Net Float Camo Large

Flotor Minciog Nash Net Float Camo Large

t3586
Livrare imediată!

77,99Lei

Flotor Minciog Nash Subterfuge Net Float Small -22%

Flotor Minciog Nash Subterfuge Net Float Small

t3619
Livrare imediată!

68,98Lei(-22%) 54,01Lei

Flotor Minciog Nash Net Float Camo Small -20%

Flotor Minciog Nash Net Float Camo Small

t3585
Livrare imediată!

63,99Lei(-20%) 50,90Lei

Flotor Minciog Nash Subterfuge Net Float Camo Large -21%

Flotor Minciog Nash Subterfuge Net Float Camo Large

t3620
Livrare imediată!

82,99Lei(-21%) 65,60Lei

MANER MINCIOG TRABUCCO DREAM TEAM NET*FAST CARP NET 3,20m

MANER MINCIOG TRABUCCO DREAM TEAM NET*FAST CARP NET 3,20m

081-06-320
Stoc epuizat

299,00Lei

MANER MINCIOG KORUM POWER TELESCOPIC NET HANDLE 3M

MANER MINCIOG KORUM POWER TELESCOPIC NET HANDLE 3M

k0380002
Stoc epuizat

177,08Lei

Halau DAM Umbrella Net Nylon 100x100x15cm 6mm 50cm

Halau DAM Umbrella Net Nylon 100x100x15cm 6mm 50cm

5060965911
Stoc epuizat

72,44Lei

MANER MINCIOG TELESCOPIC KORUM OPPORTUNIST NET HANDLE 1.80M

MANER MINCIOG TELESCOPIC KORUM OPPORTUNIST NET HANDLE 1.80M

k0380014
Stoc epuizat

193,46Lei

CAP MINCIOG KORUM FOLDING LATEX TRIANGLE NET 30"

CAP MINCIOG KORUM FOLDING LATEX TRIANGLE NET 30"

k0380021
Stoc epuizat

152,96Lei

CAP MINCIOG KORUM FOLDING TRIANGLE NET 72CM

CAP MINCIOG KORUM FOLDING TRIANGLE NET 72CM

k0380016
Stoc epuizat

143,95Lei

CAP DE MINCIOG KORUM FAST NET HEAD 26"

CAP DE MINCIOG KORUM FAST NET HEAD 26"

k0380029
Stoc epuizat

166,46Lei

Afişare 301 - 320 din 432 (22 pagini)
Queries: 8, Total time: 16.926 ms [By time] [By id] [By file]
1 (0.094)
SELECT data
FROM `oc_session`
WHERE session_id = '5bc7b176cf387e0156a1511321'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (16.250)
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('+net' 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.154)
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.082)
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.075)
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.079)
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
8 (0.110)
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