Search Trades

Find a Property Refurbishment 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=68)) ) 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
Donnington, Shropshire.
N are a Donnington based business offering Builders,... read more »
Garston, Hertfordshire.
Hatch END BuILDERS LTD are a Garston based business... read more »
Barnet, London.
Established in 2010 North Excellence are a highly successful... read more »
Hounslow, London.
Hi and welcome to premiere home interiors my names tom... read more »
Grange, Kent.
At C&S INTERIORS ,we're more than just carpenters –... read more »
Westminster, London.
Gins, Construction are a Westminster based business... read more »
Alsager, Cheshire.
We are a small family business that has been operating... read more »
Redbridge, London.
Gt Brickwork Ltd are a Redbridge based business offering... read more »
Bentley, Essex.
Welcome to Beechwood Builds! A family-run building company... read more »
Manor Park, Berkshire.
B s Builders are a Manor Park based business offering... read more »
Merton, London.
JND Projects Ltd are a Merton based business offering... read more »
Brent, London.
Viewspaces Property Maintenance are a Brent based business... read more »
Bingham, Nottinghamshire.
We work to achieve the highest standards for our... read more »
Tower Hamlets, London.
Din Property Services Ltd are a Tower Hamlets based... read more »
Countess Wear, Devon.
Marius Builders are a Countess Wear based business offering... read more »
Orton Malborne, Cambridgeshire.
Making the most of every space we work with, we offer a... read more »
Richmond upon Thames, London.
Wahdan Building ltd are a Richmond upon Thames based... read more »
Horsell Birch, Surrey.
At Rooms Make a Home, we believe that the beauty of a... read more »
© Copyright. 2023. All Rights Reserved.