Search Trades

Find a Property Maintenance Business 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=63)) 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
Wandsworth, London.
A&M Maintenance Services Ltd are a Wandsworth based... read more »
Charfield, Gloucestershire.
We are are small friendly company that has been trading... read more »
Aylestone Hill, Herefordshire.
Tupsley Diy Handyman are a Aylestone Hill based business... read more »
Shurdington, Gloucestershire.
Howse Constructions are a Shurdington based business... read more »
Harrow Hill, Gloucestershire.
Hanson Land And Tree Services are a Harrow Hill based... read more »
Chipping Sodbury, Gloucestershire.
Ross are a Chipping Sodbury based business offering... read more »
Frogland Cross, Gloucestershire.
1two1builders are a Frogland Cross based business offering... read more »
Farlow, Shropshire.
TT Construction are a Farlow based business offering... read more »
Crossway Green, Monmouthshire.
Seren Property Maintenance are a Crossway Green based... read more »
Badgeworth, Gloucestershire.
JW Maintenance are a Badgeworth based business offering... read more »
Baughton, Worcestershire.
Here at jf home improvement we offer a fast and reliable... read more »
Tolladine, Worcestershire.
Hello. We are a small friendly local company we carter... read more »
Barton, Warwickshire.
I have been self employed 15+ years. Experienced property... read more »
Filton, Gloucestershire.
JW Carpentry are a Filton based business offering Property... read more »
Winchcombe, Gloucestershire.
Luke Bond are a Winchcombe based business offering Driveway... read more »
Fairview, Gloucestershire.
Cheltenham Handyman And Property Care are a Fairview based... read more »
Kidderminster, Worcestershire.
KEVYAN Limited are a Kidderminster based business offering... read more »
Ebnall, Herefordshire.
Liam’s Maintenance are a Ebnall based business offering... read more »
Lower Slaughter, Gloucestershire.
Duncan Habbitts are a Lower Slaughter based business... read more »
Chawson, Worcestershire.
Ss Building Services are a Chawson based business offering... read more »
Cinderford, Gloucestershire.
At Rapid Roofing, we pride ourselves on our extensive... read more »
Coalpit Heath, Gloucestershire.
Here at Elite building services we take on all aspects... read more »
Wigmore, Herefordshire.
An experienced builder with 12+ years experience in... read more »
Doynton, Gloucestershire.
Looking for a honest independent Gas and Oil Heating... read more »
Hucclecote, Gloucestershire.
Mdn are a Hucclecote based business offering Carpenters,... read more »
Filton, Gloucestershire.
Mr Paul Fix-it All are a Filton based business offering... read more »
Flaggoners Green, Herefordshire.
No leak is too small .... pitched roofs, flat roofs,... read more »
Springbank, Gloucestershire.
At All Star Landscaping and Property Maintenance, we take... read more »
Kidderminster, Worcestershire.
Kevyan Homes are a Kidderminster based business offering... read more »
Emerson's Green, Gloucestershire.
William Bryant’s Bricklaying are a Emerson's Green based... read more »
© Copyright. 2023. All Rights Reserved.