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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


AVERTIZOR CARP SPIRIT XTE
Exclusiv online!

AVERTIZOR CARP SPIRIT XTE

acs490021
Livrare 48-72 ore

153,42Lei

AVERTIZOR CARP SPIRIT XSE
Exclusiv online!

AVERTIZOR CARP SPIRIT XSE

acs490028
Livrare 48-72 ore

122,92Lei

Hanger Carp Spirit, 12g, Albastru
Exclusiv online!

Hanger Carp Spirit, 12g, Albastru

acs490082
Livrare 48-72 ore

51,74Lei

SNAG EARS CARP SPIRIT ILUMINATED YELLOW
Exclusiv online!

SNAG EARS CARP SPIRIT ILUMINATED YELLOW

acs490026
Livrare 48-72 ore

80,21Lei

Averizor Carp Spirit BLAX -7%
Exclusiv online!

Averizor Carp Spirit BLAX

acs490077
Livrare 48-72 ore

99,00Lei(-7%) 92,41Lei

AVERTIZOR ELECTRONIC CARP SPIRIT HD2
Exclusiv online!

AVERTIZOR ELECTRONIC CARP SPIRIT HD2

acs490075
Livrare 48-72 ore

122,92Lei

Hanger Carp Spirit, 12g, Verde
Exclusiv online!

Hanger Carp Spirit, 12g, Verde

acs490084
Livrare 48-72 ore

51,74Lei

Hanger Carp Spirit, 12g, Rosu
Exclusiv online!

Hanger Carp Spirit, 12g, Rosu

acs490083
Livrare 48-72 ore

51,74Lei

Hanger Carp Spirit, 12g, Galben
Exclusiv online!

Hanger Carp Spirit, 12g, Galben

acs490085
Livrare 48-72 ore

51,74Lei

Vartej Carp Spirit Swivel, Nr.8, 10buc/plic
Exclusiv online!

Vartej Carp Spirit Swivel, Nr.8, 10buc/plic

acs290023
Livrare 48-72 ore

11,07Lei

Swinger Carp Spirit Rigid, 12g, Albastru
Exclusiv online!

Swinger Carp Spirit Rigid, 12g, Albastru

acs490086
Livrare 48-72 ore

72,07Lei

Varteje cu Anou Carp Spirit Flexi Ring Fast Snap
Exclusiv online!

Varteje cu Anou Carp Spirit Flexi Ring Fast Snap

acs290012
Livrare 48-72 ore

14,12Lei

Hanger Avid Revolve Bobbin Kit, Green
Exclusiv online!

Hanger Avid Revolve Bobbin Kit, Green

a0490022
Livrare 7-14 zile

60,44Lei

Vartej cu Agrafa Rapida Carp Spirit Nr.11, 10buc/plic

Vartej cu Agrafa Rapida Carp Spirit Nr.11, 10buc/plic

acs290021
Livrare imediată!

21,34Lei

Vartej Cu Anou Carp Spirit Mat, Nr.20, 10buc/plic
Exclusiv online!

Vartej Cu Anou Carp Spirit Mat, Nr.20, 10buc/plic

acs290024
Livrare 48-72 ore

20,22Lei

Vartej Rapid Cu Siguranta Carp Spirit Teflonat Nr 8 (5 buc)

Vartej Rapid Cu Siguranta Carp Spirit Teflonat Nr 8 (5 buc)

acs290002
Livrare imediată!

28,35Lei

Vartej Carp Spirit Cork Screw Swivel cu Prindere pentru PVA 10buc/plic

Vartej Carp Spirit Cork Screw Swivel cu Prindere pentru PVA 10buc/plic

acs290020
Livrare imediată!

29,37Lei

SET AVERTIZOARE CARP SPIRIT BLAX VX-R + STATIE 4+1
Exclusiv online!

SET AVERTIZOARE CARP SPIRIT BLAX VX-R + STATIE 4+1

acs490079
Livrare 48-72 ore

630,40Lei

Vartej Carp Spirit Cu Anou Si Agrafa Rapida Spinner Ring Swivel Ronnie, 10buc/plic
Exclusiv online!

Vartej Carp Spirit Cu Anou Si Agrafa Rapida Spinner Ring Swivel Ronnie, 10buc/plic

acs290025
Livrare 48-72 ore

26,32Lei

Minciog Carp Spirit Blax X-Net 42" 105cm 1.82m -27%
Exclusiv online!

Minciog Carp Spirit Blax X-Net 42" 105cm 1.82m

acs490078
Livrare 48-72 ore

249,01Lei(-27%) 181,89Lei

Afişare 1 - 20 din 26 (2 pagini)
Queries: 11, Total time: 1.821 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = 'fae1466bdc3f1c5674320fd1c9'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.172)
CREATE TEMPORARY TABLE oc_bf_tmp_product ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:837
4 (0.180)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("33831", "2", "1000", "204", "1", "126.790000000000", "1"),("33834", "2", "1000", "204", "1", "101.590000000000", "2"),("215071", "1", "1000", "204", "1", "42.760000000000", "3"),("33841", "2", "1000", "204", "1", "66.290000000000", "4"),("170527", "2", "1000", "204", "1", "76.370000000000", "5"),("153993", "2", "1000", "204", "1", "101.590000000000", "6"),("215041", "1", "1000", "204", "1", "42.760000000000", "7"),("215045", "1", "1000", "204", "1", "42.760000000000", "8"),("215069", "1", "1000", "204", "1", "42.760000000000", "9"),("215131", "2", "1000", "204", "1", "9.150000000000", "10"),("215039", "2", "1000", "204", "1", "59.560000000000", "11"),("37498", "2", "1000", "204", "1", "11.670000000000", "12"),("230210", "2", "1000", "353", "1", "49.950000000000", "13"),("125065", "1", "1009", "204", "1", "17.640000000000", "14"),("215129", "1", "1000", "204", "1", "16.710000000000", "15"),("12395", "2", "1007", "204", "1", "23.430000000000", "16"),("102176", "2", "1004", "204", "1", "24.270000000000", "17"),("153995", "2", "1000", "204", "1", "520.990000000000", "18"),("215125", "2", "1000", "204", "1", "21.750000000000", "19"),("170844", "2", "1000", "204", "1", "150.320000000000", "20"),("130735", "1", "0", "204", "1", "504.940000000000", "21"),("215033", "2", "0", "204", "1", "59.560000000000", "22"),("215035", "2", "0", "204", "1", "59.560000000000", "23"),("215037", "2", "0", "204", "1", "59.560000000000", "24"),("153991", "2", "0", "204", "1", "804.000000000000", "25"),("215555", "2", "0", "204", "1", "504.940000000000", "26")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.155)
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:1593
6 (0.231)
SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.199)
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:1393
8 (0.115)
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:1415
9 (0.101)
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:1180
10 (0.373)
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:1094
11 (0.112)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37