Something

function search($search_terms, $page) // $search_terms is a serialized id of search terms stored in the session
	{
		$search_terms = $_SESSION[$search_terms];
		
		$data = array();
		if (isset($search_terms['featured']))
			$this->db->select('SQL_CALC_FOUND_ROWS *')->from('mls_listings, custom_listings');
		else
			$this->db->select('SQL_CALC_FOUND_ROWS *')->from('mls_listings');
		
/* Determine what search terms to use based on the user input */
		if (isset($search_terms['listing_agent_code']))
			$this->db->where('listing_agent_code', $search_terms['listing_agent_code']);
		if (isset($search_terms['listing_office_name']))
			$this->db->where('listing_office_name', $search_terms['listing_office_name']);
		if (isset($search_terms['city']))
			$this->db->like('city', $search_terms['city']);
		if (isset($search_terms['county']))
			$this->db->like('county_name', $search_terms['county']);
		if (isset($search_terms['zip']))
			$this->db->like('zip_code', $search_terms['zip']);
		if (isset($search_terms['street_number']))
			$this->db->like('street_number', $search_terms['street_number']);
		if (isset($search_terms['street_name']))
			$this->db->like('street_name', $search_terms['street_name']);
		if (isset($search_terms['mls_number']))
			$this->db->like('mls_number', $search_terms['mls_number']);
		if (isset($search_terms['subdivision_name']))
			$this->db->like('subdivision_name', $search_terms['subdivision_name']);
		if (isset($search_terms['condominium_name']))
			$this->db->like('condominium_name', $search_terms['condominium_name']);
		if (isset($search_terms['property_type']) && $search_terms['property_type'] != "Any")
			$this->db->where('property_category', $search_terms['property_type']);
		if (isset($search_terms['featured']))
			$this->db->where('mls_listings.mls_number = custom_listings.mls_num')->where('custom_listings.featured', true);
			
		$low_price = (!isset($search_terms['low_price'])) ? 0 : $search_terms['low_price'];
		$high_price = (!isset($search_terms['high_price'])) ? 1000000000 : $search_terms['high_price'];
		$this->db->where('list_price >=', $low_price);
		$this->db->where('list_price <=', $high_price);
		
		if (isset($search_terms['bedrooms']))
			$this->db->where('number_of_bedrooms >=', $search_terms['bedrooms']);
		if (isset($search_terms['bathrooms']))
			$this->db->where('number_of_full_baths >=', $search_terms['bathrooms']);
		if (isset($search_terms['square_feet']))
			$this->db->where('building_square_feet >=', $search_terms['square_feet']);
		
		// Declare the return arrays...
		$data['houses'] = array();
		$data['images'] = array();
		
		$this->db->limit(10, $page);
		$this->db->orderby('list_price');
		$query = $this->db->get();
		
		$found_rows = $this->db->query('SELECT FOUND_ROWS()');
		foreach($found_rows->result_array() as $row)
			$data['found_rows'] = $row['FOUND_ROWS()'];
		
		$this->db->from('mls_photos');
		$data['houses']['white'] = array();
		$data['houses']['other'] = array();
		foreach ($query->result() as $house)
		{
			if ($house->listing_office_name == "Century 21 White Real Estate")
				$data['houses']['white'][] = $house;
			else
				$data['houses']['other'][] = $house;
			$this->db->orlike('mls_number', $house->mls_number); // Add this mls number to the photo SQL search below
			
			if (file_exists('images/mls_listings/' . $house->mls_number . '.jpg'))
				$data['images'][$house->mls_number][] = array('link' => '/images/mls_listings/' . $house->mls_number . '.jpg', 'caption' => 'Primary Photo');
		}
		
		$this->db->orderby('picture_order');
		$query2 = $this->db->get();

		
		foreach ($query2->result() as $photo)
			$data['images'][$photo->mls_number][] = $photo;
		
		$temp = array();
		foreach ($data['houses']['white'] as $house)
			$temp[] = $house;
		foreach ($data['houses']['other'] as $house)
			$temp[] = $house;
		
		$data['houses'] = array();
		$data['houses'] = $temp;
		
		return $data;
	}