Search Trades

Find a Builder in Southampton, Hampshire

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=48)) AND memberID IN (SELECT memberID FROM listings WHERE listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(50.91940) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-1.39676) ) + sin( radians(50.91940) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=74) 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
Merry Oak, Hampshire.
J And L Building And Landscapes LTD are a Merry Oak based... read more »
Summersdale, West Sussex.
Here are C&H brickwork we are pleased to turn your dreams... read more »
Lord's Hill, Hampshire.
ASR Electrical & Building LTD are a Lord's Hill based... read more »
Warden Point, Isle of Wight.
What We Do Our past projects include both new construction... read more »
Fleet, Hampshire.
Self Employer are a Fleet based business offering Builders,... read more »
Titchfield Park, Hampshire.
Welcome to Mirkwood Landscapes, we are a friendly local... read more »
Talbot Heath, Dorset.
Warrior Building Company LTD are a Talbot Heath based... read more »
Purewell, Dorset.
J W Construction are a Purewell based business offering... read more »
Eastney, Hampshire.
Shopov LTD are a Eastney based business offering Painters... read more »
Somerford, Dorset.
Straight Up Brickwork are a Somerford based business... read more »
Kinson, Dorset.
ProbuildUK are a Kinson based business offering Kitchen... read more »
Hampton Park, Hampshire.
L&M Scaffolding Access are a Hampton Park based business... read more »
Drayton, Hampshire.
Temple Property Holdings - The leading property company... read more »
Woolsbridge, Dorset.
Based in Dorset, DP Roofing & Building is a professional,... read more »
South Ham, Hampshire.
J&E Construction Ltd are a South Ham based business... read more »
Fair Oak, Hampshire.
Pro Build Southern are a Fair Oak based business offering... read more »
© Copyright. 2023. All Rights Reserved.