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 300 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


SALOPETA IMPERMEABILA SHIMANO BIBBRACE ROYAL BLUE MARIME XL -19%

SALOPETA IMPERMEABILA SHIMANO BIBBRACE ROYAL BLUE MARIME XL

shbib18rbxl
Livrare imediată!

384,75Lei(-19%) 309,90Lei

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

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

LANSETA FEEDER PRO FL ROYAL X 3.90M 60-180G

LANSETA FEEDER PRO FL ROYAL X 3.90M 60-180G

7253247293305
Livrare imediată!

169,90Lei

LANSETA FEEDER PRO FL ROYAL X 3.60M 60-180G

LANSETA FEEDER PRO FL ROYAL X 3.60M 60-180G

7253240308877
Livrare imediată!

159,90Lei

Husa Zfish Rod Case Royal Holdall, 3 Compartimente, Kaki, 130cm

Husa Zfish Rod Case Royal Holdall, 3 Compartimente, Kaki, 130cm

zf-2399
Livrare imediată!

199,05Lei

Husa, Zfish, Rod, Case, Royal, Holdall,, 3, Compartimente,, Kaki,, 110cm, ZF-2397, Huse Lansete cu Mulinete, Huse Lansete cu Mulinete ZFISH, Huse ZFISH, Lansete ZFISH, Mulinete ZFISH, ZFISH
Pichet Zfish Royale Slim Bankstick, 30-45cm
Exclusiv online!

Pichet Zfish Royale Slim Bankstick, 30-45cm

ZF-7970
Livrare 48-72ore

29,70Lei

Pichet Zfish Royale Slim Bankstick, 50-90cm
Exclusiv online!

Pichet Zfish Royale Slim Bankstick, 50-90cm

ZF-7971
Livrare 48-72ore

37,68Lei

PAT FOX ROYALE CAMO COMPACT -15%

PAT FOX ROYALE CAMO COMPACT

cbc054
Livrare imediată!

1.079,96Lei(-15%) 917,95Lei

LANSETA BOLOGNEZA COLMIC ROYAL S-100 6M 10GR
Exclusiv online!

LANSETA BOLOGNEZA COLMIC ROYAL S-100 6M 10GR

caro01a
Livrare 48-72 ore

1.525,00Lei

Lanseta Feeder TF By Dome Royal Method Carp 420H 40-100g
Exclusiv online!

Lanseta Feeder TF By Dome Royal Method Carp 420H 40-100g

1848-420
Livrare 48-72 ore

786,99Lei

Lanseta Feeder TF By Dome Royal Method Carp 360M 30-60g
Exclusiv online!

Lanseta Feeder TF By Dome Royal Method Carp 360M 30-60g

1848-360
Livrare 48-72 ore

662,00Lei

ATA MATISAJ FUJI D-METALLIC 100m 30 ROYAL BLUE 912
Exclusiv online!

ATA MATISAJ FUJI D-METALLIC 100m 30 ROYAL BLUE 912

mftmtd0912
Livrare 48-72 ore

64,00Lei

FIR MONOFILAMENT MIVARDI ROYAL FEEDER 0.225 mm 200m 6.7kg

FIR MONOFILAMENT MIVARDI ROYAL FEEDER 0.225 mm 200m 6.7kg

miv-rf222
Livrare imediată!

26,50Lei

ROD POD EXTRA CARP ROYAL 3 POSTURI

ROD POD EXTRA CARP ROYAL 3 POSTURI

ec1781
Livrare imediată!

330,00Lei

FIR MONOFILAMENT MIVARDI ROYAL SPINNING 0.225mm 200m 6.70kg

FIR MONOFILAMENT MIVARDI ROYAL SPINNING 0.225mm 200m 6.70kg

miv-rs222
Livrare imediată!

26,50Lei

FIR MONOFILAMENT MIVARDI ROYAL SPINNING 0.185mm 200m 3.90kg

FIR MONOFILAMENT MIVARDI ROYAL SPINNING 0.185mm 200m 3.90kg

miv-rs218
Livrare imediată!

24,00Lei

FIR MONOFILAMENT MIVARDI ROYAL SPINNING 0.165mm 200m 3.20kg

FIR MONOFILAMENT MIVARDI ROYAL SPINNING 0.165mm 200m 3.20kg

miv-rs216
Livrare imediată!

23,00Lei

FIR MONOFILAMENT MIVARDI ROYAL SPINNING 0.205mm 200m 4.80kg

FIR MONOFILAMENT MIVARDI ROYAL SPINNING 0.205mm 200m 4.80kg

miv-rs220
Livrare imediată!

25,50Lei

Afişare 1 - 20 din 77 (4 pagini)
Queries: 10, Total time: 294.977 ms [By time] [By id] [By file]
1 (0.124)
SELECT data
FROM `oc_session`
WHERE session_id = '989c8ff2c7f26d29d4c73be7f9'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.122)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.097)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (293.904)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%royal%") 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:698
5 (0.151)
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.112)
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.097)
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.128)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.118)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.124)
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