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

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


Plumb Energo Team Betisor Tirolez 150g

Plumb Energo Team Betisor Tirolez 150g

52290150
Livrare imediată!

10,00Lei

Aditiv Senzor Extract Squid Octopus 150g -20%

Aditiv Senzor Extract Squid Octopus 150g

snz99607
Livrare imediată!

23,00Lei(-20%) 18,40Lei

LANSETA L&K VERTIC GUIDE 2.10m, 50-150g, 2seg
Exclusiv online!

LANSETA L&K VERTIC GUIDE 2.10m, 50-150g, 2seg

13148211
Livrare 24-48 ore

285,01Lei

Momitor CARP EXPERT Apa Curgatoare Method Feeder Distanta Mare 150g

Momitor CARP EXPERT Apa Curgatoare Method Feeder Distanta Mare 150g

58270750
Livrare imediată!

21,00Lei

Lanseta Okuma LS 6K River Feeder 3.90m 150g 3+2seg

Lanseta Okuma LS 6K River Feeder 3.90m 150g 3+2seg

6k-f-1303xh
Livrare imediată!

503,10Lei

Plumb Korum pentru pasta Bait Gripper Lead 150g -33%

Plumb Korum pentru pasta Bait Gripper Lead 150g

k0310102
Livrare imediată!

19,14Lei(-33%) 12,90Lei

Lanseta ENRGO TEAM SPIN BLADE 80-150G 2.40M ELITE -20%

Lanseta ENRGO TEAM SPIN BLADE 80-150G 2.40M ELITE

13139241
Livrare imediată!

235,00Lei(-20%) 188,00Lei

Lanseta Nevis Red Carp Feeder 3.90M 60-150g
Exclusiv online!

Lanseta Nevis Red Carp Feeder 3.90M 60-150g

1847-390
Livrare 48-72 ore

249,00Lei

Boilies The Purple One pentru carlig solubile 14/18/20mm 150g
Exclusiv online!

Boilies The Purple One pentru carlig solubile 14/18/20mm 150g

98036926
Livrare 24-48 ore

24,00Lei

Lanseta bolognesa Maver IT THOR UNIVERSAL TELE 3.4M, 80-150G, Lift 8 kg, 4seg
Exclusiv online!

Lanseta bolognesa Maver IT THOR UNIVERSAL TELE 3.4M, 80-150G, Lift 8 kg, 4seg

5766002
Livrare 48-72 ore

380,00Lei

Lanseta Trabucco Achab XP Boat 2.10m 150g 2SEG

Lanseta Trabucco Achab XP Boat 2.10m 150g 2SEG

161-13-200
Livrare imediată!

135,01Lei

LANSETA TELESCOPICA TRABUCCO WIZARD RIVER & LAKE 3.50M, 150G, 4SEG

LANSETA TELESCOPICA TRABUCCO WIZARD RIVER & LAKE 3.50M, 150G, 4SEG

163-28-350
Livrare imediată!

125,00Lei

LANSETA TELESCOPICA TRABUCCO WIZARD RIVER & LAKE 3.90M, 150G, 4SEG

LANSETA TELESCOPICA TRABUCCO WIZARD RIVER & LAKE 3.90M, 150G, 4SEG

163-28-390
Livrare imediată!

139,00Lei

Lanseta SPORTEX Rapid Feeder Medium 3.60m, 80-150g, 3+3seg
Exclusiv online!

Lanseta SPORTEX Rapid Feeder Medium 3.60m, 80-150g, 3+3seg

mf3631
Livrare 48-72 ore

960,00Lei

BOILIES Tare Bucovina COMPETITION GOLD 150G

BOILIES Tare Bucovina COMPETITION GOLD 150G

5940000005009b
Stoc epuizat

22,00Lei

Lanseta Feeder Cormoran Sportline 3.30m 50-150g 3+3SEG

Lanseta Feeder Cormoran Sportline 3.30m 50-150g 3+3SEG

c.24.0150335
Livrare imediată!

169,87Lei

BOILIES SOLUBIL Bucovina COMPETITION GOLD 20mm 150G

BOILIES SOLUBIL Bucovina COMPETITION GOLD 20mm 150G

5940000004996b
Livrare imediată!

22,00Lei

Lanseta Okuma Tomcat Vertical 1.83m, 150g, 2seg
Exclusiv online!

Lanseta Okuma Tomcat Vertical 1.83m, 150g, 2seg

tmc-s-601mh
Livrare 48-72ore

368,10Lei

LANSETA TRABUCCO SONIC MASTER BOAT 2.40m, 150g, 3seg

LANSETA TRABUCCO SONIC MASTER BOAT 2.40m, 150g, 3seg

168-21-024
Livrare imediată!

120,00Lei

Plumb Culisant Arrow Hexagon, 150g

Plumb Culisant Arrow Hexagon, 150g

a3.p150
Livrare imediată!

7,58Lei

Afişare 201 - 220 din 430 (22 pagini)
Queries: 6, Total time: 11.555 ms [By time] [By id] [By file]
1 (0.146)
SELECT data
FROM `oc_session`
WHERE session_id = '2f584f4d4efbb66cce1562b0bc'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.130)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (10.733)
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`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (MATCH(pd.tag) AGAINST('+150g' IN BOOLEAN MODE)) 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:737
4 (0.171)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"BUCOVINA BAITS SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.127)
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
6 (0.248)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38