Search Trades

Find a Property Maintenance Business in Stoke-on-Trent, Staffordshire

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=63)) AND memberID IN (SELECT memberID FROM listings WHERE listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(53.02464) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-2.18781) ) + sin( radians(53.02464) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=139) ORDER BY distance) z)) ) 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
Stockport, Greater Manchester.
Olive Tree Property Services is a new business with vast... read more »
Lincoln, Lincolnshire.
BoilerInstallation has provided our utility expertise and... read more »
Cannock, Staffordshire.
Qualis Projects Ltd are a Cannock based business offering... read more »
Crewe, Cheshire.
CGJoinery are a Crewe based business offering Kitchen... read more »
Burntwood Green, Staffordshire.
S fox plastering services. Over 25 years experience and... read more »
Winsford, Cheshire.
Kings Home Improvements are a Winsford based business... read more »
Norton Canes, Staffordshire.
Anthony’s Maintenance are a Norton Canes based business... read more »
A' Chill, Highland.
Not Trading are a A' Chill based business offering... read more »
Disley, Cheshire.
L.A Joinery are a Disley based business offering Extension... read more »
Bridgnorth, Shropshire.
Bracs Maintenance/home Improvements are a Bridgnorth... read more »
Helsby, Cheshire.
JWS Property Limited are a Helsby based business offering... read more »
Lichfield, Staffordshire.
Services Plumbing:- • Bathroom installation • Cloak... read more »
Cannock, Staffordshire.
Welcome to Resina Surfacing. Our highly experienced team... read more »
Hyde, Greater Manchester.
M.Moss Building And Plastering are a Hyde based business... read more »
Pelsall, West Midlands.
MR Interiors are a Pelsall based business offering Kitchen... read more »
Bucknall, Staffordshire.
J are a Bucknall based business offering Property... read more »
Stockport, Greater Manchester.
I have been doing DIY now for around 4 years. I specialise... read more »
Stafford, Staffordshire.
Abbott And Brown Home Improvements are a Stafford based... read more »
Tamworth, Staffordshire.
Johnston Joinery are a Tamworth based business offering... read more »
Stoke-on-Trent, Staffordshire.
24/7 Boiler Services are a Stoke-on-Trent based business... read more »
Meir, Staffordshire.
P And A Construction are a Meir based business offering... read more »
Cannock, Staffordshire.
Dels Handyman Services are a Cannock based business... read more »
Tamworth, Staffordshire.
Craig Shepherd Carpentry are a Tamworth based business... read more »
Barlaston, Staffordshire.
Anglosaf Limited are a Barlaston based business offering... read more »
Cannock, Staffordshire.
Family ran business with over 50 years general building... read more »
Great Wyrley, Staffordshire.
We take on any kind of roofing and property maintenance... read more »
Stafford, Staffordshire.
Aztec Damp Proofing are a Stafford based business offering... read more »
Uttoxeter, Staffordshire.
Tbp Construction Services Ltd are a Uttoxeter based... read more »
Northwich, Cheshire.
For all your Plastering requirements free quotes given.... read more »
Burntwood, Staffordshire.
We specialise in all aspects of flooring all supplied,... read more »
© Copyright. 2023. All Rights Reserved.