Search Flowers and Gift Baskets

SELECT count(accTblInventory.InventoryID) as num from accTblInventory WHERE IF(accTblInventory.SpecialPrice > 0, accTblInventory.SpecialPrice, accTblInventory.SalePrice) >= 60 AND IF(accTblInventory.SpecialPrice > 0, accTblInventory.SpecialPrice, accTblInventory.SalePrice) <= 90 AND accTblInventory.Shop=1 AND accTblInventory.Active=1 AND accTblInventory.WebsitesID=1

Search Results: 34 products returned

  Name Category Price
Cyclamen Cyclamen Plants & Pots AUD$65.00
Rey121 Rey121 Emma Arrangements AUD$65.00
1 Rey123 Sally Arrangements AUD$65.00
Rey125 Rey125 Halle Arrangements AUD$75.00
Bouquet of Mixed Blooms Including Vase REY128 Cate Assorted Vases AUD$85.00
Rey129 Rey129 Charlize Arrangements AUD$70.00
Bijoux 712 REY712 Bijoux Arrangements AUD$80.00
Harlequin 719 REY719 Harlequin Assorted Boxes AUD$85.00
Bella 722 REY722 Bella Arrangements AUD$80.00
Pink Perfection 723 REY723 Pink Perfection Assorted Bouquets AUD$90.00

Search Again

Category:
Product Name:
Min. Price:
Max. Price:

Quick Links

Site Map
Log In
Terms
Privacy

Reynolds Florist © 2017
CONTACT US
Shop 28,
Edgecliff Centre,
203 New South Head Road,
EDGECLIFF, SYDNEY, 2027
Phone: (02) 9363 1297