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
Woodhouses, Greater Manchester.
Extensions, kitchens all building work basically, fully... read more »
Knypersley, Staffordshire.
[email protected] are a Knypersley based... read more »
Crewe, Cheshire.
Situated in Crewe, our adept handyman services include... read more »
Borough Park, Staffordshire.
GCA construction West Midlands based Commercial and... read more »
Oak Hill, Staffordshire.
R Builder are a Oak Hill based business offering Property... read more »
Rusholme, Greater Manchester.
A Nisa Trader are a Rusholme based business offering... read more »
Woodhouse Park, Greater Manchester.
I Can Fix It are a Woodhouse Park based business offering... read more »
Bridgtown, Staffordshire.
We are a small family run business providing an extensive... read more »
Dothill, Shropshire.
Total Landscaping are a Dothill based business offering... read more »
Cobridge, Staffordshire.
Teknikyapi are a Cobridge based business offering Flooring,... read more »
The Brampton, Staffordshire.
KS Contractors Stoke are a The Brampton based business... read more »
Cadishead, Greater Manchester.
I'm Gareth, qualified plasterer/renderer, I've mainly... read more »
Stirchley, Shropshire.
L&S Construction are a family business,run by 2 cousins... read more »
Madeley Heath, Staffordshire.
Mtbuilders are a Madeley Heath based business offering... read more »
Madeley Heath, Staffordshire.
Here we do all home improvements from boarding plastering... read more »
Whitehill, Staffordshire.
W&H Builders are a Whitehill based business offering... read more »
Wheelock, Cheshire.
The Timber Centre Ltd T/ Surefix North West are a Wheelock... read more »
Pitts Hill, Staffordshire.
Kh Fabrication And Maintenance are a Pitts Hill based... read more »
Barlow Moor, Greater Manchester.
Odd Jobs Handyman And Van are a Barlow Moor based business... read more »
Heath Town, West Midlands.
PLASTERFORCE LTD are a Heath Town based business offering... read more »
Tweedale, Shropshire.
We offer services for all you property needs. A friendly... read more »
Ketley Bank, Shropshire.
Matt's Property Maintenance are a Ketley Bank based... read more »
Reddish, Greater Manchester.
With a decade of expertise, I'm your go-to for all your... read more »
Carroway Head, Staffordshire.
JMP Construction Services are a Carroway Head based... read more »
The Heath, Staffordshire.
Local carpenter/Handyman. From flat packed furniture,... read more »
Heaviley, Greater Manchester.
Stockport Maintenance Team are a Heaviley based business... read more »
Withington, Greater Manchester.
AC Handyman Service are a Withington based business... read more »
Leadendale, Staffordshire.
W Leese Builder are a Leadendale based business offering... read more »
Castle Hill, Greater Manchester.
Mark Brooks are a Castle Hill based business offering... read more »
Rusholme, Greater Manchester.
We specialise in flatpack furniture building. From wardrobes... read more »
© Copyright. 2023. All Rights Reserved.