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


UNDITA PRO FL EPOCA TRAVEL 5-30G 9 SECTIUNI 69CM 4.80M

UNDITA PRO FL EPOCA TRAVEL 5-30G 9 SECTIUNI 69CM 4.80M

64-4100
Livrare imediată!

139,90Lei

Lanseta Abu Garcia Travel Tormentor Spinning Rod H, 25-65g, 3.04m, 4seg
Exclusiv online!

Lanseta Abu Garcia Travel Tormentor Spinning Rod H, 25-65g, 3.04m, 4seg

1520995
Livrare 7-14 zile

305,96Lei

Lanseta Sonik Dominator Travel Spin, 2.74m, 30-50g, 4seg
Exclusiv online!

Lanseta Sonik Dominator Travel Spin, 2.74m, 30-50g, 4seg

dxsp030
Livrare 48-72 ore

272,91Lei

Cana Termoizolanta Stanley The Shortstack Travel Mug Hammertone Ice 0.23 L

Cana Termoizolanta Stanley The Shortstack Travel Mug Hammertone Ice 0.23 L

10-02887-068
Livrare imediată!

84,97Lei

Cana Termoizolanta Stanley The Shortstack Travel Mug Matte Black Pebble 0.23 L
Exclusiv online!

Cana Termoizolanta Stanley The Shortstack Travel Mug Matte Black Pebble 0.23 L

10-02887-067
Livrare 48-72ore

84,97Lei

Cana Termoizolanta Stanley The Trigger Action Travel Matte Black Pebble 0.35L
Exclusiv online!

Cana Termoizolanta Stanley The Trigger Action Travel Matte Black Pebble 0.35L

10-09848-007
Livrare 48-72ore

123,28Lei

Lanseta Hardy Aydon Travel Fly Rod 8 Line, 2.74m, 6seg
Exclusiv online!

Lanseta Hardy Aydon Travel Fly Rod 8 Line, 2.74m, 6seg

1570708
Livrare 7-14 zile

2.549,96Lei

LANSETA SPINNING CORMORAN PROFILINE TELE TRAVEL 2,40M/15-50G

LANSETA SPINNING CORMORAN PROFILINE TELE TRAVEL 2,40M/15-50G

c.26.2050241
Livrare imediată!

107,14Lei

LANSETA SPINNING CORMORAN PROFILINE TELE TRAVEL 2,10M/10-40G

LANSETA SPINNING CORMORAN PROFILINE TELE TRAVEL 2,10M/10-40G

c.26.2040211
Livrare imediată!

96,79Lei

LANSETA CORMORA PROFILIN SPINNING TELE.TRAVEL 2,70M/20-60G

LANSETA CORMORA PROFILIN SPINNING TELE.TRAVEL 2,70M/20-60G

c.26.2060271
Livrare imediată!

119,17Lei

Lanseta Nevis Winner Travel Tele 1.80M 20-40G
Exclusiv online!

Lanseta Nevis Winner Travel Tele 1.80M 20-40G

1222-180
Livrare 48-72 ore

35,00Lei

Bazooka DAM MAD Travel Rod Tube Telescopic 220cm

Bazooka DAM MAD Travel Rod Tube Telescopic 220cm

5058361000
Livrare imediată!

413,72Lei

Lanseta Nevis Winner Travel Tele 3.00M 20-40G
Exclusiv online!

Lanseta Nevis Winner Travel Tele 3.00M 20-40G

1222-300
Livrare 48-72 ore

55,00Lei

LANSETA JAXON INTENSA GTX TELE TRAVEL 3.00M 10-40GR

LANSETA JAXON INTENSA GTX TELE TRAVEL 3.00M 10-40GR

wj-ixy30040
Livrare imediată!

203,00Lei

Lanseta Nevis Winner Travel Tele 2.10M 20-40G
Exclusiv online!

Lanseta Nevis Winner Travel Tele 2.10M 20-40G

1222-210
Livrare 48-72 ore

36,00Lei

Lanseta Nevis Winner Travel Tele 2.40M 20-40G
Exclusiv online!

Lanseta Nevis Winner Travel Tele 2.40M 20-40G

1222-240
Livrare 48-72 ore

41,00Lei

Lanseta Nevis Winner Travel Tele 2.70M 20-40G

Lanseta Nevis Winner Travel Tele 2.70M 20-40G

1222-270
Livrare imediată!

52,00Lei

PALARIE BLASER TRAVEL DARK BROWN MOTTLED MAR.56
Exclusiv online!

PALARIE BLASER TRAVEL DARK BROWN MOTTLED MAR.56

bl.122072.119.1.56
Livrare 24-48 ore

569,70Lei

PALARIE BLASER TRAVEL DARK BROWN MOTTLED MAR.57
Exclusiv online!

PALARIE BLASER TRAVEL DARK BROWN MOTTLED MAR.57

bl.122072.119.1.57
Livrare 24-48 ore

569,70Lei

Lanseta Sportex Rapid Travel Spin 260 20g 4seg

Lanseta Sportex Rapid Travel Spin 260 20g 4seg

rp2601
Livrare imediată!

720,00Lei

Afişare 41 - 60 din 148 (8 pagini)
Queries: 6, Total time: 7.537 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = 'f744267f65e857ca930788e8af'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.092)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (6.998)
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('+travel' 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.137)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.105)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.118)
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