select *,rtrim(left(postcode,len(postcode)-3)) as smallpostcode from serviceproviders where len(postcode)>5 and ( rtrim(left(postcode,len(postcode)-3)) = 'CF15' or rtrim(left(postcode,len(postcode)-3)) = 'CF31' or rtrim(left(postcode,len(postcode)-3)) = 'CF32' or rtrim(left(postcode,len(postcode)-3)) = 'CF33' or rtrim(left(postcode,len(postcode)-3)) = 'CF34' or rtrim(left(postcode,len(postcode)-3)) = 'CF35' or rtrim(left(postcode,len(postcode)-3)) = 'CF36' or rtrim(left(postcode,len(postcode)-3)) = 'CF37' or rtrim(left(postcode,len(postcode)-3)) = 'CF38' or rtrim(left(postcode,len(postcode)-3)) = 'CF39' or rtrim(left(postcode,len(postcode)-3)) = 'CF40' or rtrim(left(postcode,len(postcode)-3)) = 'CF41' or rtrim(left(postcode,len(postcode)-3)) = 'CF42' or rtrim(left(postcode,len(postcode)-3)) = 'CF43' or rtrim(left(postcode,len(postcode)-3)) = 'CF44' or rtrim(left(postcode,len(postcode)-3)) = 'CF45' or rtrim(left(postcode,len(postcode)-3)) = 'CF46' or rtrim(left(postcode,len(postcode)-3)) = 'CF47' or rtrim(left(postcode,len(postcode)-3)) = 'CF48' or rtrim(left(postcode,len(postcode)-3)) = 'CF61' or rtrim(left(postcode,len(postcode)-3)) = 'CF71' or rtrim(left(postcode,len(postcode)-3)) = 'CF72' or rtrim(left(postcode,len(postcode)-3)) = 'CF81' or rtrim(left(postcode,len(postcode)-3)) = 'CF82' or rtrim(left(postcode,len(postcode)-3)) = 'EX34' or rtrim(left(postcode,len(postcode)-3)) = 'EX35' or rtrim(left(postcode,len(postcode)-3)) = 'NP22' or rtrim(left(postcode,len(postcode)-3)) = 'NP24' or rtrim(left(postcode,len(postcode)-3)) = 'SA1' or rtrim(left(postcode,len(postcode)-3)) = 'SA10' or rtrim(left(postcode,len(postcode)-3)) = 'SA11' or rtrim(left(postcode,len(postcode)-3)) = 'SA12' or rtrim(left(postcode,len(postcode)-3)) = 'SA13' or rtrim(left(postcode,len(postcode)-3)) = 'SA14' or rtrim(left(postcode,len(postcode)-3)) = 'SA15' or rtrim(left(postcode,len(postcode)-3)) = 'SA16' or rtrim(left(postcode,len(postcode)-3)) = 'SA17' or rtrim(left(postcode,len(postcode)-3)) = 'SA18' or rtrim(left(postcode,len(postcode)-3)) = 'SA19' or rtrim(left(postcode,len(postcode)-3)) = 'SA2' or rtrim(left(postcode,len(postcode)-3)) = 'SA20' or rtrim(left(postcode,len(postcode)-3)) = 'SA3' or rtrim(left(postcode,len(postcode)-3)) = 'SA31' or rtrim(left(postcode,len(postcode)-3)) = 'SA32' or rtrim(left(postcode,len(postcode)-3)) = 'SA33' or rtrim(left(postcode,len(postcode)-3)) = 'SA39' or rtrim(left(postcode,len(postcode)-3)) = 'SA4' or rtrim(left(postcode,len(postcode)-3)) = 'SA5' or rtrim(left(postcode,len(postcode)-3)) = 'SA6' or rtrim(left(postcode,len(postcode)-3)) = 'SA7' or rtrim(left(postcode,len(postcode)-3)) = 'SA8' or rtrim(left(postcode,len(postcode)-3)) = 'SA9' ) and webVisible = 1 AND wood = 1 AND stoveinstal = 0 AND fireplaceinstal = 0 AND doubleskinflue = 0 AND liner = 0 order by len(areas) asc
bishopswood tree surgeon ltdDistance = 5 Miles
Click here for full details about bishopswood tree surgeon ltdCPL South Wales CoalDistance = 7 Miles
Click here for full details about CPL South Wales Coalwarm2woodDistance = 10 Miles
Click here for full details about warm2woodrhyalwoodDistance = 14 Miles
Click here for full details about rhyalwoodThe Firewood CompanyDistance = 23 Miles
Click here for full details about The Firewood CompanyWindfallwoodDistance = 27 Miles
Click here for full details about Windfallwoodtredomen tree and fencingDistance = 30 Miles
Click here for full details about tredomen tree and fencing
Click here to conduct another search
If you are a wood supplier and would like to appear here for free then please complete this simple Application form
We provide this as a an extra information service to our customers but obviously do not have time to go out and individually vet all the people listed. We cannot be held responsible if you are not satisfied with any of the people or companies listed here as you will be dealing with them directly. Please do let us know though is you have a particular complaint about someone listed.
