menu
close
Search Trades

Find a Tradesperson in The Lunt

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(52.56632) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-2.05307) ) + sin( radians(52.56632) ) * sin( radians( lat ) ) ) ) ) AS distance FROM members GROUP BY memberID HAVING ( distance <= 15 OR countyID=155 ) ) 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 The Lunt
Operates in The Lunt
I have been fitting kitchens bathrooms, 1st fix 2nd fix,... read more »
Operates in The Lunt
N.J Bricklaying And Electrical Services are a based... read more »
Operates in The Lunt
Allen's Ohm's are a based business offering Electricians... read more »
Operates in The Lunt
HETAS and Gas Safe registered installer - fireplaces and... read more »
Operates in The Lunt
Julia's Improvement are a based business offering Builders,... read more »
Operates in The Lunt
Southern Cross Plumbing are a based business offering... read more »
Operates in The Lunt
Barrett Electrical, Security & Fire LTD are a based... read more »
Operates in The Lunt
Mr Scaffolding uk are a based business offering Scaffolders... read more »
Operates in The Lunt
Perfect fitting and Repairs Limited are a based business... read more »
Operates in The Lunt
At Holloway plastering we love what we do and it shows,... read more »
Operates in The Lunt
KK home improvements are a based business offering... read more »
Operates in The Lunt
Designer Builds & Druveways are a based business offering... read more »
Operates in The Lunt
tile to tile are a based business offering Tiling... read more »
Operates in The Lunt
CJ Services are a based business offering Property... read more »
Operates in The Lunt
Chris PETEINATOS are a based business offering Plasterers... read more »
Operates in The Lunt
hello my name is stuart, wolverhampton building and... read more »
Operates in The Lunt
SAMPS HOME AND CARPET CLEANING SERVICES are a based... read more »
Operates in The Lunt
Samps Home and Carpet Cleaning services ltd provides... read more »
Operates in The Lunt
Fix a leak roofing are a based business offering Roofers... read more »
Operates in The Lunt
C d building services are a based business offering... read more »
Operates in The Lunt
HERITAGE Plastering & Rendering Services are a based... read more »
Operates in The Lunt
17 years experience in all aspects of decorating work... read more »
Operates in The Lunt
C.s.w Garden maintenance are a based business offering... read more »
Operates in The Lunt
PLSN Electrical Installations are a based business... read more »
Operates in The Lunt
DJ Carpentry & Maintenance are a based business offering... read more »
Operates in The Lunt
LCN is a family based business specialising in plastering,... read more »
Operates in The Lunt
We are a electrical firm based in solihull, offering high... read more »
Operates in The Lunt
Ian tipper painting & decorating are a based business... read more »
Operates in The Lunt
D. J.MASON BUILDERS LIMITED are a based business offering... read more »
Operates in The Lunt
Rob Astell roofing are a based business offering Roofers... read more »

Helping you find Tradespeople in The Lunt

If you are looking for Tradespeople in The Lunt then Book a Builder UK is here to connect you with a local trade in your area. Search our pages to find local Tradespeople The Lunt 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 The Lunt today.

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