Search Flowers and Gift Baskets

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

Search Results: 9 products returned

  Name Category Price
Wine Bottle of Australian Wine Up Sell Products AUD$35.00
Chocolates Box of Chocolates Up Sell Products AUD$17.00
Bridal Roses Bouquet Bridal Bouquet - Roses Assorted Bouquets N/a
Bridesmaid Roses Bouquet Bridesmaid Bouquet - Roses Assorted Bouquets N/a
Balloons Helium Foil Balloon Up Sell Products AUD$14.00
Affection REY735 Affection Roses AUD$60.00
Flirt REY739 Flirt Roses AUD$52.00
First Kiss REY741 First Kiss Roses AUD$49.00
Bear Teddy Bear Up Sell Products AUD$15.50

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