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

Produse ce potrivesc criteriilor de căutare


Foarfeca Pentru Fire Carp Expert 127mm

Foarfeca Pentru Fire Carp Expert 127mm

79591567
Livrare imediată!

7,00Lei

Carp Zoom BOILIE WAFTERS MAGNET-X 15mm 50gr Pineapple-NBC
Exclusiv online!

Carp Zoom BOILIE WAFTERS MAGNET-X 15mm 50gr Pineapple-NBC

cz4778
Livrare 48-72 ore

22,00Lei

Saltea de Primire Fox Deluxe Carpmaster Mat, XL
Exclusiv online!

Saltea de Primire Fox Deluxe Carpmaster Mat, XL

ccc051
Livrare 7-14 zile

832,46Lei

PICHET ANTICOROZIV CARP ACADEMY 60-90CM

PICHET ANTICOROZIV CARP ACADEMY 60-90CM

6228-090
Livrare imediată!

55,00Lei

Lanseta Cormoran Pro Carp XR 3.60m 3lbs 2Seg

Lanseta Cormoran Pro Carp XR 3.60m 3lbs 2Seg

c.20.0630360
Livrare imediată!

171,51Lei

Carp Zoom PELETE SOFT 12mm 30gr Spice

Carp Zoom PELETE SOFT 12mm 30gr Spice

cz3900
Livrare imediată!

12,50Lei

Coada Minciog Mufabila CXP Method Feeder 300 3m
Exclusiv online!

Coada Minciog Mufabila CXP Method Feeder 300 3m

71731300
Livrare 24-48 ore

71,00Lei

Montura Plumb Pierdut Carp Zoom 75cm 3buc/plic

Montura Plumb Pierdut Carp Zoom 75cm 3buc/plic

cz9637
Livrare imediată!

21,00Lei

FIR, TRABUCCO, T, FORCE, CARP, ENDURO, 600M, 0.350, MM, 15.80, Kg, 053-12-350, Fire Monofilament Crap, Fire Monofilament Crap Trabucco, Trabucco
CAP MINCIOG MATRIX CARP LANDING NETS 45x35 cm

CAP MINCIOG MATRIX CARP LANDING NETS 45x35 cm

gln064
Livrare imediată!

65,21Lei

CAP MINCIOG EXTRA CARP PLUS CONECTOR V DIN INOX 105 X 105 X 100 CM

CAP MINCIOG EXTRA CARP PLUS CONECTOR V DIN INOX 105 X 105 X 100 CM

ec0289-42
Livrare imediată!

80,00Lei

Opritoare Carp Spirit Rig Ring Stop 10buc/plic Kaki

Opritoare Carp Spirit Rig Ring Stop 10buc/plic Kaki

acs010177
Livrare imediată!

10,00Lei

CAP MINCIOG KAMASAKI CAUCIUCAT BIG CARP 55x50x40

CAP MINCIOG KAMASAKI CAUCIUCAT BIG CARP 55x50x40

71024350
Livrare imediată!

58,00Lei

Carp Zoom NADA WET METHOD FEEDER 850gr Chocolate Orange
Exclusiv online!

Carp Zoom NADA WET METHOD FEEDER 850gr Chocolate Orange

cz5201
Livrare 48-72 ore

27,00Lei

Lanseta Nevis Primus Carp Feeder 3.90m 120gr 3+3SEG

Lanseta Nevis Primus Carp Feeder 3.90m 120gr 3+3SEG

1480-390
Livrare imediată!

251,99Lei

Geanta Transport Buzzbar Carp Academy

Geanta Transport Buzzbar Carp Academy

5292-001
Livrare imediată!

58,00Lei

Carp Zoom VARGA ENTRANT MULTI POLE 4.0m

Carp Zoom VARGA ENTRANT MULTI POLE 4.0m

cz2859
Livrare imediată!

43,99Lei

Husa Pentru Suporti Delphin Area STICK Carpath -27%

Husa Pentru Suporti Delphin Area STICK Carpath

101000355
Livrare imediată!

79,00Lei(-27%) 58,00Lei

Carp Zoom VARGA ENTRANT MULTI POLE 5.0m

Carp Zoom VARGA ENTRANT MULTI POLE 5.0m

cz2866
Livrare imediată!

63,00Lei

Geanta pentru accesorii Delphin Area TACKLE Carpath

Geanta pentru accesorii Delphin Area TACKLE Carpath

101000571
Livrare imediată!

107,40Lei

Afişare 81 - 100 din 7470 (374 pagini)
Queries: 9, Total time: 531.300 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = '15029866610dbb4e66f89035c1'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.087)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.105)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (530.413)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%carp%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 80, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.198)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%carp%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1005
7 (0.115)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.102)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.113)
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