EX DISPLAY/ COLLECTION ONLY Colorado Falls Easy Fountain Garden Water Feature
Product Code : 45102L-SHOWROOM
Mega Sale Event, Now On!
This item has been assembled and is available for collection only
Brief Description
This item is Ex-display, meaning it has been assembled and is available for collection only.
Ex-display goods will have wear from showroom use. Some sets may have faults, please call us on 01283 543 974 for more information and details.
Viewing in our midlands showroom is recommended before purchase and local delivery can be quoted for.
Please Note:- This listing is for an ex-display item from our Burton on Trent showroom so delivery is not available
This set is in excellent condition but there are a few minor issues from showroom wear, so viewing is highly recommended.
.
Delivery Options - Available at Checkout
Product Description
- Mains Powered Fountain
- Easy set up - no need for plumbing
- Hard-wearing UV and frost resistant polyresin
- Built in LEDs for night viewing
- 10m extra long cable
Stunning Garden Water feature
Bring one of nature's finest bounties to your garden with the Colorado Falls garden water fountain from Kelkay. The stunning self-contained garden feature mimics a natural waterfall that suits any outdoor space, and requires no external plumbing to operate. Simply fill with water and plug it in using the extra long cable provided.The fountain looks equally as spectacular at night as it does during the day thanks to a set of LED lights inside the base, illuminating the water as it delicately cascades down the feature.
Additional Information
DimensionsHeight 98cm x Width 57cm x Depth 48cm
Cable Length: 10m
Weight: 69kg
Questions and answers
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='45102L-showroom' ORDER BY InStock DESC, soldqty desc, pNumRatings*pprice DESC