menu
close
Search Trades

Find a Tradesperson in Merston

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.categoryString, 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, CASE WHEN c.upgrdSpokenTo=1 THEN 1 ELSE 0 END AS secondStageInterview FROM ( SELECT memberID, memberName, memberURL2, memberImage, memberDescr, townID, isVerified, liabilityFile, liabilityExpiry, idFile, addressMatched, categoryString FROM members WHERE isActive=1 AND memberID IN ( SELECT memberID FROM ( SELECT *, MIN( ( 3959 * acos( cos( radians(50.81514) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-0.73094) ) + sin( radians(50.81514) ) * sin( radians( lat ) ) ) ) ) AS distance FROM members GROUP BY memberID HAVING ( distance <= 15 OR countyID=156 ) ) z ) ) a INNER JOIN areas b ON a.townID=b.id LEFT JOIN ( SELECT memberID, 1 AS isPaid, MAX(listingType) AS listingType, MAX(expiryDate) AS expiryDate, MAX(upgrdSpokenTo) AS upgrdSpokenTo FROM listings WHERE listingType>=0 AND expiryDate>NOW() GROUP BY memberID ) c ON a.memberID=c.memberID GROUP BY a.memberID ORDER BY isVerified DESC, listingType DESC
Post your job to find the right tradesperson in Merston
Operates in Merston
We are a small and local Handyman and maintenance company... read more »
Operates in Merston
N & G Flooring are a based business offering Flooring... read more »
Operates in Merston
Multi Solutions is a new business constructed from... read more »
Operates in Merston
Senior construction are a based business offering Builders,... read more »
Operates in Merston
Jones projects Architectural are a based business offering... read more »
Operates in Merston
Srl renewable plumbing & heating are a based business... read more »
Operates in Merston
Pucker painters are a based business offering Painters... read more »
Operates in Merston
F and S ind Plumbing and Drainage are a based business... read more »
Operates in Merston
A +Design & Build southern ltd are a based business... read more »
Operates in Merston
Strong island construction ltd has a proven track record... read more »
Operates in Merston
Looking for a reliable, expert roofer in Portsmouth? As... read more »
Operates in Merston
I started my company back in 2017. Over the years I have... read more »
Operates in Merston
Carpet fitting now for 35 years,can supply and fit or fit... read more »
Operates in Merston
Craig Pitts Carpentry and Kitchens are a based business... read more »
Operates in Merston
James Riddy Plastering are a based business offering... read more »
Operates in Merston
Terry are a based business offering Builders, Plumbers... read more »
Operates in Merston
Small job specialist through to complete heating systems... read more »
Operates in Merston
Hampshire Structural Brickwork Company LTD are a based... read more »
Operates in Merston
RJC Plumbing services are a based business offering... read more »
Operates in Merston
RJS Waste Management (UK) Ltd are an independent company... read more »
Operates in Merston
Kepstaflames are a based business offering Chimneys &... read more »
Operates in Merston
South Downs Construction are a based business offering... read more »
Operates in Merston
Rozario Projects Ltd are a based business offering... read more »
Operates in Merston
Quick Building Services are a based business offering... read more »
Operates in Merston
At Premium Property Maintenance we strive for perfection.... read more »
Operates in Merston
We cover all aspects off roofing work, from a repair to... read more »
Operates in Merston
Pro gas are a based business offering Boiler/Heating... read more »
Operates in Merston
DW Construction are a based business offering Driveway... read more »
Operates in Merston
We offer central heating,boiler and system installation,... read more »

Helping you find Tradespeople in Merston

If you are looking for Tradespeople in Merston then Book a Builder UK is here to connect you with a local trade in your area. Search our pages to find local Tradespeople Merston where you can view profiles, reviews and photographs of previous work before choosing to contact them.

For the best results, post your job to receive competitive quotes from specialist local trades that are looking for your type of work. Book a Builder UK is a proven and highly successful system used by 1000's of customers to find a tradesperson every month.

Our system ensures that each project is only matched with relevant and suitable suppliers, so post your job with confidence and Find Tradespeople in Merston today.

© Copyright. BookaBuilderUK.com. 2024. All Rights Reserved.