Search Flowers and Gift Baskets

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

Search Results: 37 products returned

  Name Category Price
Bubbles   n Blooms 807 REY607 Bubbles 'n Blooms Arrangements AUD$130.00
Aurora 700 REY700 Aurora Assorted Vases AUD$165.00
Fresh 701 REY701 Fresh Arrangements AUD$175.00
Gondwana Dreaming 702 REY702 Gondwana Dreaming Native Flora AUD$130.00
Tempest 703 REY703 Tempest Assorted Vases AUD$165.00
Salsa 705 REY705 Salsa Arrangements AUD$160.00
Scarlett 707 REY707 Scarlet Arrangements AUD$185.00
Executive 708 REY708 Executive Arrangements AUD$165.00
Calypso 720 REY720 Calypso Arrangements AUD$120.00
Fiesta 721 REY721 Fiesta Arrangements AUD$135.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