instead of adding it to the defulat where clause, add it to the main recordset:
SELECT PropertyID, ProductTypeID, clients_ClientID, PropertyRef, SaleType, Country, PropertyCompany, Development, PropertyType, UnitNo, PriceofProperty, ProductName, ProductDescription, Scurrency, DepositPercentage, Special, SpecialPrice, DateSpecialEnds, GMAPCommission, APCommission, PCCommission, AgentCommission, SubAgentCommission, IFAFee, SippFee, Image1, Image1path, Image2, Image2Path, Archive FROM properties WHERE ProductTypeID <= 14 AND Archive = 0 ORDER BY PriceofProperty ASC