Atkinson Mcleod have offices covering, The City, Docklands and South london. They are located in prominent central locations to attract quality Tenants and Purchasers.
| The following error has occured: PROPERTY: Couldn't find the property: SELECT p.pcode as id, (p.pg1|32!=32) as ishouse, p.pdcode as department, p.pg1 as pg1, p.paddress1 as Address_1,p.paddress2 as Address_2, p.paddress3 as Address_3, p.paddress4 as County, p.pprice as Price, SUBSTRING(p.ppostcode,1,LOCATE(' ',p.ppostcode)) as Postcode_1, SUBSTRING(p.ppostcode,LOCATE(' ',p. ppostcode),10) as Postcode_2, concat(p.paddress1, ", ", p.paddress2, ", ", SUBSTRING(p.ppostcode,1,LOCATE(' ',p.ppostcode))) ,p.pbrief as Summary, p.pstatus, p.pstatus as Status, p.pavailable, p.pg6 as Receptions,p.pg5 as Bedrooms,p.pg7 as Bathrooms,p.ptenure as Tenure, p.pendlease as endlease, p.pextra as extra, p.pocode as pocode, p.ppicfile as ppicfile, p.pocode as Office_ID, p.pcountry as Country, p.ptenure as tenure, p.pendlease as endlease, p.pstatus as Status, c.latitude as X_Coord, c.latitude as Latitude, c.longitude as Longitude, p.pMaxPrice as Max_Price, p.pMinPrice as Min_Price, p.pLots as Lots, p.pPriceQual as pPriceQual, p.plots, p.pg1 as Property_Type, c.longitude as Y_Coord, p.pg3 as Garden, p.pg4 as Parking, (p.pg1|32!=32) as is_house FROM property p LEFT JOIN coordinates c ON p.pcode=c.pcode WHERE p.pcode='CTY070159' AND (p.pstatus='F' OR p.pstatus='S') AND p.synchDel!=1 AND p.pextra NOT LIKE '%pNoInternetAdvertising=.T.%' AND p.pNotes NOT LIKE '%No Internet Advertising%' AND p.pagency!='CP' |