Search Flowers and Gift Baskets

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

Search Results: 49 products returned

  Name Category Price
Wine Bottle of Overseas Wine Up Sell Products AUD$99.00
  Phalaenopsis Orchid Plants & Pots AUD$95.00
Rey1210 Rey1210 Julia Arrangements AUD$95.00
Rey126 Rey126 Gwyneth Arrangements AUD$105.00
Tranquillity 709 REY709 Tranquillity Arrangements AUD$110.00
Sassy 713 REY713 Sassy Assorted Vases AUD$105.00
Mixed Box Arrangement REY714 Funky Assorted Boxes AUD$95.00
Moon Shadow 715 REY715 Moon Shadow Assorted Boxes AUD$95.00
Fruit Tingle 718 REY718 Fruit Tingle Fruit Baskets AUD$95.00
Calypso 720 REY720 Calypso Arrangements AUD$120.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