Search Trades

Find a Builder in Preston, Gloucestershire

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(52.00797) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-2.47489) ) + sin( radians(52.00797) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=68) 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
Lower Cam, Gloucestershire.
I am a local carpenter/joiner with over 17 years experience.... read more »
Hucclecote, Gloucestershire.
Mdn are a Hucclecote based business offering Carpenters,... read more »
Soundwell, Gloucestershire.
Hpb Building Specialist are a Soundwell based business... read more »
Springbank, Gloucestershire.
At All Star Landscaping and Property Maintenance, we take... read more »
Credenhill, Herefordshire.
1st Choice Building Services Ltd are a Credenhill based... read more »
Emerson's Green, Gloucestershire.
William Bryant’s Bricklaying are a Emerson's Green based... read more »
Patchway, Gloucestershire.
Pro render are a Patchway based business offering Plasterers,... read more »
Shortwood, Gloucestershire.
CS Bricklaying & Landscaping are a Shortwood based business... read more »
Staverton, Gloucestershire.
Hillview Construction Gloucester Ltd are a Staverton based... read more »
Great Malvern, Worcestershire.
Ms Brickwork And Landscaping are a Great Malvern based... read more »
Bradley Stoke, Gloucestershire.
Supreme Brickwork are a Bradley Stoke based business... read more »
Gloucester, Gloucestershire.
Ace group (sw) ltd are a Gloucester based business offering... read more »
Clows Top, Worcestershire.
KN Construction are a Clows Top based business offering... read more »
Yate, Gloucestershire.
South west projects specialise in extensions and conversions,... read more »
Cheltenham, Gloucestershire.
Sng Limited are a Cheltenham based business offering... read more »
Newent, Gloucestershire.
Best Builder Lev are a Newent based business offering... read more »
Good's Green, Worcestershire.
R.L.C are a Good's Green based business offering Kitchen... read more »
Broom, Warwickshire.
For all you home improvement needs From landscaping to... read more »
Gloucester, Gloucestershire.
AA are a Gloucester based business offering Builders... read more »
Cinderford, Gloucestershire.
D F Jones Brickwork are a Cinderford based business... read more »
New Mills, Herefordshire.
Edwards are a New Mills based business offering Extension... read more »
© Copyright. 2023. All Rights Reserved.