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


Fir Monofilament Prologic Density Distance Hi-Viz Yellow 0.33mm 1000m 6.15kg
Exclusiv online!

Fir Monofilament Prologic Density Distance Hi-Viz Yellow 0.33mm 1000m 6.15kg

a.pro.65031
Livrare 24-48 ore

141,17Lei

VOBLER RAPTURE PRO BEEATLE AREA F 28MM 2G JNB

VOBLER RAPTURE PRO BEEATLE AREA F 28MM 2G JNB

180-42-111
Livrare imediată!

27,00Lei

HANGER PROLOGIC K3 ALBASTRU -20%

HANGER PROLOGIC K3 ALBASTRU

a.pro.62054
Livrare imediată!

98,98Lei(-20%) 79,18Lei

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

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

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

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

Vobler Strike Pro Mustang Minnow 6cm/6g
Exclusiv online!

Vobler Strike Pro Mustang Minnow 6cm/6g

sp.mg002a.022pt
Livrare 24-48 ore

35,74Lei

Momitor Carp Expert Method Feeder Pro Method Flat XXL 70g

Momitor Carp Expert Method Feeder Pro Method Flat XXL 70g

58040070
Livrare imediată!

11,00Lei

Vobler Rapture Pro Dexter S 7.5cm 28g YMR
Exclusiv online!

Vobler Rapture Pro Dexter S 7.5cm 28g YMR

180-16-348
Livrare 48-72 ore

26,00Lei

Afişare 2041 - 2060 din 3912 (196 pagini)
Queries: 5, Total time: 111.024 ms [By time] [By id] [By file]
1 (0.070)
SELECT data
FROM `oc_session`
WHERE session_id = 'a7375fb355321bd19744424c97'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (94.542)
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('+pro' 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 (16.161)
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 2040, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.147)
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