Search Trades

Find a Extension Builder in Stoke-on-Trent, Staffordshire

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=49)) AND memberID IN (SELECT memberID FROM listings WHERE listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(53.02464) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-2.18781) ) + sin( radians(53.02464) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=139) 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
Congleton, Cheshire.
We can complete all aspects of grounds work/ landscaping... read more »
Baddeley Green, Staffordshire.
JASON CONDLIFFE ELECTRICAL SERVICES are a Baddeley Green... read more »
Northwich, Cheshire.
Insta Build are a Northwich based business offering Loft... read more »
Stafford, Staffordshire.
UK driveways and property developments are a Stafford... read more »
Hale, Greater Manchester.
At Mayfair of Cheshire we pride ourselves on the high... read more »
Macclesfield, Cheshire.
J & L Building & Design is a Macclesfield based construction... read more »
Stoke-on-Trent, Staffordshire.
We are a local, Family run business offering a reliable... read more »
Congleton, Cheshire.
Can carry out all aspects of : GardensLandscapingFencingDrainage... read more »
Stockport, Greater Manchester.
J E Property Services are a Stockport based business... read more »
Leek, Staffordshire.
All aspects of building work, groundwork & hard landscaping... read more »
Wombourne, Staffordshire.
Craig Hudson Electrical are a Wombourne based business... read more »
Telford, Shropshire.
TV boxings featured walls and 3d ceilings. Plaster boarding... read more »
Bootle, Merseyside.
John Jones plastering are a Bootle based business offering... read more »
Tamworth, Staffordshire.
Fibreglass solutions specialise in fibreglass grp flat... read more »
Audley, Staffordshire.
Anglo Business and Construction are a Audley based... read more »
Cannock, Staffordshire.
Holleran C&J are a Cannock based business offering Builders,... read more »
Disley, Cheshire.
Polybuild north west limited are a Disley based business... read more »
Burntwood, Staffordshire.
Pro-serve direct are a Burntwood based business offering... read more »
Stockport, Greater Manchester.
GNSDevelopers are a Stockport based business offering... read more »
Altrincham, Greater Manchester.
Pm builders are a Altrincham based business offering... read more »
Tamworth, Staffordshire.
Having over 20 years experience within the building trade... read more »
Talke, Staffordshire.
Im a Builder/Bricklayer with 15 years experience and have... read more »
Telford, Shropshire.
1up Property Services are a Telford based business... read more »
Oxford, Oxfordshire.
4HK Builders are a Oxford based business offering Extension... read more »
Telford, Shropshire.
MD are a Telford based business offering Landscaping... read more »
Newport, Shropshire.
I’m a qualified self employed carpenter with 17 years... read more »
Ellesmere, Shropshire.
We cover all aspects of groundworks. Landscaping and... read more »
Wilmslow, Cheshire.
Emperor Building are a Wilmslow based business offering... read more »
Sandbach, Cheshire.
A family run business, with over 20 years experience... read more »
Burntwood, Staffordshire.
Mellor are a Burntwood based business offering Extension... read more »
© Copyright. 2023. All Rights Reserved.