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 Mitchell Catch Rod Telescopic, 80-150g, 3.90m, 5seg

Lanseta Mitchell Catch Rod Telescopic, 80-150g, 3.90m, 5seg

1406801
Stoc epuizat

121,02Lei

Lanseta Mitchell Traxx MX3LE Jigging Rod 902ML, 7-32g, 2.74m, 2seg

Lanseta Mitchell Traxx MX3LE Jigging Rod 902ML, 7-32g, 2.74m, 2seg

1542800
Stoc epuizat

382,13Lei

Lanseta Mitchell Traxx MX3LE Lure Spinning Rod 802H, 15-60g, 2.44m, 2seg

Lanseta Mitchell Traxx MX3LE Lure Spinning Rod 802H, 15-60g, 2.44m, 2seg

1542790
Stoc epuizat

363,02Lei

Lanseta Penn Overseas XT Inshore Spinning Rod, 15-40g, 2.44m, 5seg

Lanseta Penn Overseas XT Inshore Spinning Rod, 15-40g, 2.44m, 5seg

1522290
Stoc epuizat

927,01Lei

Lanseta Penn Regiment III Boat Travel Spinning Rod EH, 30-50lb, 2.24m, 4seg
Lanseta Penn Regiment III Halibuster Rod H, 20-30lbs, 2.40m, 1+1seg

Lanseta Penn Regiment III Halibuster Rod H, 20-30lbs, 2.40m, 1+1seg

1544361
Stoc epuizat

764,96Lei

Lanseta Penn Regiment III Inner Boat Rod 701 H, 20-30lbs, 2.13m, 1seg

Lanseta Penn Regiment III Inner Boat Rod 701 H, 20-30lbs, 2.13m, 1seg

1544355
Stoc epuizat

584,96Lei

Lanseta Penn Warfare Trolling Boat Bottom Rod, 30-50lb, 1.74m, 1+1seg

Lanseta Penn Warfare Trolling Boat Bottom Rod, 30-50lb, 1.74m, 1+1seg

1560633
Stoc epuizat

191,21Lei

Lanseta Penn Wrath Boat Rod, 2.10m, 30-50lbs, 2seg

Lanseta Penn Wrath Boat Rod, 2.10m, 30-50lbs, 2seg

1536414
Stoc epuizat

258,41Lei

Lanseta PENN Wrath II Boat Squid Rod, 150g, 2.13m, 3seg

Lanseta PENN Wrath II Boat Squid Rod, 150g, 2.13m, 3seg

1536423
Stoc epuizat

218,60Lei

Lanseta Penn Wrath Rod, 10-40g, 2.10m, 2seg

Lanseta Penn Wrath Rod, 10-40g, 2.10m, 2seg

1536367
Stoc epuizat

198,67Lei

Lanseta Penn Wrath Rod, 30-60g, 2.70m, 2seg

Lanseta Penn Wrath Rod, 30-60g, 2.70m, 2seg

1536410
Stoc epuizat

258,41Lei

Lanseta Penn Wrath Rod, 80-120g, 2.40m, 2seg

Lanseta Penn Wrath Rod, 80-120g, 2.40m, 2seg

1536409
Stoc epuizat

238,54Lei

Lanseta Penn Wrath Surfcast Rod, 4.26m, 170g, 3seg

Lanseta Penn Wrath Surfcast Rod, 4.26m, 170g, 3seg

1536417
Stoc epuizat

437,62Lei

Lanseta Telescopica JRC Defender Rod LR-T, 3.90m, 3.50lbs, 6seg

Lanseta Telescopica JRC Defender Rod LR-T, 3.90m, 3.50lbs, 6seg

1545328
Stoc epuizat

350,95Lei

Minciog Rod Hutchinson DMX , 107cm

Minciog Rod Hutchinson DMX , 107cm

htln01
Stoc epuizat

740,00Lei

Minciog Rod Hutchinson Sceptre, Verde Oliv, 107cm

Minciog Rod Hutchinson Sceptre, Verde Oliv, 107cm

htln05
Stoc epuizat

390,00Lei

Sistem PB Products Prindere Lanseta Bungee Rod Lock, Small

Sistem PB Products Prindere Lanseta Bungee Rod Lock, Small

pb29500
Stoc epuizat

24,99Lei

Boilies Rod Hutchinson Instant Attractor Scopex & Cream, 20mm, 1kg

Boilies Rod Hutchinson Instant Attractor Scopex & Cream, 20mm, 1kg

rh0401
Stoc epuizat

55,00Lei

Boilies Rod Hutchinson Instant Attractor Squid & Octopus, 20mm, 1kg

Boilies Rod Hutchinson Instant Attractor Squid & Octopus, 20mm, 1kg

rh0601
Stoc epuizat

55,00Lei

Afişare 1221 - 1240 din 1502 (76 pagini)
Queries: 4, Total time: 40.955 ms [By time] [By id] [By file]
1 (0.162)
SELECT data
FROM `oc_session`
WHERE session_id = 'dc1a911b5891c39999b55a28b2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.131)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (40.470)
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('+rod' 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 (0.192)
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