Search Trades

Find a Property Maintenance Business in Warrington, Cheshire

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.39185) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-2.59542) ) + sin( radians(53.39185) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=32) 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
Ormskirk, Lancashire.
Connor Mcilwaine are a Ormskirk based business offering... read more »
Nant Mawr, Flintshire.
Sarl Mcone are a Nant Mawr based business offering Builders,... read more »
Northwood, Merseyside.
At CC Group 23, our mission is to simplify property... read more »
Reddish, Greater Manchester.
With a decade of expertise, I'm your go-to for all your... read more »
Crumpsall, Greater Manchester.
Todays Marketing Limited are a Crumpsall based business... read more »
Linnyshaw, Greater Manchester.
Master Engineer are a Linnyshaw based business offering... read more »
Gilnow, Greater Manchester.
MARCU&SON LTD are a Gilnow based business offering Flooring,... read more »
Wigan, Greater Manchester.
WB Home improvements are a Wigan based business offering... read more »
Gorse Hill, Greater Manchester.
Handyman Manchester are a Gorse Hill based business... read more »
Tuebrook, Merseyside.
I consider myself to be a handyman ( working full time... read more »
Clough Foot, West Yorkshire.
N T Tiling are a Clough Foot based business offering... read more »
Orrell, Merseyside.
Dap Handymen are a Orrell based business offering Kitchen... read more »
Higher Croft, Lancashire.
Jones & Ward Civils Ltd are a Higher Croft based business... read more »
Darn Hill, Greater Manchester.
MnA Roofing And Building Specialist are a Darn Hill based... read more »
Stockton Heath, Cheshire.
Alexander Property Maintenance are a Stockton Heath based... read more »
Ashton-Under-Lyne, Greater Manchester.
I am a skilled master builder with approximately 25 years... read more »
Cadley, Lancashire.
I Have No Company are a Cadley based business offering... read more »
Speke, Merseyside.
TWS Brickwork Solutions Ltd are a Speke based business... read more »
Chester, Cheshire.
Chris ‘ Joinery are a Chester based business offering... read more »
Heaviley, Greater Manchester.
Stockport Maintenance Team are a Heaviley based business... read more »
St Helens, Merseyside.
Fix That Leak are a St Helens based business offering... read more »
Calderbrook, Greater Manchester.
R M Property Services are a Calderbrook based business... read more »
Springfield, Greater Manchester.
DJRC Property Services are a Springfield based business... read more »
Millbrook, Greater Manchester.
JLG Labour Services are a Millbrook based business offering... read more »
Withington, Greater Manchester.
AC Handyman Service are a Withington based business... read more »
Castle Hill, Greater Manchester.
Mark Brooks are a Castle Hill based business offering... read more »
Hulme, Greater Manchester.
Mercure Homes Ltd are a Hulme based business offering... read more »
Limehurst, Greater Manchester.
Eds Property Maintenance are a Limehurst based business... read more »
Birch, Greater Manchester.
Virtue FM Ltd are a Birch based business offering Extension... read more »
Irlam, Greater Manchester.
R.S Flat Roofing & Systems are a Irlam based business... read more »
© Copyright. 2023. All Rights Reserved.