The following error has occured: PROPERTY: Couldn't find the property: SELECT DISTINCT(p.pcode) as id, p.pdcode as department, p.ptype as pg1, p.paddress1 as Address_1,p.paddress2 as Address_2, p.paddress3 as Address_3, p.paddress4 as County, p.pwrent 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.pg4+p.pg5) as Bedrooms,p.pg7 as Bathrooms, p.pextra as extra, p.pocode as pocode, p.ppicfile as ppicfile, p.pocode as Office_ID, p.pstatus as Status, c.latitude as X_Coord, c.latitude as Latitude, c.longitude as Longitude, p.ptype as Property_Type, c.longitude as Y_Coord, p.pspecial as Garden, p.pspecial as Parking, p.ptype&1=1 as is_house FROM property p LEFT JOIN coordinates c ON p.pcode=c.pcode WHERE p.pcode='BAL080569' AND 1 AND p.synchDel!=1 AND p.pextra NOT LIKE '%pNoInternetAdvertising=.T.%' AND p.pNotes NOT LIKE '%No Internet Advertising%' AND p.prole!='CP'