Cotswold Men's Hawling Boots in Brown
Product Code : 27139-45587
Mega Sale Event, Now On!
Practical men's walking boot
Brief Description
The Cotswold Men's Hawling Boot is a classy men's walking shoe, inspired by the journey from the Cotswold town to the countryside trail.
The boot is packed with technological features, with internal breathable waterproof membrane, moisture wicking lining and energy rebounding dual density rubber/phylon sole.
Product Description
- Cotswold Men's Hawling Boots
- Brown colourway
- Supple matt-finish leather upper
- Inner breathable waterproof membrane
- Nylon mesh textile tongue with wide gusset
- Deep padded nylon mesh collar
- Hardwearing metal D-Ring and upper eyelet
- Sporty outdoor-strength cord lacing
- Moisture-wicking breathable lining
- Removable memory foam foot bed
- Cushioning and energy rebounding phylon midsole
- Hardwearing traction non-slip rubber outsole
The Cotswold Men's Hawling Boot is a classy men's walking shoe, inspired by the journey from the Cotswold town to the countryside trail.
The boot is packed with technological features, with internal breathable waterproof membrane, moisture wicking lining and energy rebounding dual density rubber/phylon sole.
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='27139-45587' ORDER BY InStock DESC, soldqty desc, pNumRatings*pprice DESC