<query name="findPostingDetailsByCategoryAndCity"><![CDATA[
            from PostingDetails as pid left join pid.lessorAddress as addr right join pid.categorizedItems as ci where addr.city like ?% and ci.id.categoryId = ?
        ]]></query> 

   public List findPostingDetails(Long categoryId, String city){
      List list = getHibernateTemplate().findByNamedQuery(
            "findPostingDetailsByCategoryAndCity",
            new Object[] { city + "%", categoryId });

      if (list.size() < 1)
         return null;

      return list;
   }