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


Momitor Carp Expert Method Feeder Pro Method Flat XXL 40g

Momitor Carp Expert Method Feeder Pro Method Flat XXL 40g

58040040
Livrare imediată!

9,50Lei

Shad Dragon Phantom PRO Motor Oil / Clear 36911 4inch /10cm -15%

Shad Dragon Phantom PRO Motor Oil / Clear 36911 4inch /10cm

cheph40d36911b
Livrare imediată!

20,00Lei(-15%) 17,01Lei

VVOBLER RAPTURE PRO CRANKY BLEAK 5cm 3.5g OB
Exclusiv online!

VVOBLER RAPTURE PRO CRANKY BLEAK 5cm 3.5g OB

180-05-674
Livrare 48-72 ore

20,00Lei

Minciog Rapture Aggressor Pro Net XL 60x50 2.10m 2seg
Exclusiv online!

Minciog Rapture Aggressor Pro Net XL 60x50 2.10m 2seg

084-51-620
Livrare 48-72 ore

365,00Lei

Vobler Spro Swimbait BBZ1 Floating 10 Cm Killer Gill 21 Gr
Exclusiv online!

Vobler Spro Swimbait BBZ1 Floating 10 Cm Killer Gill 21 Gr

004863-00500-00000
Livrare 48-72 ore

106,01Lei

Vobler Strike Pro Baby Buster, C480F, 25g, 10cm

Vobler Strike Pro Baby Buster, C480F, 25g, 10cm

sp.eg050.c480f
Livrare imediată!

53,50Lei

Manusi Fox Spomb Pro Casting Marime XL-XXL -33%

Manusi Fox Spomb Pro Casting Marime XL-XXL

dtl006
Livrare imediată!

89,96Lei(-33%) 60,27Lei

Shad Lucky John Pro Series Tioga 2inch 5,1cm PA01 Watermelon 8 buc/plic

Shad Lucky John Pro Series Tioga 2inch 5,1cm PA01 Watermelon 8 buc/plic

lj-t2-pa01
Livrare imediată!

20,00Lei

CICADA STRIKE PRO ASTRO VIBE 5.5CM/16.7G Culoare: 945
Exclusiv online!

CICADA STRIKE PRO ASTRO VIBE 5.5CM/16.7G Culoare: 945

sp.pjg005b.945
Livrare 24-48 ore

40,02Lei

Minciog Savage Gear Pro Folding Rubber Mesh - XL
Exclusiv online!

Minciog Savage Gear Pro Folding Rubber Mesh - XL

a2.sg.50804
Livrare 24-48 ore

298,19Lei

SHAD DAIWA PROREX DUCK FIN 4.5CM 8BUC/PLIC FIRETIGER
Exclusiv online!

SHAD DAIWA PROREX DUCK FIN 4.5CM 8BUC/PLIC FIRETIGER

d.15604.804
Livrare 24-48 ore

41,22Lei

Momitor feeder DELPHIN PROFES RIVER 40gr

Momitor feeder DELPHIN PROFES RIVER 40gr

930111040
Livrare imediată!

7,00Lei

Set Crosete + Burghiu Carp Expert Pro Method Feeder Soft Pellet Master

Set Crosete + Burghiu Carp Expert Pro Method Feeder Soft Pellet Master

80204008
Livrare imediată!

23,30Lei

Fir Monofilament Prologic Density Distance Hi-Viz Yellow 0.35mm 1000m 6.8kg

Fir Monofilament Prologic Density Distance Hi-Viz Yellow 0.35mm 1000m 6.8kg

a.pro.65032
Livrare imediată!

141,17Lei

Minciog Prologic Avenger Camo 1.80m 1seg -30%
Exclusiv online!

Minciog Prologic Avenger Camo 1.80m 1seg

a2.pro.65004
Livrare 24-48 ore

229,86Lei(-30%) 160,90Lei

HUSA PROTECTIE DAIWA LANSETA 170X2.5CM -30%

HUSA PROTECTIE DAIWA LANSETA 170X2.5CM

d.ch257893
Livrare imediată!

69,73Lei(-30%) 48,81Lei

VOBLER RAPTURE PRO RYUJIN YAMAME RED BELLY 4.5CM 4G

VOBLER RAPTURE PRO RYUJIN YAMAME RED BELLY 4.5CM 4G

180-17-448
Livrare imediată!

34,00Lei

Protectie Varf + Banda Fixare Lanseta Rapture Rod Tip Belt Set
Exclusiv online!

Protectie Varf + Banda Fixare Lanseta Rapture Rod Tip Belt Set

048-65-010
Livrare 48-72 ore

38,00Lei

HUSA Trakko PROTECTIE VARF LANSETA
Exclusiv online!

HUSA Trakko PROTECTIE VARF LANSETA

cby-97
Livrare 48-72ore

14,49Lei

Momitor Carp Expert Method Feeder Pro Method Flat XXL 80g
Exclusiv online!

Momitor Carp Expert Method Feeder Pro Method Flat XXL 80g

58040080
Livrare 24-48 ore

11,00Lei

Afişare 3781 - 3800 din 7177 (359 pagini)
Queries: 6, Total time: 596.535 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = '05d18d0c8d009a5b0f828c14da'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (567.345)
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 (pd.tag LIKE "%pro%") 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 (28.689)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 3780, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.150)
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
6 (0.106)
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