GiftTree USA - Gifts, Homeware, Lifestyle and More
Search GiftTree USA

Eriosyce esmeraldana

Gift Tree

$9.99 USD
Size:
Eriosyce esmeraldana is a rare and visually striking cactus species that stands out for its distinctive spines and vibrant blooms. Native to the deserts of Chile, this unique cactus is highly sought after by collectors and succulent enthusiasts for its unusual appearance and easy-care nature, making it an exceptional addition to any indoor or outdoor garden.

Eriosyce esmeraldana is a tiny geophytic , spineless (or spiny) plant usually solitary or sometime branching.

The product may be provided by a different brand of comparable quality.
The actual product may vary slightly from the image shown.

Read all Disclaimer...

Available in New Zealand at GiftTree NZ, in Australia at GiftTree AU,  in Canada at Gift Tree CA, and in the United Kingdom  at Gift Tree UK!

Shop amazing plants at The Node – a top destination for plant lovers
Ask a Question Ask a Question

You might also like

Exception: Unknown column 'product_language' in 'where clause'
Database Query Error (1054)

Debug Info:
- Query: 'SELECT * FROM commerce_products WHERE (((`product_id` IN (553, 1430, 1474, 1522, 1524, 1526, 1534, 1535, 1542, 1836, 2165, 2220, 2221, 2391, 2392, 2393, 2423, 2445, 2848, 6956, 6957, 6959, 6961, 6964, 6990, 6991, 6993, 6996, 7001, 7017, 553, 1418, 1472, 1473, 1477, 1478, 1481, 1484, 1486, 1491, 1505, 1514, 1515, 1518, 1519, 1521, 1534, 1535, 1537, 1539, 1541, 1542, 1560, 1563, 1564, 1595, 1602, 1603, 1605, 1606, 1607, 1619, 1623, 1645, 1646, 1647, 1650, 1651, 1671, 1836, 1966, 2056, 2057, 2058, 2059, 2081, 2097, 2165, 2220, 2221, 2392, 2423, 2445, 2651, 2848, 2851, 2852, 2853, 2854, 2855, 2857, 2957, 2958, 2959, 2960, 2991, 2992, 3094, 3095, 3096, 3097, 3098, 3171, 3172, 3302, 3303, 3334, 3335, 3368, 3408, 4152, 4168, 4189, 4194, 4362, 4364, 4513, 4519, 4522, 4529, 4649, 4651, 4770, 4771, 4784, 4986, 4987, 4989, 4990, 5402, 5406, 5503, 6216, 6577, 6818, 6957, 6959, 6960, 6961, 6963, 6964, 6989, 553, 1418, 1473, 1477, 1478, 1481, 1484, 1486, 1491, 1505, 1514, 1515, 1518, 1519, 1521, 1522, 1534, 1535, 1537, 1539, 1541, 1542, 1560, 1562, 1563, 1564, 1595, 1603, 1650, 1651, 1836, 1916, 1966, 2056, 2057, 2058, 2059, 2081, 2097, 2165, 2220, 2221, 2392, 2423, 2445, 2651, 2730, 2741, 2742, 2743, 2848, 2851, 2852, 2853, 2854, 2855, 2857, 2956, 2958, 2959, 2960, 2991, 2992, 3061, 3094, 3095, 3096, 3098, 3138, 3172, 3302, 3334, 3335, 3368, 4195, 4196, 4313, 4314, 4359, 4360, 4361, 4362, 4364, 4512, 4513, 4516, 4519, 4522, 4524, 4529, 4649, 4651, 4652, 4771, 4783, 4784, 4987, 4989, 4990, 4991, 5299, 5300, 5301, 5302, 6216, 6576, 6577, 6579, 6580, 6582, 6583, 6585, 6587, 6594, 6599, 6614, 6638, 6660, 6662, 6663, 6818, 6823, 6824, 6825, 6956, 6957, 6959, 6960, 6961, 6963, 6964, 6993, 6998, 7001, 7004, 7014, 7016, 7017, 7021, 7022, 7039, 7084, 7176, 7235, 7236, 7286, 7293, 1478, 1537, 1560, 1595, 1603, 1605, 1671, 2392, 2393, 2423, 2445, 2644, 2651, 3094, 3096, 3098, 3177, 3335, 4314, 5395, 5407, 6216, 6575, 6579, 6580, 6616, 6638, 6639, 6956, 6957, 6958, 6960, 6961, 6962, 7016, 7017, 7180, 1478, 1537, 1560, 1565, 1603, 2644, 3177, 5395, 1478, 1537, 1560, 1595, 1603, 1605, 2651, 5395, 1537, 1560, 1595, 1606, 1607, 1649, 1916, 2423, 2848, 3097, 3303, 4170, 6216, 6244, 6249, 6250, 6286, 6359, 6360, 6365, 6366, 6587, 6607, 6608, 6660, 6663, 6769, 6771, 6805, 6819, 6820, 6821, 6949, 6956, 6957, 6961, 6963, 6964, 6994, 6998, 7004, 7019, 7022, 7039, 7083, 7085, 7179, 7182, 7235, 7238, 7285, 7289, 7292, 7293, 7348, 7349, 7456, 7458, 7538, 7539, 7540, 7541, 7543, 7544, 7545, 7818, 7884, 7887, 7888, 7892, 7893, 7910, 7911, 7913, 7935, 7937, 7942, 7954, 8085, 8086, 8087, 8089, 8091, 8092, 8093, 8094, 8095, 8140, 8144, 8154, 8203, 8205, 8206, 8297, 8345, 8348, 8353, 8355, 8356, 8470, 8497, 10133, 10455, 10456, 1478, 1537, 1565, 1595, 1606, 1645, 1916, 2423, 2559, 2848, 3095, 3096, 3303, 3335, 4170, 6225, 6243, 6244, 6245, 6246, 6248, 6249, 6250, 6355, 6356, 6357, 6359, 6362, 6363, 6366, 6387, 6388, 6390, 6391, 6575, 6576, 6579, 6580, 6582, 6583, 6587, 6592, 6594, 6599, 6602, 6607, 6608, 6610, 6613, 6614, 6616, 6618, 6619, 6637, 6638, 6660, 6661, 6663, 6665, 6666, 6763, 6764, 6765, 6767, 6769, 6771, 6773, 6774, 6802, 6805, 6817, 6818, 6819, 6820, 6821, 6823, 6824, 6825, 6828, 6882, 6949, 6950, 6951, 6952, 6953, 6954, 6955, 6956, 6957, 6958, 6959, 6960, 6961, 6962, 6963, 6964, 6989, 6990, 6991, 6992, 6993, 6994, 6996, 6998, 7001, 7002, 7004, 7012, 7013, 7014, 7015, 7016, 7017, 7021, 7022, 7039, 7044, 7083, 7084, 7085, 7136, 7173, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7184, 7186, 7187, 7238, 7239, 7243, 7285, 7293, 7348, 7349, 7456, 7458, 7539, 7540, 7543, 7545, 7546, 7884, 7886, 7888, 7891, 7892, 7894, 7895, 7896, 7897, 7900, 7901, 7909, 7910, 7911, 7913, 7918, 7921, 7930, 7935, 7938, 7939, 7940, 7942, 7945, 7954, 8015, 8016, 8017, 8085, 8086, 8087, 8089, 8091, 8092, 8093, 8094, 8095, 8140, 8144, 8147, 8154, 8203, 8205, 8206, 8345, 8348, 8353, 8355, 8356, 8470, 8477, 8497, 8498, 8499, 10133, 10455, 10456, 35044, 1560, 2814, 2815, 2817, 2853, 3368, 5302, 6211, 6224, 6246, 6248, 6250, 6286, 6327, 6328, 6329, 6332, 6343, 6355, 6356, 6357, 6359, 6360, 6361, 6362, 6363, 6364, 6365, 6366, 6368, 6387, 6388, 6389, 6390, 6391, 6392, 6393, 6575, 6576, 6577, 6579, 6580, 6582, 6583, 6585, 6587, 6592, 6594, 6599, 6601, 6602, 6607, 6608, 6610, 6613, 6614, 6616, 6618, 6619, 6636, 6637, 6638, 6639, 6660, 6661, 6662, 6663, 6665, 6666, 6716, 6717, 6718, 6757, 6762, 6763, 6764, 6765, 6767, 6769, 6771, 6773, 6774, 6802, 6805, 6817, 6818, 6819, 6820, 6821, 6823, 6824, 6825, 6828, 6851, 6881, 6882, 6949, 6950, 6951, 6952, 6953, 6954, 6955, 6957, 6958, 6959, 6960, 6961, 6962, 6963, 6964, 6989, 6990, 6991, 6992, 6993, 6994, 6996, 6998, 7001, 7002, 7004, 7012, 7013, 7014, 7015, 7016, 7017, 7019, 7021, 7022, 7039, 7044, 7083, 7085, 7136, 7137, 7138, 7173, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7182, 7184, 7355, 7437, 7440, 7442, 7444, 7526, 7527, 7529, 7582, 7583, 7742, 7745, 7825, 7844, 7848, 7947, 7948, 7949, 7984, 7985, 7997, 10455, 31101, 31103, 41389, 6224, 6245, 6250, 6956, 6957, 6958, 6959, 6960, 6961, 6962, 6963, 6964, 6989, 6990, 6991, 6992, 6993, 6996, 7001, 7013, 7014, 7015, 7016, 7017, 7019, 7022, 7039, 7044, 7083, 7179, 7455, 7457, 7540, 7544, 7630, 7632, 7773, 7775, 7791, 7799, 7811, 7814, 7885, 7887, 7889, 7900, 7903, 7904, 7909, 7930, 7935, 7937, 7938, 7939, 7940, 7942, 7944, 7945, 7954, 8459, 8463, 8470, 8477, 25380) AND (`product_language` IS NULL AND `product_id` != 6961)) AND `product_is_offline` = \'0\') AND `product_deleted_datetime` IS NULL) ORDER BY `product_order` asc, `product_price_base` desc, `product_title` asc LIMIT 0, 8'
in Page /products/ line 2
in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 993