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
Eastleigh, Hampshire.
Sporia ltd are a Eastleigh based business offering Patio... read more »
Keynsham, Somerset.
Here at Teak Construction we offer a range of services,... read more »
Milton Keynes Village, Buckinghamshire.
a team of Painters with over 7 years in the field will... read more »
Manston, West Yorkshire.
S&M Snags & Maintenance are a Manston based business... read more »
Kensington & Chelsea, London.
Fully insured contracting company based in London. We... read more »
Telford, Shropshire.
ProHome Interiors are a Telford based business offering... read more »
Squires Gate, Lancashire.
H20 Distributions are a Squires Gate based business... read more »
Brent, London.
London Premier Properties are a Brent based business... read more »
Woodlands, South Yorkshire.
Trent building are a Woodlands based business offering... read more »
Downend, Gloucestershire.
BusyBee Electrical are a Downend based business offering... read more »
Redbridge, London.
Renovations,Sales, Construction, Airmchair-Investment... read more »
Calcot Row, Berkshire.
We are skilled in performing general repair and maintenance... read more »
Hales Place, Kent.
R.B Property Services A friendly, profesional and reliable... read more »
Haringey, London.
Construction jobs undertaken (Refurbishment, tiling,... read more »
Lewisham, London.
Bricklayer with 5 years of experience working with new... read more »
Stonewood, Kent.
Halo Roofing And Building Ltd are a Stonewood based... read more »
Stamshaw, Hampshire.
R S K Property Services are a Stamshaw based business... read more »
© Copyright. 2023. All Rights Reserved.