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


Lanseta Shakespeare Skp Concept Light Tip 3.00m, 3+2seg

Lanseta Shakespeare Skp Concept Light Tip 3.00m, 3+2seg

1550396
Stoc epuizat

349,74Lei

Lanseta Shakespeare Superteam CX Float, 3.00m, 3-6lb, 2seg

Lanseta Shakespeare Superteam CX Float, 3.00m, 3-6lb, 2seg

1558437
Stoc epuizat

247,46Lei

Lanseta Shakespeare Ugly Stik Travel Spin Rod 1.98m, 5-15g

Lanseta Shakespeare Ugly Stik Travel Spin Rod 1.98m, 5-15g

1156008
Stoc epuizat

239,96Lei

Lanseta Spinning Jackall T-Connection Area TCA-S61ML, 1.90m, 1-4.5g, 2seg

Lanseta Spinning Jackall T-Connection Area TCA-S61ML, 1.90m, 1-4.5g, 2seg

ja.807246551
Stoc epuizat

3.243,59Lei

LANSETA SPINNING PRO FL MURROW 1.80M 0.2-6G

LANSETA SPINNING PRO FL MURROW 1.80M 0.2-6G

64-4102
Stoc epuizat

131,90Lei

Lanseta Sportex Black Pearl Maxx Baitcast, 2.10m, 13-29g, 2seg

Lanseta Sportex Black Pearl Maxx Baitcast, 2.10m, 13-29g, 2seg

bp2131
Stoc epuizat

698,99Lei

Lanseta Sportex Competition Carp CS-5 3.66m, 3.25lbs, 3seg

Lanseta Sportex Competition Carp CS-5 3.66m, 3.25lbs, 3seg

cc144442
Stoc epuizat

809,00Lei

Lanseta Sportex Competition Carp CS-5 Spod 3.66m, 5.50lbs, 2seg

Lanseta Sportex Competition Carp CS-5 Spod 3.66m, 5.50lbs, 2seg

cc144450
Stoc epuizat

860,00Lei

Lanseta Sportex Illusion Baitcast 2.10m, 3-17g, 2seg

Lanseta Sportex Illusion Baitcast 2.10m, 3-17g, 2seg

il2100
Stoc epuizat

540,00Lei

Lanseta Sportex Illusion SharpShoot 2.25m, 21-68g, 2seg

Lanseta Sportex Illusion SharpShoot 2.25m, 21-68g, 2seg

il2202
Stoc epuizat

600,00Lei

Lanseta Sportex Xclusive Float XT 3.60m, 20-40g, 3seg

Lanseta Sportex Xclusive Float XT 3.60m, 20-40g, 3seg

pf3633
Stoc epuizat

1.130,00Lei

Lanseta Sportex Xclusive Match XT 3.60m, 5-29g, 3seg

Lanseta Sportex Xclusive Match XT 3.60m, 5-29g, 3seg

mr3631
Stoc epuizat

1.250,00Lei

Lanseta Sunset Troller XRS2, 30lbs, 1.65m, 1seg

Lanseta Sunset Troller XRS2, 30lbs, 1.65m, 1seg

20311stsrf8151165-130
Stoc epuizat

165,02Lei

Lanseta Telescopica Mikado Intro Power Telerod, 150g, 3.30m, 8seg

Lanseta Telescopica Mikado Intro Power Telerod, 150g, 3.30m, 8seg

WAA798-330
Stoc epuizat

235,00Lei

Lanseta Telescopica Mitchell Suprema 2.0 PEP Tele, 4.20m, 15-55g, 4seg

Lanseta Telescopica Mitchell Suprema 2.0 PEP Tele, 4.20m, 15-55g, 4seg

1392791
Stoc epuizat

382,13Lei

Lanseta Telescopica Mitchell Suprema A2 PEP Tele, 3.90m, 3-15g, 4seg

Lanseta Telescopica Mitchell Suprema A2 PEP Tele, 3.90m, 3-15g, 4seg

1392737
Stoc epuizat

305,62Lei

Lanseta Telescopica Mitchell Suprema A3 PEP Tele, 3.90m, 10-40g, 4seg

Lanseta Telescopica Mitchell Suprema A3 PEP Tele, 3.90m, 10-40g, 4seg

1392738
Stoc epuizat

305,62Lei

Lanseta Yamaga Blanks Early Seabass 93M 2.819m 7-35gr

Lanseta Yamaga Blanks Early Seabass 93M 2.819m 7-35gr

yb00296
Stoc epuizat

2.240,00Lei

Varf Rezerva Lanseta Feeder Team Feeder By Dome Gold Serie 2.5oz

Varf Rezerva Lanseta Feeder Team Feeder By Dome Gold Serie 2.5oz

1861_391_2.5oz
Stoc epuizat

85,00Lei

Husa Daiwa Hard 1 Lanseta + Mulineta, 130cm

Husa Daiwa Hard 1 Lanseta + Mulineta, 130cm

d.15808.310
Stoc epuizat

343,01Lei

Afişare 6141 - 6160 din 8574 (429 pagini)
Queries: 5, Total time: 250.449 ms [By time] [By id] [By file]
1 (0.208)
SELECT data
FROM `oc_session`
WHERE session_id = 'da95624df9a3e73045f51ecd22'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (216.032)
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('+lanseta' 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 (33.887)
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 6140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.214)
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