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


Porumb, Flotant, Claumar, 10Buc, MIX, clm201232-0550, Porumb Artificial, Porumb Artificial Claumar, Porumb Claumar, Artificial Claumar, Claumar
Fir Monofilament Katran Crypton Carp & Method Feeder, Moss Green, 0.215mm, 4.01kg, 300m

Fir Monofilament Katran Crypton Carp & Method Feeder, Moss Green, 0.215mm, 4.01kg, 300m

4262389020123
Livrare imediată!

48,00Lei

Mulineta Fl Strategist Tx 14000 Silver

Mulineta Fl Strategist Tx 14000 Silver

5252205151239
Livrare imediată!

449,80Lei

Pichet Telescopic FL Subtire Negru Fara Bughiu

Pichet Telescopic FL Subtire Negru Fara Bughiu

1231205906326
Livrare imediată!

24,20Lei

LANSETA SHIMANO TRIBAL TX-A MARKER 3.66 m 3.00 Lbs 2seg -38%

LANSETA SHIMANO TRIBAL TX-A MARKER 3.66 m 3.00 Lbs 2seg

txam12300
Livrare imediată!

565,00Lei(-38%) 353,00Lei

Baterie Lithium Power CR123A - 3V - Panasonic

Baterie Lithium Power CR123A - 3V - Panasonic

adv-344
Livrare imediată!

15,01Lei

Varf Rezerva Benzar Lanseta Universal Feeder 3oz Fibra Rosu -20%

Varf Rezerva Benzar Lanseta Universal Feeder 3oz Fibra Rosu

12329104
Livrare imediată!

32,00Lei(-20%) 25,60Lei

TRICOU Maver UK TEAM WHITE XXL
Exclusiv online!

TRICOU Maver UK TEAM WHITE XXL

n1238
Livrare 48-72 ore

93,00Lei

Husa, Rigida, FL, 1, Compartiment, 115cm, 5752123467530, Huse Rigide si Tuburi Lansete, Huse Rigide si Tuburi Lansete FL., FL.
TRICOU Maver UK TEAM WHITE XL
Exclusiv online!

TRICOU Maver UK TEAM WHITE XL

n1237
Livrare 48-72 ore

93,00Lei

TRICOU Maver UK TEAM BLACK XXXL
Exclusiv online!

TRICOU Maver UK TEAM BLACK XXXL

n1234
Livrare 48-72 ore

93,00Lei

CARLIGE Maver IT KATANA 1235 NEGRU NR 3/0
Exclusiv online!

CARLIGE Maver IT KATANA 1235 NEGRU NR 3/0

1235a3/0
Livrare 48-72 ore

20,00Lei

Pantaloni Nash Tackle Joggers Black XL

Pantaloni Nash Tackle Joggers Black XL

c1123
Livrare imediată!

175,99Lei

TRICOU Maver UK TEAM BLACK XXL
Exclusiv online!

TRICOU Maver UK TEAM BLACK XXL

n1233
Livrare 48-72 ore

93,00Lei

CARLIGE Maver IT KATANA 1235 NEGRU NR 6/0
Exclusiv online!

CARLIGE Maver IT KATANA 1235 NEGRU NR 6/0

1235a6/0
Livrare 48-72 ore

20,00Lei

CARLIGE Maver IT KATANA 1235 NEGRU NR 1/0
Exclusiv online!

CARLIGE Maver IT KATANA 1235 NEGRU NR 1/0

1235a1/0
Livrare 48-72 ore

16,01Lei

CARLIGE Maver IT KATANA 1235 NEGRU NR 7/0

CARLIGE Maver IT KATANA 1235 NEGRU NR 7/0

1235a7/0
Livrare imediată!

24,00Lei

Varf Rezerva Benzar Lanseta Universal Feeder 3oz Carbon Rosu -20%

Varf Rezerva Benzar Lanseta Universal Feeder 3oz Carbon Rosu

12329105
Livrare imediată!

35,00Lei(-20%) 28,00Lei

LINGURITA Oscilanta Misu Argintata MIG21 Mare 23g
Exclusiv online!

LINGURITA Oscilanta Misu Argintata MIG21 Mare 23g

f3.osc.ma.m2123
Livrare 24-48 ore

20,49Lei

CARLIGE Maver IT KATANA 1235 NEGRU NR 4/0
Exclusiv online!

CARLIGE Maver IT KATANA 1235 NEGRU NR 4/0

1235a4/0
Livrare 48-72 ore

20,00Lei

Afişare 1 - 20 din 527 (27 pagini)
Queries: 10, Total time: 1,064.145 ms [By time] [By id] [By file]
1 (0.085)
SELECT data
FROM `oc_session`
WHERE session_id = 'feea853ae4a904f473b7361d2d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.088)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (614.531)
SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%123%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555
5 (447.448)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%123%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.201)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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_to_category` AS p2c ON (p.product_id = p2c.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '2' AND p2c.category_id = '373' AND (pd.tag LIKE "%123%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1005
7 (1.382)
SELECT COUNT(*) AS val, filter_group, filter_id
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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_to_category` AS p2c ON (p.product_id = p2c.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '2' AND p2c.category_id = '373' AND (pd.tag LIKE "%123%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:917
8 (0.114)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.098)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.110)
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