Search Trades

Find a Chimney & Fireplace Business in the UK

Post your job and get free quotes from tradespeople near you! Post your job
SELECT a.memberID, a.memberName, a.memberURL2, a.memberImage, a.memberDescr, a.townID, b.countyID, COALESCE(c.isPaid, 0) AS isPaid, c.listingType, a.isVerified AS premierMember, b.place_name, b.county, a.liabilityFile, a.liabilityExpiry, a.idFile, a.addressMatched, d.secondStageInterview FROM ( SELECT memberID, memberName, memberURL2, memberImage, memberDescr, townID, isVerified, liabilityFile, liabilityExpiry, idFile, addressMatched FROM members WHERE isActive=1 AND memberID IN (SELECT memberID FROM listings WHERE expiryDate>NOW() AND listingID IN (SELECT listingID FROM listingcats WHERE categoryID=112)) ) a INNER JOIN areas b ON LEFT JOIN ( SELECT memberID, 1 AS isPaid, MAX(listingType) AS listingType, MAX(expiryDate) AS expiryDate FROM listings WHERE listingType>=0 AND expiryDate>NOW() GROUP BY memberID ) c ON a.memberID=c.memberID LEFT JOIN ( SELECT memberID, 1 AS secondStageInterview FROM listings WHERE listingType>=0 AND upgrdSpokenTo=1 GROUP BY memberID ) d ON a.memberID=d.memberID GROUP BY a.memberID ORDER BY isVerified DESC, listingType DESC
Book a free wren kitchen design
Huddersfield, West Yorkshire.
Northern Stoves Ltd are a specialist stove company based... read more »
Bedford, Bedfordshire.
Offering all double glazing repair services such as; *hinges... read more »
Camberley, Surrey.
Surrey Sweeping are a Camberley based business offering... read more »
Derby, Derbyshire.
PCD CHIMNEY SERVICES are a Derby based business offering... read more »
Atherstone, Warwickshire.
crown stoves are a Atherstone based business offering... read more »
Abbey Dore, Herefordshire.
Freds shoes are a Abbey Dore based business offering... read more »
Nottingham, Nottinghamshire.
Mr. are a Nottingham based business offering Chimneys &... read more »
Llanddewi Velfrey/Llanddewi Felffre, Pembrokeshire.
Tidy Tristram tackling dirty stoves! Another day on the... read more »
Banstead, Surrey.
Prestige chimney sweep are a Banstead based business... read more »
Camberley, Surrey.
We are a family run business providing a personal service... read more »
Norwich, Norfolk.
We are a family run business based in Norwich offering... read more »
Uckfield, East Sussex.
South Weald Stoves specialise in fireplace and chimney... read more »
Belper, Derbyshire.
Alton Building are a Belper based business offering... read more »
Adlington, Lancashire.
We are a family run fire and fireplace company with over... read more »
Birmingham, West Midlands.
Hetas registered installer,specialist in fitting and... read more »
Bovey Tracey, Devon.
ProSweep Professional Chimney Sweep is approved by Devon... read more »
St Neots, Cambridgeshire.
Cromwell Stoves Limited are a St Neots based business... read more »
Hertford, Hertfordshire.
Hertfordshire’s largest showroom display of the finest... read more »
Farnham, Surrey.
Elite Heating are a Farnham based business offering... read more »
Manchester, Greater Manchester.
N/a are a Manchester based business offering Chimneys &... read more »
Thatcham, Berkshire.
Thames Valley Chimney Sweep are a Thatcham based business... read more »
Melksham, Wiltshire.
Corinthian Stone are a Melksham based business offering... read more »
Beccles, Suffolk.
We offer a professional, friendly and reliable Property Maintenance... read more »
Chalfont St Peter, Buckinghamshire.
Pivotal Builds LC Limited are a Chalfont St Peter based... read more »
Nottingham, Nottinghamshire.
Reclaimed Roof Tiles and Moore specialise in reclaimed... read more »
Cheltenham, Gloucestershire.
ACP home improvements provides to your every need such... read more »
Cupar, Fife.
A.Millar Roofing are a Cupar based business offering... read more »
Cambridge, Cambridgeshire.
Acorn Property Improvements are a Cambridge based business... read more »
Bodmin, Cornwall.
We are a new business to book a builder which take on all... read more »
Stockport, Greater Manchester.
I aim to provide the highest quality of work I have been... read more »
© Copyright. 2023. All Rights Reserved.