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


Pieptene Stonfo Combi
Exclusiv online!

Pieptene Stonfo Combi

8028651017385
Livrare 48-72 ore

28,00Lei

Zarnoitoare Sticla Fox Rage Strike Point Hitcher Rattle Large, 3buc
Exclusiv online!

Zarnoitoare Sticla Fox Rage Strike Point Hitcher Rattle Large, 3buc

nac051
Livrare 7-14 zile

33,71Lei

Zarnoitoare Sticla Fox Rage Strike Point Hitcher Rattle Small, 3buc
Exclusiv online!

Zarnoitoare Sticla Fox Rage Strike Point Hitcher Rattle Small, 3buc

nac049
Livrare 7-14 zile

33,71Lei

Kit, Accesorii, Spinning, pentru, Copii, Shakespeare, Cosmic, Tackle, Box, Pink, 1512025, Alte Accesorii Rapitor, Alte Accesorii Rapitor Shakespeare, Alte Shakespeare, Accesorii Shakespeare, Rapitor Shakespeare, Shakespeare
Opritoare, STONFO, 272-1, Full, Stop,, Marime, 1,, 10buc/pac, 8028651027216, Alte Accesorii Monturi Stationar, Alte Accesorii Monturi Stationar Stonfo, Alte Stonfo, Accesorii Stonfo, Monturi Stonfo, Stationar Stonfo, Alte Accesorii Monturi Rapitor, Alte Accesorii Monturi Rapitor Stonfo, Alte Stonfo, Accesorii Stonfo, Monturi Stonfo, Rapitor Stonfo, Stonfo -34%
Zarnoitoare Sticla Fox Rage Strike Point Hitcher Rattle Medium, 3buc
Exclusiv online!

Zarnoitoare Sticla Fox Rage Strike Point Hitcher Rattle Medium, 3buc

nac050
Livrare 7-14 zile

33,71Lei

Kit, Accesorii, Spinning, pentru, Copii, Shakespeare, Cosmic, Tackle, Box, Orange, 1512024, Alte Accesorii Rapitor, Alte Accesorii Rapitor Shakespeare, Alte Shakespeare, Accesorii Shakespeare, Rapitor Shakespeare, Shakespeare
TEU CULISANT PENTRU RAPITOR MARE HORVATH

TEU CULISANT PENTRU RAPITOR MARE HORVATH

79012014
Livrare imediată!

7,00Lei

TEU CULISANT ENERGOTEAM MIC PENTRU RAPITOR

TEU CULISANT ENERGOTEAM MIC PENTRU RAPITOR

79012013
Livrare imediată!

7,00Lei

Dispozitiv Legat Noduri JAXON Knot Tool -23%

Dispozitiv Legat Noduri JAXON Knot Tool

ac-pc075
Livrare imediată!

31,00Lei(-23%) 23,90Lei

Clip DAM Madcat Dead Bait -21%

Clip DAM Madcat Dead Bait

4063156665
Livrare imediată!

12,55Lei(-21%) 9,90Lei

Carabina Rapala RCD Red
Exclusiv online!

Carabina Rapala RCD Red

rcdcr
Livrare 48-72ore

49,00Lei

Counter Preston Offbox Triple Clicker Counter

Counter Preston Offbox Triple Clicker Counter

p0110097
Livrare imediată!

157,46Lei

Counter Berkley Line Counter, Black

Counter Berkley Line Counter, Black

1318371
Livrare imediată!

94,36Lei

Protectie Bucla DAM Loop Thimbles Madcat 10buc/pac
Exclusiv online!

Protectie Bucla DAM Loop Thimbles Madcat 10buc/pac

a.mad.56052
Livrare 24-48 ore

12,01Lei

Indicator de Semnalizare Stonfo din Spuma, Marime 1
Exclusiv online!

Indicator de Semnalizare Stonfo din Spuma, Marime 1

8028651016838
Livrare 48-72 ore

28,00Lei

Cliptroll Stonfo
Exclusiv online!

Cliptroll Stonfo

8028651005375
Livrare 48-72 ore

85,00Lei

Anouri Rotunde Zeck Solid Ring Nr.1 6.5mm 43kg Negru 10buc

Anouri Rotunde Zeck Solid Ring Nr.1 6.5mm 43kg Negru 10buc

41605110043
Livrare imediată!

15,15Lei

Indicator de Semnalizare Stonfo din Spuma, Marime 2
Exclusiv online!

Indicator de Semnalizare Stonfo din Spuma, Marime 2

8028651016845
Livrare 48-72 ore

28,00Lei

Bobinator Nod STONFO Roto
Exclusiv online!

Bobinator Nod STONFO Roto

8028651013875
Livrare 48-72 ore

115,00Lei

Afişare 1 - 20 din 68 (4 pagini)
Queries: 11, Total time: 192.632 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = '9a78fcdf9164ad6630c8d6ba4d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (190.685)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%alte%' AND pd.tag LIKE '%accesorii%' AND pd.tag LIKE '%rapitor%')) 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:698
4 (0.157)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (0.477)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.102)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.201)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1209
8 (0.084)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1231
9 (0.077)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:996
10 (0.591)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:910
11 (0.088)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38