SELECT * FROM b_productesactivats WHERE id>=0 AND familia='GARRO' AND (guardat<>'OCULT') ORDER BY tarifae DESC
Customers access
new user
remind password
your cart
€
find your Macrobonsai ®
Age (years): any age 10 to 100 years 100 to 300 years 300 to 600 years 600 to 1000 years more than 1000 years
Type any type bonsais olive tree pompon straight olive tree pompon oval olive tree Macrobonsai® selection olive tree Macrobonsai® straight olive tree Macrobonsai® oval olive tree tables palmáceas plantas ejemplares
Price (€): any price 0 € to 1000 € 1.000 € to 3000 € 3.000 € to 5000 € 5.000 € to 8000 € 8.000 € to 10000 € 10.000 € to 20000 € 20.000 € to 30000 € more than 30000 €
Order by low to high age: low to high age: high to low caliber: low to high caliber: high to low price: low to high price: high to low
PRODUCTS
====SELECT * FROM g_categoriesopcions
REF: 0404105
Tree number: 35-040
Variety: GARROFER
Plant height: 300 cm
REF: 0404546
Tree number: 35-036
Plant height: 310 cm
REF: 00525098
Tree number: 35-042
Plant height: 350 cm
Iberplant Jardineria i Vivers SL - Macrobonsai ® - contact - Legal warning - Terms of sale - Cookies policy