Choose the shelf to display Outdoor bonsai trees > Unique bonsai > Coniferous bonsai > Deciduous bonsai > Flowering and fruiting bonsai > Bonsai masterpieces > Bunjin-ji style > Mini bonsai > Japanese yamadoris bonsaï Young trees Acer seeds and more Bonsai soil and fertiliser > Fertilizer -> organic fertilizer -> chimical fertilizer > Bonsai maintenance > Bonsai soil Bonsai tools > Watering equipment -> Copper watering can -> Watering nozzles > Wire for bonsai -> White aluminium wire -> Brown aluminium wire -> Copper wire > Bonsai tools > Training Tools -> Cutters -> Jin and shari tools -> Pruning scissors -> Folding saw > Potting tools > Bonsai cut paste > Bonsai toolkits Hostas Wind bells and chimes Bonsai pots > Cascade pots > Small Yixing pot > Mini pot > Oval pots > Josef Valuch bonsai pots > Bonsai training pots > Tokoname bonsai pots > Rectangular pots > Oriental round pots > Saucers and trays > Biggest bonsai pot > Square pot > Other types Lanterns, basins and statues > Stone Lantern > Water basins, mizu bachi, tsukub > Mini stone lantern > Natural color stone lantern > buddha and granit statues > Rocks and natural water basins > Granite bridges Saxifrages Kusamono small plants Special offer Oriental figurines > Wooden figure netsuke > Miniature clay Bonsai tables and jita > Japanese crafts > Bonsai stands > Japanese clay teapots > Japanese jita Bamboo fences Maillot Bonsai bookshop > Books > magazine > Second hand book > Japanese exhibitions catalog Bulletins
Roche samba n° 57
› Lanterns, basins and statues
Description
Rock samba imported from Japan. Unique piece, natural with his/her/its veining. Basin used in the confection of the Japanese gardens, chaniwa, gardens of tea or walks. Outside measurements: 700*400 mm. Height: 750 mm.
#samba 3.5 #lanterns 2.8 #statues 2.7 #gardens 2.7 #basins 2.6 #roche 2.5 #measurements 2.2 #confection 2 #imported 1.8 #japanese 1.8
Formule (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'samba', '')))/LENGTH('samba')) +
ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'samba', '')))/LENGTH('samba')) ) * 3.5)
+ (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'gardens', '')))/LENGTH('gardens')) +
ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'gardens', '')))/LENGTH('gardens')) ) * 2.7)
+ (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'roche', '')))/LENGTH('roche')) +
ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'roche', '')))/LENGTH('roche')) ) * 2.5)
+ (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'measurements', '')))/LENGTH('measurements')) +
ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'measurements', '')))/LENGTH('measurements')) ) * 2.2)
+ (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'confection', '')))/LENGTH('confection')) +
ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'confection', '')))/LENGTH('confection')) ) * 2)
+ (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'imported', '')))/LENGTH('imported')) +
ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'imported', '')))/LENGTH('imported')) ) * 1.8)
+ (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'japanese', '')))/LENGTH('japanese')) +
ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'japanese', '')))/LENGTH('japanese')) ) * 1.8)
+ (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'natural', '')))/LENGTH('natural')) +
ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'natural', '')))/LENGTH('natural')) ) * 1.7)
+ (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'veining', '')))/LENGTH('veining')) +
ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'veining', '')))/LENGTH('veining')) ) * 1.7)
+ (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'chaniwa', '')))/LENGTH('chaniwa')) +
ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'chaniwa', '')))/LENGTH('chaniwa')) ) * 1.7)
You may also like
Roche samba N° 56785,00 €
Roche samba N° 59685,00 €
Roche samba N°6-11833545,00 €
Roche samba N° 11-11838520,00 €
Roche samba N° 12-11839640,00 €
Roche samba N° 13-11840285,00 €
Roche samba N° 68-11854880,00 €
Roche samba N°11791565,00 €
Roche tsukubai samba N°192.230,00 €
Roche tsukubai samba 119941.830,00 €
Roche sanba rouge 12088845,00 €
Table and stools in sanba stone from Japan3.800,00 €
Table and stools in sanba stone from Japan2.800,00 €
Bonsai focus magazine 9912,95 €
Stone lantern yama doro 160 cm585,00 €
Stone lantern yama doro 120 cm485,00 €
PINUS PENTAPHYLLA ref: 190902232.650,00 €
PINUS PENTAPHYLLA ref:191202214.360,00 €