Wedding Flowers & Flowers Near Me

Wholesale Flowers for Floral Designers
Rush Order
Wholesale Flowers for Floral Designers
*The colors in the photos may not reflect exact color of flowers received due to lighting differences when photos were taken
Free shipping within the continental US Free Fedex ShippingFree UPS Shipping

Green with Yellow Cast Spray Rose

4.5 out of 5 with 2 ratings
Green with Yellow Cast Spray Rose is a green variety with a yellow cast giving the appearance of light yellowish-green petals. Each stem bears 3-5 mini roses that open into ravishing blooms, adding a brilliant look to wedding centerpieces, cakes, hair combs, or any floral arrangement requiring smaller blooms.
1. Choose Stem Quantity:
Price per stem
10 Stems
( $5.00 per stem )
20 Stems
( $4.65 per stem )
60 Stems
( $2.60 per stem )
100 Stems
( $1.90 per stem )
1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ksanchez_wholeblo2.pov.products_options_values_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[SELECT attributes_image, products_options_values_name FROM products_attributes pa LEFT JOIN products_options_values pov ON ( pa.options_values_id = pov.products_options_values_id ) WHERE products_id = '277' AND attributes_image != '' GROUP BY attributes_image ORDER BY products_options_sort_order]