If the Application and Database is in same server or location, you could use this
string strQuery = "SELECT * FROM LoanRates where getdate() between LoanAvailableFrom and LoanAvailableTo";
else
string strQuery = "SELECT * FROM LoanRates where @date between LoanAvailableFrom and LoanAvailableTo";
SqlCommand cmd = new SqlCommand(strQuery);
string date = DateTime.Now.ToString("yyyy-MM-dd");
cmd.Parameters.Add("@date", date);