turmalín # 14248 z lokality Pomba pit, Serra das Éguas, Brumado, Bahia, Brazílie

dravit, turmalín

dravit, turmalín


Vystaveno 30.8.2019

Cena: 950 Kč, cca 37€
včetně dph 21%
dravit
turmalín

Šířka1.8 cm 0.7 ″
Výška2.2 cm 0.9 ″
Hloubka1.5 cm 0.6 ″
Hmotnost12 g 0.43 oz
 
Lokalita

Pomba pit
Serra das Éguas, Brumado, Bahia

Stát

Brazílie


Drobný, oboustranně zakončený a matně lesklý krystal výrazně hnědého dravitu z naleziště Pomba pit. Lokalita se nachází v horách blízko města Brunado v brazilském státu Bahia.

dravit, turmalín, #14248:950


Objednáváte konkrétní vyfotografovaný kus. Při objednání obdržíte přesně to, co vidíte na obrázku. Vzorek si můžete osobně prohlédnout v naší prodejní galerii.




dravit, turmalín
Pomba pit, Brazílie
950 Kč, cca 37€
1,8 x 2,2 x 1,5 cm
Vystaveno 30.8.2019
Podle zákona o evidenci tržeb je prodávající povinen vystavit kupujícímu účtenku. Zároveň je povinen zaevidovat přijatou tržbu u správce daně online; v případě technického výpadku pak nejpozději do 48 hodin. ::: GDPR - Informace o zpracování osobních údajů
© 2005 - 2019 NEROSTY.CZ

hledám turmalín

SQL: SELECT *, 'zbozi_nerosty_rs_v_3' AS tabule FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='turmalín')OR(nazev1_cz='turmalín')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT *, 'zbozi_rockshop_rs_v_3' AS tabule FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='turmalín')OR(nazev1_cz='turmalín')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT *, 'zbozi_levne_rs_v_3' AS tabule FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='turmalín')OR(nazev1_cz='turmalín')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT *, 'zbozi_balkan_rs_v_3' AS tabule FROM zbozi_balkan_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='turmalín')OR(nazev1_cz='turmalín')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT *, 'zbozi_turmaliny_rs_v_3' AS tabule FROM zbozi_turmaliny_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='turmalín')OR(nazev1_cz='turmalín')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) ORDER BY id DESC

Počet vzorků: 1

skládám menu

SQL: SELECT DISTINCT nazev_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev1_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev1_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev1_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_balkan_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev1_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_balkan_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_balkan_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_turmaliny_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev1_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_balkan_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_turmaliny_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 )

Počet druhů: 7

Omezení dostupnosti: ((status='skladem') OR (status='rezervovano'))

Omezení oddělením:

Omezení státy:

Omezení jinak: AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1566109920 ) AND (pridano1 <= 1571293920 )