Kelkay Mysterious Moon Easy Fountain Water Feature
Product Code : 44023
100% from 1 reviews
Mega Sale Event, Now On!
Brief Description
The Mysterious Moon water feature has been uniquely designed to look and feel like it has been crafted out of weathered stone. The simple design allows the water to cascade down the textured sphere into the bowl below. This stunning piece of stone effect art would be a fantastic addition to any garden.
One year warranty included.
Delivery Options - Available at Checkout
Estimated delivery
Free Delivery2-3 Working Days
Free Delivery2-3 Working Days
Product Description
- Self-contained fountain with recirculating pump included.
- Plug & Play - no electrical or water plumbing required.
- Durable construction with a high-end look of stone effect
- Easy to setup and low maintenance: no peeling or tarnishing.
- This fountain includes a low voltage LED light.
- This product is hand finished and hand crafted therefore variations will occur.
- All fittings and instructions are included with each fountain.
- Size: H770mm x Dua710mm
The Mysterious Moon water feature has been uniquely designed to look and feel like it has been crafted out of weathered stone. The simple design allows the water to cascade down the textured sphere into the bowl below. This stunning piece of stone effect art would be a fantastic addition to any garden.
Questions and answers
Product Reviews
Kelkay Mysterious Moon Easy Fountain Water Feature
Overall rating100% from 1 reviews
SELECT TOP 10 pID,CASE WHEN RTRIM(LTRIM(pLink))<>'' THEN 'product/'+plink WHEN RTRIM(LTRIM(pURL))<>'' THEN pURL ELSE 'product/pl/'+CAST(REPLACE(pid,'/','%2F') AS VARCHAR(MAX)) END,pImage,pName,ISNULL(pListPrice,0),ISNULL(case when pInStock<1 AND ISNULL(mMerchID,'')<>'' THEN pmPrice ELSE pPrice END,0) pPrice,pPackSize,CASE WHEN pInStock<1 AND ISNULL(mMerchID,'')<>'' THEN pmInStock ELSE pInStock END pInStock,pDiscontinued,pAlternativeURL,pPreOrder,CASE WHEN pInStock<1 AND ISNULL(mMerchID,'')<>'' THEN mDeliveryTime ELSE pDeliveryTime END pDeliveryTime,CASE WHEN pInStock<1 AND ISNULL(mMerchID,'')<>'' THEN 1 ELSE 0 END IsMerch,ISNULL(mMerchID,''),ISNULL(mMerchantName,''),pDescription,case when pInStock>0 OR ISNULL(mMerchID,'')<>'' THEN 1 ELSE 0 END InStock, case when pInStock<1 AND ISNULL(mMerchID,'')='FARMANDGARD' AND ISNULL(pmSpecialOffer,'')<>'' THEN pmSpecialOffer ELSE pusp END pUsp,pnew,case when pInStock<1 AND ISNULL(mMerchID,'')<>'' THEN pmShipping WHEN pPrice>50 THEN 0 ELSE pShipping END,pReviewCount,pReviewAvg FROM products OUTER APPLY (SELECT TOP 1 pmPrice,pmInStock,mMerchID,mMerchantName, CASE WHEN LTRIM(RTRIM(pmDeliveryText))<>'' THEN LTRIM(RTRIM(pmDeliveryText)) ELSE msEstimatedTimeScale END AS mDeliveryTime, CASE WHEN pmPrice>msFreeWhenOver THEN 0 WHEN msFlatRate IS NOT NULL THEN msFlatRate WHEN msMinShipping IS NOT NULL AND msMinShipping>pmShipping THEN msMinShipping WHEN msMaxShipping IS NOT NULL AND msMaxShipping<pmShipping THEN msMaxShipping ELSE pmShipping END pmShipping, pmSpecialOffer FROM productmerchant AS [t0] LEFT OUTER JOIN [dbo].[Merchant] AS [t1] ON [t1].[mMerchID] = [t0].[pmMerchID] LEFT OUTER JOIN [dbo].[MerchantService] AS [t2] ON [t2].[msMerchId] = [t1].[mMerchID] WHERE pmApproved=1 AND pmDisplay=1 AND pmInStock>0 AND pmPrice>0 AND msSequence=1 AND pmEAN=EAN ORDER BY pmPrice) MerchStuff,customers_also_purchased WHERE pDisplay=1 AND pID=soldwithpID AND mainpid='44023' ORDER BY InStock DESC, soldqty desc, pNumRatings*pprice DESC