Flowers Near Me

Rush Order
  Click to View All Filters

LA Hybrid Lilies

LA Hybrid Lilies represent a cross breed between Easter lilies and Asiatic lilies. Recently, they have increased in popularity in contrast to Asiatic hybrids. They are known to have larger flowers which are more clustered at the top of the stem and more upward facing than Oriental varieties. They have been favored as wedding flowers and have fleshly stems, blade-like leaves, and trumpet shaped flowers. They also contain smooth petal surfaces and no fragrance. Most varieties come with 3-5 blooms. However, a few varieties can include more than 5 blooms per stem. They come in vibrant solid and bicolor shades that are perfect for enhancing wedding floral arrangements and wedding bouquets.

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='192' AND p.products_status=1 AND p.products_stock=1 GROUP BY p2c.products_id ORDER BY p2c.order_id LIMIT 0,27]