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

Produse ce potrivesc criteriilor de căutare


SPINNERTAIL, RAPTURE, CHIBI, ASP, SPIN, N, JIG, 14GR, GHOST, 180-21-004, Spinnertails, Spinnertails Rapture, Spinnertails Rapture, Rapture -10%
LANSETA SPRO CRX ASP ZANDER 2.85 M 5-40 GR 2 BUC -23%

LANSETA SPRO CRX ASP ZANDER 2.85 M 5-40 GR 2 BUC

002411-00185-00000
Livrare imediată!

415,00Lei(-23%) 319,90Lei

Starleti Night Wasp Bulb 4.5mm

Starleti Night Wasp Bulb 4.5mm

80000745
Livrare imediată!

2,50Lei

Kit plasa solubila PVA Spro Meshsystem Hydraspool Wide 35mm/7m

Kit plasa solubila PVA Spro Meshsystem Hydraspool Wide 35mm/7m

2pva01pms736
Livrare imediată!

42,00Lei

Starleti Feeder Night Wasp SS 2buc/plic

Starleti Feeder Night Wasp SS 2buc/plic

80000605
Livrare imediată!

4,00Lei

Starleti Night Wasp Energo Team 2buc/plic 4.5mm

Starleti Night Wasp Energo Team 2buc/plic 4.5mm

80001045
Livrare imediată!

2,00Lei

Kit plasa solubila PVA Spro Meshsystem Hydraspool Wide 25mm/7m

Kit plasa solubila PVA Spro Meshsystem Hydraspool Wide 25mm/7m

2pva01pms725
Livrare imediată!

37,50Lei

VOBLER, CARP, ZOOM, PREDATOR-Z, ASP, MINNOW, 9.0cm, 5.8gr, FLOATING, 1006, cz1006, Voblere Floating, Voblere Floating Carp Zoom, Carp Zoom -24%
VOBLER, CARP, ZOOM, PREDATOR, -Z, ASP, SHAD, 10cm, 11.0gr, FLOATING, 0856, cz0856, Voblere Floating, Voblere Floating Carp Zoom, Carp Zoom -24%
Spinnertail EnergoTeam Wizard ASP Verde Tiger, 10g, 4.5cm, Nr.8

Spinnertail EnergoTeam Wizard ASP Verde Tiger, 10g, 4.5cm, Nr.8

87300102
Livrare imediată!

8,00Lei

VOBLER, CARP, ZOOM, PREDATOR, -Z, ASP, SHAD, 10cm, 11.0gr, FLOATING, 0832, cz0832, Voblere Floating, Voblere Floating Carp Zoom, Carp Zoom -24%
VOBLER, CARP, ZOOM, PREDATOR-Z, ASP, MINNOW, 9.0cm, 5.8gr, FLOATING, 1013, cz1013, Voblere Floating, Voblere Floating Carp Zoom, Carp Zoom -20%
VOBLER, CARP, ZOOM, PREDATOR-Z, ASP, MINNOW, 9.0cm, 5.8gr, FLOATING, 1037, cz1037, Voblere Floating, Voblere Floating Carp Zoom, Carp Zoom -24%
VOBLER, CARP, ZOOM, PREDATOR, -Z, ASP, SHAD, 10cm, 11.0gr, FLOATING, 0849, cz0849, Voblere Floating, Voblere Floating Carp Zoom, Carp Zoom -24%
Varga Colmic Spenk Super Strong 5.00m
Exclusiv online!

Varga Colmic Spenk Super Strong 5.00m

casp10b
Livrare 48-72 ore

449,00Lei

Spinnertail, EnergoTeam, Wizard, ASP, Albastru,, 18g,, 5.5cm,, Nr.8, 87300183, Spinnertails, Spinnertails EnergoTeam, EnergoTeam
Spinnertail, EnergoTeam, Wizard, ASP, Verde, Tiger,, 18g,, 5.5cm,, Nr.8, 87300182, Spinnertails, Spinnertails EnergoTeam, EnergoTeam
SPINNERTAIL, RAPTURE, CHIBI, ASP, SPIN, N, JIG, 14GR, SILVER, 180-21-001, Spinnertails, Spinnertails Rapture, Spinnertails Rapture, Rapture
SPINNER SPRO ASP UV 28G Metal Perch
Exclusiv online!

SPINNER SPRO ASP UV 28G Metal Perch

004341-00950-00000
Livrare 48-72 ore

48,69Lei

Spinnertail EnergoTeam Wizard ASP Alb Rosu, 10g, 4.5cm, Nr.8

Spinnertail EnergoTeam Wizard ASP Alb Rosu, 10g, 4.5cm, Nr.8

87300101
Livrare imediată!

8,00Lei

Afişare 41 - 60 din 95 (5 pagini)
Queries: 11, Total time: 277.499 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = '7e7fc80287d193c8a8f25cce62'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.150)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (274.516)
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 "%asp%") 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
5 (0.097)
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
6 (0.591)
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 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.311)
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.134)
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.119)
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 (1.232)
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.138)
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