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


LANSETA SHIMANO SPEEDCAST FEEDER 3.96M, 90G

LANSETA SHIMANO SPEEDCAST FEEDER 3.96M, 90G

spcpr90fdr
Livrare imediată!

1.339,00Lei

Lanseta feeder Shimano Aero X1 Distance 3.66m 90g 2+2seg -37%

Lanseta feeder Shimano Aero X1 Distance 3.66m 90g 2+2seg

aex1dfdr12
Livrare imediată!

429,99Lei(-37%) 269,00Lei

Set Vartej Rapid + Con Antitangle Delphin FDR Quick S, 5buc/blister -33%

Set Vartej Rapid + Con Antitangle Delphin FDR Quick S, 5buc/blister

969901200
Stoc epuizat

11,00Lei(-33%) 7,40Lei

Lanseta feeder Shimano Aero X5 Distance Feeder 3.96m 90g 3+3seg -25%

Lanseta feeder Shimano Aero X5 Distance Feeder 3.96m 90g 3+3seg

aex5dfdr13
Stoc epuizat

1.090,00Lei(-25%) 816,99Lei

Tambur de rezerva cu adancime mica Delphin LEEDER FDR 5T SH aluminium

Tambur de rezerva cu adancime mica Delphin LEEDER FDR 5T SH aluminium

101001240
Stoc epuizat

57,00Lei

Tambur de rezerva cu adancime mica Delphin LEEDER FDR 7T SH aluminium

Tambur de rezerva cu adancime mica Delphin LEEDER FDR 7T SH aluminium

101001242
Stoc epuizat

57,00Lei

Tambur de rezerva cu adancime mica Delphin LEEDER FDR 6T SH aluminium

Tambur de rezerva cu adancime mica Delphin LEEDER FDR 6T SH aluminium

101001241
Stoc epuizat

57,00Lei

Tambur de rezerva Trabucco Spectrum FDR 5500

Tambur de rezerva Trabucco Spectrum FDR 5500

034-81-555
Stoc epuizat

110,00Lei

Lanseta Shimano Aero X5 Distance Heavy Power Feeder Rod 14ft 4.27m 150g 3+3buc -25%

Lanseta Shimano Aero X5 Distance Heavy Power Feeder Rod 14ft 4.27m 150g 3+3buc

aex5dhpfdr14
Stoc epuizat

1.265,01Lei(-25%) 948,00Lei

Lanseta Shimano Aero X3 Distance Feeder, 100g, 3.96m, 3seg -8%

Lanseta Shimano Aero X3 Distance Feeder, 100g, 3.96m, 3seg

aex3dfdr13
Stoc epuizat

608,99Lei(-8%) 560,28Lei

Lanseta Shimano Aero X3 Distance Feeder, 90g, 3.66m, 2seg -8%

Lanseta Shimano Aero X3 Distance Feeder, 90g, 3.66m, 2seg

aex3dfdr12
Stoc epuizat

572,00Lei(-8%) 526,24Lei

Lanseta Delphin NIRVANA FDR, 3.90m, 80g, 3+3seg

Lanseta Delphin NIRVANA FDR, 3.90m, 80g, 3+3seg

101001487
Stoc epuizat

717,00Lei

Lanseta Shimano Aero X3 Distance Feeder, 150g, 4.27m, 3seg -8%

Lanseta Shimano Aero X3 Distance Feeder, 150g, 4.27m, 3seg

aex3dhpfdr14
Stoc epuizat

651,00Lei(-8%) 598,93Lei

Lanseta Delphin NIRVANA FDR , 3.60m, 80g, 3+3seg

Lanseta Delphin NIRVANA FDR , 3.60m, 80g, 3+3seg

101001486
Stoc epuizat

691,00Lei

Mulineta Delphin Leeder FDR 5T

Mulineta Delphin Leeder FDR 5T

101001222
Stoc epuizat

200,00Lei

Carlige Fudo Round (FDRD-BN) nr.8 BN - Black Nickel 15 buc/plic -20%

Carlige Fudo Round (FDRD-BN) nr.8 BN - Black Nickel 15 buc/plic

2701-8
Stoc epuizat

10,00Lei(-20%) 8,00Lei

Carlige Fudo Round (FDRD-BN) nr.10 BN - Black Nickel 15 buc/plic -20%

Carlige Fudo Round (FDRD-BN) nr.10 BN - Black Nickel 15 buc/plic

2701-10
Stoc epuizat

10,00Lei(-20%) 8,00Lei

Mulineta Delphin Leeder FDR 6T -25%

Mulineta Delphin Leeder FDR 6T

101001223
Stoc epuizat

205,00Lei(-25%) 153,80Lei

VOBLER LUCKY JOHN SHAD-XDR 8F 012 8CM 14G

VOBLER LUCKY JOHN SHAD-XDR 8F 012 8CM 14G

ljo0308fdr-012
Stoc epuizat

32,00Lei

Varf Delphin NIRVANA FDR Light Carbon Glass, 1buc

Varf Delphin NIRVANA FDR Light Carbon Glass, 1buc

101001308
Stoc epuizat

41,00Lei

Afişare 21 - 40 din 45 (3 pagini)
Queries: 12, Total time: 203.761 ms [By time] [By id] [By file]
1 (0.141)
SELECT data
FROM `oc_session`
WHERE session_id = '318dd8b9eda39769a26f1fb848'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.129)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (202.606)
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 = '0' AND (pd.tag LIKE "%fdr%") 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
4 (0.126)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.101)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.097)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.094)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.095)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.095)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.091)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (0.090)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
12 (0.096)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38