Flowers Near Me

Rush Order
  Click to View All Filters

Asiatic Lilies Wholesale

Asiatic Lilies and LA Hybrid have fresh stems, blade-like leaves, and trumpet-shaped flowers. They have a smooth surface and no fragrance. Most of them come with 3-5 blooms. However, there are some varieties that include more than 5 blooms per stem. They come in vibrant, solid and bicolor shades that will enhance your floral centerpieces and wedding bouquets. Vase Life: 7-14 days, depending on care and handling Availability: Available year round Length: approx 24 to 28 inches Packing: Whole Blossoms Asiatic lilies are packed in bunches of 10 stems.

1055 Expression #92 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ksanchez_wholeblo2.pd.language_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[select * from products as p LEFT JOIN products_to_categories as p2c ON p.products_id=p2c.products_id LEFT JOIN categories c ON c.categories_id=p2c.categories_id LEFT JOIN products_description pd ON pd.products_id=p.products_id WHERE p2c.categories_id='179' AND p.products_status=1 AND p.products_stock=1 GROUP BY p2c.products_id ORDER BY p2c.order_id LIMIT 0,27]