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
Summergangs, East Riding of Yorkshire.
A RYMER FIREPLACE AND BUILDING SERVICES are a Summergangs... read more »
Graig Trewyddfa, Swansea.
Tim Hoyle Stoves are a Graig Trewyddfa based business... read more »
Moreton-in-Marsh, Gloucestershire.
Cotswold Pitch Roof Repair are a Moreton-in-Marsh based... read more »
Gedling, Nottinghamshire.
I&T Roofing are a Gedling based business offering Roofers,... read more »
Blacklands, East Sussex.
The English Mantel are a Blacklands based business offering... read more »
Maidstone, Kent.
We are a trusted reliable company operating in the South... read more »
Brighton Hill, Hampshire.
Fully qualified Hetas registered stove installer. We can... read more »
Templehall, Fife.
We are a fully time served roofing company who pride our... read more »
Charlestown, Greater Manchester.
Kartels Tradesmen Ltd are a Charlestown based business... read more »
Edenbridge, Kent.
Roofs To Roots are a Edenbridge based business offering... read more »
Caerphilly/Caerffil, Caerphilly.
We are a family run business with over 40years experience... read more »
Stowmarket, Suffolk.
Welcome to Next generation stoves ltd Woodburning and... read more »
Glasgow, Glasgow City.
Love's Masonry are a Glasgow based business offering... read more »
© Copyright. 2023. All Rights Reserved.