def search_sale

    if not params['queryc'].nil? then
       @queryc = params['queryc']
    else
      @queryc = "sale_type = 'sale'"
      unless params[:min_price].blank?
        @queryc += " AND asking_price > " + params[:min_price]
      end
      unless params[:min_cap].blank?
        @queryc += " AND cap_rate > " + params[:min_cap]
      end
      unless params[:square_feet_search] == 'All' || params[:square_feet_search].blank?
        if params[:square_feet_search] == '0-5,000'
          @queryc += " AND square_feet > 0 AND square_feet < 5000"
        end
        if params[:square_feet_search] == '5,000-10,000'
          @queryc += " AND square_feet > 5000 AND square_feet < 10000"
        end
        if params[:square_feet_search] == '10,000-20,000'
          @queryc += " AND square_feet > 10000 AND square_feet < 20000"
        end
        if params[:square_feet_search] == '20,000-50,000'
          @queryc += " AND square_feet > 20000 AND square_feet < 50000"
        end
        if params[:square_feet_search] == '50,000+'
          @queryc += " AND square_feet > 50000"
        end
      end
      unless params[:max_price].blank?
        @queryc += " AND asking_price < " + params[:max_price]
      end
      unless params[:property_type] == 'All' || params[:property_type].blank?
        @queryc += " AND property_use = '" + params[:property_type].to_s + "'"
      end
      unless params[:agent_name].blank?
        @queryc += " AND (agent_1 LIKE '" + params[:agent_name] + "' OR agent_2 LIKE '%" + params[:agent_name] + "%')"
      end
      unless params[:city_search].blank?
        @queryc += " AND city = '" + params[:city_search] + "'"
      end
      unless params[:state_search].blank?
        @queryc += " AND state = '" + params[:state_search] + "'"
      end
      unless params[:county_search].blank?
        @queryc += " AND county = '" + params[:county_search] + "'"
      end
      unless params[:search_terms].blank?
        if params[:search_terms].length > 3
          @queryc += " AND (header_1 LIKE '%" + params[:search_terms] + "%' OR header_2 LIKE '%" + params[:search_terms] + "%' OR description LIKE '%" + params[:search_terms] + "%')"
        else
          @warning_message = "Search terms must be at least 4 characters long."
        end
      end
      unless params[:id].blank?
        @queryc = "sale_type = 'sale' AND status = 'Active' AND id=" + params[:id]
      end
      if @queryc == "sale_type = 'sale'"
        @search_results = ""
        @results_message = "Please enter search criteria above."
      else
        if logged_in? && (current_user.access == 'Admin' || current_user.access == 'Agent')
          unless params[:search_type] == 'All'
            @queryc += " AND status = '" + params[:search_type] + "'"
          else
            @queryc += " AND status = 'Active'"
          end
        else
          @queryc += " AND status = 'Active' AND hl_listing = 1"
        end
      end
    end
    if @queryc == "sale_type = 'sale'"
      @search_pages = ""
      @search_results = ""
      @results_message = "Please enter search criteria above."
    else
      @search_pages = Paginator.new self, Property.count( :conditions => @queryc ), 3, params[:page]
      @search_results = Property.find( :all, :conditions => @queryc, :offset => @search_pages.current.offset, :limit => @search_pages.items_per_page )
      @results_message = "No matches found."
    end


    if @search_results == ""
        @featured_properties = Property.find(:all, :limit => 2, :conditions => "featured = 1 AND sale_type = 'sale' AND status = 'active' AND hl_listing = 1")
    else
        @featured_properties = ""
    end
  end