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 - Lansete Carp Spirit

Produse ce potrivesc criteriilor de căutare


Sapca Zeck Flexfit Cap Summer 23, Marime S/M (54-57cm)
Exclusiv online!

Sapca Zeck Flexfit Cap Summer 23, Marime S/M (54-57cm)

81305281575
Livrare 48-72 ore

155,97Lei

Sac Crap Mikado - Basic (120X90Cm)
Exclusiv online!

Sac Crap Mikado - Basic (120X90Cm)

is14-r707
Livrare 48-72 ore

78,00Lei

Saltea Primire Crap - (102X60Cm) Aix-2000B
Exclusiv online!

Saltea Primire Crap - (102X60Cm) Aix-2000B

aix-2000b
Livrare 48-72 ore

92,00Lei

Penar, Mikado, -Pentru, Carlige, Legate, P005, (38X10X, 3.5Cm), UAC-P005, Penare / Portofele, Penare / Portofele Mikado, Penare Mikado, Portofele Mikado, Mikado
Rucsac Bag Pack - Sling Bag (29X20X14Cm)
Exclusiv online!

Rucsac Bag Pack - Sling Bag (29X20X14Cm)

uwi-001
Livrare 48-72 ore

136,01Lei

Saltea Crap Mikado First Mat (127X69 Cm)
Exclusiv online!

Saltea Crap Mikado First Mat (127X69 Cm)

is14-r609
Livrare 48-72 ore

120,00Lei

Saltea Crap Mikado First Mat (87X49 Cm)
Exclusiv online!

Saltea Crap Mikado First Mat (87X49 Cm)

is14-r608
Livrare 48-72 ore

72,00Lei

CUTIE HORVATEH PENTRU TWISERE DELUXE HA-2 (13X21X4 CM)
Exclusiv online!

CUTIE HORVATEH PENTRU TWISERE DELUXE HA-2 (13X21X4 CM)

75101002
Livrare 24-48 ore

23,00Lei

Shad Pontoon21 Awaruna 125 3 inci (7.6cm) 7 buc/plic -26%

Shad Pontoon21 Awaruna 125 3 inci (7.6cm) 7 buc/plic

awaruna30125
Livrare imediată!

20,00Lei(-26%) 14,80Lei

Shad, Pontoon21, Awaruna, 424, 1.5, inci, (3.8cm), 10, buc/plic, 4571115338570, Shad-uri, Shad-uri Pontoon21, Pontoon21
Cleste EnergoTeam Plutitor EVA Universal ET Outdoor (20cm)
Exclusiv online!

Cleste EnergoTeam Plutitor EVA Universal ET Outdoor (20cm)

80899544
Livrare 24-48 ore

34,30Lei

TAVA MATRIX SELF SUPPORTING SIDE TRAYS Large (57 cm x 45 cm)

TAVA MATRIX SELF SUPPORTING SIDE TRAYS Large (57 cm x 45 cm)

gba050
Livrare imediată!

449,96Lei

Shad Pontoon 21 Awaruna 104 3 inci (7.6cm) 7 buc/plic

Shad Pontoon 21 Awaruna 104 3 inci (7.6cm) 7 buc/plic

4571115386724
Livrare imediată!

24,00Lei

Shad Pontoon21 Awaruna 424 2 inci (5.1cm) 9 buc/plic

Shad Pontoon21 Awaruna 424 2 inci (5.1cm) 9 buc/plic

4571115338778
Livrare imediată!

24,00Lei

Shad, Pontoon21, Awaruna, 113, 2, inci, (5cm), 9, buc/plic, 4571115361745, Shad-uri, Shad-uri Pontoon21, Pontoon21
Shad Pontoon21 Awaruna 202 3 inci (7.6cm) 7 buc/plic

Shad Pontoon21 Awaruna 202 3 inci (7.6cm) 7 buc/plic

4571115339003
Livrare imediată!

24,00Lei

GALEATA PENTRU PESTISORI MIKADO UABM-325 (31 x 22 x 22 cm)
Exclusiv online!

GALEATA PENTRU PESTISORI MIKADO UABM-325 (31 x 22 x 22 cm)

uabm-325
Livrare 48-72 ore

88,00Lei

GALEATA PENTRU PESTISORI MIKADO UABM-324 (33 x 23 cm)

GALEATA PENTRU PESTISORI MIKADO UABM-324 (33 x 23 cm)

uabm-324
Livrare imediată!

122,00Lei

Shad, Pontoon21, Awaruna, 424, 4, inci, (10cm), 5, buc/plic, 4571115386472, Shad-uri, Shad-uri Pontoon21, Pontoon21 -27%

Shad, Pontoon21, Awaruna, 424, 4, inci, (10cm), 5, buc/plic, 4571115386472, Shad-uri, Shad-uri Pontoon21, Pontoon21

4571115386472
Livrare imediată!

20,00Lei(-27%) 14,60Lei

Minciog Avid Carp Breach Landing Net 42 inch (107cm) - 180cm -37%

Minciog Avid Carp Breach Landing Net 42 inch (107cm) - 180cm

a0610003
Stoc epuizat

376,34Lei(-37%) 235,30Lei

Afişare 1 - 20 din 99 (5 pagini)
Queries: 13, Total time: 186.381 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '0cf82b80826404129adfda4c72'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.078)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.129)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (183.824)
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 "%cm)%") 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:697
5 (0.123)
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:1547
6 (0.627)
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:181
7 (0.222)
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:1204
8 (0.077)
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:1223
9 (0.074)
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:982
10 (0.911)
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:904
11 (0.069)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.064)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.076)
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